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.