excel Ch. 2
Comma style format
which can be assigned to a range of cells by clicking the Comma style button, inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
condition
which is made up of two values and relational operator, is true or false for each cell in the range.
values version
which shows the results of the formulas you have entered rather than the resulting values.
Accounting Number Format
with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point.
formula
you can assign a formula to a cell, and Excel will calculate the result.
spell checker
you can use to check a worksheet for spelling errors.
Range Finder
use Range Finder to check which cells are referenced in the formula assigned to the active cell.
fixed dollar sign
when you use accounting number format button to assign the accounting number format, Excel displays a fixed dollar sign to the far left cell, often with spaces between it and the first digit.
formulas version
Excel also can display and print the formulas version of the worksheet, which shows the actual formulas you have entered, rather that the resulting values.
MAX function
Excel includes a function called the MAX function that displays the highest value in range.
functions
Excel includes prewritten formulas called functions to help you compute a range of values and statics.
conditional formatting
Excel lets you apply formatting that appears only when the value in a cell meets conditions that you specify. you can apply conditional formatting to a cell, a range of cells, the entire worksheet, or the entire workbook.
circular reference
a formula in a cell that contains a reference back to itself is called a circular reference.
point mode
allow you to select cells for use in a formula by using the mouse.
Page Layout view
allows you to create or modify a worksheet while viewing how it will look in printed format.
margins
are those portions of a printed page outside the main body of the printed document and always are blank when printed.
relative cell references
if you copy across, then excel adjusts the column portion of cell references. these cell references are called relative cell references.
blank cell
in Excel has a numerical value of zero, which would have resulted in an error message.
pixel
is a dot on the screen that contains a color.
theme
is a predefined set of colors, fonts, chart styles, cell styles, and fill effects can be applied to an entire worksheet.
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 do not want to see.
header
is common content that prints on every page of a worksheet.
debugging
is the process of finding and correction errors in the worksheet.
best fit
means that the width of the column will be increased or decreased so the t the widest entry will fit in the column.
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 (-).
AVERAGE function
sum the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range C4:C12
asterisk
the asterisk (*) following d4 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 signs
the equal sign (=) preceding d4*e4 alerts excel that you are entering a formula or function and not text.
arguments
the values that you use with a function are called arguments.
floating dollar sign
to assign a floating dollar sign that appears immediately to the left of the first digit with no spaces, use the Currency style.
MIN function
to determine the lowest number in the range.
