Computer Applications
Exam Review
Course Introduction
This course offers a comprehensive introduction to essential computer applications commonly used in academic, professional, and personal settings. Students will develop practical skills in word processing, spreadsheet management, presentation creation, and database handling using industry-standard software suites. The course emphasizes hands-on experience, enabling students to efficiently create, edit, and manage documents, analyze data, and design impactful presentations. Additional topics include file management, internet research, email communication, and basic cybersecurity. By the end of the course, students will be equipped with the digital literacy necessary to succeed in a technology-driven environment.
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) Changes made to a PivotChart are automatically reflected in the corresponding PivotTable.
A)True
B)False
Answer: True
Q2) A(n)________ allows you to summarize and examine data such as analyzing book sales by categories.
A)PowerPivot
B)Table Analysis
C)PivotTable
D)Aggregate Analysis
Answer: C
Q3) When creating a calculated field in a PivotTable,range names and cell references outside the PivotTable CANNOT be used.
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
Videos
16
Source URL: https://quizplus.com/quiz/36631
Sample Questions
Q1) An inverse uses light-colored text on a dark-colored background. A)True
B)False Answer: False
Q2) 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
Q3) OLE stands for ________.
A)OnLine Editing
B)Object Linking and Embedding
C)OnLine Embedding
D)Object Labeling and Editing
Answer: B
Q4) A masthead is used to identify information at the top of a newsletter or other periodical.
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) 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
Q2) ________ is NOT an option available in the Drop Cap dialog box.
A)Number of lines to drop
B)The letter for the drop cap initial
C)The size of the drop cap initial
D)How far from the text the drop cap displays
Answer: B
Q3) The ________ of a document offers identifying information at the top of a newsletter.
Answer: masthead
Q4) A(n)________ is a phrase or sentence taken from an article to emphasize a key point.
Answer: pull quote
Page 5
Q5) A(n)________ is a geometric or nongeometric object such as a rectangle,star,or arrow.
Answer: shape
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) Data increments on a chart's Y-axis can be manually changed.
A)True
B)False
Q2) What does ##### represent in a cell in Excel?
A)The cell contains a formula that has not yet displayed.
B)That cell is linked to a PowerPoint slide.
C)There is an error in the cell.
D)The cell is not wide enough to display the data.
Q3) Match the following chart elements with their descriptions:
I.plot area
II.chart area
III.data points
IV.data series
V.multiseries
A.cells that contain numeric values
B.area representing the data
C.contains data points that represent a set of related numbers
D.the chart and all of its elements
E.data for two or more sets of data
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q4) Column ________ are used to identify the contents of the columns of a table.
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) ________ 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.
Q2) Once grouped,columns cannot be ungrouped.
A)True
B)False
Q3) Which of the following is the best tool for analyzing employee performance over a period of time?
A)Data table
B)PivotTable
C)Subtotals
D)Outline
Q4) When editing a PivotTable where are values field settings edited?
A)PivotTable Design tab
B)Data tab
C)PivotTable Fields task pane
D)Formulas tab
Q5) What are the benefits of using PivotTables over traditional data tables?
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) When you violate a validation rule,Access allows you to continue entering the record. A)True
B)False
Q2) A(n)________ property sets the property of a field to force data entry.
Q3) The default Required setting for all fields except the primary key field is Yes. A)True
B)False
Q4) [Enter city] on the criteria line of a query is an example of the criteria in a parameter query.
A)True B)False
Q5) If you run a query and a dialog box appears asking you to enter data,it is a ________.
Q6) The Date function is commonly used as a default value for a date field. A)True B)False
Q7) The ________ function returns a number rounded to a specific number of decimal places.
Q8) What can you use to create an expression to calculate lapsed time? 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) To select all slices in a pie,you double-click any slice.
A)True
B)False
Q2) When a table is embedded,any changes to the source data file are reflected in the presentation.
A)True
B)False
Q3) You can use a table ________ to apply formatting to the table components based on the theme of your presentation.
A)style
B)template
C)pattern
D)design
Q4) 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
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) The Validation Text property is used to display a message when the corresponding validation rule is not met.
A)True
B)False
Q2) Using the Round function with only one parameter rounds the numerical value of the parameter to the nearest ________.
A)whole number
B)tenth
C)hundredth
D)thousandth
Q3) Validation rules are entered in the ________ pane.
A)Field Properties
B)Validation
C)Rules
D)Data macro
Q4) The table that contains the values for a lookup field CANNOT be modified.
A)True
B)False
Page 12
To view all questions and flashcards with answers, click on the resource link above.
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) Given an interest rate,the number of years,and a planned down payment,you would use ________ to find the highest cost of a house you can afford while maintaining the monthly payment.
A)a one-variable data table
B)a two-variable data table
C)Solver
D)Goal Seek
Q3) When using Solver,the ________ cell contains the formula used to optimize the results.
A)objective
B)pivotal
C)changing
D)optimizing
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) Word templates can be downloaded from microsoft.com.
A)True
B)False
Q2) When two documents are combined,you have the option to combine them into a new document.
A)True
B)False
Q3) Theme fonts can be revised.
A)True
B)False
Q4) The ________ pane allows you to move through a document by viewing headings,pages,and search results.
A)Inspect
B)Viewing
C)Search
D)Navigation
Q5) 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) Which of the following is NOT affected by theme effects?
A)Borders around graphics
B)Shapes
C)Text
D)SmartArt
Q2) After you create a bookmark,you can move it to any location in the document.
A)True
B)False
Q3) Deleting a subdocument from a master document also deletes the actual subdocument file permanently.
A)True
B)False
Q4) Which of the following statements is TRUE about master documents and subdocuments?
A)You can issue locks to all the subdocuments collectively.
B)When a master document is locked,all subdocuments are automatically unlocked.
C)When a master document is locked,all subdocuments are locked.
D)Changes can be made to a master document at any time,but to subdocuments only when they are unlocked.
Q5) The Navigation Pane button is a(n)________ which will only turn on or off.
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) A(n)________ is set so when a user clicks text or an object on a slide,an image appears.
Q2) A trigger must use animation.
A)True
B)False
Q3) Click the ________ tab to begin the processing of adding a hyperlink to a slide.
Q4) An End action button moves to the end of the last bullet on the current slide.
A)True
B)False
Q5) The ________ action button automatically moves to the last slide in a slide show.
Q6) Which of the following is NOT a timing option setting available for a slide object?
A)Set the animation to repeat unlimited times
B)Set the animation to rewind
C)Determine how an animation is triggered
D)Set the method for starting an animation
Q7) A(n)________ arrow on a motion path indicates the ending point of the path.
Page 16
Q8) ________ create interactivity by branching to slides or other locations such as additional files on the same storage device.
To view all questions and flashcards with answers, click on the resource link above.
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) Which what-if analysis tool is best suited to determine the input value needed to achieve a specific output?
A)Solver
B)Scenario Manager
C)Goal Seek
D)Two-variable Data Table
Q2) When creating a one-variable data table,one or more formulas that relate to the variable must be used.
A)True
B)False
Q3) A substitution value replaces the original input value of a variable in a data table.
A)True
B)False
Q4) Which of the following tools has the ability to manipulate constraints?
A)Goal Seek
B)Solver
C)Scenario Manager
D)Two-variable Data Table
Q5) Scenario summary reports are placed on/in a ________.
To view all questions and flashcards with answers, click on the resource link above. Page 17
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 must care be taken when running a delete query?
Q2) Duplicate values in a table can prevent you from:
A)enforcing referential integrity.
B)adding additional records.
C)having an accurate database.
D)running an append query.
Q3) Backing up the database prior to running an update query is the best precaution.
A)True
B)False
Q4) Before running a make table query,what should you do?
A)Preview the datasheet to verify that the records are those that you intend to insert into the table.
B)View the results in Design view.
C)Create the table,you can always delete it if the information is wrong.
D)Create a delete query at the same time.
Q5) To test an update query before running the query,what should you do first?
A)From Design view,click View in the Results group and click Datasheet view.
B)From Design view,click the Run button.
C)From Design view,verify that all fields are listed.
D)From Design view,click Update in the Query type group.
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) You use the ________ to determine how First-Level text,Second-level text,and so on are animated.
A)Text Animation dialog box
B)Group text arrow
C)Advanced Animation dialog box
D)Text Animation Panel
Q2) You use the Animation ________ to modify an animation.
A)Panel
B)Pane
C)Menu
D)Ribbon
Q3) 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
Q4) Which of the following is NOT an animation type?
A)Transition
B)Entrance
C)Emphasis
D)Motion
To view all questions and flashcards with answers, click on the resource link above. Page 19
Chapter 16: Action and Specialized Queries: Hands On
Exercise Videos
Source URL: https://quizplus.com/quiz/36645
Sample Questions
Q1) A purge query is used to remove records from a table.
A)True
B)False
Q2) The ________ Query Wizard would be used to compare customer records in the Customer and Order tables to determine which customers have made no purchases.
A)Find Unmatched
B)List Unmatched
C)Find Missing
D)List Missing
Q3) You CANNOT edit a crosstab query.
A)True
B)False
Q4) You should back up your database before testing an action query.
A)True
B)False
Q5) 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
Chapter 17: Specialized Functions: Hands On Exercise
Videos
Source URL: https://quizplus.com/quiz/36646
Sample Questions
Q1) CUMIPMT and CUMPRINC are lookup functions.
A)True
B)False
Q2) Which of the following is NOT a database function?
A)DAVERAGE
B)DMAX
C)DCOUNT
D)DEFREQUENCY
Q3) Knowing the interest rate,number of payments,and the monthly payments,you would use the ________ function to determine the amount of a loan.
A)FV
B)PV
C)IPMT
D)PPMT
Q4) You would use the ________ function to return the position of a value in a list.
A)AND
B)IF
C)MATCH
D)INDEX
21
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following is NOT a suggestion for creating a secure password?
A)Use upper- and lowercase letters
B)Use something that you will remember,like an address
C)Include numbers
D)Include special characters
Q2) You can assign a keyboard shortcut to a macro,and then use that shortcut to run the macro.
A)True
B)False
Q3) When saving a form containing macros,you save it as ________.
A)Rich Text Format
B)Word XML Document
C)Word Template
D)Word Macro-Enabled Template
Q4) A(n)________ is a series of actions that can be used to automate a repetitive task.
A)procedure
B)macro
C)event
D)argument
To view all questions and flashcards with answers, click on the resource link above. Page 22
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) Macros can be edited and deleted from the Macros dialog box.
A)True
B)False
Q2) When formatting restrictions are set on a document,users CANNOT click the buttons to format,but the keystrokes for formatting are still available.
A)True
B)False
Q3) The process of playing back or using a macro is called ________ macro.
Q4) A file marked as final becomes a read-only file.
A)True
B)False
Q5) The process of creating a macro is called ________ macro.
Q6) You set ________ to prevent users from changing the content of a document.
A)IRM
B)editing restrictions
C)user exceptions
D)formatting restrictions
23
Q7) If the Developer tab is NOT available,click the ________ tab,click Options,and click Customize Ribbon.
To view all questions and flashcards with answers, click on the resource link above.
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) When you give a presentation with hidden slides,you have the option of revealing the hidden slides while displaying the presentation.
A)True
B)False
Q2) When you have added slides to a custom show in the Define Custom Show dialog box,how are the slides displayed?
A)Listed by slide title only
B)Numbered based on their original slide number
C)By original slide number and slide title
D)Numbered based on their position in the new show
Q3) Red used in a presentation tends to gain attention and stimulate people into making decisions.
A)True
B)False
Q4) In the default handout master,where is the page number located?
A)In different locations dependent on the theme
B)On the left of the page
C)At the bottom of the page
D)At the top of the page
To view all questions and flashcards with answers, click on the resource link above. Page 24
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) PPMT should be used to calculate the specific interest paid on one installment of a loan.
A)True
B)False
Q2) The FV function is best suited for calculating the current value of an investment.
A)True
B)False
Q3) Which of the following functions will calculate the total principal paid between select periods?
A)CUMPRINC
B)PPMT
C)IPMT
D)CUMIPMT
Q4) The PV function would be best suited to calculate the future value of an investment.
A)True
B)False
Q5) A(n)________ is a schedule that calculates the interest,principal repayment,and remaining balance of a loan.
To view all questions and flashcards with answers, click on the resource link above. Page 25
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) Which of the following is NOT used when laying out forms and reports?
A)Changing the Allow Edits property to No
B)Controls not bound to specific fields
C)Controls that change each time a new record is displayed
D)Lines,pictures,and other non-data-related elements
Q2) A ________ is a form that enables users to view but not change data.
A)read-only form
B)data entry form
C)sub form
D)split form
Q3) Which of the following appears once at the top of each page in a form or report?
A)Form or Report Page Header
B)Form or Report Page Footer
C)Form or Report Header
D)Form or Report Footer
Q4) What are two options for adding emphasis to your form or report?
A)Line or rectangle control
B)Rectangle or calculated control
C)Unbound or rectangle control
D)Bound or unbound control
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) You can have PowerPoint check both your grammar and spelling as you type.
A)True
B)False
Q3) An object placed on the slide master appears on every slide layout.
A)True
B)False
Q4) PowerPoint's ________ feature enables you to type your initials and have them them replaced by your full name;for example,tn becomes Tom Norton.
A)AutoReplace
B)AutoCorrect
C)AutoComplete
D)AutoFill
Q5) You can create a custom color by selecting amounts of red,green,and yellow. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 27
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) You can adjust the tab order to control the advancement from one field or control to the next.
A)True
B)False
Q3) You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.
A)selection
B)check
C)list
D)combo
Q4) Advanced controls can be used in forms but not in reports. A)True
B)False
28
To view all questions and flashcards with answers, click on the resource link above.
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) Which of the following is NOT a math and statistical function?
A)COUNTIF
B)AVERAGEIF
C)SUMIF
D)MEDIANIF
Q2) A PivotChart is a visual display of tabulated frequencies.
A)True
B)False
Q3) To perform an analysis of variance,you use the ________ tool.
A)ANOVA
B)VAR
C)CORREL
D)COVARIANCE
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 29
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) The Word themes used for an ordinary document can also be used for a Web page document.
A)True
B)False
Q2) Which of the following can you NOT hyperlink to?
A)Another Web folder
B)A bookmark in the current Web page
C)Another Web page
D)A bookmark in another Web page
Q3) Which of the following is an example of CamelCase notation?
A)new_order
B)Neworder
C)newOrder
D)NewOrder
Q4) Twitter is one of the largest blog providers on the Internet.
A)True
B)False
Q5) You can only hyperlink to a bookmark in the current Web page. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 30
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) Online photos must be downloaded and saved to the hard drive first before they can be inserted into a Web page.
A)True
B)False
Q2) When you create a new tab,a new group is automatically created with it.
A)True
B)False
Q3) You may save your Web page as ________ if you want to reduce the file size and Word editing options.
Q4) Word 2013 has all of the capability of a Web development and design program. A)True
B)False
Q5) Are you allowed to use any pictures and videos that you downloaded from the Internet freely?
Q6) The ________ zoom feature will enlarge the inserted online image on a Web page.
Q7) Of the following blog Web sites,only ________ is NOT supported by Word.
A)Blogger
B)Flickr
C)Telligent Community
D)SharePoint Blog Page 31
To view all questions and flashcards with answers, click on the resource link above. Page 32
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) Where does the Document Properties panel appear when in Normal view?
A)Above the selected slide
B)In a separate dialog box
C)Below the selected slide
D)In a panel to the right of the selected slide
Q2) A Mark as Final designation for a file is permanent.
A)True
B)False
Q3) If you remove hidden data from a presentation,you may not be able to restore it with the Undo command.
A)True
B)False
Q4) How is a PowerPoint file output as a video clip,and what would be included in that video?
Q5) Which of the following is NOT a content area checked by the Document Inspector?
A)Comments and Annotations
B)Document Properties and Personal Information
C)Custom XML
D)Mark as Final
Q6) Differences in files using the Compare feature can be accepted or ________. Page 33
To view all questions and flashcards with answers, click on the resource link above. Page 34
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) Which function is best suited to determine how the data set is spread around the mean?
A)COVARIANCE
B)CORREL
C)STDEV.P
D)VARA
Q2) What is the difference between COVARIANCE and ANOVA?
Q3) When using the QUARTILE.INC function which quartile would include the highest value in the dataset?
A)1
B)2
C)3
D)4
Q4) The Analysis ToolPak can be activated in:
A)Formula tab.
B)Excel Options.
C)Review tab.
D)Developer tab.
Q5) The ________ function determines the strength of a relationship between two datasets.
To view all questions and flashcards with answers, click on the resource link above. Page 35
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) PDF documents are the preferred format when exporting from Access.
A)True
B)False
Q2) What is the purpose of a ScreenTip?
A)It displays when you point your mouse over the hyperlink text
B)It modifies what the user sees in Datasheet view
C)It launches the hyperlink
D)It edits the hyperlink
Q3) What do you do if you only want to export part of a table to Excel?
A)Filter the table first
B)You cannot export only part of a table
C)Only reports can be exported
D)Access cannot export to Excel
Q4) What happens to the size of an Access database when a table is linked to an Excel spreadsheet?
A)The size of the database remains the same.
B)The linked table adds space to the database size.
C)The linked table adds space byte for byte.
D)The size of the database decreases in size.
Q5) When there is a file in the ________ field a paperclip appears in the field.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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) To distribute your presentation on a USB device to someone who does not have PowerPoint installed on his or her computer,you use the ________ feature.
A)Package Presentation for USB
B)Package Presentation for CD
C)Universal Share
D)Share PowerPoint
Q2) An annotation made on a slide during a presentation can be printed.
A)True
B)False
Q3) Saving a presentation as a(n)________ Presentation makes it difficult for anyone to modify it.
A)PowerPoint Macro-Enabled
B)PowerPoint Picture
C)PowerPoint 97-2003
D)OpenDocument
Q4) If you forget the password to a protected presentation,you CANNOT unprotect it. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) You can export an Access query to an Excel spreadsheet,but you CANNOT export a report.
A)True
B)False
Q4) When preparing an Excel spreadsheet to be imported into an Access database,the first row of the spreadsheet must have column headings that are recognized as field names by Access.
A)True
B)False
Q5) You can export an Access table or form to another Access database.
A)True
B)False
38
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) To ungroup worksheets,right-click any one of the grouped worksheets' tabs and click Ungroup Sheets.
A)True
B)False
Q2) When linking to an external workbook,the workbook name is surrounded by single quotation marks.
A)True
B)False
Q3) When using Trace Precedents and Trace Dependents,tracer arrows display showing the relationship between cells and formulas.
A)True
B)False
Q4) When Excel detects an error in a formula:
A)the cell containing the formula is surrounded in a green border.
B)a green triangle is displayed in the top-left corner of the cell containing the formula.
C)the cell containing the formula is displayed with a light green fill.
D)the text in the cell containing the formula is displayed in bold green.
To view all questions and flashcards with answers, click on the resource link above. Page 39
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) Dependent cells contain formulas independent of other cells.
A)True
B)False
Q2) A________ is a pointer to a cell in another worksheet.
Q3) What error will cause #NUM! to appear?
A)Invalid arguments in a function
B)Misspelled name
C)Deleted cell reference
D)Invalid range name
Q4) Which function is best used to return a value if an error exists in a cell?
A)IF
B)GETERROR
C)IFERROR
D)VALIDATE
Q5) When worksheets are grouped all structural changes will be copied across worksheets.
A)True
B)False
Q6) What is the difference between a precedent and dependent cell?
Q7) What are the benefits of grouping worksheets?
To view all questions and flashcards with answers, click on the resource link above. Page 40
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) What are four ways to keep your database application safe?
Q2) You should add a(n)________ to any field that will be searched because it reduces the time it takes to run queries and reports when it is added.
Q3) A(n)________ database contains only the tables of a database.
Q4) The ________ contains the queries,forms,and reports of the database.
A)back-end database
B)database documenter
C)front-end database
D)design tools
Q5) To set a password,the database has to be opened in exclusive mode.
A)True
B)False
Q6) The Table Analyzer analyzes the database and normalizes it for you.
A)True
B)False
Q7) A(n)________ is a primary key that is made up of two or more fields.
Q9) What is the main reason for splitting a database? Page 41
Q8) The formal process of deciding which fields should be grouped together into which fields is called ________.
To view all questions and flashcards with answers, click on the resource link above. Page 42
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 should consider using the Database Splitter tool to see if the performance of a database can be improved.
A)True
B)False
Q2) 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
Q3) To make the opening of forms and reports easy for users,you could implement a(n)________ form,which is a menu system that uses tabs.
A)navigation
B)tabbed
C)linked
D)active
Q4) You would use the Performance Analyzer tool to help reduce data redundancies. A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 43
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
13 Verified Questions
13 Flashcards
Source URL: https://quizplus.com/quiz/36666
Sample Questions
Q1) 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,"-","")
Q2) A Web query does not import the data,instead it creates a link to the Web page,which can be refreshed.
A)True
B)False
Q3) Using the Convert Text to Columns Wizard is similar to using the Text Import Wizard.
A)True
B)False
Q4) When creating a Web query,tables in the Web page are indicated by:
A)a solid yellow border.
B)the table text displayed in yellow.
C)the table highlighted in yellow.
D)a yellow selection icon with a right-pointing arrow.
Page 44
To view all questions and flashcards with answers, click on the resource link above.
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) You ________ data when you import data from an external source without maintaining a link to the original data.
Q2) A(n)________ file uses commas to separate data into columns that can be imported into Excel.
Q3) Which of the following is the best option for transferring data between incompatible systems?
A)XHTML
B)CSS
C)XML
D)HTML
Q4) <!-- Created June 29 1979 --> is an XML comment.
A)True
B)False
Q5) Which function is best suited to return the specified number of characters from the middle of a text string?
A)LEFT
B)SUBSTITUTE
C)MID
D)RIGHT
To view all questions and flashcards with answers, click on the resource link above. Page 45
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) An SQL keyword defines the purpose and the structure of a SQL statement.
A)True
B)False
Q2) When does an event occur?
A)When a user enters,edits or deletes data and when users open,use and close forms and reports
B)When the Navigation Pane is displayed and when the macro can be run independently
C)When the Navigation Pane is hidden and when the macro can be run independently
D)When Access executes steps stored in the table lookup fields
Q3) Access provides two methods of programming creating macros and creating procedures using Visual Basic Applications.
A)True
B)False
Q4) Once a macro has been created,you should ________ to initiate the tasks.
A)run the macro
B)convert the macro
C)display the macro
D)control the macro
46
Q5) Data macros can only be used with what event?
To view all questions and flashcards with answers, click on the resource link above.
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 can use the Macro ________ to edit a macro.
A)Analyzer
B)Documenter
C)Designer
D)Wizard
Q2) You must end very SQL statement with a ________. A)comma (,)
B)period (. )
C)colon (:)
D)semicolon (;)
Q3) You use the Macro Wizard to create and edit macros.
A)True
B)False
Q4) You can use an SQL statement in place of a table or query record source.
A)True
B)False
Q5) SQL stands for Sequential Query Language.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 47
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) To distribute a workbook to others so that it retains the same format and cannot be changed,you would save the workbook as a(n)________ file.
A)PDF
B)RTF
C)XLSX
D)TXT
Q2) 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
Q3) 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.
To view all questions and flashcards with answers, click on the resource link above.
Page 48
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) When displayed,the ________ will show file properties directly above the current workbook.
Q2) Which of the following is not an Excel Options category?
A)General
B)Formulas
C)Format
D)Proofing
Q3) Which of the following tools is best suited for checking a workbook for personal data?
A)File Inspector
B)Document Inspector
C)Accessibility Checker
D)Compatibility Checker
Q4) Once a workbook is ________ it is read-only.
Q5) ________ is the maximum number of users that can access a shared file at once.
Q6) The ________ checks the workbook for personal data.
Q7) When a file is created,customizations such as the author's name are saved as ________.
Q9) The Share Workbook command is located on the ________. Page 49
Q8) The ________ should be used to make sure your files are backwards compatible.
To view all questions and flashcards with answers, click on the resource link above. Page 50
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) The VBA editor can be access using the keystroke combination ________.
Q2) Where are custom cell styles saved?
A)The workbook in which you created the style
B)A personal styles workbook
C)My Documents
D)A personal macro workbook
Q3) Which of the following is not controlled with cell style formats?
A)Font attributes
B)Print settings
C)Cell-protection settings
D)Border and fill styles
Q4) Where are Trust Center options located?
A)Data tab
B)Backstage
C)Insert tab
D)Formulas tab
Q5) Recorded macros can be viewed in the ________.
Q6) Excel passwords can be up to ________ characters.
Q7) ________ can be placed in VBA to provide information regarding a macro.
Q8) By default,macros in Excel are ________.
To view all questions and flashcards with answers, click on the resource link above. Page 51
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 protected worksheet can consist of both locked and unlocked cells.
A)True
B)False
Q2) 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
Q3) To automate the task of clear existing values and displaying instructions for users to enter specific data,you would create a(n)________.
A)event
B)procedure
C)argument
D)macro
Q4) If you forget the password to a protected worksheet,you can contact Microsoft to get a replacement password to unprotect it.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.