EXCEL: Formulas, Functions, and Formatting
function
A _____ is a prewritten formula that is built into excel.
condition
A _____ is made up of two values and a relational operator.
zero
A blank cell in Excel has a numerical value of _____ .
equal sign
An _____ alerts excel that you are entering a formula or function and not text.
Range Finder
An easy way to verify that a formula references the cells that you want it to reference is to use excel's _____ .
conditional formatting
Formatting that appears only when the value in a cell meets specific conditions is called _____ .
multiplication
In the formula: =A4/B4+C5-D5*E6 the _____ operation is performed first.
100
The Percent style button is used to display a value determined by multiplying the cell by _____, rounding the result to the nearest percent, and adding a percent sign.
comma
The _____ Style format inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
Adjust to
The _____ box allows you to specify the percentage of reduction or enlargement in the printout of a worksheet.
Auto Fill Options
The _____ button gives options for how to fill cells following a fill operation.
Trace Error
The _____ button lists error-checking options following the assignment of an invalid formula to a cell.
fixed
The _____ dollar sign displays to the far left in a cell.
average
The _____ function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
formulas
The _____ version of a worksheet show the actual formulas.
*
The arithmetic operator for multiplication is _____ .
min
Use the _____ function to determine the lowest number in a range.
max
Use the _____ function to display the highest value in a range.
arguments
Values used with a function are called _____ .
0
When you decrease a column width to _____ , the column is hidden.
Greater than
Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
comma style format
which can be assigned to a range of cells by clicking the comma style botton inserts a comma every three position to the left of teh deimal point and causes number to be displayed to teh nearest hundredths
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
asterisk
following d4 is the arithmentic operator that directrs excel to perform the multiplicationpoeration
relative cell references
if you copy across then excel asjusts the colum portion of celll references
blank cell
in excel has a munerical value of zero
pixel
is a dot on the screen that contains a color
theme
is a predifined set of colors fonts charts styles cell styles and fill effects that can entries within their respective colums improves the appearance of the worksheet
recalculates
Every time you enter a value into a cell in the worksheet, Excel _____ all formulas.
#REF!
Excel displays which of the following for an invalid reference?
18.5*B4
The formula _____ multiples the contents of cell B4 by 18.5.
order of operations.
The order in which calculations are performed in a formula is called the _____ .
debugging
The process of finding and correcting errors in a worksheet is called _____ .
Ctrl+Accent Mark
To display your worksheet in formula view, press _____ .
four-digit years
To ensure that Excel interprets year values the way you intend, use _____ .
parentheses
To override the order of operations, use _____ .
F8
To select a range using the keyboard, press the _____ key and then use the arrow keys.
Range Finder
To verify that a formula contains the intended cell references, use Excel's _____ .
Point mode
_____ allows you to select cells for use in a formula by using the mouse.
Hiding
_____ cells is a technique you can use to hide data that might be sensitive or not relevant to a report.
Best fit
_____ means that the width of a column will be increased or decreased so the widest entry will fit in the column.
circular reference
a formula in a cell that contains a refernce back to itself
hidding cells
is a technique you can use to hide data that might not ve relevant to a particular report or senitive data that you do not want others to see
order of operation
is as follows first negation(-) then all percentages (%) then all exponentiations(^) then all multiplications(*) and divisioin(/) and finally all addition(+) and subtractino(-)
header
is common content that prints on every page of a worksheet
debugging
is the process of finding a correcting errors in the worksheet
formuals version
of teh worksheet which shows the actual formuals you have entered rather than teh resulting values
values version
of the worksheet which shows the results of the formuls you have entered rather than the actual formuals
floating dollar sign
that appears immeiately to the left of the first digit eith no spaces use the currency style
normal view
the defualt view tht you have worked in up until this point in the book
fixed dollar sign
to the far left in teh cell often with spaces between it and the first digit
accounting number format
with a dollar sign to the left of the munber inserts a common every three position to the left of the deciamal point and displays numbers to the nearest cent
spell checker
you can use the check a worksheet for spelling errors