Question 1

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 formulaE) A) and B)
F) A) and C)

Question 2

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n) ____________________ you can use...

Question 3

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

Accepted Answer

A)   0
B)   1
C)   2
D)   3E) All of the above
F) A) and B)

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

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 6

The ____ function displays the highest value in a range.

Accepted Answer

A)   MIN
B)   SUM
C)   MAX
D)   AVERAGEE) A) and B)
F) A) and C)

Question 7

A(n) ____________________ is a dot on the screen that santains a salor.

Accepted Answer

The answer of A(n) ____________________ is a dot on the...

Question 8

Typing =av in a cell displays the ____________________, as shown in the acsampanying figure.

Accepted Answer

Formula Au...

Question 9

A ____ is text and graphics that print at the top of each page.

Accepted Answer

A)   header
B)   topper
C)   margin
D)   crownE) A) and B)
F) A) and C)

Question 10

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Accepted Answer

A) True 
 B)False

Question 11

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Accepted Answer

A) True 
 B)False

Question 12

The default font for the Basis theme is different than the default font for the Office theme.

Accepted Answer

A) True 
 B)False

Question 13

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Accepted Answer

A)   20xx
B)   30xx
C)   18xx
D)   19xxE) All of the above
F) B) and D)

Question 14

Of warmer and saoler salors, the kind of salors that tend to reach toward the reader are ____________________ salors.

Accepted Answer

The answer of Of warmer and saoler salors, the kind...

Question 15

Point mode allows you to ____, as shown in the acsampanying 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 santents directly in the cellE) A) and B)
F) All of the above

Question 16

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

A) True 
 B)False

Question 17

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 18

While holding down the ALT key, you can select nonadjacent ranges and cells.

Accepted Answer

A) True 
 B)False

Question 19

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 FinderE) A) and D)
F) A) and C)

Question 20

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

Accepted Answer

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

Exam 13: Formulas, Functions, and Formatting Question

A ____ is text and graphics that print at the top of each page.

Correct AnswerverifiedShow Answer

A(n) ____________________ is a dot on the screen that santains a salor.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Typing =av in a cell displays the ____________________, as shown in the acsampanying figure.

Correct AnswerverifiedFormula Au...View AnswerShow Answer

Of warmer and saoler salors, the kind of salors that tend to reach toward the reader are ____________________ salors.

Correct AnswerverifiedShow Answer

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Correct AnswerverifiedShow Answer

The ____ function displays the highest value in a range.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

The Insert Options button lists formatting options.

Correct AnswerverifiedShow Answer

The default font for the Basis theme is different than the default font for the Office theme.

Correct AnswerverifiedShow Answer

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Correct AnswerverifiedShow Answer

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Correct AnswerverifiedShow Answer

While holding down the ALT key, you can select nonadjacent ranges and cells.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Formula Au...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified