Understanding Excel Formulas and Functions

What is the main purpose of using formulas in Excel?

• To change the font colour

• To perform calculations automatically

• To print the spreadsheet

• To draw pictures

Which symbol is always used to start a formula in Excel?

• $

• @

• =

• #

What does a column in Excel look like?

• A horizontal line of cells

• A vertical line of cells

• A single cell

• A diagonal line of cells

Which of the following is a correct cell reference in Excel?

• 1A

• A1

• AA

• 11

If you want to add the values in cells A1 and B1, which formula would you use?

• =A1+B1

• =A1*B1

• =A1/B1

• =A1-B1

What is the function of the SUM formula in Excel?

• To subtract numbers

• To add numbers together

• To multiply numbers

• To divide numbers

Which formula would you use to find the average of numbers in cells A1 to A5?

• =SUM(A1:A5)

• =AVERAGE(A1:A5)

• =COUNT(A1:A5)

• =MIN(A1:A5)

What does the formula =A2*B2 do?

• Adds the values in A2 and B2

• Multiplies the values in A2 and B2

• Divides A2 by B2

• Subtracts B2 from A2

Which of the following is NOT a basic arithmetic operator in Excel?

• +

• -

• ^

• %

If you want to copy a formula from one cell to another, which feature would you use?

• Format Painter

• Fill Handle

• Spell Check

• Sort