Digital Literacy Test Bank
Course Introduction
Digital Literacy is designed to equip students with essential skills for navigating the rapidly evolving digital world. The course covers foundational concepts of computer and internet usage, digital communication, online research, information evaluation, and digital safety. Students will learn how to responsibly engage with digital content, use productivity tools, manage digital identities, and understand the ethical and societal implications of technology. Through practical assignments and project-based learning, participants will develop critical thinking and problem-solving abilities necessary for effective participation in modern digital environments.
Recommended Textbook
Exploring Microsoft Office Excel 2016 Comprehensive 1st Edition by Mary Anne
Available Study Resources on Quizplus
13 Chapters
1301 Verified Questions
1301 Flashcards
Source URL: https://quizplus.com/study-set/1467
Page 2
Chapter 1: Introduction to Excel
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29219
Sample Questions
Q1) A range is specified by its ________.
A)top and bottom row and left and right column
B)top row and leftmost column
C)top right and bottom left cells
D)top left and bottom right cells
Answer: D
Q2) A(n)________ is a line you can put around a cell or range of cells for emphasis. Answer: border
Q3) What is the small green square in the bottom right of a cell called?
A)Sizing handle
B)Fill handle
C)Copy/Paste handle
D)Move Cell handle
Answer: B
Q4) Which is not a valid range?
A)A1:A3, B1:B3
B)A1:A9
C)A1:F1
D)A1:F9
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Formulas and Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29223
Sample Questions
Q1) The default calculation using the PMT function will produce a negative number.
A)True
B)False
Answer: True
Q2) Which of the following is not a valid test in an =IF statement?
A)A4-B4
B)A4<b4
C)A4>A4
D)B4<=B4
Answer: A
Q3) The ________ function counts the number of calculable values, but ignores cells that have text or are empty.
Answer: COUNT
Q4) If you are looking up exact values in a lookup table then it does not matter how the table is sorted.
A)True
B)False
Answer: True
Q5) When working with dates, Excel actually assigns ________ numbers to each date.
Answer: serial
4
To view all questions and flashcards with answers, click on the resource link above.
Chapter 3: Charts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29224
Sample Questions
Q1) In the task pane, what does a diagonal black triangle next to a chart category indicate?
A)All the category's options are displayed.
B)None of the category's options are displayed.
C)There are no options for this category.
D)Every option for this category have already been chosen.
Answer: A
Q2) Pie charts can only display one data series.
A)True
B)False
Answer: True
Q3) In a pie chart which of the following is a good reason for using category data labels rather than the legend?
A)They reveal more information.
B)They take up less space.
C)They are easier to format.
D)They are easier to read.
Answer: D
Q4) A bar chart uses ________ bars.
Answer: horizontal
Page 5
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Datasets and Tables
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29225
Sample Questions
Q1) To go to the first unfrozen cell you would press Ctrl+________ at the same time.
Q2) If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?
A)Conditional formatting
B)AutoFill formatting
C)AutoComplete formatting
D)Aggregate Cell formatting
Q3) This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].
A)True
B)False
Q4) What is not true about tables in Excel?
A)Column headings stay on the screen automatically.
B)Filter arrows make it quick and easy to filter the data in the table.
C)Row headings stay on the screen automatically.
D)You can export the data to a SharePoint list.
Q5) By how many levels will Excel allow you to sort?
A)16
B)32
C)64
D)128
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Subtotals, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29226
Sample Questions
Q1) If you want to turn off grand totals for columns on a PivotTable, select this option in the Grand Totals options.
A)On for Rows Only
B)On for Columns Only
C)Off for Rows and Columns
D)On for Rows and Columns
Q2) You created a PivotTable and later made changes to values in the underlying data.What happens to the PivotTable?
A)The PivotTable updates automatically when you make changes to the dataset.
B)Excel gives an error message that data has changed and the PivotTable may no longer be accurate.
C)Changes in the dataset do not affect the PivotTable until you refresh the PivotTable.
D)Excel deletes the PivotTable automatically so you can recreate it.
Q3) In a PivotTable Fields task pane, the ________ filters the data to display results based on particular conditions you set.
Q4) A slicer has a window with a button for each item in a field.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 6: What-If Analysis
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/29227
Sample Questions
Q1) A Scenario Manager Summary report displays the single best input to achieve the desired outcome.
A)True
B)False
Q2) A(n)________ specifies the cell that contains a formula that produces the value to be optimized with Solver.
A)objective cell
B)set value
C)target cell
D)variable cell
Q3) A(n)________ is the changeable input value used in a what-if analysis.
Q4) Which is not true about Scenario Manager?
A)Is rarely used in business models
B)Defines and manages up to 32 scenarios
C)Provides more variability and details than a data table
D)Used to provide best-case, worst-case, and most-likely scenarios.
Q5) The Solver Add-in is loaded by default.
A)True
B)False
Q6) If Solver is installed on your computer, it will display on the ________ tab.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Specialized Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29228
Sample Questions
Q1) Which of the following is not an argument in a Database function?
A)Database
B)Criteria
C)Filter
D)Field
Q2) The ________ function calculates the principal payment for a specified period on a loan or investment.
A)PPMT
B)IPMT
C)PMT
D)NPER
Q3) The DCOUNTA function returns an error if it encounters a blank record.
A)True
B)False
Q4) NPER calculates the periodic interest rate of an investment or loan.
A)True
B)False
Q5) If you have 3 possible outcomes in a nested IF statement, then you need ________ logical tests.
Q6) The ________ function calculates the total future value.
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Statistical Functions
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29229
Sample Questions
Q1) Which of the following is not an argument in the PERCENTRANK.INC and PERCENTRANK.EXC functions?
A)array
B)criteria
C)x
D)significance
Q2) Correlation is a tool included on the Analysis ToolPak.
A)True
B)False
Q3) Excel 2016 has NO new functions in the Analysis ToolPak.
A)True
B)False
Q4) ________ is a measure of how two sets of data vary simultaneously.
A)Deviation
B)Covariance
C)Probability
D)Frequency
Q5) A quartile is a value used to divide a range into five equal groups.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Multiple-Sheet Workbook Management
Available Study Resources on Quizplus for this Chatper
89 Verified Questions
89 Flashcards
Source URL: https://quizplus.com/quiz/29230
Sample Questions
Q1) If you cannot immediately see the source of an error in a nested formula, this tool will walk you through the intermediary calculations.
A)Evaluate Formula
B)Trace Dependents
C)Trace Precedents
D)IFERROR
Q2) All of the following could produce a #NAME? error except ________.
A)Misspelled word
B)Invalid Range Name
C)Invalid arguments in a function
D)Invalid Function Name
Q3) '[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.
Q4) What does a green triangle in the upper left corner of a cell mean?
A)Precedent to another cell
B)Source cell lost
C)Potential syntax error
D)Potential logic error
Q5) Right clicking a sheet tab and selecting Select All Sheets will ________ all worksheets in the workbook.
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Imports, Xml, and Power Add-Ins
Available Study Resources on Quizplus for this Chatper
87 Verified Questions
87 Flashcards
Source URL: https://quizplus.com/quiz/29220
Sample Questions
Q1) Describing XML as ________ means that it can be expanded as necessary to fit the needs of the data.
Q2) Embedded data in an excel workbook is ________.
A)uneditable data linked to a web source
B)data that imported using Power Query
C)any imported data
D)editable data with no link back to its original source
Q3) Power Pivot is installed in all version of Excel.
A)True
B)False
Q4) ________ is an Excel add-in that enables you to create a visual dashboard.
A)Power View
B)Power Pivot
C)Power Query
D)Power Dash
Q5) Which is not true about building PivotTables in Power Pivot?
A)They can contain calculations.
B)They can be built on multiple tables.
C)They can have numerical data, only.
D)They are for Business intelligence analysis.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Collaboration and Workbook Distribution
Available Study Resources on Quizplus for this Chatper
88 Verified Questions
88 Flashcards
Source URL: https://quizplus.com/quiz/29221
Sample Questions
Q1) A cell that contains a comment is marked with a green triangle.
A)True
B)False
Q2) Which tool is best suited to merge multiple versions of a shared workbook?
A)Combine
B)Compare and Merge Workbooks
C)Side by Side
D)Change manager
Q3) The Office ________ controls the overall appearance and color of the interface of Office.
Q4) Which of the following is not an option in the Properties dialog box?
A)General
B)Data
C)Summary
D)Statistics
Q5) The Accessibility Checker reviews a document for all of these except ________.
A)Spelling errors
B)Tables with header rows.
C)Objects without Alt text.
D)Hyperlinks without ScreenTips
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Templates, Styles, and Macros
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/29222
Sample Questions
Q1) Delete macros in the ________ dialog box.
Q2) What is the file extension for a Macro-Enabled Workbook?
A).xlsb
B).xlsm
C).xltm
D).xlm
Q3) What file extension do templates use?
A).xlsx
B).xlsm
C).xltx
D).xlsb
Q4) Use the ________ function to trap errors when creating templates.
Q5) ________ files save with .xltx file extensions.
Q6) Which of the following is not a good guideline for creating a template?
A)Include instructions
B)Enter all possible data.
C)Use consistent and appropriate formatting
D)Provide meaningful names to worksheets
Q7) A password on a protected workbook can be ________ characters long.
Q8) ________ is the file extension for Macro-Enabled Workbooks.
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Appendix: Exploring Microsoft Office Excel 2016 Comprehensive
Poatsygrauer
Available Study Resources on Quizplus for this Chatper
106 Verified Questions
106 Flashcards
Source URL: https://quizplus.com/quiz/29231
Sample Questions
Q1) Landscape orientation
A)Duplicates a selection from the original location and places a copy in the Office Clipboard
B)Removes a selection from the original location and places it in the Clipboard
C)Page that is wider than it is tall
D)Page that is taller than it is wide
E)Places a selection in the Clipboard into another location
Q2) The Clipboard is an area of memory that is used to temporarily hold selections that you have cut or copied, and it allows you to paste the selections.
A)True
B)False
Q3) Microsoft Office ________ is an application that is used to store quantitative data and to perform accurate and rapid calculations.
Q4) The ________ identifies the current file name and the application in which you are working.
A)title bar
B)status bar
C)Quick Access Toolbar
D)Ribbon
To view all questions and flashcards with answers, click on the resource link above. Page 15