How can we help?

You can also find more resources in our Help Center.

Excel Chapter 2

STUDY
PLAY
Accounting Number Format
assigns the desired Accounting number format
arguments
the values that you use with a function
asterisk
following d4 is the arithmetic operator that directs Excel to perform the multiplication operation
AVERAGE function
sums the numbers in the specified range and then divides the sum by the number of nonzero cells in the range
best fit
the width of the column will be increased or decreased so the widest entry will fit in the column
blank cell
in Excel, has a numerical value of zero, which would have resulted in an error message
Comma style format
can be assigned to a range of cells by clicking the Comma Style button on the Ribbon, 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 a relational operator , is true or false for each cell in the range
conditional formatting
formatting that appears only when the value in a cell meets conditions that you specify
debugging
the process of finding and correcting errors in the worksheet
e-mail
electronice mail, the electronic transmission of messages and files to and from other computers using the internet
equal sign
preceding d4*e4 is an important part of the formula, it alerts excel that you are entering a formula or function and not text
fixed dollar sign
to the far left in the cell, often with spaces between it and the first digit
floating dollar sign
appears immediately to the left of the first digit with no spaces, use the Currency style in the Format Cells dialog box
formula
assign it to excel and it will calculate a result
formulas version
shows the actual formulas you have entered rather than the resulting values
function
a prewritten formula that is built into Excel
hiding cells
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 others to see
landscape orientation
means the printout is printed across the length of the page
MAX function
displays the highest value in a range
MIN function
determines the lowest (minimum) number in the range D4:D12
Normal View
the default view that you have worked in up until thid point in the book
order of operations
moving from left to right in a formula starting with negation, percentage, exponentiations, multiplications, divisions, additions and subtractions
Page Layout View
allows you to create or modify a worksheet while viewing how it will look in printed format
pixel
a dot on the screen that contains a color
Point mode
allows you to select cells for use in a formula by using the mouse
portrait orientation
printed across the width of the page
previewing the worksheet
you can see exactly how it will look without generating a printout
Range Finder
to check which cells are referenced in the formula assigned to the active cell
relative cell references
if you copy across, excel adjusts the column portion of cell references
smart tag indicator
a small purple triangle to indicate that a smart tag is available
smart tags
labeled data
spell checker
checks the worksheet for spelling errors
theme
a prefined set of colors, fonts, chart styles, cell styles, and fill effects
values version
shows the results of the formulas you have entered
Web query
you can import data stored on a website