To cancel entry before entering it into the cell, press the
worksheet is used to manipulate data
the___ or check box completes an entry.
4) By default, text is
What is meant by order of Operations?
What is meant by recalculation
in Excel has a numerical value of zero.
A______is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
_______displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
What is the Range Finder
Pressing the _____ key, removes the marquee
The _______ returns a number that corresponds to the system date and time beginning with December 31, 1899.
_________ to show the relationship or proportion of parts to a whole.
How do you create cell names
36) You can path to the What-If Analysis button by going to ______
To prevent round-off errors, use the ______function.
What is VLOOKUP and HLOOKUP
_______formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
Like the AutoFilter query technique, the _________displays a subset of the table.
52) The ____________ function is useful when you want to add values in a range only if they meet a criteria
What is consolidation?
What does drill through mean?
that spans two or more sheets in a workbook is called a 3-D range.
Text to be displayed in a number format, must be in
It is recommended that you use the _____function on formulas that potentially can result in more decimal places than the applied format displays.