Exam 12: Collaborating on a Shared Workbook
Exam 1: Getting Started With Excel100 Questions
Exam 2: Formatting Workbook Text and Data100 Questions
Exam 3: Calculating Data With Formulas and Functions100 Questions
Exam 4: Analyzing and Charting Financial Data100 Questions
Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts100 Questions
Exam 6: Managing Multiple Worksheets and Workbooks100 Questions
Exam 7: Developing an Excel Application100 Questions
Exam 8: Working With Advanced Functions100 Questions
Exam 9: Exploring Financial Tools and Functions100 Questions
Exam 10: Performing What If Analyses100 Questions
Exam 11: Connecting to External Data99 Questions
Exam 13: Managing Your Files100 Questions
Select questions type
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of data stored in rows and columns
Free
(Multiple Choice)
4.9/5
(37)
Correct Answer:
E
To add a digital signature to a document,you need a(n) ,which is an attachment to a document that authenticates the source of the signature._________________________
Free
(True/False)
4.9/5
(32)
Correct Answer:
False
To determine whether a workbook contains sensitive or personal information,you use the _______ to search the workbook to locate data and text that you may want removed.
Free
(Multiple Choice)
4.9/5
(31)
Correct Answer:
B
Database tables can be inserted directly into PivotCharts and ____________________.
(Short Answer)
4.9/5
(39)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Conditions you set to limit the number of records a database extracts
(Multiple Choice)
4.8/5
(27)
_______ properties are properties created for organizations to use in designing and distributing electronic forms.
(Multiple Choice)
4.9/5
(31)
If you cannot obtain a digital certificate from a third party,you can create your own ____________________ certificate,which is a certificate created and signed by the person it certifies.
(Short Answer)
4.8/5
(33)
Marking a workbook as final makes the workbook _______,discouraging a user from making any changes to it.
(Multiple Choice)
5.0/5
(37)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the collection of characteristics of a particular person,place,or thing
(Multiple Choice)
4.9/5
(29)
To determine whether a workbook contains sensitive or personal information,you use the ____________________ to search the workbook to locate data and text that you may want removed.
(Short Answer)
4.9/5
(24)
____________________ properties are properties you define and create specifically for a workbook.
(Short Answer)
4.8/5
(34)
The wide collection of file hosting sites that allow document sharing supported by the Internet include _______.
(Multiple Choice)
4.8/5
(29)
Your cousin Rebecca knows that you are an experienced Excel user. She has created a workbook and needs input from three fellow workers. She wants to retain her workbook as the original copy. She will need your help in collecting input.
-Comments are a powerful collaboration tool,giving team members the ability to offer insights and make suggestions about the workbook and its content.Now Rebecca would like to review the comments by clicking the _______.
(Multiple Choice)
4.8/5
(38)
Once workbook sharing is removed,the contents of the tracking log are ____________________,and there is no way to retrieve the history of edits made to the document.
(Short Answer)
4.8/5
(39)
A _______ Excel workbook tracks the changes made by different people so everyone can examine when and where each change was made.
(Multiple Choice)
4.8/5
(34)
A final way to ensure that a document has not been changed by an unauthorized user is with a(n)________ signature,which can be thought of as an electronic version of a written signature.
(Multiple Choice)
4.9/5
(38)
_______ occur when users try to save different values in the same cell.
(Multiple Choice)
4.8/5
(37)
Document properties or metadata are the descriptive details about a workbook.
(True/False)
4.9/5
(33)
MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Field that is present in both tables
(Multiple Choice)
4.8/5
(39)
The most serious differences between Excel 2013 and older versions of Excel include: _______.
(Multiple Choice)
4.8/5
(40)
Showing 1 - 20 of 120
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)