Uploading Your Work — Unit test Answers

11 verified answers2 views
6

Which of the following represents the standard order of operations for mathematical formulas?

A
parentheses, exponents, multiplication and division, addition and subtraction
B
addition and subtraction, multiplication and division, parentheses, exponents
C
exponents, parentheses, multiplication and division, addition and subtraction
D
multiplication and division, parentheses, exponents, addition and subtraction
9

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

A
Orientation settings
B
Margin settings
C
Collation settings
D
Label settings
11

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

A
top margin
B
bottom margin
C
header margin
D
footer margin
12

Which formatting group would commonly be used for monetary figures?

A
number
B
general
C
accounting
D
currency
13

Maria selects cells C4 through F4 using her mouse. What is the term used to describe this selection?

A
worksheet
B
range
C
cell
D
named range
14

Which of the following Excel features allows you to automatically populate adjacent cells with data?

A
AutoEdit
B
AutoFill
C
Macros
D
Flash Fill
15

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

A
Arrange All
B
Arrange Side by Side
C
Switch Windows
D
Collapse Windows
16

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?

A
Delete > Shift Cells Left
B
Insert > Entire Row
C
Insert > Shift Cells Down
D
Delete > Entire Row
17

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

A
Wrap Text
B
Align Center
C
Merge and Center
D
Align Right

Did you find these answers helpful?