Functions, Formulas, and Tables Quiz

What is the quickest way to enter a function in a cell if you already know the name of the function?

• Search for the function in the Formula tab.

• Use the AutoSum feature.

• Directly enter the function in the cell.

• Use the AutoFill feature.

What does AutoFill allow you to do in an Excel spreadsheet? Select the best answer.

• Automatically select a function for a formula

• Automatically fill cells with information based on other selected cells

• Automatically enter headings for tables

• Generate random data for selected cells

How many arguments are used in the following Excel function which returns the current date and time? NOW()

• Zero

• One

• Two

• Three

How many operands are in the following formula? =D4+D13-D15*D13

• 3

• 4

• 5

• 6

Which of these formulas uses only relative cell references?

• ($A$10+6)/5

• 5*(10+20)

• SUM(A1:A9)/2

• (10^C$5)+20

What is the argument in this function? =MAX(F3:F26)

• F3:F26

• MAX

• F3

• F26

In the formula =12*A3*(25-13), which calculation is performed first?

• 12*A3

• A3*(25-13)

• 25-13

• None of the above

How many errors are in the following formula? =(A3+A5+A6)/A5*B1)

• 1

• 2

• 3

• 0

Which of these statements about AutoFilling formulas is TRUE?

• You can AutoFill formulas, but not functions.

• You cannot AutoFill formulas with absolute cell references.

• AutoFill automatically adjusts formulas with relative cell references.

• None of the above

How many operators are in the following formula? =B14+AVERAGE(E1:E50)-D3/D6

• 1

• 2

• 3

• 4