Excel 1.03-1.05(Part 1)

Match it! Select the correct answer from the pull down...Good luck!

Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

Which of the following are valid Microsoft Excel functions?

Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?

Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?

Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

Angie is calculating her average sales for the past four months. If she uses =AVERAGE(B1:B4), this is an example of which type of entry?