Excel Chapter 2 Working with Formulas and Functions

Which of the following is the correct formula for adding the contents of cell C2 to the contents of cell C3?

• C2+C3

• =C2+C3

• C2+C3=

• +2C+3C

Rather than typing a cell reference into a formula, you can _____ to add it to the formula.

• click the cell on the worksheet

• hover your mouse pointer over the cell on the worksheet

• right-click the cell on the worksheet

• drag the referenced cell into the cell containing the formula

Because it follows the standard mathematical order of operations, Excel will evaluate the formula =4+2*3 as equal to _____.

• 10

• 18

• 9

• 2

In Excel, which of the following formulas would return a result of 33?

• =5+6*3

• =6+5*3

• =(5+6)*3

• =5*3+6

Which of the following functions will cause the current date to display in the active cell?

• =(TODAY)

• =TODAY()

• =(DATE)

• =DATE()

Which of the following formulas should you use to find the total of a range of values located in rows 5 through 15 of column F of an Excel worksheet?

• =SUM(F5:F15)

• =ADD(F5:F15)

• =TOTAL(F5:F15)

• @SUM(F5:F15)

Most Excel functions require that their arguments be surrounded by _____.

• braces { }

• square brackets [ ]

• quotation marks “ ”

• parentheses ( )

If you don’t know the exact name of a function, you can use the Search for a function text box in the _____ to enter a description of what you want to do.

• Insert Function dialog box

• Formula bar

• Name box

• More Functions button drop-down list

The AVERAGE function is located in the Statistical option, which can be accessed by clicking the _____ button in the Function Library group on the FORMULAS tab.

• Financial

• Logical

• More Functions

• Math & Trig

To preview the result of an AutoSum function, drag over a range of cells and then check the

• Formula bar

• Status bar

• Name box

• Title bar