Deck 48: Formulas

Question 1

In Excel,when you click the Show Formulas button,all cells containing a formula will display the formula instead of the formula result.

Answer 1

True

Question 2

After you have finished entering a formula,complete the process by pressing the Enter key.

Answer 2

True

Question 3

The formula =B1+B2+B3+B4 is copied from cell B5 to cell C5.What is the formula found in cell C5 after the copy is complete?

A) =B1+B2+B3+B4
B) =C1+C2+C3+C4
C) =B5
D) =

Answer 3

B

Question 4

In most situations,Excel formulas contain specific values and not cell references.

Question 5

Excel starts working on the left when calculating a formula,and then follows ____ as it moves to the right.

A) the order of precedence
B) the formula
C) operations
D) operators

Question 6

To perform a division operation,use the ____ key on the keyboard or keypad.

A) colon
B) forward slash
C) hyphen
D) backward slash

Question 7

A cell containing a formula will always display the result of the formula.

Question 8

The advantage of using a(n)____ in a formula is that the result is automatically updated if a cell's value changes.

A) cell value
B) operator
C) cell reference
D) marquee

Question 9

The hyphen character is used for multiplication.

Question 10

In most situations,formulas contain ____.

A) specific values
B) functions
C) formats
D) cell references

Question 11

A formula is an expression that generally results in a numerical value.

Question 12

What is the value displayed in a cell that contains the formula =15*4/6?

A) 66
B) 25
C) 10
D) 2/3

Question 13

Double-clicking a cell performs the same action as pressing the ____ key.

A) Tab
B) F6
C) F2
D) Delete

Question 14

To analyze an existing formula in a cell for accuracy,use the ____.

A) color-coding system
B) Evaluate Formula button
C) fill handle
D) Insert Function button

Question 15

A defined name as a cell reference must always be unique.

Question 16

Formula analysis is called formula auditing.

Question 17

To type an exponent as a cell value such as 4²,you would type the number 4,hold down the Shift key,and then press 2.

Question 18

When you enter a formula in a cell,what is displayed in the cell after you press the Enter key?

A) the formula's result
B) the formula
C) an Excel operator
D) an error indicator

Question 19

When you press F5 in a cell containing a formula,the formula becomes visible with its cell references color-coded.

Question 20

What is the value displayed in a cell that contains the formula =4*(5+6)?

A) 26
B) 15
C) 120
D) 44

Question 21

A name assigned to a range of cells is called a ____ name.

A) range
B) function
C) defined
D) list

Question 22

You can show all of a spreadsheet's formulas by pressing the ____ key combination.

A) Ctrl+grave accent (`)
B) Alt+F2
C) Alt+grave accent( `)
D) Ctrl+F2

Question 23

To simplify formulas,you can assign ____ to specific cells,and then use them in formulas instead of cell addresses.

A) ranges
B) names
C) values
D) formulas