Name ________________________________________________ Sect. ______ Score ________/35

Excel, Chapter 18 Review Sheet

Fill in the blanks and hand in at start of your class.

1. p. 363: A formula uses numbers and ___________________________ to perform calculations such as addition, subtraction, multiplication, and division.
2. p. 363-4: The _________________________ is a symbol that tells Excel what mathematical operation to perform with the operands. In the formula =B5+6, the operands are B5 and 6, the operator is the ______________________.
3. p. 364: A formula can be as simple as a ______________________ cell reference
4. p. 364: Formulas containing more than one operator are called ___________________ formulas.
5. p. 364: The sequence used to calculate the value of a formula is called the ____________________.
6. p. 365: When entering the cell reference, the column letter can be keyed in either _______________ or lowercase.
7. p. 365: Once you press Enter or click the Enter button on the Formula Bar, the result of the formula will display in the __________________. To see the formula you must click in the cell and then view the formula in the ______________________________.
8. p. 365: There are three methods to edit a formula: a) you can ____________________________ the cell and then edit the formula in the cell, 2) you can select the cell, press __________________, and then edit the formula in the cell, or 3) you can select the cell and then edit the formula in the ___________________________.
9. p. 367: When Excel cannot properly perform a calculation, an ____________________________ will display in the cell where you entered the formula.
10. p. 369: By default, when you create formulas, the cell references are formatted as ______________ cell references. That means when the formula is copied to another cell, the cell references will be _____________________ relative to the formula’s new location.
11. p. 369: To create an absolute cell reference, you insert a _________________________ before the column letter and/or the row number of the cell reference you want to stay the same.
12. p. 369: A cell reference that contains both relative and absolute references is called a ___________ cell reference.
13. p. 370: A function contains three parts – the ______________________, the __________________ name, and the ________________________.
14. p. 370: The argument is a value, _______________________, range, or text that acts as an operand in a function formula. It’s enclosed in ____________________________ after the function name.
15. p. 371: Sometimes Excel does not identify the correct _____________________ when you use the AutoSum feature.
16. p. 372: The _____________________________________ dialog box guides you through the process of building a formula that contains a function.
17. p. 374: The ________________ function is a statistical function that displays the number of cells with numerical values in the argument range.
18. p. 375: The __________________ function displays the smallest number contained in the range identified in the argument.
19. p. 376: ______________________ help to make data more interesting and easier to read and understand. They’re a graphic representation of your worksheet data.
20. p. 376: The _____________________ chart illustrates trends in data at equal intervals.
21. p. 377: The __________________ chart compares the sizes of portions as they relate to a whole unit and illustrates that the parts total 100 percent.
22. p. 377: You can create the chart on a __________________ sheet or you can create the chart on the worksheet that has the data you want to chart – which is called an ______________________ chart.
23. p. 379: When you edit the data in the worksheet, Excel will _______________________________ the chart to reflect the changes.
24. p. 380 & 382: You can change the chart options (formats and types as well) ___________________ you create a chart.
25. p. 380: The Chart Options command enables you to change many of the chart features such as the __________________ in the chart title or the ________________________ of the legend.