Exam 5: Excel Lesson 3: Using Formulas and Functions

Which error value could you correct by widening the column containing the cell?

What kinds of things should you be aware of when you move or copy a formula? How can you check your worksheet to see if any errors have occurred after moving or copying formulas? Does checking a worksheet for errors guarantee that it is error-free?

A constant is a sign or symbol that indicates what calculation is to be performed.

A forward slash (/) is the arithmetic operator used for subtraction.

When you point to the fill handle on a selected cell, the pointer turns to a black cross that you can click and drag.

Excel indicates when a formula you have entered results in an error by displaying a(n) ____________________.

When a formula contains more than one arithmetic operator, the ____________________ is the specific sequence used to calculate the value of the formula.

Case EX 3-2 Bernadette has created a worksheet containing sales figures for the past year. She needs to extract information about the data that she can use in a presentation. To total a range of cells for the month of January, Bernadette could use the Sum button on the ____ tab in the Editing group.

A function must follow a set of established rules, called ____.

The Insert Function dialog box is displayed when you click the Insert Function button in the Function Library group on the ____ tab of the Ribbon.

Every function requires an argument.

Excel provides the user with built-in formulas, called functions , that enable you to perform complex calculations easily.

In a formula, when Excel performs calculations in the normal algebraic precedence, which calculation is executed first?

____ are numbers entered directly into a formula that do not change.

To quickly switch between displaying values and formulas in a worksheet, use the keyboard shortcut ____.

In the function =SUM(B8:B11), which is the argument?

When you click the Sum button arrow, a menu of the most common financial functions is displayed.

Case EX 3-2 Bernadette has created a worksheet containing sales figures for the past year. She needs to extract information about the data that she can use in a presentation. If Bernadette wanted to find out which region had the largest number of sales, she would use which statistical function?

A cell with an error displays a triangle in the lower-right corner.

When you click the Error Checking button, Excel checks for common errors in your worksheet and displays the Error Checking dialog box with options for resolving the error.