Computer Literacy
Chapter Exam Questions
Course Introduction
Computer Literacy introduces students to the fundamental concepts, terminology, and practical skills necessary to effectively use computers in daily life and academic environments. The course covers topics such as basic computer hardware and operating systems, file management, internet browsing, email communication, word processing, spreadsheets, and presentation software. Emphasis is placed on developing the confidence and competence to use technology safely, efficiently, and responsibly, preparing students to adapt to the continually evolving digital world.
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) ________ is used to exclude particular categories or values from a PivotTable.
A)Mining
B)Grouping
C)Outlining
D)Filtering
Answer: D
Q2) You can move a field from one PivotTable area to another by just dragging it.
A)True
B)False
Answer: True
Q3) 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
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) OLE stands for ________.
A)OnLine Editing
B)Object Linking and Embedding
C)OnLine Embedding
D)Object Labeling and Editing
Answer: B
Q2) Continuous is one of the ________.
A)section breaks
B)page breaks
C)column options
D)margin options
Answer: A
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) When you right-click a linked object in a Word document,the ________ option allows you to immediately retrieve any changes in the source file.
A)Paste
B)Edit Link
C)Open Link
D)Update Link
Answer: D
Q2) All of the following EXCEPT ________ are considered techniques for readability and attractiveness of desktop publishing documents.
A)grids
B)tables
C)borders
D)lists
Answer: A
Q3) WordArt uses some predefined styles to enhance a long paragraph in a document.
A)True
B)False
Answer: False
Page 5
To view all questions and flashcards with answers, click on the resource link above.
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(n)________ identifies the data series of a chart.
Q2) What happens when you double-click a linked object in PowerPoint?
A)The source application opens and you can edit the source object.
B)The object opens for editing in PowerPoint.
C)The shortcut menu pops up and you can click Open to edit the file.
D)An error pops up that notifies you that the source application cannot be accessed.
Q3) PowerPoint allows up to ________ rows and columns in a table.
A)25
B)50
C)75
D)250
Q4) Which of the following is NOT a method to eliminate a border when combining cells in a table?
A)Select cells,right-click,and select Merge Cells.
B)Select the cells and click Merge Cells.
C)Erase the border.
D)Highlight the border and press Delete.
Q5) OLE stands for ________ and embedding.
Q6) What is a Z-axis on a chart?
To view all questions and flashcards with answers, click on the resource link above. Page 6
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 the process of joining rows or columns of related data together into a single entity.
Q2) Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force?
A)% of Column Total
B)% of Row Total
C)Running Total
D)% of Grand Total
Q3) Where is the Subtotal command located on the Ribbon?
A)Insert tab
B)Data tab
C)View tab
D)Backstage
Q4) A(n)________ is a powerful,interactive data-mining feature that enables you to summarize and analyze data,especially helpful when working with large datasets.
Q5) Multiple subtotals can be applied to one data set.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
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) Validation text restricts the data value that can be entered into a field.
A)True
B)False
Q2) Reports can be created based on the results of a parameter query.
A)True
B)False
Q3) A lookup list accepts multiple values in a single field.
A)True
B)False
Q4) Which data validation method forces users to conform to a specific data-entry format for a given field?
A)Input mask
B)Validation text
C)Default value
D)Data macro
Q5) The default Required setting for all fields except the primary key field is Yes.
A)True
B)False
8
Q6) ________ enable you to execute programming tasks whenever data in a table is changed.
To view all questions and flashcards with answers, click on the resource link above.
Page 9
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 combine a group of cells into a single cell,you click ________ Cells.
A)Join
B)Unite
C)Merge
D)Combine
Q2) A column chart can be used to display a single or multiseries data set.
A)True
B)False
Q3) Clicking Distribute Columns and Distribute Rows ensures that the width and height of all cells will be distributed equally.
A)True
B)False
Q4) When drawing a table,the pointer is displayed as a(n)________.
A)pen
B)pencil
C)cross-hair
D)I-beam
Q5) You can use the Eraser to remove table borders.
A)True
B)False
10
To view all questions and flashcards with answers, click on the resource link above.
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) 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
Q2) The DatePart function has ________ required parameters.
A)1
B)2
C)3
D)4
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) When a field is required,it must have a default value.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) 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
Q2) The ________ value replaces the original input value of the variable in a data table.
A)replacement
B)substitution
C)trial
D)sample
Q3) ________ are restrictions or limitations imposed on Solver as it determines the optimum value.
A)Bounds
B)Constraints
C)Restraints
D)Controls
Q4) A plug-in is a program that has to be added to Excel to extend its functionality.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) A template may include ________,which are fields or blocks of text used to control the location of objects in a document.
A)text boxes
B)proxies
C)placeholders
D)subdocuments
Q2) Word has ________,which are partially completed documents such as letters,memos,reports,and resumes that contain preformatted text and/or graphics.
A)styles
B)layouts
C)themes
D)templates
Q3) To combine two Word documents,you click Merge.
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 13
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) Describe the three elements in a document theme.
Q2) Describe three precautions that you should follow when creating a master document and several subdocuments.
Q3) Match the following Word extensions to their meanings:
I.dotx
II.docx
III.dotm
IV.dot
A.Word 2013 macro-enhanced template
B.Word 2013 template
C.Word 2013 document
D.Word versions prior to 2010 template
Q4) If you want to save a file as a template,you need to change the Save as type to:
A)Word Document.
B)Word template.
C)PDF.
D)Word Macro-Enabled Document.
Q5) To display ________ in a document,make sure that the document is expanded to display the text of the whole document.
Q6) Pressing Ctrl+G opens the ________ tab of the Find and Replace dialog box. Page 14
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) The ________ PowerPoint animation controls how an object leaves or disappears from a slide.
Q2) Click the ________ tab to begin the processing of adding a hyperlink to a slide.
Q3) The direction of a motion path can be reversed.
A)True
B)False
Q4) How can you reshape a motion path?
A)Right-click and select Change.
B)Click each point of the motion path you want to change and drag it.
C)You must redraw a new path over the old.
D)Display the edit points and drag a point to a new location.
Q5) A hyperlink can be attached to a WordArt object.
A)True B)False
Q6) How does a ScreenTip add to a presentation?
Q7) Adding ________,the ability to branch nonsequentially to a different part of a presentation,helps involve the audience and capture their interest.
A)True B)False Page 16
Q8) From an action button,you can run a specific program or application.
To view all questions and flashcards with answers, click on the resource link above.
Page 17
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) 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
Q2) When creating a one-variable data table with substitution values in a vertical column,the formula reference must be on the row below and one column to the left of the first substitution value.
A)True
B)False
Q3) A(n)________ is used to compare the impacts of one variable on a calculated result.
Q4) ________ will vary one input value to reach one optimized result.
Q5) A two-variable data table allows two variables but only one result. A)True
B)False
Q6) Multiple objective cells can be used with Scenario Manager. A)True
B)False
Page 18
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ query can be used for adding records to an existing table.
A)append
B)update
C)make table
D)delete
Q2) What do you do if you make a mistake when running a Find Unmatched query?
A)Delete the query and start over,then reverse the order of the tables.
B)Rerun the query using different fields.
C)Delete associated records in the table.
D)Modify the aggregate function.
Q3) What should be the first step taken before creating an update query?
A)Back up the database
B)Switch to Datasheet view
C)Move the records to a different table
D)Run the query
Q4) 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.
To view all questions and flashcards with answers, click on the resource link above. Page 19
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 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
Q2) 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.
Q3) In PowerPoint,which of the following CANNOT be linked to using a hyperlink?
A)E-mail address
B)Contacts
C)Slide in the presentation
D)Web page
Q4) You can apply an entrance effect or an exit effect to an object,but not both to the same object.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 16: Action and Specialized Queries: Hands On
Exercise Videos
Source URL: https://quizplus.com/quiz/36645
Sample Questions
Q1) A select query is used to select records from one or more tables and use them to create a new table.
A)True
B)False
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) A make table query selects records from one or more tables and uses them to create a new table.
A)True
B)False
Q4) A(n)________ query is used to display aggregate data in a row-and-column layout.
A)summary
B)crosstab
C)action
D)outline
To view all questions and flashcards with answers, click
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) CUMIPMT and CUMPRINC are lookup functions.
A)True
B)False
Q2) =IF(AND(D7="manager",F7<F$3),"Due for raise","NA")is an example of a compound function.
A)True
B)False
Q3) When a loan is repaid,the total principal matches the ________ for the final payment.
A)future value
B)present value
C)total interest
D)cumulative principal
Q4) 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
To view all questions and flashcards with answers, click on the resource link above. Page 22
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) A(n)________ is a series of actions that can be used to automate a repetitive task.
A)procedure
B)macro
C)event
D)argument
Q2) Macros are edited using the ________ editor.
A)Visual Studio
B)Visual Basic
C)Macro
D)Run-Time
Q3) Passwords are NOT case-sensitive;therefore,Tony and tony are considered the same.
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 23
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) If the Developer tab is NOT available,click the ________ tab,click Options,and click Customize Ribbon.
Q2) All forms must be password-protected.
A)True
B)False
Q3) 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
Q4) When a user enters data into an electronic form,the fields in the form are automatically accessed:
A)from the top-left corner to the bottom-right corner.
B)from the left to the right of the table.
C)in the order in which the developer inserted them.
D)from the top of the page to the bottom.
Q5) User must insert a digital image of a signature on the signature line.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 24
Q6) A form ________ is a document that includes layout,structure,and formatting.
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) The ________ and ________ symbols are used to expand and collapse the view of groups within the Customize the Ribbon options of the PowerPoint Options dialog box.
A)++;+
B)*;-
C)+;-
D)#;!
Q2) To be sure a font will be available and accessible for a presentation when presented on another computer,________ the fonts in your presentation.
Q3) A zero for each of the RGB colors in the color model represents:
A)no color at all.
B)blue.
C)white.
D)black.
Q4) ________ custom shows connect a primary custom show to another custom show using links.
Q5) Orientation of handouts of slides cannot be changed.
A)True
B)False
Q6) HSL,a color model,stands for hue,saturation,and ________.
To view all questions and flashcards with answers, click on the resource link above. Page 25
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) Which database function should be used to count records with empty cells?
A)DCOUNT
B)DCOUNTA
C)DGET
D)DSUM
Q2) ________ will return the total interest paid within a time range on a loan.
Q3) CUMIPMT calculates the cumulative interest throughout a loan.
A)True
B)False
Q4) In order for the AND function to return a true value,all arguments must be true.
A)True
B)False
Q5) Advanced filtering will not copy results to a new location.
A)True
B)False
Q6) The FV function is best suited for calculating the current value of an investment.
A)True
B)False
Q7) What is the difference between advanced filtering and database functions?
Page 26
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) A form or report header appears one time at the top of each form or report.
A)True
B)False
Q2) What will cause a group to print on a separate page?
Q3) Which of the following displays when you insert a text box?
A)Label control
B)Text box control
C)Design view control
D)Section control
Q4) Both forms and reports have a text box control,which displays the data found in the record source.
A)True
B)False
Q5) Page breaks can be added at specific locations in forms or reports.
A)True
B)False
Q6) List the five default sections of a report.
27
Q7) If you would like to see subtotals in a report,you would add a(n)________ in the Grouping footer section.
Q8) In which section of a form or report is a company logo usually added?
To view all questions and flashcards with answers, click on the resource link above. Page 28
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) To select every object on a slide,you press ________.
A)Ctrl + A
B)Ctrl + E
C)Ctrl + O
D)Ctrl + S
Q2) When giving a presentation,you can display hidden slides by pressing ________.
A)Ctrl + H
B)H
C)Ctrl + P
D)P
Q3) If a newly created tab is to the right of the desired location on the Ribbon,you can reposition it by using the ________ button.
A)Move Left
B)Move Right
C)Move Up
D)Move Down
Q4) If you do not want your audience to see a slide,you must delete it prior to the presentation.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
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) You can adjust the tab order to control the advancement from one field or control to the next.
A)True
B)False
Q2) Advanced controls can be used in forms but not in reports.
A)True
B)False
Q3) A text box can be converted into a combo box.
A)True
B)False
Q4) A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.
A)True
B)False
Q5) Form headers or report footers are examples of form or report ________.
A)subdivisions
B)divisions
C)segments
D)sections
To view all questions and flashcards with answers, click on the resource link above. Page 30
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) To calculate the number of high school teachers that were hired before 1/1/2005,you would use the COUNT function.
A)True
B)False
Q2) To analyze the trend between SAT scores and attendance,you would calculate the ________.
A)median
B)standard deviation
C)covariance
D)variance
Q3) To test to see if there is a relationship between test scores and attendance,you would use the ________ function.
A)STDEV.S
B)CORREL
C)STDEV.P
D)FREQUENCY
Q4) A PivotChart is a visual display of tabulated frequencies.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 31
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) You can ________ a frequently used template to the Backstage view so that it appears at the top portion of the template selection.
A)post
B)pin
C)attach
D)integrate
Q2) Twitter is one of the largest blog providers on the Internet.
A)True
B)False
Q3) To make Web site files and folders easier to read,you should use spaces in their names.
A)True
B)False
Q4) The default name of a Web site's home page is usually default.html or ________.
A)home.html
B)web.html
C)index.html
D)main.html
To view all questions and flashcards with answers, click on the resource link above. Page 32
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) The command to insert an online video into a document is located in the Media group of the Insert tab.
A)True
B)False
Q2) It is NOT a good idea to substitute spaces in folder and file names with:
A)underscores.
B)CamelCase notation.
C)hyphens.
D)the %20 combination.
Q3) Documents that are part of the WWW are known as Web pages.
A)True
B)False
Q4) A blog created in Word can only be posted to the blog service providers that are enabled in Word.
A)True
B)False
Q5) You may replace the space in a Web folder or file name with CamelCase,hyphen,or
Q7) WWW stands for ________. Page 33
Q6) HTML stands for ________ Markup Language.
To view all questions and flashcards with answers, click on the resource link above. Page 34
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) What is the primary benefit of using the Package Presentation for CD feature of PowerPoint?
A)The file size is substantially reduced from that of a standard presentation.
B)It runs faster than a standard PowerPoint presentation.
C)You can play the presentation on two screens simultaneously.
D)You can play the presentation without having PowerPoint on the computer.
Q2) Comments display in Slide Show mode.
A)True
B)False
Q3) 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
Q4) A table on a slide that includes extensive formatting may display an Error category message in the Accessibility Checker.
A)True
B)False
Q6) What is the Accessibility Checker used for in PowerPoint? Page 35
Q5) ________ are text notes that are attached to a slide in a presentation.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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 of the following will determine the variance of a population?
A)VARA
B)VAR.P
C)VAR.S
D)VARPA
Q2) ANOVA stands for ________.
Q3) The ________ is an Excel add-in that offers powerful tools for statistical analysis.
Q4) Which of the following tools is not included in the Analysis ToolPak?
A)Anova: Single Factor
B)Correlation
C)Rank Average
D)Covariance
Q5) Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text?
A)STDEVA
B)STDEV.P
C)STDEV.S
D)STDEVPA
Q6) The ________ function can be used to perform a single condition summary.
Page 37
To view all questions and flashcards with answers, click on the resource link above.
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) The file extension for a Rich Text Format file is slx.
A)True
B)False
Q2) How do you insert blank lines above a table after exporting it from Access into Word?
A)Click immediately before the first value in the first cell of the table and press Enter to add an additional line.
B)You will have to cut the table and add a blank line,then paste the table back at the new cursor position.
C)You cannot add additional lines above the table.
D)Additional lines will appear below the table by default.
Q3) A(n)________ is the location of a Web site or Web page on the Internet.
A)URL
B)HTTP
C)HTML
D)PDF
Q4) Why would you export the structure of a table to a different database and not the data?
Q5) Why is it easy to export Access tables to Excel?
Q6) What is an imported spreadsheet?
To view all questions and flashcards with answers, click on the resource link above. Page 38
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) A secure password should have uppercase and lowercase letters along with numbers and symbols.
A)True
B)False
Q2) While a presentation is running,you can use the ________ to draw lines on the slide.
A)Highlighter
B)Marker
C)Pen
D)Pencil
Q3) 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
Q4) Keywords,Category,Status are examples of presentation properties.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 39
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 can export an Access table or form to another Access database.
A)True
B)False
Q2) The ________ data type is used to create a link to a Web site.
A)Internet link
B)external link
C)hyperlink
D)Web link
Q3) You CANNOT export Access data to a(n)________.
A)Excel spreadsheet
B)Word document
C)Access table
D)PowerPoint presentation
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 are limited to one attachment per record.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 40
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) 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)
Q2) When creating a data validation rule,you can specify both input message and an alert.
A)True
B)False
Q3) When linking to an external workbook,the workbook name is surrounded by single quotation marks.
A)True
B)False
Q4) When worksheets are grouped,[Group] is displayed in the titles bar immediately after the file name.
A)True
B)False
Q5) A hyperlink to a worksheet always references cell A1 of that worksheet.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 41
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) What happens when data that is externally linked is edited and both the source and destination file are open?
A)The links will automatically update
B)The links will not update
C)A security prompt appears
D)There will be no change
Q2) Which of the following functions does not contain a syntax error?
A)=avg(B1:B9)
B)=AVERAG(B1:B9)
C)=AVERAGE(B1;B9)
D)=AVERAGE(B1:B9)
Q3) Which of the following functions cannot be used as a 3-D formula?
A)SUM
B)PMT
C)AVERAGE
D)MAX
Q4) OctoberSales.xlsx is an example of CamelCase notation.
A)True
B)False
Q5) When worksheets are grouped ________ appears in the title bar.
42
To view all questions and flashcards with answers, click on the resource link above.
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 does the Database Documenter list?
Q2) What are four ways to keep your database application safe?
Q3) The Performance Analyzer evaluates a database and makes recommendations for optimizing the database.
A)True
B)False
Q4) What do the Performance Analyzer Analysis Notes tell you?
Q5) The formal process of deciding which fields should be grouped together into which fields is called ________.
Q6) To set a password,the database has to be opened in exclusive mode.
A)True
B)False
Q7) What is a certification authority?
A)A commercial company that issues and validates identities using digital signatures for a fee
B)An electronic,encryption-based,secure stamps of authentication
C)A guarantee that you are the only one using the database
D)Altering digital information using an algorithm
Q8) What are the benefits of normalization? Page 43
Q9) Name two situations that violate 1NF.
To view all questions and flashcards with answers, click on the resource link above.
Page 44
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) A field that has multiple values separated by commas is an example of a repeating group.
A)True
B)False
Q2) Which of the following is NOT a result of running the Performance Analyzer tool?
A)Suggestions
B)Commands
C)Recommendations
D)Ideas
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) Which of the following is NOT a database security measure?
A)Encrypt and password-protect a database
B)Save the database as an ACCDE file
C)Distribute the database as a PDF file
D)Digitally sign and publish a database
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) In the expression,<High>270.65</High>,the <High> and </High> are referred to as ________.
A)tags
B)markers
C)delimiters
D)identifiers
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) 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) When importing a text file into Excel,you must specify a delimiter.
A)True
B)False
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) Where is the Text to Columns Wizard located in Excel?
A)Data tab
B)Insert tab
C)Formulas tab
D)Backstage
Q2) Which of the following sources cannot be imported into Excel?
A)SQL Server
B)Analysis Services
C)Direct image files from a web page
D)Windows Azure Marketplace
Q3) When creating a Web query which option preserves all original formatting?
A)Rich text
B)HTML formatting
C)XML
D)Style Sheet
Q4) ________ are settings that control how imported data in cells connect to their source data.
Q5) What is the difference between linking imported files and embedding imported files?
Q6) Microsoft Access data tables and ________ can be imported into Excel.
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) Instead of specifying the individual field names in SQL,you can use the asterisk character (*)to select all of the fields.
A)True
B)False
Q2) Data macros are used to ensure the accuracy of data in a(n): A)table. B)report.
C)embedded macro.
D)stand-alone macro.
Q3) In a SELECT statement,field names are listed after the SELECT statement and are separated by commas.
A)True
B)False
Q4) An SQL SELECT statement is used to retrieve reports from tables in a database. A)True
B)False
Q5) What are three reasons for using an SQL statement for a record source?
To view all questions and flashcards with answers, click on the resource link above. Page 48
Q6) The type of macro that is used to validate and ensure the accuracy of data that is entered into a table is called a(n)________ macro.
Chapter 40: Using Macros and SQL in Access: Hands On
Exercise Videos
16 Flashcards
Source URL: https://quizplus.com/quiz/36669
Sample Questions
Q1) A named macro can be used to send an e-mail message when a form is used to change an entry in a table.
A)True
B)False
Q2) A named macro is displayed as an object in the Navigation Pane.
A)True
B)False
Q3) SQL stands for Sequential Query Language.
A)True
B)False
Q4) You can only create data macros from within a table.
A)True
B)False
Q5) A(n)________ macro can be designed to automatically open several tables,forms,or reports.
A)internal
B)independent
C)stand-alone
D)embedded
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) Information such as author,title,and keywords are examples of document
A)properties
B)descriptions
C)identifiers
D)attributes
Q2) When a workbook is shared,[Shared] is displayed after the file name on the title bar.
A)True
B)False
Q3) To edit a comment,you click in the comment and make the desired changes.
A)True
B)False
Q4) To change the author name,you click Options on the FILE tab and enter the new author name.
A)True
B)False
Q5) Check Compatibility is used to verify that critical Excel 2013 features are not lost when a workbook is opened in an earlier version of Excel. A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 50
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) Excel customization options can be located in the ________ area.
Q2) Which of the following is not a default command of the Quick Access Toolbar?
A)Close
B)Save
C)Undo
D)Redo
Q3) Which of the following is not a method for protecting the worksheet against changes?
A)Track Changes
B)Add a signature line
C)Export to PDF
D)Mark as Final
Q4) What are some ways to protect a workbook?
Q5) If a password is lost is cannot be ________.
Q6) Change tracking can only be activated in shared workbooks.
A)True
B)False
Q7) When a signature line is added,the document becomes read-only.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 51
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) Recorded macros can be viewed in the ________.
Q2) Cells can be locked from the ________ group on the Home tab.
Q3) Excel passwords can be up to ________ characters.
Q4) Comments cannot be viewed in the VBA editor.
A)True
B)False
Q5) By default all cells are locked.
A)True
B)False
Q6) A ________ is a set of instructions that execute a sequence of commands to automate repetitive or routine tasks.
Q7) What are the benefits of using macros?
Q8) What is the default reference type when recording a macro?
A)Absolute
B)Relative
C)Mixed
D)Normalitive
Q9) By default,the macro recorder uses absolute references.
A)True
B)False Page 52
To view all questions and flashcards with answers, click on the resource link above. Page 53
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) After a macro has been added to a template,you should click Save to save the template with the macro.
A)True
B)False
Q2) 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
Q3) When creating a new workbook,you can select a style from the gallery to give your workbook a consistent look.
A)True
B)False
Q4) When creating a new workbook,any templates that you create can be displayed by clicking Personal in the New panel.
A)True
B)False
54
To view all questions and flashcards with answers, click on the resource link above.