Question 1

Moving from left to right,the first calculation in the order of operations is negation (-).

Accepted Answer

A) True 
 B)False

Question 2

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

Accepted Answer

A)  40 
B)  26 
C)  48 
D)  13

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Copies a formula.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 4

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 5

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Accepted Answer

A)  contiguous 
B)  indexed 
C)  direct 
D)  indirect

Question 6

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Accepted Answer

A)  left parenthesis 
B)  right bracket 
C)  right parenthesis 
D)  left bracket

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Opens the Format Cells dialog box.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 8

Anna is a competitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet contains the following data: start and end time, total time, and distance.
-After three months,Anna wants to the know the average distance she runs.What should she do to calculate the average distance?

Accepted Answer

A)  Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula AutoComplete list and then enter the function's argument. 
B)  Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula AutoComplete list and then enter the function's argument. 
C)  Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D)  Enter the text =su at the end of the data in the Distance column; then select the SUM function from the Select Function list and then enter the function's argument.

Question 9

The / arithmetic operator indicates ____________________.

Accepted Answer

The answer of The / arithmetic operator indicates ____________________....

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Wraps text in a cell.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 11

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

Accepted Answer

A)  AutoCorrect 
B)  Insert 
C)  Auto Fill 
D)  Paste

Question 12

____________________ colors jump out of a dark background and are easiest to see.

Accepted Answer

The answer of ____________________ colors jump out of a dark...

Question 13

The default view in Excel is called ____ view.

Accepted Answer

A)  Normal 
B)  Standard 
C)  Basic 
D)  Values

Question 14

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula

Question 16

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is a method of entering functions?

Accepted Answer

A) keyboard,touch gesture,or pointer 
B) the Sum menu 
C) the Insert Function box in the formula bar 
D) the Name box area in the formula bar 
E)  None of the above.

Question 18

-Point mode allows you to ____,as shown in the accompanying figure.

Accepted Answer

A)  select cells for use in a formula using the keyboard 
B)  select a function from the Sum button list 
C)  select cells for use in a formula using the mouse pointer 
D)  edit cell contents directly in the cell

Question 19

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

Accepted Answer

The answer of ____________________ means that the width of a...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Spell-checking a worksheet.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Exam 2: Formulas,Functions,and Formatting

Moving from left to right,the first calculation in the order of operations is negation (-).

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Copies a formula.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Opens the Format Cells dialog box.

The / arithmetic operator indicates ____________________.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Wraps text in a cell.

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

____________________ colors jump out of a dark background and are easiest to see.

The default view in Excel is called ____ view.

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

Which of the following happens when you enter the formula =G15 into a cell?

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

Which of the following is a method of entering functions?

-Point mode allows you to ____,as shown in the accompanying figure.

____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Spell-checking a worksheet.