Name:    Computer Literacy Module 2 Lesson 18

True/False
Indicate whether the sentence or statement is true or false.

1.

A formula can consist of a single cell reference.

2.

Formulas use numbers, cell references, and operators to add, subtract, multiply, and divide.

3.

When adding cell addresses in a formula, you must use uppercase letters.

4.

After you enter a formula, you do not see the formula in the cell; you see the result of the formula.

5.

If Excel cannot properly perform a calculation, it will display an error value in the cell where you entered the formula.

6.

You can assume that the Excel AutoSum function will always pick the correct range to sum.

7.

Cell references must be entirely absolute or entirely relative.

8.

You can use the Function Arguments dialog box to help you construct a function formula.

9.

The Average function is a mathematical function.

10.

The Sum function is a statistical function.

11.

Charts are used to make data easier to read and understand.

12.

You must create a chart on the same worksheet that contains the data for the chart.

13.

After you change data in a worksheet used to create a chart, you must manually update the chart.

14.

If you want to change a bar chart to a column chart, you must start over and create a new chart from worksheet data.

15.

Chart options, formats, and types can all be changed at any time, even after the chart has been created.

Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.

16.

The sequence used to determine which calculations are carried out first in Excel is called the ____.
 a. calculation system c. order of evaluation b. operation sequence d. evaluation sequence

17.

The symbol that tells Excel what mathematical operation to carry out is the ____.
 a. operator c. argument b. operand d. function

18.

A formula that contains more than one operator is called a ____.
 a. compound formula c. complicated formula b. function formula d. complex formula

19.

To see a formula after you have entered it, you must click in the cell containing the formula and then view the formula in the ____.
 a. Formula Bar c. Formula Toolbar b. Status Bar d. Name Box

20.

To edit a formula, you can ____.
 a. double-click the cell and then edit the formula in the cell b. select the cell, press F2, and then edit the formula in the cell c. select the cell and then edit the formula in the Formula Bar d. all of the above

21.

A function formula contains the ____.
 a. equal sign and the function name b. equal sign, the function name, and the argument c. equal sign and the argument d. function name and the argument

22.

By default, when you create formulas, the cell references are formatted as ____ references.
 a. absolute cell c. mixed cell b. relative cell d. function

23.

To create an absolute cell reference, insert a(n) ____ before the column letter and/or row number.
 a. > c. \$ b. & d. #

24.

When a(n) ____ cell reference is copied to another cell, the cell references will be adjusted to their new location.
 a. absolute c. mixed b. relative d. none of the above

25.

To describe large quantities of data in a worksheet, you use a ____ function.
 a. statistical c. logical b. mathematical d. none of the above

26.

To display the number of entries containing values in a range of cells, you would use the ____ function.
 a. Max c. Count b. Min d. Sum

27.

The ____ function displays the minimum value within the specified range of cells.
 a. Average c. Median b. Min d. Count

28.

The Function Arguments dialog box displays ____.
 a. a description of the function c. the argument b. the current result of the entire formula d. all of the above

29.

To show how individual items relate to a whole unit, you would create a(n) ____ chart.
 a. area c. bar b. pie d. scatter

30.

After you have created a chart, you can edit the position of the legend in the ____ dialog box.
 a. Legend c. Chart Options b. Chart Type d. Chart Format

Completion
Complete each sentence or statement.

31.

To view all available Excel functions, open the _________________________ dialog box.

32.

To show comparisons among individual items, you would create a(n) ____________________ chart.

33.

A(n) ____________________ chart is created on the same sheet as the data used in the chart.

34.

The symbol _____________________ is used to indicate division in an Excel formula.

35.

The symbol to indicate multiplication in a formula is a(n) ____________________.

36.

In a formula that contains both a multiplication and an addition operation, ____________________ will be performed first.

37.

Excel has more than 300 built-in ____________________ for performing calculations.

38.

You usually create a chart from a(n) ____________________ of cells rather than the entire worksheet.

39.

The ____________________ helps you identify chart options, including types of charts and data labels.

40.

All formulas begin with the ____________________ sign.

41.

Cell references that contain both absolute and relative cell references are called ____________________ cell references.

42.

The ____________________ function totals a range of cells and then divides the total by the number of entries in the range.

43.

The number or cell reference in a formula is the _____________________.

44.

If you want to be able to copy an Excel formula to other cells without the cell references changing, use ____________________ cell references.

45.

If you see ##### displayed in a cell where you have entered a formula, it indicates a(n) ____________________.

46.

The ____________________ button is an exclamation point within a diamond that displays next to a cell with a formula error.

47.

The ____________________ is a value, cell reference, range, or text that acts as an operand in a function formula.

48.

The Insert Function button is located on the ____________________.

49.

When a function formula includes more than one argument, ____________________ are used to separate the arguments.

50.

An accurate worksheet allows you to draw ____________________ conclusions from the data presented.