Excel Formulas

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

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 10; and C10 is 20 and the formula is: =C10+A5

• 10

• 20

• 30

• 40

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

• 20

Does Excel allow the use of numbers in formulas?

• yes

• no

What order does the order of operations follow?

• right to left

• left to right

• up to dow

• middle outwards

Do you need an = sign to start a formula?

• no

• yes

• never

What does the function Autosum do?

• Adds the numbers up in the cell in the selected cells

• Multiplies the numbers in the selected cells

• Divides the numbers in the selected cells

• Counts the numbers in the selected cells

What does the * symbol do in Excel?

• Divides

• Multiplys

• Adds

• Takes away