Digital Literacy Exam Preparation Guide
Course Introduction
Digital Literacy explores the skills and competencies required to effectively and responsibly navigate the digital world. This course covers foundational topics such as online communication, information evaluation, digital safety and security, ethical use of technology, collaborative tools, and the basics of content creation. Students will learn to critically assess digital information, utilize emerging technologies, and understand the societal impacts of digital transformation, empowering them to become informed and active participants in the digital age.
Recommended Textbook
New Perspectives Microsoft Office 365 and Excel 2016 Comprehensive 1st Edition by June Jamrich
Available Study Resources on Quizplus
13 Chapters
935 Verified Questions
935 Flashcards
Source URL: https://quizplus.com/study-set/2189 Page 2
Chapter 1: Getting Started With Excel
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43584
Sample Questions
Q1) According to the order of operation in Excel:
A) Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
B) Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.
C) Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.
D) Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.
Answer: A
Q2) In ____ orientation,a page is taller than it is wide.
A) natural
B) landscape
C) portrait
D) basic
Answer: C
Q3) ____________________ removes the data from the row or column as well as removes the row or column itself.
Answer: Deleting
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Formatting Workbook Text and Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43585
Sample Questions
Q1) In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.
A) A1!E1!
B) A1
C) E1
D) A1-E1
Answer: B
Q2) Calculated values too large to fit into the cell are displayed in scientific notation._________________________
A)True
B)False
Answer: True
Q3) By default,numbers appear in the _____ and generally display values exactly as you type them.
A) Home tab
B) General format
C) General number toolbar
D) currency format
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
Page 4
Chapter 3: Performing Calculations With Formulas and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43586
Sample Questions
Q1) Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet.She can use ______.
A) Lookup Analysis
B) What-If Analysis
C) IF conditions
D) nested OR conditions
Answer: B
Q2) Using AutoFill,what would be the extended series of the initial entry Jan? ___
A) uary
B) Feb, Mar, Apr
C) Kan, Lan, Man, Nan
D) Jan1, Jan2, Jan3
Answer: B
Q3) The ____________________ is the middle value from a sample.
Answer: median
Q4) ____________________ is a set of rules which specifies how a function should be written.
Answer: Syntax
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Analyzing and Charting Financial Data
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43587
Sample Questions
Q1) You can move a chart from one worksheet to another,or you can place the chart in its own chart sheet.____________
A)True
B)False
Q2) When combination charts have data series with vastly different values,you can create ____ charts.
A) dual axis
B) secondary
C) multivalued
D) multiple axis
Q3) The PMT function calculates the payment required in each period to pay back the loan.___________
A)True B)False
Q4) Interest is the amount of money being loaned.___________ A)True B)False
Q5) You can add ___________________ to identify smaller intervals between the major tick marks.
Page 6
Q6) An _______ chart takes up less space than a chart sheet.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 5: Working With Excel Tables, Pivottables, and Pivotcharts
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43588
Sample Questions
Q1) The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data.____________________
A)True
B)False
Q2) To find anyone whose Camp is either Day Camp,or Overnight Camp,or Nature Camp,what should he do?
A) Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value.
B) Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value.
C) Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value.
D) Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.
Q3) A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 6: Managing Multiple Worksheets and Workbooks
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43589
Sample Questions
Q1) When you click a(n)____,the computer switches to the file or portion of the file that it references.
A) index
B) hyperlink
C) template
D) icon
Q2) In the Links group,click the Hyperlink button and the _______ Hyperlink dialog box opens.
Q3) Usually represented by words with colored letters and underlines or images
A)3-D
B)hyperlink
C)worksheet group
D)source
E)destination
F)link
Q4) Hyperlinks are usually represented by words with colored letters and underlines or images._________________________
A)True
B)False
Q5) ____________________ appear whenever you place the pointer over a hyperlink.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Developing an Excel Application
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43590
Sample Questions
Q1) The _____ Macro workbook is a hidden workbook opened whenever you start Excel,making its macros available anytime you use Excel.
A) Universal
B) Personal
C) Microsoft
D) XP
Q2) Every cell in a workbook has a(n)locked property that determines whether or not changes can be made to that cell._________________________
A)True
B)False
Q3) Any blanks or parentheses in row or column labels are changed to underscore characters in defined names._________________________
A)True
B)False
Q4) Even when the worksheet is unprotected,the locked property determines whether or not changes can be made to a given cell.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Working With Advanced Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43591
Sample Questions
Q1) If you omit the range_lookup value from a LOOKUP function,which of the following is true?
A) The function returns the #NAME? error value.
B) Your function can only search the first column of the lookup table.
C) It is considered an approximate match.
D) It is considered an exact match.
Q2) All the logical conditions listed in an AND function must be true for the AND function to return a TRUE value.
A)True
B)False
Q3) You can include up to _____ logical conditions in the AND function.
A) 25
B) 50
C) 225
D) 255
Q4) A formula that includes a structured reference can be fully qualified or unqualified.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
Page 10
Chapter 9: Exploring Financial Tools and Functions
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43592
Sample Questions
Q1) The NPV function is used in calculating the net present value of a transaction,which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.
A) current
B) projected
C) future
D) total
Q2) The list of values in the XNPV function must include at least one positive cash flow and one negative cash flow.
A)True
B)False
Q3) If you don't include a pv value,Excel assumes a future value of 1._________________________
A)True
B)False
Q4) Use the XNPV and XIRR functions for cash flows that appear _______.
A) with a regular pattern
B) at unevenly spaced intervals
C) at evenly spaced intervals
D) to be cyclical
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Performing What-If Analyses
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43593
Sample Questions
Q1) The data table provides the results of several what-if analyses,but results are often clearer if you include a(n)_______ chart.
A) Excel
B) CVP
C) Goal Seek
D) Income
Q2) As in traditional what-if analysis,Goal Seek starts with the end result and determines what value you should use to reach a desired answer.
A)True
B)False
Q3) Binding constraints always show a slack of _______.
A) -0.01
B) 0
C) 0.01
D) 1
Q4) You cannot merge scenarios in situations involving multiple workbooks.
A)True
B)False
Q5) What are the steps to create a one-variable data table?
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Analyzing Data With Business Intelligence
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43594
Sample Questions
Q1) Stores information about a specific characteristic of a person,place,or thing
A)delimiter
B)database
C)record
D)field
E)table
F)query
G)common field
Q2) You can click the ________ View button in Power Pivot to view the structure and relationships of the tables in the Data Model.
A) Data
B) Diagram
C) Database
D) None of the above
Q3) A text file contains only text and numbers without any formulas,special fonts,graphics,or formatted text.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above.
13
Chapter 12: Collaborating on a Shared Workbook
Available Study Resources on Quizplus for this Chatper
75 Verified Questions
75 Flashcards
Source URL: https://quizplus.com/quiz/43595
Sample Questions
Q1) To change the length of the tracking log history,specify a new length in _______ on the Advanced tab in the Share Workbook dialog box.
A) months
B) days
C) years
D) hours
Q2) Provider of verified digital signatures
A)linked object
B)embedding object
C)PDF (Portable Document Format)
D)Standard properties
E)Custom properties
F)Object linking and embedding (OLE)
G)Encryption
H)digital certificate
I)certificate authority (CA)
J)source file
K)shared workbook
Q3) Describe the steps to review tracked changes in a shared workbook.
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 13: Working With Text Functions
Available Study Resources on Quizplus for this Chatper
35 Verified Questions
35 Flashcards
Source URL: https://quizplus.com/quiz/43583
Sample Questions
Q1) The LEN function returns the number of characters in a string.
A)True
B)False
Q2) The _________ function converts the first letter of each word to uppercase,capitalizes any letter that does not follow another letter,and changes all other letters to lowercase.
A) CONCATENATE
B) PROPER
C) Paste Values
D) Columns
Q3) Custom formats describe how Excel should display a:
A) Date or number
B) Time
C) Text string
D) All of the above
Q4) Compatibility Mode keeps the workbook in the older file format with the .xsl file extension.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15