AnswersGA-Business and TechnologyManaging Workbook Properties

Managing Workbook Properties — Unit test Answers

24 verified answers2 views
21
Free Preview

When using the protection options in Excel 2016, what does the Protect Workbook function do?

A
It protects all the worksheets in a workbook from being reformatted or typed into.
B
It adds a password to access the worksheet.
C
It prevents worksheets from being inserted, deleted, or moved.
D
It saves a workbook in a way that will allow only a select group of people to access it.
22
Free Preview

Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?

A
=SUM(F2:F5,Sheet2A10)
B
=SUM(F2:F5,Sheet2!A10)
C
=SUM(F2:F5,!Sheet2A10)
D
=SUM(F2:F5,_Sheet2A10)
23

Which setting is used to determine the order of printing pages?

A
Collation Settings
B
Orientation Settings
C
Margin Settings
D
Scaling Settings
24

In addition to the format commands that are found in the ribbon, which option is available for more extensive formatting?

A
Fix Cells dialog box
B
Format Cells dialog box
C
Format dialog box
D
Quick Access tool bar

Did you find these answers helpful?

More from this Course

Quiz
20 verified answers

Agriculture, Food, and Natural Resources Career Pathways

Assignment
9 verified answers

Sharing and Protecting Worksheets

Assignment
3 verified answers

Managing Workbook Properties