Exam 11: Excel : Formulas, Functions, and Formatting

One of the reasons Excel is such a valuable tool is that you can assign a(n)_________________________ to a cell, and Excel will calculate the result.

Statistical functions ignore blank cells.

Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time, total time, and distance.Now Anna wants to know the longest total time she has run.By looking at the total time values, she finds the longest total time to be 54 minutes.Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time.Why did Anna prefer to use the MAX function?

You can open the Format Cells dialog box by pressing the _____ keys.

The _____ function determines the lowest number in a range.

The _____ Option button lists formatting options following an insertion of cells, rows, or columns.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

When cell entries are short, right-aligning the entries within their respective columns improves the appearance of the worksheet.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The _____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

A formula in a cell that contains a reference back to itself is called a(n)_________________________.

Briefly discuss displaying the formulas version of a worksheet.

Using the Excel spell checker, you can _____.

The adjusted cell references in a copied and pasted formula are called _____ references.

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting.

You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals _____.

The arithmetic operator, ^, directs Excel to perform the division operation.