Digital Literacy
Final Test Solutions
Course Introduction
Digital Literacy explores the essential skills and knowledge required to navigate, evaluate, and create information using digital technologies. This course examines the effective use of various digital tools and platforms, the critical assessment of online resources, and the responsible management of digital identity and privacy. Students will develop competencies in communication, collaboration, and problem-solving in digital environments, enabling them to participate confidently and ethically in the digital world.
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) ________ options are the settings that are in effect when an application is installed.Spelling and grammar checker as active is one example of this.
Answer: Default
Q2) Desktop and SkyDrive are examples of Windows 8 apps.
A)True
B)False
Answer: True
Q3) The Notification area of Windows 8 is displayed in the bottom-left corner of the Start screen.
A)True
B)False
Answer: False
Q4) After you start your computer and enter your username and password,________ displays in Windows 8.
A)the desktop
B)each Charm
C)the Mini toolbar
D)the Start screen
Answer: D
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) Explain how a linked style includes elements of both character and paragraph formatting.
Answer: A linked style can include elements of both character and paragraph formatting because the formats applied by a linked style are dependent upon the text selected.With no text selected,both paragraph and character formats are applied.However,if text is selected,only character formatting is applied.
Q2) Which of the following is the best choice of font for a typical business document?
A)Times New Roman 12 pt.
B)Arial 11 pt.
C)Times New Roman 8 pt.
D)Calibri 11 pt.
Answer: A
Q3) Times New Roman is an example of a(n)________ font,which includes thin lines at the top and bottom of primary strokes.
Answer: serif
Q4) When working with tabs on Word's ruler,how would you reposition an existing tab and how would you remove a tab?
Answer: Drag a tab to reposition it,and drag a tab off the ruler to remove it.
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) The process whereby the mouse pointer becomes an eyedropper tool that you can use to copy a border from one table to another is:
A)Border Styles.
B)Format Painter.
C)Border Painter.
D)Border Sampler.
Q2) A newly created table is automatically formatted in ________ style.
Q3) To divide cells,click this command in the Merge group on the Table Tools Layout tab.
A)Split Table
B)Split Cells
C)Distribute Columns
D)AutoFit
Q4) The Word feature that provides access to predesigned tables,including calendars,tabular lists,and matrices is:
A)Draw Table.
B)Quick Tables.
C)Excel Spreadsheet.
D)Table Styles.
To view all questions and flashcards with answers, click on the resource link above. Page 5
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) A comment balloon will not identify you as the author.
A)True
B)False
Q2) In order to use Word Web App,you must have Word 2013 installed on your computer.
A)True
B)False
Q3) Simple Markup is a Word 2013 feature that does which of the following?
A)Provides an uncluttered display of edits and comments
B)Minimizes the display of comment balloons but shows every change made to a document
C)Highlights all changes made to a document,showing edited text in another font color
D)Abbreviates changes,providing a code for interpreting the abbreviations
Q4) The writing style best suited for preparing documents and books for publication is: A)Chicago.
B)MLA.
C)Turabian.
D)APA.
Q5) As a component of Office Web Apps,________ is a limited version of Word.
Page 6
To view all questions and flashcards with answers, click on the resource link above.
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) A(n)________ calls attention to information by displaying it in an area along the side of featured information.
Q2) Use a Section Break when you want to change the column specifications.
A)True
B)False
Q3) An underlying,but invisible,set of horizontal and vertical lines of a document is known as a(n)________.
Q4) A(n)________ is a phrase or sentence taken from an article to emphasize a key point.
Q5) ________ breaks a single object into numerous individual objects.
Q6) If you click Paste Special,you can choose the ________ option from the Paste Special dialog box to create a link to the original file.
Q7) When you paste Excel data into a Word document,the data:
A)are pasted into table cells.
B)convert to symbols.
C)retain Excel spreadsheet formatting.
D)retain Excel spreadsheet capabilities. Page 7
Q8) Insert a(n)________ Break at the end of the last column to balance the text within the columns.
To view all questions and flashcards with answers, click on the resource link above. Page 8
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) A padlock is associated with the ________ feature in Word.
A)Subdocuments
B)Master documents
C)Combine
D)Compare
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) When using the View Side by Side feature,the maximum number of documents that you can display at one time is: A)two. B)four.
C)five. D)three.
Q4) To preview a template,click the File tab to access the ________ view of Word.
Q5) The View Side by Side command is accessible from the ________ group.
Q6) Pressing Ctrl+G opens the ________ tab of the Find and Replace dialog box. Page 9
To view all questions and flashcards with answers, click on the resource link above.
Page 10
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) All of the following are options for passwords EXCEPT:
A)creating two different passwords to open a document.
B)removing a password.
C)creating one password to open a file and a different one to modify the file.
D)changing a password once you have created one.
Q2) The ________ form control enables a user to select from a list of choices,but also allows the user to modify the choices in the list.
A)drop-down list
B)combo
C)combo box
D)rich text
Q3) All forms must be password-protected.
A)True
B)False
Q4) The ________ Mode is a toggle;click it once to activate it and click it again to deactivate it.
Q5) Design Mode is a toggle.
A)True
B)False
Page 11
Q6) The process of playing back or using a macro is called ________ macro.
To view all questions and flashcards with answers, click on the resource link above. Page 12
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) Web pages CANNOT be created by anyone who does not know HTML.
A)True
B)False
Q2) A document saved as a Single File Web Page is ready to be uploaded to a Web server.
A)True
B)False
Q3) ________ is the most common way to upload Web pages to a location viewable through the Internet.
A)FTP
B)XML
C)WWW
D)HTML
Q4) Ctrl+A
A)display the Open dialog box of the Web browser
B)move from one open Web page to another
C)temporarily display the menu
D)select all the text
E)to open a link
Q5) WWW stands for ________.
To view all questions and flashcards with answers, click on the resource link above. Page 13
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) Which of the following is NOT an option when clicking the Full Page Slides button?
A)Scale to Fit
B)High Quality
C)Grayscale
D)Frame
Q2) You have created your presentation and decide that you need to reorder some of your slides.Name the steps necessary in order to do this.
Q3) After you have created a storyboard,it is advisable to lengthen sentences and add adverbs and adjectives to your text.
A)True
B)False
Q4) A table can only be inserted on a slide layout that includes an automatic placeholder for a table.
A)True
B)False
Q5) A written note or drawing that offers additional commentary or explanation and is written during a slide show is known as a(n)________.
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) Slides can only be printed in expanded view,not in collapsed view. A)True
B)False
Q2) The ________ gallery pairs a title font with a body font.
Q3) It is not possible to drag and drop text while in the Outline view.
A)True
B)False
Q4) The main points of a slide appear as Level 1 on the slide.
A)True
B)False
Q5) A(n)________ font is a font has small lines at the end of letters.
Q6) What are two options for printing an outline?
Q7) A hierarchy of text indicates the level of importance among the text entered on a slide.
A)True
B)False
Q9) In design,empty space on a slide is known as ________ space. Page 15
Q8) The Increase List Level and Decrease List Level is located on the ________ tab.
Q10) Why is it helpful to collapse the view of an outline in an Outline View presentation?
To view all questions and flashcards with answers, click on the resource link above.
Page 16
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 combination of formatting options that can easily be applied to a shape or graphic.
Q2) Clip art images can be resized by dragging a sizing handle.
A)True
B)False
Q3) When entering text in the Text pane of a SmartArt design and you want to increase the indent level,press: A)Tab.
B)Enter.
C)Shift+Tab.
D)Alt+Tab.
Q4) The Text pane of a SmartArt diagram is most similar to a(n): A)outline.
B)text box.
C)Word document. D)shape.
Q5) The WordArt Quick Style feature is located on the ________ tab.
Q7) Explain the difference between WordArt and SmartArt? Page 17
Q6) What is the definition of guides,and how can they help when creating a presentation?
To view all questions and flashcards with answers, click on the resource link above.
Page 18
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) Both bitmap and vector images are created using mathematical statements.
A)True
B)False
Q2) Bitmap images are created by bits or:
A)mathematical statements.
B)bytes.
C)pixels.
D)shapes.
Q3) Which of the following video options is NOT included on the Video Tools Format tab?
A)Looping
B)Cropping
C)Applying a style
D)Sizing
Q4) If you choose a single picture layout page as a page layout for you photo album,the image will need to manually be maximized on the page.
A)True
B)False
Q5) Why might file compression be important?
Q6) Click the ________ tab to add a video to a slide.
To view all questions and flashcards with answers, click on the resource link above. Page 19
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) Which of the following type of chart is known for its capability to explode a segment or piece?
A)Bar chart
B)Column chart
C)Doughnut chart
D)Pie chart
Q2) The View Gridlines button is a toggle button.What is a toggle button and what happens if you click the View Gridlines button?
Q3) To increase a column width in Excel,position the mouse pointer on the line to the left of the column heading,and triple-click to adjust the column width automatically.
A)True
B)False
Q4) Why might you want to apply a predefined layout to a chart?
Q5) You can have a table without any borders;actually,the borders are invisible.
A)True
B)False
Q6) Should data in a table be as simple as possible or very complex? Explain.
Page 20
Q7) Column ________ are used to identify the contents of the columns of a table.
Q8) What is a Z-axis on a chart?
To view all questions and flashcards with answers, click on the resource link above.
Page 21
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) Which of the following is NOT a type of PowerPoint animation?
A)End
B)Entrance
C)Motion Path
D)Emphasis
Q2) A(n)________ animation type draws attention to an object that is already located on a slide.
Q3) An End action button moves to the end of the last bullet on the current slide.
A)True
B)False
Q4) If you type training@greatservicedogs.com on a slide,PowerPoint will automatically convert it to an e-mail link.
A)True
B)False
Q5) Fly Out is a type of PowerPoint ________ that includes direction,smoothing,and sound settings.
Q6) What does it mean to reverse a custom path?
Q7) A trigger must use animation.
A)True
B)False
Page 22
To view all questions and flashcards with answers, click on the resource link above.
Page 23
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) PowerPoint allows a default of ________ undos but can be change to any number from 3 to 150.
Q2) ________ is the color most associated with calm,fertility,money,and growth.
Q3) What does the Customize Ribbon tab allow you to do?
Q4) How many colors are combined for a color theme?
A)12
B)16
C)24
D)35
Q5) When in Slide Sorter view,how would you know that hidden slides are included?
Q6) A newly created template will be saved with a ________ extension.
A).potx
B).pptx
C).pptm
D).ptem
Q7) The Intersect Shapes command removes all intersected areas of two shapes.
A)True
B)False
Q8) The Custom Slide Show button is located on the ________ tab. Page 24
Q9) To modify handout masters of a presentation,click the ________ tab.
To view all questions and flashcards with answers, click on the resource link above. Page 25
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) What advantages does using SkyDrive offer you?
Q2) Of the following,________ can be described as similar to sticky notes on slides of a presentation.
A)ink annotations
B)collaboration
C)comments
D)markups
Q3) Personal data in a presentation can be discovered using:
A)the Document Inspector.
B)the Accessibility Checker.
C)Mark as Final.
D)Document Properties.
Q4) What is the Accessibility Checker used for in PowerPoint?
Q5) If you remove hidden data from a presentation,you may not be able to restore it with the Undo command.
A)True
B)False
Q6) The SharePoint ________ offers a copy of a SharePoint site for offline use. Page 26
Q7) What does it mean to flatten a PowerPoint file?
Q8) ________ 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 27
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) Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option.
A)True
B)False
Q2) For Excel to recognize a formula,it must start with a(n)________ sign.
Q3) An output area is defined as:
A)a region of a worksheet with formulas dependent on values from an input area.
B)a display of the range name and tab name within a workbook.
C)a range of cells containing values for variables used in formulas and functions within a worksheet.
D)the active cell on an active worksheet.
Q4) The Date number format only allows Long Date,for example,March 14,2016.
A)True
B)False
Q5) A value:
A)controls the sequence in which Excel performs arithmetic operations.
B)is a number that represents a quantity and can be the basis of calculations.
C)includes letters,numbers,and spaces.
Page 28
D)is a combination of cell references,operators,values,and/or functions used to perform calculations.
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) Formula ________ displays a list of functions and defined names that match the letters that you start typing when creating a formula.
Q2) A nested function:
A)contains data for the basis of the lookup and data to be retrieved.
B)is the lowest value for a specific category or series in a lookup table.
C)looks up a value and returns a related result from the lookup table.
D)contains another function embedded inside one or more of its arguments.
Q3) What is syntax and why is it important? Provide an example.
Q4) If a formula contains a reference to the cell containing a formula,a(n)________ reference exists.
Q5) How does a nested function work? Provide an example.
Q6) Excel 2013 contains more than 650 functions.
A)True
B)False
Q7) The pv of a PMT function refers to the present value of a loan.
A)True
B)False
Page 29
Q8) A function in Excel must begin with a plus sign (+).
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 30
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)________ is a grid that contains the data source values and labels.
Q2) A chart sheet:
A)is a label that describes the chart.
B)enables you to adjust the size of a chart.
C)contains a single chart and no spreadsheet data.
D)is a miniature chart contained in a single cell.
Q3) If you embedded a chart on the same sheet as the data source,you cannot print the chart only.
A)True
B)False
Q4) A chart ________ controls which data series and categories are visible in a chart.
Q5) A column chart is most effective with four to eight categories that display. A)True
B)False
Q6) Excel creates a chart on the same worksheet as the original data,but you can move the chart to its own chart sheet in the workbook.
A)True
B)False
Q7) What is a chart sheet and what are its limitations?
Page 31
To view all questions and flashcards with answers, click on the resource link above.
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) Function key ________ accesses the Go To command in Excel.
Q2) Which of the following is NOT a Table Style option?
A)Subtotal Row
B)Filter Button
C)First Column
D)Banded Rows
Q3) How can you identify the difference between automatic page breaks on a worksheet and manual page breaks?
Q4) The Freeze Panes option keeps:
A)only the first column visible as you scroll through a worksheet.
B)both rows and columns above and to the left of the active cell visible as you scroll.
C)only the designated rows visible as you scroll through a worksheet.
D)all row names and column headings on the screen for preparation in printing.
Q5) Which of the following is NOT included in the Table Style Options group?
A)Footer Row
B)Last Column
C)Banded Columns
D)Filter Button
Q6) What do banded rows and banded columns do in an Excel table?
To view all questions and flashcards with answers, click on the resource link above. Page 32
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) Filters can only be applied to PivotTables one at a time.
A)True
B)False
Q2) PivotTables can be created from the ________ tab in the Ribbon.
Q3) What is the name of the tab that appears in the Ribbon when a PivotTable is selected?
A)PivotTable Options
B)PivotTable
C)PivotTable Tools
D)Analysis
Q4) A(n)________ is a user-defined field that does not exist in the original dataset.
Q5) When setting custom calculation options in a PivotTable,what does Running Total calculate?
A)Displays each value as a percentage of the grand total
B)Displays each value as a percentage of the respective column
Total.The values in each column total 100%
C)Displays values as running totals
D)Displays values as: (value for the item)/ (value for the parent Item on rows)
To view all questions and flashcards with answers, click on the resource link above. Page 33
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) A________ is a rule that Solver has to enforce to reach the objective value.
A)binding constraint
B)stop value
C)nonbinding constraint
D)step value
Q2) Multiple objective cells can be used with Goal Seek.
A)True
B)False
Q3) When calculating the optimal blend of down payment and interest rate to purchase an automobile,a limit of no more than a $10,000 down payment is an example of which of the following?
A)Nonbinding constraint
B)Objective cell
C)Integer
D)Set cell
Q4) How can you determine if the Solver add-in is active?
A)Solver is an option on the Home tab
B)Solver appears on the Data tab
C)Solver is available via right-click
D)Solver appears in the Goal Seek dialog box
To view all questions and flashcards with answers, click on the resource link above. Page 34
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 final value of an investment of $100 a month that earns 4% interest over 5 years?
A)PV
B)FV
C)NPV
D)IPMT
Q2) What is the benefit of using MATCH nested with INDEX over lookup functions such as VLOOKUP?
Q3) If payments are made at the beginning of the month the type argument should be set to ________ when using the IPMT function
Q4) The ________ function returns a user defined message if an error is detected.
Q5) Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?
A)DMIN
B)DSUM
C)DMAX
D)DCOUNTA
Q6) Excel permits ________ IF statements in one formula.
Q7) The first argument of any database function is ________.
To view all questions and flashcards with answers, click on the resource link above. Page 35
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) The ________ is a predefined set of numerical values that are used to organize and count data using the FREQUENCY function.
Q2) The Analysis ToolPak can be activated in:
A)Formula tab.
B)Excel Options.
C)Review tab.
D)Developer tab.
Q3) Which of the following is not included in an ANOVA summary report?
A)SS
B)df
C)MS
D)TF
Q4) The ________ is the range of cells that contain the values that are being evaluated for frequency of occurrence when using the FREQUENCY function.
Q5) What are the benefits of using the Analysis ToolPakover traditional statistical functions in Excel?
Q6) The ________ function is best suited to return the rank as a percentage of students within a high school.
Q7) ANOVA stands for ________.
To view all questions and flashcards with answers, click on the resource link above. Page 36
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) When worksheets are grouped which of the following actions will not occur across all worksheets?
A)Data entry
B)Structural changes
C)Formatting
D)Conditional formatting
Q2) What formula auditing tool can be used to control the data input from the user?
A)IFERROR
B)Data validation
C)Watch Window
D)Trace dependents
Q3) When using the tracer arrows cell with errors have ________ arrows.
Q4) When worksheets are grouped all structural changes will be copied across worksheets.
A)True
B)False
Q5) A hyperlink cannot be used to access an e-mail address.
A)True
B)False
Q6) What is the difference between a precedent and dependent cell?
To view all questions and flashcards with answers, click on the resource link above. Page 37
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) A(n)________ file uses commas to separate data into columns that can be imported into Excel.
Q2) Text files can be imported into Excel workbooks.
A)True
B)False
Q3) XML stands for ________ Markup Language.
Q4) Which function is best suited to capitalize the first letter of each word in a text string?
A)UPPER
B)PROPER
C)LOWER
D)CONCATENATE
Q5) Which of the following is not part of XML?
A)Start tag
B)Element
C)Hyperlink
D)XML declaration
Q6) Flash Fill can often perform the same tasks as the PROPER function.
A)True
B)False
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) Excel files can be exported in different formats from the ________ area.
Q2) When workbooks are shared users can see changes made by others.
A)True
B)False
Q3) AutoCorrect options are located in which Excel Options category?
A)Formulas
B)Proofing
C)General
D)Advanced
Q4) Which of the following changes will Excel not track?
A)Functions
B)Formulas
C)Deletion
D)Formatting
Q5) Change tracking can only be activated in shared workbooks.
A)True
B)False
Q6) What are the benefits of customizing Excel?
Q7) The Share Workbook command is located on the ________.
Q8) What are the benefits of sharing a workbook?
To view all questions and flashcards with answers, click on the resource link above. Page 39
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) Which of the following is not a Trust Center option?
A)Trusted App Catalogs
B)Trusted Publishers
C)Trusted Calculations
D)Message Bar
Q2) The VBA editor can be opened with the key stroke Alt+F11.
A)True
B)False
Q3) Custom cell styles cannot be removed.
A)True
B)False
Q4) Which of the following items is not stored inside VBA modules?
A)Sub procedures
B)Keywords
C)Comments
D)Index documents
Q5) Recorded macros can be viewed in the ________.
Q6) Good,Bad,and Neutral are predefined cell styles.
A)True
B)False
Page 40
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) Which of the following is NOT a tab in Access 2013?
A)Create
B)Home
C)Format
D)File
Q2) An Access database can MOST accurately be described as a structured collection of:
A)tables. B)objects. C)records. D)modules.
Q3) A sort can only list records in a database in a specific numeric sequence. A)True
B)False
Q4) The ________ view in Access looks similar to an Excel spreadsheet.
A)Report
B)Form
C)Datasheet
D)Design
Q5) Tables,queries,reports,and forms are all examples of ________.
To view all questions and flashcards with answers, click on the resource link above. Page 41
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) Calculated fields are frequently created with ________ data.
Q2) Which of the following is FALSE about changes in multitable queries?
A)Deleting a join line affects all relationships in all tables of the database.
B)Join lines can be deleted in a query with no impact on the relationships.
C)When you add two tables to a query,join lines appear automatically.
D)The Relationship window displays join lines.
Q3) Which statement accurately describes the function of a query?
A)Queries allow a user to ask questions about data and then provide answers by providing subsets or summaries of data.
B)Queries delete data stored in tables,displaying only those records that match the query's criteria.
C)Queries edit data stored in tables,displaying only those records that match the query's criteria.
D)Queries manipulate data stored in tables,hiding only those records that match the subsets or summaries of the query's criteria.
Q4) Multitable queries take advantage of table relationships in a database.
A)True
B)False
Q5) What are the three ways to run a query?
To view all questions and flashcards with answers, click on the resource link above. Page 42
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) Which of the following aggregate functions CANNOT be used with Short Text data?
A)MINIMUM
B)AVG
C)MAXIMUM
D)COUNT
Q2) To create a new query,click Query Design in the:
A)Insert group on the CREATE tab.
B)Insert group on the DATABASE TOOLS tab.
C)Queries group on the CREATE tab.
D)Queries group on the DATABASE TOOLS tab.
Q3) Sum,Avg,and Count are examples of ________ functions.
Q4) All of the following are true in reference to Expression Builder EXCEPT:
A)Expression Builder inserts placeholders that tell you where each argument belongs when you insert functions.
B)Expression Builder gives you lists of fields,operators,and functions you need to create expressions.
C)Expression Builder can only be used with user-designed functions and not with built-in functions.
D)Expression Builder can be used when working with controls in forms and reports.
Page 43
To view all questions and flashcards with answers, click on the resource link above.
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) To add a field to a report,click Add Existing Fields in the:
A)Tools group on the DESIGN tab.
B)Tools group on the FORMAT tab.
C)Fields group on the DESIGN tab.
D)Fields group on the FORMAT tab.
Q2) The ________ asks a series of questions and then uses the answers to generate a customized report.
Q3) A subform combines two views of the same record source
A)True
B)False
Q4) To sort the order of records in a form,you need to open the form in:
A)Tabular View.
B)Form View.
C)Design View.
D)Print Preview.
Q5) The form Layout view can be used for all of the following EXCEPT:
A)adding or removing a field.
B)changing the order of fields.
C)adding a calculated field.
D)changing the width of a field.
To view all questions and flashcards with answers, click on the resource link above. Page 44
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) ________ function checks to see if a field does not contain a value.
A)IsNull
B)IsNotNull
C)IIF
D)Math
Q2) What is the purpose of adding an input mask to a field?
Q3) A lookup list accepts multiple values in a single field.
A)True
B)False
Q4) When using an input mask,data is still not necessarily consistent.
A)True
B)False
Q5) A required field is one that cannot be left blank when you create a new record.
A)True
B)False
Q6) A(n)________ forces data entry into a table or form to conform to a specific format.
Q7) Why is it easier to create a parameter query instead of multiple queries using the same field?
Q8) The ________ Wizard restricts how data is entered 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) When running a delete query,you are prompted with a warning message.
A)True
B)False
Q2) The process of creating a make table query is very similar to which other type of query?
A)Append query
B)Delete query
C)Find duplicates query
D)Update query
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) Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.
A)True
B)False
Q5) Access does not have a way to identify duplicate values.
A)True
B)False
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) What are group headers and footers used for?
Q2) When would a calculated field need to be added to a form or report?
A)When a formula is needed in the form or report
B)When you want to add some explanatory text to the form or report
C)When using an unbound control in the form or report
D)When using a bound control in the form or report
Q3) How can you add emphasis to a form or report?
Q4) A read-only form is a form that enables users to view but not change data.
A)True
B)False
Q5) Subforms have to be created using the Form Wizard.
A)True
B)False
Q6) In which section of a form or report is a company logo usually added?
Q7) Simple forms created with a Form tool will handle most basic database solution needs.
A)True
B)False
Q8) The ________ section in a report repeats for each record in a record source. Page 48
Q9) List the five default sections of a report.
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) A(n)________ data type enables you to quickly link to any file on your computer or to any Web page on the Internet.
Q2) ________ documents cannot be edited after being exported.
A)PDF or XPS
B)HTML or DOCX
C)DOCX or XPS
D)JPEG or PDF
Q3) Which of the following allows you to manage attached files in forms and reports?
A)Attachment control
B)Attachment field
C)Attachment file
D)Attached form
Q4) PDF is a file format created by Microsoft.
A)True
B)False
Q5) Why would you want to export an Access report to a PDF?
Q6) The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.
Page 50
Q7) What is the disadvantage of storing attachments in your database?
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) A(n)________ occur when the value of one non-key field is functionally dependent on the value of another non-key field.
A)transitive dependencies
B)composite keys
C)non-key fields
D)functional dependencies
Q2) ________ dependencies occur when the value of one non-key field is functionally dependent on the value of another non-key field.
Q3) 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.
Q4) A table that contains no repeating groups or repeating columns is in:
A)first normal form.
B)second normal form.
C)third normal form.
D)fourth normal form.
Q5) You can digitally sign and publish your database simultaneously from within Access 2013.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 51