Deck 95: Formulas

Question 1

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

Answer 1

False

Question 2

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

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

Answer 2

D

Question 3

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

Answer 3

True

Question 4

What is the value displayed in a cell that contains the formula =48+4*2?

A) 104
B) 56
C) 54
D) none of the above

Question 5

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

Question 6

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

A) control+grave accent
B) option+F2
C) alt+grave accent
D) command+F2

Question 7

In most situations,Excel formulas contain ____.

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

Question 8

The formula analysis process is called formula auditing.

Question 9

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

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

Question 10

The hyphen key is used for multiplication.

Question 11

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 12

When you use a(n)____ in a formula,the cell's value is automatically updated when you type a new value in one of the cells.

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

Question 13

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

Question 14

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

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

Question 15

In Excel,when you click the Show Formulas button,you can choose to display the formula in all cells containing a formula.

Question 16

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) none of the above

Question 17

You ____-click a cell when you want to edit the contents.

A) command
B) option
C) double
D) right

Question 18

To enter the number in Excel,type 2,press and hold the shift key,and then press the ____ key. c : \Users\USER\Dropbox\QuizPlus Production Documents\To Be Verified\Amani\TB1470,Emerge with Computers v.5.0 5th Edition by Kenneth Baldauf\Images\C1020(11.03_2011AcademPub_0.' JPG '

A) 4
B) 6
C) control
D) F1

Question 19

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

Question 20

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 21

You can use a cell's ____________________ to copy a formula from one cell to another.

Question 22

You can make formulas easier to read by assigning ____ to specific cells,and then use them in formulas instead of cell addresses.

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

Question 23

Formulas should begin with a(n)____________________ sign.

Question 24

Most of the tools for auditing formulas are found on the ____________________ tab in the Function and Audit Formulas groups.

Question 25

Click the ____________________ key to exit Edit mode.

Question 26

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

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