1. Which
Group(s) are on the Review Ribbon? (Select all correct answers.)
a. Proofing
b. Language
c. Comments
d. Changes
Tip: Advanced Excel, page 199
2. Spreadsheets can be spell-checked.
a. True
b. False
Tip: Advanced Excel, page 200
3. Which of the following actions can be restricted in the Protect Sheet
command? (Select all correct answers.)
a. Format Cells
b. Format Columns
c. Format Rows
d. Insert Rows
e. Insert Columns
Tip: Advanced Excel, page 206
4. Which of
the following are true about the Protect and Share options?
(Select all
correct answers.)
a. The Tracking is turned on
b. The Workbook is shared
c. A Password is required
Tip: Advanced Excel, page 210
5. Which of
the following are Reviewing options? (Select all correct answers.)
a. Accept
b. Reject
c. Accept all
Tip: Advanced Excel, page 214
6. More than one person can add a comment on an Excel spreadsheet.
a. True
b. False
Tip: Advanced Excel, page 218
7. Which is true about Compare and Merge? (Select all correct answers.)
a. Only works on a Shared Workbook
b. Command is NOT available in Reviewing Ribbon by default
c. Works on any workbook
Tip: Advanced Excel, page 219
8. Which of
the following are document properties? (Select all correct answers.)
a. Size
b. Title
c. Last Modified
d. Created
e. Author
f. Last Printed
Tip: Advanced Excel, 223
9. What is the new Excel file format used in Office 2007, 2010 and 2013?
a. .xls
b. xlsx
c. .xlst
d. .exl
Tip: Advanced Excel, page 227
10. Which of the following is true about the Mark as Final command?
(Select all
correct answers.)
a. It is to discourage editing
b. A file marked as Final has the ribbons removed
c. A file marked as Final cannot be edited
Tip: Advanced Excel, page 230
