Technology for Business Question Bank
Course Introduction
This course explores the integration and application of technology within modern business environments, emphasizing how digital tools and information systems enhance organizational operations, productivity, and decision-making. Students will examine current technological trends, such as cloud computing, big data, artificial intelligence, and e-commerce, while addressing ethical considerations and cybersecurity challenges. Through practical case studies and hands-on projects, learners will gain insights into selecting and implementing appropriate technological solutions to solve real-world business problems and create competitive advantages.
Recommended Textbook
Exploring Microsoft Office 2013 Volume 2 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
44 Chapters
2763 Verified Questions
2763 Flashcards
Source URL: https://quizplus.com/study-set/1838
Page 2
Chapter 1 : Subtotals, Pivot-tables,
and Pivot-charts:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/36630
Sample Questions
Q1) A ________ is used to graphically represent the data in a PivotTable.
A)PivotChart
B)PowerPivot
C)Scatter Chart
D)PivotGraph
Answer: A
Q2) Slicer styles are located on the ________ tab.
A)VIEW
B)INSERT
C)DESIGN
D)OPTIONS
Answer: D
Q3) To remove a field from a PivotTable,you select it and press Delete.
A)True
B)False
Answer: False
Q4) You can move a field from one PivotTable area to another by just dragging it.
A)True
B)False Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2 : Desktop Publishing and Graphic Design: Hands
On Exercise Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/36631
Sample Questions
Q1) When linking a range of cells from an Excel worksheet to a Word document,which of the following Paste Link options should be used?
A)Formatted Text
B)Microsoft Excel Worksheet Object
C)Unformatted Text
D)Word Hyperlink
Answer: B
Q2) OLE stands for ________.
A)OnLine Editing
B)Object Linking and Embedding
C)OnLine Embedding
D)Object Labeling and Editing
Answer: B
Q3) A pull quote is a phrase or sentence taken from an article to emphasize a key point,which may be in larger type,a different font,or italics.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Desktop Publishing and Graphic Design:
Creating a Newsletter working With Graphics and Linking Objects
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36632
Sample Questions
Q1) Match the following terms to their meanings:
I.Drawing Canvas
II.Lock anchor setting
III.Bring Forward
IV.Send Backward
V.Send Behind text
A.use to assign an absolute position to a graphic
B.moves the object to display behind text
C.frame-like boundary object in the document
D.moves an object below the object directly in back of it
E.moves an object on top of the object directly in front of it
Answer: C,A,E,D,B
Q2) If you embed an Excel worksheet into a Word document,you can make changes to the source file and they will be reflected in the Word document.
A)True
B)False
Answer: False
Q3) A(n)________ graphic can be used to represent a process or a hierarchy chart.
Answer: SmartArt
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Infographics: Creating Text Charts, tables, and Graphs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36633
Sample Questions
Q1) A ________ is the default chart style in the Insert Chart dialog box.
A)3-D Column
B)Line
C)Clustered Bar
D)Clustered Column
Q2) Click the Chart Elements arrow in the Current Selection group on the ________ tab to choose individual chart elements.
Q3) A(n)________ is a form of text-based chart that organizes information into a structured grid.
Q4) The default chart style in PowerPoint is a(n)________ Column chart.
Q5) A(n)________ application is used to create an original object that may be embedded or linked into another application.
Q6) PowerPoint allows up to ________ rows and columns in a table.
A)25
B)50
C)75
D)250
Q7) What is a Z-axis on a chart?
Q8) Why might you want to apply a predefined layout to a chart? Page 6
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Subtotals Pivot-tables and Pivot-charts
Available Study Resources on Quizplus for this Chatper
103 Verified Questions
103 Flashcards
Source URL: https://quizplus.com/quiz/36634
Sample Questions
Q1) You must sort in order to properly execute a subtotal.
A)True
B)False
Q2) Which tool is best suited for use with PivotTables when the data is based on multiple tables?
A)PivotCharts
B)Slicers
C)Sorting
D)Filters
Q3) ________ is a built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections.
Q4) How are grouped columns ungrouped?
A)Select the entire worksheet and click Ungroup in the Subtotal group
B)Select one cell in the grouped columns and click Ungroup in the Outline group
C)Select all grouped columns and click Ungroup in the Outline group
D)Right-click and select Ungroup
Q5) The Subtotal feature creates a(n)________,a hierarchical structure of data.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Data Validation and Data Analysis: Reducing
Errors and Extracting Better Information
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36635
Sample Questions
Q1) Instead of modifying the query grid each time a new criteria is needed,a parameter query can be created to enter the criteria.
A)True
B)False
Q2) The data validation method that causes fields to be limited to predefined list of values is a:
A)lookup list.
B)default value.
C)data macro.
D)validation text.
Q3) Reports can be created based on the results of a parameter query.
A)True
B)False
Q4) A Multivalued Lookup field accepts numerous options instead of just one field choice.
A)True
B)False
Q5) If a field in a table has a ________ a drop down menu will appear in the field.
Q6) What does a IsNull function do?
Q7) What is the purpose of adding an input mask to a field? Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 7: Infographics: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/36636
Sample Questions
Q1) Which option scales a slide to show the entire slide?
A)Ensure Fit
B)Maximize
C)Whole Slide
D)Zoom
Q2) By using a predefined ________,you can keep your charts consistent and maintain a professional look to a presentation.
A)layout
B)design
C)scheme
D)pattern
Q3) You can manually change each element of a chart individually,or you can apply a predefined layout to the entire chart.
A)True
B)False
Q4) To combine a group of cells into a single cell,you click ________ Cells.
A)Join
B)Unite
C)Merge
D)Combine
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 8: Data Validation and Data Analysis: Hands On
Exercise Videos
Available Study Resources on Quizplus for this Chatper
18 Verified Questions
18 Flashcards
Source URL: https://quizplus.com/quiz/36637
Sample Questions
Q1) When creating a parameter query,the prompt is enclosed in ________.
A)parentheses ( )
B)braces { }
C)brackets [ ]
D)quotations " "
Q2) Validation rules are entered in the ________ pane.
A)Field Properties
B)Validation
C)Rules
D)Data macro
Q3) When most people in a database reside in New York,you should make NY the ________ value for the State field.
A)data validation rule
B)default
C)lookup field
D)input mask
Q4) The Validation Text property is used to display a message when the corresponding validation rule is not met.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 9: What If Analysis: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/36638
Sample Questions
Q1) To optimize the monthly payments,you would designate the home cost,down payment,APR,and number of years for the loan as the ________ variable cells.
A)changing
B)objective
C)dependent
D)independent
Q2) ________ are restrictions or limitations imposed on Solver as it determines the optimum value.
A)Bounds
B)Constraints
C)Restraints
D)Controls
Q3) When entering text to be displayed in the column headings of a data table,the text must be enclosed in quotation marks.
A)True
B)False
Q4) Data tables can be constructed using one,two,or three variables.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 10: Time Saving Tools: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/36639
Sample Questions
Q1) When working with a lengthy document,you may want to create a master document with ________.
A)subordinate documents
B)subdocuments
C)slave documents
D)partial documents
Q2) You can ________ a location so that you can quickly find the location in a document.
A)hyperlink
B)bookmark
C)flag
D)tag
Q3) Word templates can be downloaded from microsoft.com.
A)True
B)False
Q4) Theme colors CANNOT be revised.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 11: Time Saving Tools: Using Templates multiple
Documents and Themes
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36640
Sample Questions
Q1) You can continue to edit individual subdocuments in Word after you insert them into a master document.
A)True
B)False
Q2) To save an item that you have created as AutoText,click the ________ tab.
Q3) Shadowing,glows,and borders are part of the theme: A)effects.
B)templates.
C)colors.
D)fonts.
Q4) A padlock is associated with the ________ feature in Word.
A)Subdocuments
B)Master documents
C)Combine
D)Compare
Q5) Deleting a subdocument from a master document also deletes the actual subdocument file permanently.
A)True
B)False
Q6) Templates have ________ to allow users to type information into the document. Page 15
To view all questions and flashcards with answers, click on the resource link above.
Page 16
Chapter 12: Interactivity and Advanced Animation: Engaging the Audience
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/36641
Sample Questions
Q1) Points on a motion path can be dragged off of the path line to delete them.
A)True
B)False
Q2) It is recommended that when you link from a menu slide in a presentation to a topic slide in the same presentation,you should create a(n):
A)link back to the menu slide.
B)automatic link to the following slide.
C)submenu on the follow-up slide.
D)link to the final slide in the presentation.
Q3) To apply a motion path,first select the object and then click the ________ tab.
Q4) The ________ action button automatically moves to the last slide in a slide show.
Q5) How do you reshape a motion path?
Q6) A hyperlink can be attached to a WordArt object.
A)True
B)False
Q7) The ________ Pane can be opened from the Animations tab and the Advanced Animation group.
Page 17
Q8) A(n)________ is set so when a user clicks text or an object on a slide,an image appears.
To view all questions and flashcards with answers, click on the resource link above.
Page 18
Chapter 13: What If Analysis
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/36642
Sample Questions
Q1) Multiple objective cells can be used with Goal Seek.
A)True
B)False
Q2) Which of the following is not a method supported by Solver?
A)GRG Nonlinear
B)Simplex LP
C)Evolutionary
D)Duplex
Q3) What what-if analysis tool would you use to compare the impact of different interest rates on a car payment?
A)Solver
B)Goal Seek
C)One-variable data table
D)Two-variable data table
Q4) The ________ replaces the original input value of a variable in a data table.
Q5) ________ has the ability to generate Answer Reports.
A)Goal Seek
B)One-variable data table
C)Solver
D)Two-variable data table
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 14: Action and Specialized Queries: Moving Beyond the Select Query
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/36643
Sample Questions
Q1) Why should you backup your database before testing an action query?
A)Action queries change data in your database that cannot be reversed.
B)Action queries change data in your database but the changes are temporary.
C)Action queries do not make any changes to your database.
D)Action queries duplicate data in your database.
Q2) An append query is a query that:
A)copies records from one table to another.
B)changes the data values in one or more fields that meet specific criteria.
C)automatically creates a new table from data that already exists.
D)removes records from a table based on criteria.
Q3) Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.
A)True
B)False
Q4) If you would like to add data from an Excel spreadsheet to an existing Access table,you might use a(n)________ query.
Q5) Why is it better to enter zero in a field instead of leaving the field blank?
Q7) How do appended records appear in the destination table? Page 20
Q6) To remove the duplicate records found in a table,you would run a(n)________ query.
To view all questions and flashcards with answers, click on the resource link above.
Page 21
Chapter 15: Interactivity and Advanced Animation: Hands
On Exercise Videos
Available Study Resources on Quizplus for this Chatper
15 Verified Questions
15 Flashcards
Source URL: https://quizplus.com/quiz/36644
Sample Questions
Q1) The motion path of a custom path is indicated by a:
A)solid red line.
B)dashed green line.
C)red starting point and a green ending point.
D)green starting point and a red ending point.
Q2) You can enter a subject to an e-mail link by right-clicking the link,clicking Edit Hyperlink,and then entering the subject in the Subject box.
A)True
B)False
Q3) You use the Animation ________ to modify an animation.
A)Panel
B)Pane
C)Menu
D)Ribbon
Q4) The only way to create an e-mail hyperlink is to click Hyperlink in the Links group,select E-mail Address,and then type the e-mail address.
A)True
B)False
22
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Action and Specialized Queries: Hands On
Exercise Videos
Available Study Resources on Quizplus for this Chatper 14 Verified Questions 14 Flashcards
Source URL: https://quizplus.com/quiz/36645
Sample Questions
Q1) To find the same values in a table,you would use the Find ________ Query Wizard.
A)Repeated
B)Alike
C)Matching
D)Duplicates
Q2) A(n)________ query is used to copy new employee records from one table and add them to an existing table.
A)make table
B)append
C)select
D)dispose
Q3) You would use a(n)________ query to make changes to the retail price field for records meeting a specified criteria.
A)select
B)update
C)append
D)make table
Q4) The results of running an update query can be reversed using the Undo button. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 23
Chapter 17: Specialized Functions: Hands On Exercise
Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/36646
Sample Questions
Q1) DMIN is a database function.
A)True
B)False
Q2) CUMIPMT and CUMPRINC are lookup functions.
A)True
B)False
Q3) Entering an IF in the Value_if_true box or in the Value_if_false box,creates a(n)________ function.
A)embedded
B)complex
C)compound
D)nested
Q4) You would use the ________ function to return the position of a value in a list.
A)AND
B)IF
C)MATCH
D)INDEX
Q5) MATCH and INDEX are logical functions. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 18: Document Automation: Hands On Exercise
Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/36647
Sample Questions
Q1) When protecting a form,you must provide a password.
A)True
B)False
Q2) Theme colors CANNOT be revised.
A)True
B)False
Q3) Before you can insert form controls in a document,you must first add the DEVELOPER tab to the ribbon.
A)True
B)False
Q4) A ________ Content Control is used to display a series of options from which users can select.
A)Rich Text
B)Plain Text
C)Building Block Gallery
D)Drop-Down List
Q5) When creating a form for users who may not have Word 2013,you should use legacy form controls instead of content controls.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 19: Document Automation: Forms, macros, and Security
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/36648
Sample Questions
Q1) You set ________ to prevent users from changing the content of a document.
A)IRM
B)editing restrictions
C)user exceptions
D)formatting restrictions
Q2) The ________ in Microsoft Office helps protect users from unsafe macros.
A)Trust Center
B)Protect Document button
C)NewMacros project
D)Check for Issues button
Q3) A document that requires a password to open it must also have another password to modify the content.
A)True
B)False
Q4) Users can select a cover page,header,footer,or predefined text from a Building Block Gallery.
A)True
B)False
Q5) The process of creating a macro is called ________ macro.
Q6) Macros are stored in a macro project called ________ in the Normal template. Page 26
To view all questions and flashcards with answers, click on the resource link above. Page 27
Chapter 20: Customization: Customizing Powerpoint and the Slide Show
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/36649
Sample Questions
Q1) All new tabs and groups can be renamed,but the names cannot include a space. A)True
B)False
Q2) If more than one hyperlink exists on a slide,all hyperlinks must be accessed before the main custom slide show can be viewed.
A)True
B)False
Q3) Multiple custom slide shows can be linked together with hyperlinks. A)True
B)False
Q4) The ________ Ribbon feature in the PowerPoint Options dialog box allows you to personalize a tab on the Ribbon.
Q5) Press ________ during a presentation to reveal a hidden slide.
Q6) ________ fonts are scalable fonts supported by Windows.
Q7) The two tabs included in the Colors dialog box to make color choices are:
A)Color1 and Color2.
B)Standard and Custom.
C)Custom and Select.
D)Cold and Warm.
Q8) HSL,a color model,stands for hue,saturation,and ________. Page 28
To view all questions and flashcards with answers, click on the resource link above. Page 29
Chapter 21: Specialized Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/36650
Sample Questions
Q1) Returns the value or the reference to a value within a range based on X and Y coordinates.
A)DSUM
B)INDEX
C)IPMT
D)PPMT
Q2) If payments are made at the end of the month the type argument should be set to ________ when using the IPMT function
Q3) Which of the following logical functions will return a value if false if one of the arguments is false?
A)OR
B)AND
C)NOT
D)IF
Q4) In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)),F5*K7 is the:
A)Value_if_true.
B)Value_if_false.
C)Logical_test.
D)Modifier.
Q5) What is the difference between advanced filtering and database functions?
Page 30
To view all questions and flashcards with answers, click on the resource link above.
Chapter 22: Advanced Forms and Reports: Moving Beyond the Basics
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/36651
Sample Questions
Q1) After adding grouping,a ________ appears just above the Detail section in Design view,along with the name of the field by which you are grouping.
A)Group header
B)Group footer
C)Page header
D)Form header
Q2) The ________ is the sequential advancing in a form from one field to the next.
A)tab order
B)bound control
C)unbound control
D)calculated control
Q3) A page footer appears at the bottom of the last page of a form or report.
A)True
B)False
Q4) Where would you go to change tab order in a form?
A)Design view - Tab order in Tools group
B)Property sheet
C)Datasheet view - Tab order in Tools group
D)Detail section
Q5) How can you add emphasis to a form or report?
To view all questions and flashcards with answers, click on the resource link above. Page 31
Chapter 23: Customization: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/36652
Sample Questions
Q1) When creating your own custom color theme,you can change Text/Background colors as well as the Accent colors.
A)True
B)False
Q2) Personal information such as the user name and initials are entered by clicking ________ in the PowerPoint Options dialog box.
A)Personalization
B)Advanced
C)General
D)Account
Q3) An object placed on the slide master appears on every slide layout.
A)True
B)False
Q4) To initiate the AutoCorrect options,you click Language in the PowerPoint Options dialog box.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
32
Chapter 24: Advanced Forms and Reports: Hands On
Exercise Videos
Available Study Resources on Quizplus for this Chatper
12 Verified Questions
12 Flashcards
Source URL: https://quizplus.com/quiz/36653
Sample Questions
Q1) If you want users to view a form but not make any changes to its data,you would use a ________ form.
A)protected
B)locked
C)secure
D)read-only
Q2) By using a ________,you can create a form that displays records from two related tables.
A)linked form
B)subordinate form
C)subform
D)mini-form
Q3) To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.
A)Changes dialog box
B)Property Sheet
C)Protection dialog box
D)Attributes Sheet
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 25: Statistical Functions: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/36654
Sample Questions
Q1) The QUARTILE.EXC functions returns values in the range:
A)0 to 4
B)1 to 4
C)0 to 3
D)1 to 3
Q2) The SUMIF function is used when finding a total having more than one criterion.
A)True
B)False
Q3) Which of the following is NOT a descriptive statistical function?
A)DAVERAGE
B)STDEV.P
C)VAR.S
D)FREQUENCY
Q4) Which of the following is NOT an Analysis Toolpak tool?
A)Analysis of variance
B)Covariance
C)Histogram
D)Standard deviation
To view all questions and flashcards with answers, click on the resource link above. Page 34
Chapter 26: Word and the Internet: Hands On Exercise
Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/36655
Sample Questions
Q1) Twitter is one of the largest blog providers on the Internet.
A)True
B)False
Q2) The Word themes used for an ordinary document can also be used for a Web page document.
A)True
B)False
Q3) Which of the following is an example of CamelCase notation?
A)new_order
B)Neworder
C)newOrder
D)NewOrder
Q4) To make Web site files and folders easier to read,you should use spaces in their names.
A)True
B)False
Q5) When saving a simple Word document as a Web page,you should save it as a Single File Web Page (*.mth;*.mthl).
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 35
Chapter 27: Word and the Internet: Web Page Creation and Enhancement
and Blogs
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/36656
Sample Questions
Q1) Which of the following statements about creating a new tab is TRUE?
A)A new group named New Group (Custom)is automatically created.
B)Two new groups are automatically created with a new tab.
C)New tabs retain the new tab name of Custom tab 1,Custom tab 2,etc.
D)New groups can be created for a new tab;individual commands cannot.
Q2) Your blog can include WordArt,pictures,and symbols.
A)True
B)False
Q3) The Present Online feature is new in Word 2013.What is the purpose of this feature and how do you access it?
Q4) Saving a Word document as an .html file compresses it and allows you to easily send all Web sites that are part of that file to someone.
A)True
B)False
Q5) All the following are options on the Share feature on the File tab EXCEPT:
A)Present Offline.
B)Invite People.
C)Email.
D)Post to Blog.
To view all questions and flashcards with answers, click on the resource link above. Page 36
Chapter
28: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/36657
Sample Questions
Q1) Which of the following document properties is entered automatically?
A)Date and time
B)Author and title
C)Author and subject
D)Title and keywords
Q2) All PowerPoint 2013 features are fully supported when saved as an OpenDocument presentation.
A)True
B)False
Q3) The Compatibility Checker corrects all problems with features that you have used in PowerPoint 2013 but will not be compatible with previous PowerPoint versions.
A)True
B)False
Q4) ________ are text notes that are attached to a slide in a presentation.
Q5) Your mouse can be used as a laser pointer while displaying a PowerPoint file. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 37
Q6) If you receive a file with a Mark as Final designation,what can or can't you do,and what does that tell you?
Chapter 29: Statistical Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/36658
Sample Questions
Q1) The PERCENTRANK.INC function excludes 0 and 1.
A)True
B)False
Q2) The ________ function calculates the variance of a population.
Q3) Which of the following functions does not base its calculations on data samples?
A)STDEV.S
B)VARPA
C)VAR.S
D)STDEVA
Q4) By default the Analysis ToolPak is active.
A)True
B)False
Q5) ________ calculates the variance of a sample.
Q6) The FREQUENCY function can count words.
A)True
B)False
Q7) The Analysis ToolPak appears in the Data tab.
A)True
B)False
Q8) ________ a measure of how two sets of data vary simultaneously.
To view all questions and flashcards with answers, click on the resource link above. Page 38
Chapter 30: Get Connected: Exchanging Data Between
Access and Other Applications
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/36659
Sample Questions
Q1) JPEG and other photo formats increase the database size byte for byte.
A)True
B)False
Q2) What is the main reason for exporting data to Excel instead of Word?
A)You are not able to analyze the data as you can in Excel.
B)The data can be manipulated the same as in Excel.
C)Charts can be made in Word just as in Excel.
D)Table information looks the same in both Word and Excel.
Q3) When you export an object from Access to Word,Access creates a file in the PDF format.
A)True
B)False
Q4) The objects you select to export from Access to Word should have which of the following types of layout?
A)Tabular
B)Stepped
C)Block
D)Outline
Page 39
Q5) If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 31: Collaboration and Distribution: Hands On
Exercise Videos
Available Study Resources on Quizplus for this Chatper
15 Verified Questions
15 Flashcards
Source URL: https://quizplus.com/quiz/36660
Sample Questions
Q1) Mark as Final and Encrypt with Password are two ________ options.
A)Presentation Security
B)Defensive Actions
C)Lock Presentation
D)Protect Presentation
Q2) A(n)________ is a text note that is attached to a slide and can be view when the presentation is not running.
A)inscription
B)annotation
C)notation
D)comment
Q3) An annotation made on a slide during a presentation can be printed.
A)True
B)False
Q4) While a presentation is running,you can use the ________ to draw lines on the slide.
A)Highlighter
B)Marker
C)Pen
D)Pencil
To view all questions and flashcards with answers, click on the resource link above. Page 40
Chapter 32: Get Connected: Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/36661
Sample Questions
Q1) You are limited to one attachment per record.
A)True
B)False
Q2) To open the Attachments dialog box,you ________.
A)point to the paperclip icon and press F2
B)click the paperclip icon
C)double-click the paperclip icon
D)right-click the paperclip icon
Q3) When displaying a form or report,you would use an attachment control to manage your attached files.
A)True
B)False
Q4) When importing a fixed-length text file,the values in any field must have the same number of characters.
A)True
B)False
Q5) You can export an Access query to an Excel spreadsheet,but you CANNOT export a report.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 33: Multiple Sheet Workbook Management: Hands
On Exercise Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/36662
Sample Questions
Q1) A formula that references itself is called a(n)________ reference.
A)absolute
B)reliant
C)circular
D)dependent
Q2) To examine multiple worksheets in the same workbook at the same time,you use New Window and Arrange All located on the ________ tab.
A)PAGE LAYOUT
B)VIEW
C)INSERT
D)DESIGN
Q3) When linking to an external workbook,the workbook name is surrounded by single quotation marks.
A)True
B)False
Q4) Which of the following references is written incorrectly?
A)=[e09h2Indianapolis_LastFirst.xlsx]Yearly Totals!$F$3
B)="October Sales"!E3+"November Sales"!E3+"December Sales"!E3
C)="[e09h2Bloomington_LastFirst.xlsx]Yearly Totals"!$F$3
D)=SUM("Qtr1:Qtr4"!E3)
To view all questions and flashcards with answers, click on the resource link above. Page 42
Chapter 34: Multiple Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/36663
Sample Questions
Q1) When is the input message displayed in a cell that contains a validation rule?
A)When the user violates a rule
B)When the cell is clicked
C)When the workbook is opened
D)When the cell is double-clicked
Q2) ________ is the process of dividing a worksheet window into two or four resizable windows.
Q3) The Watch Window will update as user defined cells change.
A)True
B)False
Q4) Which of the following is not a formula auditing tool?
A)Trace Precedents
B)Watch Window
C)Calculation Options
D)Trace Dependents
Q5) The #NUM! error indicates an invalid argument used in a function.
A)True
B)False
Q6) ________ is/are not supported when worksheets are grouped.
Q7) When using the tracer arrows cell with no errors have ________ arrows.
To view all questions and flashcards with answers, click on the resource link above. Page 43
Chapter 35: Fine Tuning the Database: Analyzing and Improving Database Performance
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/36664
Sample Questions
Q1) A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.
A)True
B)False
Q2) Digital certificates are electronic,encryption-based,secure stamps of authentication.
A)True
B)False
Q3) A(n)________ occurs when the value of one field is determined by the value of another.
A)functional dependency
B)non-key field
C)composite key
D)primary key
Q4) The Database Documenter creates a report that contains detailed information about the tables and other selected objects in your database.
A)True
B)False
Q5) What does the Database Documenter list?
Page 44
To view all questions and flashcards with answers, click on the resource link above.
Chapter 36: Fine Tuning the Database: Hands On Exercise
Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/36665
Sample Questions
Q1) You would use the ________ to evaluate a database and produce results for optimizing the database.
A)Performance Analyzer
B)Database Documenter
C)Table Analyzer
D)Database Splitter
Q2) You should consider using the Database Splitter tool to see if the performance of a database can be improved.
A)True
B)False
Q3) When you use the Database Splitter tool,it splits a database into two files:
A)major and minor
B)primary and secondary
C)independent and dependent
D)front-end and back-end
Q4) If you lose the password of an encrypted database,you can contact Microsoft to unlock the database.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 45
Available Study Resources on Quizplus for this Chatper
13 Verified Questions
13 Flashcards
Source URL: https://quizplus.com/quiz/36666
Sample Questions
Q1) The ________ function is used to change NEW YORK to New York.
A)CONCATENATE
B)UPPER
C)LOWER
D)PROPER
Q2) Data imported from an Access table is formatted as a range of cells.
A)True
B)False
Q3) You can use ________ in conjunction with data in existing columns to separate the data into distinct columns.
A)Format Painter
B)Flash Fill
C)Copy with Paste Special
D)the fill handle
Q4) To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1,you would type ________.
A)=SWAP(A1,"-","")
B)=EXCHANGE(A1,"-","")
C)=SUBSTITUTE(A1,"-","")
D)=REPLACE(A1,"-","")
To view all questions and flashcards with answers, click on the resource link above. Page 46
Chapter 38: Imports, web Queries, and XML
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/36667
Sample Questions
Q1) What governing body created XML?
A)IEEE
B)World Wide Web Consortium
C)The Computer Science Society
D)ICANN
Q2) Which of the following functions does not manipulate text?
A)CONCATENATE
B)PROPER
C)UPPER
D)INDEX
Q3) Web queries refresh data automatically.
A)True
B)False
Q4) What is the maximum number of strings that can be manipulated with the CONCATENATE function?
A)25
B)125
C)200
D)255
Q5) When using XML,the ________ contains the name of an element preceded by a slash.
To view all questions and flashcards with answers, click on the resource link above. Page 47
Chapter 39 : Using Macros and SQL in Access: Advanced Techniques
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/36668
Sample Questions
Q1) Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.
A)True
B)False
Q2) When modifying a macro in the Macro Designer,it is not necessary to save because Access saves automatically.
A)True
B)False
Q3) There are three keywords found in a typical SQL SELECT statement: SELECT,FROM,and ORDER BY.
A)True
B)False
Q4) Microsoft has developed its own version of SQL for Access,which varies slightly from the industry standard SQL language.
A)True
B)False
Q5) The Macro Designer enables you to create and edit macros. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 48
Chapter 40: Using Macros and SQL in Access: Hands On
Exercise Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/36669
Sample Questions
Q1) You must end very SQL statement with a ________.
A)comma (,)
B)period (. )
C)colon (:)
D)semicolon (;)
Q2) A(n)________ macro can be attached to a command button control on a form.
A)dependent
B)external
C)embedded
D)stand-alone
Q3) You can use the Macro ________ to edit a macro.
A)Analyzer
B)Documenter
C)Designer
D)Wizard
Q4) Which of the following events CANNOT be used as a trigger for a macro?
A)On Click
B)Before Change
C)After Update
D)While Open
To view all questions and flashcards with answers, click on the resource link above. Page 49
Chapter 41: Collaboration and Workbook Distribution:
Hands On Exercise Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/36670
Sample Questions
Q1) You can display the ________ between the Ribbon and the Formula Bar so the document properties are always shown.
A)Document Properties Panel
B)Document Information Panel
C)Document Properties Pane
D)Document Information Pane
Q2) To delete a comment from a cell,you:
A)double-click the cell and select Delete Comment.
B)right-click the cell and select Delete Comment.
C)click in the comment and click Cut on the HOME tab.
D)click in the comment and Press Delete.
Q3) You use the ________ to find any content that might cause difficulties for users.
A)Accessibility Inspector
B)Accessibility Checker
C)Content Inspector
D)Content Checker
Q4) You CANNOT retrieve a lost SkyDrive password.
A)True
B)False
50
To view all questions and flashcards with answers, click on the resource link above.
Chapter 42: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/36671
Sample Questions
Q1) Where is the Share Workbook command located within Excel?
A)Data tab
B)Insert tab
C)Formulas tab
D)Review tab
Q2) Hidden comments do not print.
A)True
B)False
Q3) Which of the following changes will Excel not track?
A)Functions
B)Formulas
C)Deletion
D)Formatting
Q4) Which Excel Options category contains Editing options?
A)General
B)Advanced
C)Formulas
D)Trust Center
Q5) When a history worksheet is created,it is ________ when the file is saved.
Q6) The default file format for Excel 2013 files is ________.
51
To view all questions and flashcards with answers, click on the resource link above.
Chapter 43: Templates styles and Macros
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/36672
Sample Questions
Q1) Where is the Protect Sheet command located in the Ribbon?
A)Backstage
B)Formulas tab
C)Review tab
D)Data tab
Q2) Locked cells cannot be ________.
Q3) What are the benefits of using macros?
Q4) The file extension for an Excel Macro-Enabled Workbook is ________.
Q5) Which of the following is not a tool to improve efficiency in a common workbook that is used by numerous employees in a business?
A)Template
B)Macros
C)Themes
D)Print settings
Q6) A(n)________ is a collection of format settings based on the currently selected theme to provide a consistent appearance within a worksheet and among similar workbooks.
Q7) The ________ function should be used to trap errors when creating templates.
Q8) By default,the macro recorder uses ________ references.
Q9) New templates can be located and viewed in the ________. Page 52
To view all questions and flashcards with answers, click on the resource link above. Page 53
Chapter 44: Templates, styles, and Macros:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
18 Verified Questions
18 Flashcards
Source URL: https://quizplus.com/quiz/36673
Sample Questions
Q1) A ________ is a predefined document structure that defines basic document settings,such as font,margins,and available styles.
A)template
B)style
C)theme
D)pattern
Q2) To make it easier to run a macro,you can assign the macro to ________.
A)the Ribbon
B)a menu
C)the Quick Access toolbar
D)a button
Q3) After a macro has been added to a template,you should click Save to save the template with the macro.
A)True
B)False
Q4) To protect a worksheet,you click Format in the ________ group.
A)Cells
B)Worksheet
C)Workbook
D)Editing
To view all questions and flashcards with answers, click on the resource link above. Page 54