Question 1

Match between columns
                        Premises: Applies the Currency style with a floating dollar sign and two decimal places.

Accepted Answer

The Answer of = and CONTROL-SHIFT-$ and #REF! and COMMAND-1 is...

Question 2

Match between columns
                        Premises: An invalid cell reference in a formula.

Accepted Answer

The Answer of CONTROL-SHIFT-$ and COMMAND-= and = and #REF! is...

Question 3

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A)  ^
B)  *
C)  %
D)  > D

Question 4

Using the Excel spell checker, you can ____.

Accepted Answer

A)  check the spelling in a single cell
B)  check the spelling of words in a selected range
C)  add words to the dictionary
D)  add words to the AutoCorrect list

Question 5

The adjusted cell references in a copied and pasted formula are called ____ references.

Accepted Answer

A)  related
B)  relative
C)  pasted
D)  alternative

Question 6

Leo, owner of Leo's Bread Company, recently installed Excel 2010 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 7

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

A)  MIN
B)  SUM
C)  AVERAGE
D)  MAX

Question 8

Clicking the Insert Function button opens the Formula Builder window, as shown in the accompanying figure.

Accepted Answer

A) True 
 B)False

Question 9

The / arithmetic operator indicates ____________________.

Accepted Answer

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

Question 10

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell, and Excel will calculate the result.

Accepted Answer

The answer of One of the reasons Excel is such...

Question 11

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A)  function
B)  feature
C)  task
D)  calculation

Question 12

Match between columns
                        Premises: Manually recalculates formulas.

Accepted Answer

The Answer of COMMAND-OPTION-RETURN and COMMAND-1 and COMMAND-C and CONTROL-SHIFT-$ is...

Question 13

The values that you use with a function are called arguments .

Accepted Answer

A) True 
 B)False

Question 14

The AutoSum pop-up menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following is the path to the Spelling button?

Accepted Answer

A)  (Home tab | Proofing group) 
B)  (Proofing tab | Spelling group) 
C)  (Review tab | Proofing group) 
D)  (Review tab | Checking group)

Question 18

Pressing the COMMAND-= keys instructs Excel to recalculate all formulas.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

If you have a long text entry, such as a paragraph, you can instruct Excel to ____________________ text in the cell.

Accepted Answer

The answer of If you have a long text entry,...

Exam 4: Excel: Formulas, Functions, and Formatting

Identify the letter of the choice that best matches the phrase or definition.

Identify the letter of the choice that best matches the phrase or definition.

All of the following are valid Excel arithmetic operators EXCEPT ____.

Using the Excel spell checker, you can ____.

The adjusted cell references in a copied and pasted formula are called ____ references.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Clicking the Insert Function button opens the Formula Builder window, as shown in the accompanying figure.

The / arithmetic operator indicates ____________________.

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell, and Excel will calculate the result.

A ____ is a prewritten formula that is built into Excel.

Identify the letter of the choice that best matches the phrase or definition.

The values that you use with a function are called arguments .

The AutoSum pop-up menu allows you to enter one of five often-used functions easily into a cell.

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

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

Which of the following is the path to the Spelling button?

Pressing the COMMAND-= keys instructs Excel to recalculate all formulas.

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

If you have a long text entry, such as a paragraph, you can instruct Excel to ____________________ text in the cell.