Managing Workbook Properties — Unit test

Question 1

Zoe needs to ensure that a larger spreadsheet fits on a single page. How can she achieve this?

Revolt · Accepted Answer

Orientation settings

Question 2

Seneca needs to combine multiple cells into a single column heading. Which option should she use?

Revolt · Accepted Answer

Merge and Center

Question 3

Which formatting group would commonly be used for monetary figures?

Revolt · Accepted Answer

currency

Question 4

Which item is used in Excel to identify the row of a particular cell?

Revolt · Accepted Answer

number

Question 5

Which margin is at the very bottom of the page when printing worksheets?

Revolt · Accepted Answer

footer margin

Question 6

Which function is used to add a range of cells?

Revolt · Accepted Answer

=SUM

Question 7

Fiona is starting to utilize the protection capabilities of Excel 2016. For the Lock or Unlock Cells function to work, which option should be enabled?

Revolt · Accepted Answer

The Protect Worksheet function needs to be enabled.

Question 8

Jin needs to add a row into his spreadsheet, but he does not want to remove any existing data. Which combination of options should he use?

Revolt · Accepted Answer

Insert > Entire Row

Question 9

Carla needs to be able to quickly switch back and forth between open worksheets. Which option should she use?

Revolt · Accepted Answer

Switch Windows

Question 10

Elan needs to ensure that he can control the order of operations in his formulas. Which characters are used to provide the highest precedence?

Revolt · Accepted Answer

parentheses

Managing Workbook Properties — Unit test Answers

More from this Course

TRY EDGENUITY HACKS