Digital Literacy Exam Review
Course Introduction
Digital Literacy is a foundational course designed to equip students with the essential skills needed to navigate, evaluate, and create information using a range of digital technologies. The course covers topics such as internet safety, online communication, critical evaluation of digital content, responsible use of social media, and basic proficiency in commonly used software tools. Emphasizing both practical and ethical considerations, students will learn how to participate confidently and responsibly in the digital world, preparing them for academic, professional, and personal success in an increasingly technology-driven society.
Recommended Textbook
Exploring Microsoft Office 2013 Volume 1 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus
37 Chapters
3754 Verified Questions
3754 Flashcards
Source URL: https://quizplus.com/study-set/2006
Page 2
Chapter 1: Office Fundamentals and File Management
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39846
Sample Questions
Q1) The ________ bar informs a user of the current drive or folder.
Answer: Address
Q2) When and how does the Mini toolbar appear in Office 2013? What is it used for?
Answer: When any amount of text is selected within a worksheet,document,or presentation,you can slightly move the mouse pointer within the selection to display the Mini toolbar.The Mini toolbar provides access to most common formatting selections.
Q3) What is the default location for saving files in Office 2013 applications? Briefly describe it.
Answer: SkyDrive is the default location for saving files in Office 2013.SkyDrive is an app used to store,access,and share files and folders.
Q4) Increasing the font size while in Print Preview by using the zoom increases the actual font size of the document when printed.
A)True
B)False
Answer: False
Q5) The ________ is located at the bottom of the window in Office 2013 and contains file information.
Answer: status bar
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 3: Word: Document Presentation: Editing and Formatting
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39848
Sample Questions
Q1) When you drag a center sizing handle to resize an object,both the height and width are adjusted simultaneously.
A)True
B)False
Answer: False
Q2) This type of style includes both character and paragraph formatting.
A)Object
B)Linked
C)Theme
D)Style set
Answer: B
Q3) Which of the following is NOT a location from which you can obtain an online picture?
A)Office.com
B)SkyDrive
C)Flickr
D)Photoshop Answer: D
Q4) Default tab stops are ________ aligned. Answer: left
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 4: Word: Document Productivity: Working With
Tables and Mail Merge
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39849
Sample Questions
Q1) A(n)________ is a grid of rows and columns that organizes data.
Q2) Rows in a Word table are numbered 1,2,3,and so on.
A)True
B)False
Q3) The intersection of a column and row in a Word table is a(n)________.
Q4) Having selected a table style,you cannot modify it.
A)True
B)False
Q5) Text that is separated by tabs can be converted into a table.
A)True B)False
Q6) A(n)________ is a placeholder for variable data such as an address or salutation.
Q7) When you point to the edge of a row or column gridline,a(n)________ displays,enabling you to insert a row or column.
Q8) A formula can contain more than one mathematical ________,such as + and -.
Page 5
Q9) During the mail merge process,you can create a data source.
A)True
B)False
Q10) Use the ________ dialog box to select an option to center a table horizontally.
To view all questions and flashcards with answers, click on the resource link above.
6
Chapter 5: Word: Collaboration and Research:
Communicating and Producing Professional Papers
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39850
Sample Questions
Q1) An index and a table of contents are terms that refer to the same thing.
A)True
B)False
Q2) Word Web App includes two views--Editing view and ________ view.
Q3) Suppose you have used appropriate heading styles to identify a hierarchy of topics in a document,and then used Word 2013 to create a table of contents.You find that one section in the paper is not necessary,so you remove it.Is it possible for Word to update the table of contents,and if so,how can you make that happen?
Q4) When you click Bibliography in the Citations and Bibliography group on the References tab,you can select from Bibliography,References,or ________.
Q5) How would you determine whether to use footnotes or endnotes in a paper?
Q6) All writing styles share similarities.How would you determine which writing style to follow when writing a research paper?
Q7) Which of the following is NOT an example of plagiarism?
A)Failure to cite sources
B)Purchasing a paper written by someone else
C)Conducting research online
D)Asking someone else to write a paper for you
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Word: Desktop Publishing and Graphic Design:
Creating a Newsletter, working With Graphics, and Linking Objects
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39851
Sample Questions
Q1) You embed an object in a document,rather than link it,when you want to:
A)make editing changes directly to the embedded object.
B)make sure that the object does not appear directly in the Word document.
C)store the embedded object in its own file and simply tie it to the Word document.
D)make changes to the source file and have the object in Word be updated automatically.
Q2) A(n)________ is a phrase or sentence taken from an article to emphasize a key point.
Q3) ________ is most often associated with hyperlinks and should be used sparingly.
A)Upper case
B)Underlining
C)Bold
D)Italics
Q4) A grid is distinguished by the number of ________ it contains.
A)rows
B)columns
C)horizontal lines
D)cells
Q5) ________ breaks a single object into numerous individual objects. Page 8
To view all questions and flashcards with answers, click on the resource link above.
Page 9
Chapter 7: Word: Time Saving Tools: Using Templates, multiple Documents, and Themes
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39852
Sample Questions
Q1) To display ________ in a document,make sure that the document is expanded to display the text of the whole document.
Q2) All the following statements about bookmarks are true,EXCEPT that:
A)You should try to use long,descriptive names for your bookmark.
B)you may sort bookmarks according to the bookmark name or the bookmark location in the document.
C)a bookmark will help you return to a specific location quickly.
D)you can bookmark anything in Word,including headings ,charts,and pictures.
Q3) The ________ feature of Word is most often preferred when you submit a document to others and request feedback.
A)Combine
B)Track Changes
C)Compare
D)Side by Side
Q4) A(n)________ document acts like a binder for managing smaller documents.
Q5) Theme colors can be accessed from both the Design and Home tabs.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Q6) Templates have ________ to allow users to type information into the document.
Chapter 8: Word: 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/39853
Sample Questions
Q1) 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
Q2) User must insert a digital image of a signature on the signature line.
A)True
B)False
Q3) A file marked as final becomes a read-only file.
A)True
B)False
Q4) When printed,the data entered into fields appears as ________ text. A)bigger
B)regular
C)bolded
D)italicized
Q5) To disallow other users from making any changes to a document,click the File tab,and click ________.
11
Q6) The process of creating a macro is called ________ macro.
Q7) Macros are stored in a macro project called ________ in the Normal template.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 9: Word: Word and the Internet: Web Page
Creation and Enhancement, and Blogs
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39854
Sample Questions
Q1) 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
Q2) All of the following are examples of Web pages EXCEPT: A)Index.html.
B)Order.mhtml.
C)Order.docm.
D)Default.htm.
Q3) Which of the following statements about inserting online videos into a Web page is FALSE?
A)You do not have to leave your open document to go to another window.
B)You will see a live preview.
C)The online video is embedded into the Web page.
D)You can view the video directly within the context of the document itself.
Q4) Documents that are part of the WWW are known as Web pages.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Q5) Are there any rules that you HAVE to follow when naming files and folders for Web pages?
Chapter 10: Power: Introduction to Powerpoint: Creating a Basic Presentation
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39855
Sample Questions
Q1) You must delete all unused placeholders on a slide since they will show when you run the slide show.
A)True
B)False
Q2) Which of the following lists of phrases uses parallel construction?
A)Turning on the faucet,drinking the water,and turn the faucet off B)Went running,walking,and then rode her bike
C)Mowed the lawn,weeded the flower beds,and put the tools away D)She plays volleyball,likes to hike,and runs cross country
Q3) Which of the following is NOT considered a step in checking spelling and incorrect word usage in a PowerPoint slide show?
A)Use the Editing feature.
B)Read the slide content after you enter it.
C)Use the Spelling feature.
D)Ask a friend or colleague to review it.
Q4) Contextual mistakes in PowerPoint 2013 are noted by:
A)a red wavy underline.
B)dark red bolded text.
C)a thick green underline.
D)blue flashing text.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 11: Power: Presentation Development: Planning and Preparing
a Presentation
Available Study Resources on Quizplus for this Chatper
101 Verified Questions
101 Flashcards
Source URL: https://quizplus.com/quiz/39856
Sample Questions
Q1) The Increase List Level and Decrease List Level is located on the ________ tab.
Q2) What is the most efficient way to set the fonts,color scheme,and effects for your entire slide show?
Q3) The Section button is located in the ________ group.
Q4) Which of the following files will import all of the outline text into one placeholder on one slide?
A)Outline1.docx
B)Outline2.htm
C)Outline3.rtf
D)Outline4.txt
Q5) Which of the following is TRUE about background shapes and graphics?
A)Shapes and graphics can be hidden on all background themes.
B)Intense background styles can be changed and hidden;subtle ones cannot.
C)Backgrounds cannot be changed by the user.
D)Background shapes and graphics can be hidden on ALL slides but not on one individual slide.
Q6) What sort of effects can be found in the Effects Gallery?
Page 14
Q7) It is only possible to demote text to a lower level prior to entering the text.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 15
Chapter 12: Power: Presentation Design: Illustrations and Infographics
Available Study Resources on Quizplus for this Chatper
94 Verified Questions
94 Flashcards
Source URL: https://quizplus.com/quiz/39857
Sample Questions
Q1) A(n)________ is a set of intersecting lines,similar to graph paper.
Q2) Use the ________ feature to create an equal space between shapes.
A)Distribute
B)Align
C)Rotate
D)Grid
Q3) Line ________ or thickness around a shape can be adjusted.
Q4) Which of the following is NOT a method of selecting more than one shape in order to apply a Quick Style?
A)Drag the mouse around all objects.
B)Press Ctrl and select each object.
C)Press Shift and select each object.
D)Press Alt and select each object.
Q5) Nonprinting vertical and/or horizontal lines on a slide to help align objects are known as ________.
Q6) A(n)________ is a combination of formatting options that can easily be applied to a shape or graphic.
Q7) The Shapes gallery can be accessed from the ________ tab.
Q8) A(n)________ SmartArt diagram shows how parts relate to a whole. Page 16
Q9) The order of various layers of objects is known as the ________ order.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 13: Power: Powerpoint Rich Media Tools: Enhancing
With Multimedia
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/39858
Sample Questions
Q1) To begin to record audio for a presentation,click the ________ tab.
Q2) Which of the following is FALSE about the photo album feature in PowerPoint 2013?
A)The order of photos can be changed after the album is created.
B)Transitions can be added to slides in a photo album presentation.
C)The Photo Album feature is accessed from the Design tab.
D)Slide images may be reduced to fit into slide placeholders.
Q3) Artistic effects for images use the Live Preview feature.
A)True
B)False
Q4) Which of the following is FALSE about the video editing tools in PowerPoint?
A)If you use the Start and End markers for timing,you view the video as you make changes.
B)Videos can be faded in and faded out.
C)Videos can be muted.
D)Videos can only be started with a click of the mouse.
Q5) The ________ button in the Edit Photo Album dialog box allows you to turn an image 90 degrees each time it is clicked.
Page 18
Q6) The ________ of a picture is the area to be kept with the Remove Background tool.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 14: Power: Infographics: Creating Text Charts, tables,
and Graphs
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39859
Sample Questions
Q1) What is a primary difference between text-based charts and statistical charts and graphs?
A)Text-based charts add visual description to a presentation;statistical charts and graphs must be interpreted and described only by a presenter.
B)Text-based charts have been available in previous versions of PowerPoint;statistical charts and graphs are a new feature of PowerPoint 2013.
C)Text-based charts are limited to text only;statistical charts and graphs can include numbers as well as text.
D)Text-based charts are used primarily to illustrate relationships;statistical charts and graphs use points,lines,and other shapes to communicate numerical relationships.
Q2) Which of the following is NOT a button in the Shape Styles group on the Chart Tools Format tab?
A)Shape Fill
B)Shape Border
C)Shape Outline
D)Shape Effects
Q3) The ________ of a pie chart could be Rent,Food,Tuition,and Transportation.
To view all questions and flashcards with answers, click on the resource link above.
Page 19
Chapter 15: Power: Interactivity and Advanced Animation: Engaging the Audience
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39860
Sample Questions
Q1) To apply a motion path,first select the object and then click the ________ tab.
Q2) How does the Home action button differ from the Beginning action button?
A)The Home button can be set to go to any slide;the Beginning button moves to the first slide.
B)Both can be set to go to any slide,but the Beginning button can also be set to go to the final slide.
C)The Beginning button can be set to go to any slide;the Home button moves to the first slide.
D)The Home button goes to the first slide;the Beginning button goes to the first line of the current slide.
Q3) Arcs,hearts,and stars are examples of PowerPoint ________.
A)animation effects
B)motion paths
C)action buttons
D)triggers
Q4) A linear presentation progresses sequentially through slides,starting with the first slide and ending with the last slide.
A)True
B)False
Page 20
To view all questions and flashcards with answers, click on the resource link above.
Chapter 16: Power: 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/39861
Sample Questions
Q1) What does the Customize Ribbon tab allow you to do?
Q2) Increasing the number of undo levels in PowerPoint increases the amount of RAM required.
A)True
B)False
Q3) 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)#;!
Q4) When in Slide Sorter view,how would you know that hidden slides are included?
Q5) RGB,a numeric system for identifying colors is a combination of red,green,and ________ light.
Q6) While in ________ view,type the slide number of a hidden slide and Enter to reveal it.
Q7) PowerPoint saves a master as a template with an extension of ________.
Page 21
Q8) PowerPoint allows a default of ________ undos but can be change to any number from 3 to 150.
To view all questions and flashcards with answers, click on the resource link above.
Page 22
Chapter 17: Power: 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/39862
Sample Questions
Q1) To check for hidden data in a PowerPoint file,you can open the document properties.
A)True
B)False
Q2) When you choose to save annotations in a presentation,they can then be viewed in Normal view.
A)True
B)False
Q3) To reply to a comment,click the comment,click Reply,and type your reply in the text box.
A)True
B)False
Q4) Which of the following is NOT a feature of SharePoint collaboration?
A)Store presentations in a document workspace.
B)Save and reuse your own or others' presentations stored in the library.
C)Receive e-mail notifications when slides are changed in the library.
D)Online discussions as presentations are being developed.
Q5) To insert a comment,click the ________ tab.
Q6) What can you view in a document's properties? Page 23
To view all questions and flashcards with answers, click on the resource link above.
Page 24
Chapter 18: Excel: Introduction to Excel: What Is a Spreadsheet
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39863
Sample Questions
Q1) Adjust the column ________ to accommodate the widest entry in a column.
Q2) Use ________ to complete a sequence in a worksheet such as January,February,March,and April.
Q3) Describe a nonadjacent range,provide an example,and describe how to select a nonadjacent range.
Q4) Use the ________ to select a range by clicking in it and typing a range address,and then pressing Enter.
Q5) Describe alignment in relation to Excel 2013.How is text automatically aligned,how are values automatically aligned,and how are dates automatically aligned?
Q6) The Show Formulas button is accessible from the ________ tab.
Q7) The ________ of a workbook displays the file name as well as the software name.
Q8) Which of the following is NOT a number format available in the Number group on the Home tab?
A)Comma Style
B)Percent Style
C)Accounting Number Format
D)Date Format
Q9) A number that represents a quantity or amount is called a(n)________. Page 25
Q10) How do the Comma,Accounting,and Currency formats differ?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 19: Excel: Formulas and Functions: Performing
Quantitative Analysis
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39864
Sample Questions
Q1) The =DATE(year,month,day)function returns a(n)________ for a date.
Q2) When you decrease the decimal places that display in a cell,Excel rounds the value stored in that cell and uses the rounded value in calculations.
A)True
B)False
Q3) Excel provides three basic count functions: COUNT,COUNTA,and ________.
Q4) While lookup tables are typically designed vertically,they can also be designed horizontally.
A)True
B)False
Q5) Describe a circular reference.Provide an example.
Q6) What are the rules for creating range names?
Q7) Which of the following is a new feature in Excel 2013?
A)Lookup tables
B)The COUNT functions
C)Quick Analysis
D)The Range Names feature
Q8) Formula ________ displays a list of functions and defined names that match the letters that you start typing when creating a formula. Page 27
To view all questions and flashcards with answers, click on the resource link above. Page 28
Chapter 20: Excel : Charts: Depicting Data Visually
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39865
Sample Questions
Q1) A(n)________ chart is a derivative of a scatter chart in which both axes are value axes.
Q2) What is a chart sheet and what are its limitations?
Q3) Describe the three Format task panes that allows you to format with fill and border elements of a chart.
Q4) Describe the three types of sparklines available in Excel 2013 and how each may be useful.
Q5) Sizing handles display as small,black-filled circles to resize a chart.
A)True
B)False
Q6) What does a chart filter do?
Q7) A chart filter in Excel 2013:
A)controls which charts are printed and which are visible on the screen of a workbook.
B)controls which data series and categories are visible in a chart.
C)displays a list of all charts in a workbook in order to select which charts you want to print.
D)displays all chart types and filters that are available for the data you want to present.
Q8) ________ are small white-filled squares that display when a chart is selected.
To view all questions and flashcards with answers, click on the resource link above. Page 29
Chapter 21: Excel: Datasets and Tables: Managing Large
Volumes of Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39866
Sample Questions
Q1) In Page Break Preview,the print area has a white background with a dotted blue border.
A)True
B)False
Q2) The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out.
Q3) When you no longer need conditional formatting,you can clear it for a selected range or for an entire worksheet.
A)True
B)False
Q4) A page break:
A)indicates which worksheet is set to print.
B)is the sequence in which pages print.
C)indicates where data starts on a new printed page.
D)stops the printer from printing.
Q5) The calculations on a total row in a table use the ________ function.
Q6) You can sort data by one or more columns.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 30
Chapter 22: Excel: Subtotals, Pivot-tables, and
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39867
Sample Questions
Q1) ________ provide visual representations of data filters that are active in a PivotTable.
Q2) Custom calculated fields will not update if the data source changes.
A)True
B)False
Q3) What does the Values Area of a PivotTable do?
A)Subdivides data into one or more additional categories
B)Filters the data to display results based on particular conditions you set
C)Organizes and groups data into categories on the left side.Each group Name occupies a single row
D)Displays summary statistics,such as totals or averages
Q4) Slicer captions can be used to provide instructions to users.
A)True B)False
Q5) When subtotals are applied,outline button number ________ displays the entire list.
Q6) More than one function can be applied per field in a PivotTable.
A)True B)False
Q7) What are the benefits of using Slicers over traditional filters?
To view all questions and flashcards with answers, click on the resource link above. Page 31
Chapter 23: Excel : What-If Analysis
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39868
Sample Questions
Q1) When creating substitution values using the Series dialog box,what is the last number used in the substitution values?
A)Stop value
B)Step value
C)Integer
D)Constraint
Q2) Multiple objective cells can be used with Goal Seek.
A)True
B)False
Q3) When using Scenario Manager,scenarios can be edited.
A)True
B)False
Q4) Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?
A)Solver
B)Goal Seek
C)Scenario Manager
D)One-variable data table
Q5) What is the benefit of using Solver over Goal Seek and Scenario Manager?
To view all questions and flashcards with answers, click on the resource link above. Page 32
Chapter 24: Excel: Specialized Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39869
Sample Questions
Q1) Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20000 loan paid back over 5 years?
A)FV
B)RATE
C)NPV
D)PV
Q2) What is the difference between advanced filtering and database functions?
Q3) The end_period argument should have the value of ________ if you are calculating cumulative interest using CUMIPMT for the third payment of a loan.
Q4) Which database function should be used to count records with empty cells?
A)DCOUNT
B)DCOUNTA
C)DGET
D)DSUM
Q5) The ________ function is best suited to return the highest numerical value of a range of values within a database.
Q6) ________ calculates the standard deviation of a sample population.
Q7) ________ will return the principal paid on one specific payment of a loan.
Q8) ________ will return the interest paid for one installment of a loan.
To view all questions and flashcards with answers, click on the resource link above. Page 33
Chapter 25: Excel: Statistical Functions
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39870
Sample Questions
Q1) Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?
A)Correlation
B)Histogram
C)Descriptive Statistics
D)ANOVA
Q2) ANOVA stands for ________.
Q3) When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?
A)0
B)1
C)2
D)3
Q4) ________ is a statistical hypothesis test that helps determine if samples of data were taken from the same population.
Q5) VARPA calculates the variance of a population including logical values and text. A)True
B)False
Q6) A ________ is a visual display of tabulated frequencies.
To view all questions and flashcards with answers, click on the resource link above. Page 34
Chapter 26: Excel : Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39871
Sample Questions
Q1) If the destination file is closed when you change data in the source file,the destination file does automatically update to match the source file.
A)True
B)False
Q2) ________ errors are the result of a syntactically correct formula but logically incorrect construction,which produces inaccurate results.
Q3) The #NUM! error indicates an invalid argument used in a function.
A)True
B)False
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) ________ is the process of selecting two or more worksheets.
Q6) When worksheets are grouped all structural changes will be copied across worksheets.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 35
Chapter 27: Excel: Imports, web Queries, and Xml
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39872
Sample Questions
Q1) Which of the following is an alternative to using the CONCATENATE function?
A)&
B)+
C)SUM
D):
Q2) Which of the following is not part of XML?
A)Start tag
B)Element
C)Hyperlink
D)XML declaration
Q3) What is the following syntax <?xml version="1.0" encoding="UTF-8"?>
A)XHTML
B)HTML
C)XML declaration
D)Tag
Q4) When connections are being refreshed,Excel displays the message "Running background query" in the status bar.
A)True
B)False
Q5) Text can be converted into separated columns using the ________ Wizard.
Page 36
To view all questions and flashcards with answers, click on the resource link above.
Chapter 28: Excel : Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/39873
Sample Questions
Q1) Shared workbooks cannot be marked as final.
A)True
B)False
Q2) A(n)________ can be inserted to provide notes or feedback to other users of a workbook.
Q3) Which of following is the default file format for Excel 97-2003?
A).TXT
B).XLS
C).XLSX
D).XLTX
Q4) Author properties can be updated from which category in the Backstage view?
A)Account
B)Info
C)Share
D)Options
Q5) The default file format for Excel 2013 files is ________.
Q6) A workbook marked as final is read-only.
A)True
B)False
Q7) Excel files can be exported in different formats from the ________ area.
To view all questions and flashcards with answers, click on the resource link above. Page 37
Chapter 29: Excel: Templates, styles, and Macros
Available Study Resources on Quizplus for this Chatper
93 Verified Questions
93 Flashcards
Source URL: https://quizplus.com/quiz/39874
Sample Questions
Q1) Data and Model,Titles and Headings,and Number Format are all examples of predefined ________.
Q2) Which of the following is not a default cell style?
A)Standard
B)Bad
C)Good
D)Neutral
Q3) Which of the following cannot be modified in a custom cell style?
A)Number
B)Alignment
C)Print area
D)Fill
Q4) Which of the following items is not stored inside VBA modules?
A)Sub procedures
B)Keywords
C)Comments
D)Index documents
Q5) Good,Bad,and Neutral are predefined cell styles.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Chapter 30: Access : Introduction to Access: Finding Your Way
Through an Access Database
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39875
Sample Questions
Q1) A comparison operator in Access is used to evaluate the relationship between two primary keys.
A)True
B)False
Q2) Filter by Selection displays only records that match a criterion that you select.
A)True
B)False
Q3) Access' ________ feature creates a duplicate copy of a database.
A)Back Up Database
B)RDBMA
C)Compact and Repair
D)Relationship
Q4) Explain a query in Access.Provide an example.
Q5) What does a custom Web app enable you to do?
A)Create databases through Access' Web app.
B)Create relational tables that can be distributed through the Web.
C)Create a database and share with others through the Web.
D)Share and distribute database files without the need for Access to be installed on every computer.
To view all questions and flashcards with answers, click on the resource link above. Page 39
Chapter 31: Access: Tables and Queries in Relational
Databases: Designing Databases and Extracting Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/39876
Sample Questions
Q1) A(n)________ produces a value from an expression or function that uses one or more fields in a database.
Q2) Which of the following is NOT a guideline for adding fields to a database table?
A)Consider the future use of the database.
B)Store data in their smallest parts.
C)Design to accommodate date arithmetic.
D)Link tables using foreign keys
Q3) Multitable queries take advantage of table relationships in a database.
A)True
B)False
Q4) A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.
A)True
B)False
Q5) The Run command appears as a red exclamation point in Design view.
A)True
B)False
Q6) Use the ________ tab to begin the process of importing an Excel worksheet.
40
Q7) The ________ data type can be used for fields that contain monetary values.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 32: Access: Customize,analyze,and Summarize
Query Data: Creating and Using Queries to Make Decisions
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/39877
Sample Questions
Q1) A(n)________ is a variable or constant that is needed to produce output for a function in a calculated field.
A)formula
B)argument
C)expression
D)function
Q2) Following the order of operations,3+2*6 evaluates to 30.
A)True
B)False
Q3) It is NOT possible to add a condition to a Totals query.
A)True
B)False
Q4) A(n)________ function performs a calculation on an entire column of data and returns a single value.
Q5) Calculated fields are created in the Datasheet view of a table.
A)True
B)False
Q6) Exponents are evaluated first according to the order of operations.
A)True
B)False Page 41
To view all questions and flashcards with answers, click on the resource link above. Page 42
Chapter 33: Access: Creating and Using Professional Forms and
Reports: Moving Beyond Tables and Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/39878
Sample Questions
Q1) You would use a(n)________ to add data into or edit data in a table.
Q2) ACCDB is a file type used to exchange documents independent of software applications and operating systems.
A)True
B)False
Q3) PDF stands for ________.
Q4) The ________ view allows alterations to the form design while still viewing the data.
A)Data
B)Design
C)Layout
D)Form
Q5) Explain the differences between a form with a subform and a split form.
Q6) When working with forms,the Remove Layout option only appears in ________ view.
A)Design
B)Layout
C)Form
D)Control
Q7) To create a form,you click Form in the Forms group on the ________ tab. Page 43
Q8) The ________ source is also referred to as the data source.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 34: Access: Data Validation and Data Analysis:
Reducing Errors and Extracting Better Information
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/39879
Sample Questions
Q1) The options for a lookup field can be stored in a separate table. A)True
B)False
Q2) Why would you set a default value for a field?
Q3) The ________ function checks if a field does not contain a value
Q4) When using an input mask,data is still not necessarily consistent.
A)True
B)False
Q5) Reports can be created based on the results of a parameter query. A)True B)False
Q6) If you add a validation rule to a table with existing records,some data in those records may violate the rule. A)True B)False
Q7) After setting a required property to an existing table,what does Access do to the existing records if the field is blank?
A)True B)False Page 45
Q8) Validation rules limit the type or range of data a user can enter into a field.
To view all questions and flashcards with answers, click on the resource link above. Page 46
Chapter 35: Access : 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/39880
Sample Questions
Q1) What are the four types of action queries?
Q2) 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.
Q3) The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.
A)True
B)False
Q4) The find unmatched query requires two tables with a common field where one of the tables is missing information.
A)True
B)False
Q5) How do appended records appear in the destination table?
Q6) Action queries display different icons than select queries in the Navigation Pane.
A)True
B)False
Q7) What is the best precaution to take prior to running an update query?
To view all questions and flashcards with answers, click on the resource link above. Page 47
Chapter 36: Access: 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/39881
Sample Questions
Q1) Both label controls and text box controls are known as bound controls.
A)True
B)False
Q2) What is a subform?
Q3) The skill used to create a form can be used to create a report as well.
A)True
B)False
Q4) A ________ describes the data associated with a text box.
A)Label control
B)Text control
C)Design control
D)Form control
Q5) Page breaks can be added at specific locations in forms or reports.
A)True
B)False
Q6) Which sections display on forms and reports by default?
A)Detail and form/report header and footer
B)Detail and form/report page header and footer
C)Form/report page header and footer
D)Form/report header and footer
Page 48
To view all questions and flashcards with answers, click on the resource link above. Page 49
Chapter 37: Access: 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/39882
Sample Questions
Q1) PDF is a file format created by Microsoft.
A)True
B)False
Q2) Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.
A)True
B)False
Q3) What differentiates a hyperlink from text?
A)Blue underline
B)Green underline
C)Red underline
D)Black underline
Q4) What type of files are compressed by Access when you attach them?
A)Word and Excel files
B)Word and JPEG files
C)Excel and JPEG files
D)JPEG and other photo formats
Q5) ________ have consistent formatting,and are used to exchange information between computer applications.
Q6) Why would you want to export an Access report to a PDF? Page 50
To view all questions and flashcards with answers, click on the resource link above.
Chapter 38: Access: 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/39883
Sample Questions
Q1) Normalization rules indicate the current state of a table.
A)True
B)False
Q2) A timestamp can prove that your database has or has not been modified since you applied your signature.
A)True
B)False
Q3) What does the Database Splitter do?
A)Splits database into two files,a back-end and a front-end database
B)Divides the table and creates relationships that control how the new tables are linked
C)Adds more indexes to increase database performance
D)Provides a brief description of a potential problem and its possible solution
Q4) The ________ tool enables you to split a database into a front-end and back-end database.
Q5) The ________ contains the queries,forms,and reports of the database.
A)back-end database
B)database documenter
C)front-end database
D)design tools
To view all questions and flashcards with answers, click on the resource link above. Page 52