Excel Formulas

Which of the following is not an arithmetic operator?

• =

• +

• s

• ^

Why do you start a formula with an = sign?

• to tell Excel you are entering a formula

• just because

• you are entering text

Where does Excel return the result of a formula

• the same cell where the formula is entered

• A1

• in your head

What is the answer to the following formula: =2^4 + 7

• 13

• 71

• 23

• 123

What is the answer to the following formula: =25% * 40

• 140

• 25

• 75

• 10

In the following formula, what gets done first: =6+2*(6-2)

• 6+2

• 2*6

• 2*(6+2)

• (6-2)

Which arithmetic operator is being used in the following formula: =T75- AA45

• addition

• multiplication

• subtraction

• format

What is the answer if the value in cell A5 is 75; C10 is 20; B23 is 15; E15 is 100; G20 is 5 and the formula is: =C10 + (A5 * G20)/ B23

• 43

• 55

• 49.6

• 45

What is the answer to the following formula: -(P45/Q14) where the value in cell P45 is 25, and in cell Q14 is 5?

• 5

• 15

• -30

• -5

Does Excel allow the use of numbers in formulas?

• yes

• no