Question 1

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Accepted Answer

The answer of ____________________ are those portions of a printed...

Question 2

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Accepted Answer

A)  scheme 
B)  gallery 
C)  theme 
D)  style

Question 3

When you decrease the row height to ____,the row is hidden.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3

Question 4

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

A)  placement 
B)  operations 
C)  positioning 
D)  selections

Question 5

You can click the ____ button to undo an automatic correction.

Accepted Answer

A)  Auto Fill Options 
B)  AutoCorrect Options 
C)  Paste Options 
D)  Trace Error

Question 6

To copy cell contents,you can select the cell and then press the ____ keys.

Accepted Answer

A)  CTRL+V 
B)  CTRL+X 
C)  CTRL+B 
D)  CTRL+C

Question 7

A formula in a cell that contains a reference back to itself is called a(n)____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 8

To set row height to best fit,____________________ the bottom boundary of the row heading.

Accepted Answer

The answer of To set row height to best fit,____________________...

Question 9

You can press the ____________________ key to quit Range Finder.

Accepted Answer

The answer of You can press the ____________________ key to...

Question 10

You can click the Page Layout button on the status bar to switch to ____________________ view.

Accepted Answer

The answer of You can click the Page Layout button...

Question 11

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

Accepted Answer

A) True 
 B)False

Question 12

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is the path to the Conditional Formatting button?

Accepted Answer

A)  (HOME tab | Editing group) 
B)  (STYLES tab | Formatting group) 
C)  (FORMATTING tab | Styles group) 
D)  (HOME tab | Styles group)

Question 14

Leo, owner of Leo’s Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
-Leo wants the sales numbers for rye bread,onion rolls,and bagels to look different each time the sales for each exceeds $500.What Excel feature can Leo use to accomplish this?

Accepted Answer

A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version

Question 15

The Accounting number format assigns a floating dollar sign._________________________

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Accepted Answer

The answer of The ____________________ is a small black square...

Question 17

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 18

Briefly discuss the order of operations.

Accepted Answer

The answer of Briefly discuss the order of operations....

Question 19

Cooler colors tend to pull away from the reader._________________________

Accepted Answer

A) True 
 B)False

Question 20

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Accepted Answer

A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder

Exam 2: Formulas,Functions,and Formatting

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

When you decrease the row height to ____,the row is hidden.

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

You can click the ____ button to undo an automatic correction.

To copy cell contents,you can select the cell and then press the ____ keys.

A formula in a cell that contains a reference back to itself is called a(n)____________________.

To set row height to best fit,____________________ the bottom boundary of the row heading.

You can press the ____________________ key to quit Range Finder.

You can click the Page Layout button on the status bar to switch to ____________________ view.

To use Range Finder to verify that a formula contains the intended cell references,click or tap the cell with the formula you want to check.

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

Which of the following is the path to the Conditional Formatting button?

The Accounting number format assigns a floating dollar sign._________________________

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Briefly discuss the order of operations.

Cooler colors tend to pull away from the reader._________________________

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.