Have an account?
Skip to Content
Computers
7th -
12thgrade
Excel Chapter 2 Working with Formulas and Functions
22 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Because it follows the standard mathematical order of operations, Excel will evaluate the formula =4+2*3 as equal to _____.
10
18
9
2
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Which of the following functions will cause the current date to display in the active cell?
=(TODAY)
=TODAY()
=(DATE)
=DATE()
- Multiple ChoicePlease save your changes before editing any questions.
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)
- Multiple ChoicePlease save your changes before editing any questions.
Most Excel functions require that their arguments be surrounded by _____.
braces { }
square brackets [ ]
quotation marks “ ”
parentheses ( )
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Which function should you use to calculate your payments for a car loan?
PMT
LOAN
AUTO
MORTGAGE
- Multiple ChoicePlease save your changes before editing any questions.
Which of the following is an absolute cell reference?
A5
$B$6
$C8
C$4
- Multiple ChoicePlease save your changes before editing any questions.
Imagine that cells C1:C7 contain the hours an employee worked each day for one week. Cell B3 contains the employee’s hourly wage. You want to insert a formula in cells D1:D7 that will calculate the employee’s total earnings for each day. Which of the following formulas, when entered in cell D1 and then copied down the rest of the column, will give you the correct results?
=C1*$B$3
=$C$1*B3
=C1*$B3
=$C$1*$B$3
- Multiple ChoicePlease save your changes before editing any questions.
Chapter 2 suggests that key data referenced by formulas throughout the worksheet should be placed _____ to make them more accessible.
near the top of the sheet
at the bottom of the sheet
directly next to the cells containing formulas that reference the data
in the right-most column of the worksheet
- Multiple ChoicePlease save your changes before editing any questions.
If you move a formula containing a relative and an absolute reference to a new location, _____.
both cell references will change
both cell references will remain the same
the absolute reference will change, but the relative reference will remain the same
the relative reference will change, but the absolute reference will remain the same
- Multiple ChoicePlease save your changes before editing any questions.
To paste a copied cell in more than one location, use _____.
the Enter key
the keyboard shortcut Ctrl + Enter
the Paste button
the options on the Insert tab
- Multiple ChoicePlease save your changes before editing any questions.
To clear the scrolling marquee that surrounds a cell range you have selected and cut, press _____.
Esc
F1
F12
Alt + M
- Multiple ChoicePlease save your changes before editing any questions.
You can remove the data from a range of cells with any of the following methods except _____.
select the range and then press Delete
right-click the range, then select Clear Contents from the shortcut menu
select the range, click the Clear button in the Editing group on the HOME tab, and then click Clear Contents
select the range and press F1
- Multiple ChoicePlease save your changes before editing any questions.
Which of the following options is not available on the Clear button in the Editing group on the HOME tab?
Clear Formats
Clear Comments
Clear All
Clear Errors
- Multiple ChoicePlease save your changes before editing any questions.
To display all the formulas in a worksheet at once, click the _____ button in the Formula Auditing group on the FORMULAS tab.
Show Formulas
Error Checking
Evaluate Formula
Audit Formulas
- Multiple ChoicePlease save your changes before editing any questions.
The keyboard shortcut to display formulas is _____.
Ctrl + “
Ctrl + `
Alt + F2
Alt + F4
- Multiple ChoicePlease save your changes before editing any questions.
To print a worksheet with the formulas displayed, you may need to _____ first.
click the Protect Sheet button
set up conditional formatting
adjust the orientation or margins
format the worksheet as a table