Excel Chapter 2

Circular Reference

A formula in a cell that contains a reference back to itself is called a circular reference.

Function

A function is a prewritten formula that is built into Excel.

Header

A header is text and graphics that print are the top of each page.

Pixel

A pixel, which is short for picture element, is a dot on the screen that contains a color.

Indirect Circular Reference

An indirect circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Hiding Cells

Hiding cells is a technique you can use to hide data that might not be relevant to a particular report or sensitive data that you o not what others to see.

Margins

Margins are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Order of Operations

Moving from left to right in a formula, the order of operations is as follows: first negation, then all percentages, then all exponentiations, then all multiplications and divisions, and finally, all additions and subtractions.

Page layout view

Page layout view allows you to create or modify a worksheet while viewing how it will look in printed form.

Point mode

Point mode allows you to select cells for use in formula by using your finger or the pointer.

Values Version

The results of all formulas.

Relative cell references

These cell references are called relative cell references.

Formula Version

Excel also can display and print the formulas version of the worksheet, which shows the actual formulas you have entered, rather than the resulting values.

MAX Function

Excel includes a function called the MAX Function that displays the highest value in a range.

Spell Checker

Excel includes a spell checker you can use to check a worksheet for spelling errors.

Best Fit

Best fit means that the width of the column will be increased or decreased so that the widest entry will fit in the column.

Debugging

Debugging is the process of finding and correcting errors in the worksheet.

Formula

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

Range Finder

Range Finder checks which cells are referenced in the formula assigned to the active cell.

Footer

Similarly a footer is text and graphics that print are the bottom of each page.

Asterisk

The asterisk following c4 is the arithmetic operator that directs Excel to perform the multiplication operation.

Normal view

The default view that you have worked in up until this point in the book is called Normal view.

Equal Sign

The equal sign preceding c4*d4 alerts Excel that you are entering a formula.

MIN Function

The next step is t enter the MIN function in cell B15 to determine the lowest number in the range B4:B12.