P4C QUIZ MICROSOFT EXCEL 2

All formulas in Excel begin with the following symbol

• =

• +

Which formula below will add the value of B2 to the value of C3?

• =B2+C3

• =B2*B3

Which is NOT a mathematical operator in Excel?

• +

• *

• &

• /

When a formula is typed into a cell, it is also typed into the...

• formula bar

• cell to the right

• ribbon

• font area

Which of the following option is a formula?

• Add A1 - A5

• Subtract the numbers from A1 to A5

• =SUM(A1:A5)

• =A1-B1

What is the function of the word '=SUM' at the beginning of an Excel spreadsheet?

• To add all the data together using addition only

• To calculate all the data correctly without any mistakes

• To tell the person viewing that it should be added together

• To inform the computer that an arithmetic function occurs

Which one is the formula for: Three hundred and forty eight divided by sixty-three?

• 348/63=

• =348/63

• 63/348

• 348/63

Subtracts 67 from cell J7

• 67-J7=

• =J7-98

• =J7-67

• =67-J7

Cell F4 multiplied by cell G7

• G7*F4=

• =F4*G7

• F4xG7=

• =F4xG7

The numbers entered and use for calculations are

• values

• tabs

• cells

• formulas