Unit Test — Unit test Answers

25 verified answers
6

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

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

What is the quickest way to modify the width of columns in Excel to account for different lengths of text?

A
click and drag the column border
B
AutoFill
C
click and drag the row border
D
double-click the column border
10

Nick has chosen to hide a worksheet that contains sensitive data when presenting information from his workbook. Which statement is correct?

A
The worksheets that are hidden will retain data, but references to those worksheets will no longer function.
B
The worksheets that are hidden will have their data removed.
C
The worksheets that are hidden will retain their data, and references will continue to function as normal
D
You will have to unhide the worksheets to make references function correctly.
12

What is required to utilize Excel Online?

A
local administrative account
B
product key for Excel
C
Office 365 user account
D
compact disc version of Excel
14

Liam would like to duplicate the formatting of cells in an easy fashion. Which option should he use?

A
Format Cells dialog box
B
Quick Access tool bar
C
Format Painter
D
Ribbon
17

Which of the following mouse actions selects a range of cells C4:G4?

A
click a single cell
B
click an entire row
C
click and drag from one cell to another
D
click an entire column
18

Lisa intends to use the Hide command on a column in her spreadsheet. How are the cells in this column affected by this command?

A
The data in all of the cells is deleted.
B
The data in only some of the cells is deleted.
C
The cells can no longer be referenced in functions or formulas.
D
The cells can still be referenced in functions or formulas.

Did you find these answers helpful?

Unit Test — Unit test Answers — Computer…