Exam 11: Excell: Collaborating With Others and Preparing a Workbook for Distribution
Exam 1: Introduction to Microsoft Office 2016 Features90 Questions
Exam 1: Excell: Creating a Worksheet and Charting Data97 Questions
Exam 2: Excell: Using Functions, Creating Tables, and Managing Large Workbooks90 Questions
Exam 3: Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools79 Questions
Exam 4: Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets99 Questions
Exam 5: Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering98 Questions
Exam 6: Excell: Creating Charts, Diagrams, and Templates100 Questions
Exam 7: Excell: Creating Pivottables and Pivotcharts91 Questions
Exam 8: Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas96 Questions
Exam 9: Excell: Using Macros and Visual Basic for Applications97 Questions
Exam 10: Excell: External Data, Database Functions, and Side-By-Side Tables96 Questions
Exam 11: Excell: Collaborating With Others and Preparing a Workbook for Distribution95 Questions
Select questions type
Match the following terms with their descriptions:
i.Mark as Final command
II.Passwords
III.change history
IV.Encryption
Free
(Multiple Choice)
4.9/5
(37)
Correct Answer:
D,C,A,B
As others make changes to a shared workbook,you can view and track the changes they make by viewing the details in the ________.
Free
(Multiple Choice)
5.0/5
(39)
Correct Answer:
D
The Mark as ________ command prevents additional changes to the document and disables typing,editing comments,and proofing marks.
Free
(Short Answer)
4.8/5
(33)
Correct Answer:
Final
To change the Attributes area in the Properties dialog box of a file,the file must be ________.
(Short Answer)
4.7/5
(32)
Match the following terms with their descriptions:
i.metadata
II.background image
III.Track Changes
IV.Symbol dialog box
v.Read-only property
(Multiple Choice)
4.7/5
(36)
You can change file properties before the file is distributed so that the recipients will know who distributed the file.
(True/False)
4.9/5
(34)
Sheet names make it easier to understand and navigate a ________.
(Short Answer)
4.7/5
(36)
Match the following terms with their descriptions:
i.intranet
II.watermark
III.properties
IV.collaboration
v.shared workbook
(Multiple Choice)
4.7/5
(31)
In a shared network environment,using the Contact Card option,you could do the following with certain authors of the spreadsheet: ________.
(Multiple Choice)
4.8/5
(31)
A faded image or text used as a background of a document is ________.
(Multiple Choice)
4.8/5
(37)
When more than one copy of a shared workbook contains marked changes,first merge the workbooks so you can review all the changes in a single workbook.
(True/False)
4.8/5
(40)
In Excel,a Marked as Final document will display Read-Only in the ________ bar.
(Short Answer)
4.8/5
(29)
When more than one copy of the shared workbook contains marked changes,first ________ the workbooks so that you can view everyone's changes in a single workbook.
(Multiple Choice)
4.7/5
(37)
To view details about workbook changes,including insertions and deletions,you can control the collaboration process by using Excel's ________.
(Multiple Choice)
4.8/5
(36)
When you create your own digital certificate,it is referred to as a ________.
(Multiple Choice)
4.9/5
(36)
Once the changes are recorded,you can review the shared file and decide to ________.
(Multiple Choice)
4.9/5
(22)
Previous sharing sessions are no longer available if you ________.
(Multiple Choice)
4.8/5
(33)
A digital means of proving identity and authenticity in a document is known as a digital license.
(True/False)
4.8/5
(35)
After changes are made to a copy of a shared workbook,it can be ________ with the original shared workbook.
(Short Answer)
4.8/5
(33)
Showing 1 - 20 of 95
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)