Excel Chapter 2
True or False: The equal sign (=) precedes a formula.
True
To start a new line in a cell, press the ______keys.
ALT+ENTER
True or False: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
False
True or False: As in algebra, you can use the brackets to override the order of operations Excel follows to perform calculations.
False
True or False: Best fit means that the width of the column will be increased or decreased by a percentage you specify.
False
True or False: The range automatically selected by Excel is always correct.
False
True or False: You cannot format an entire column at once.
False
True or False: The Accounting number format assigns a floating dollar sign.
False (fixed)
Which of the following is the path to the Comma Style button?
HOME tab/ Numbers Group
Which of the following is the path to the Conditional formatting button?
HOME tab/ Styles Group
Clicking the ______ opens the Insert Function Dialog Box.
Insert Function box in the formula bar
______ are those portions of a printed page outside the main body of the printed document and always are blank when printed.
Margins
________views shows the worksheet divide into pages as well as the header/ footer information.
PageLayout
______view allows you to create or worksheet while viewing how it will look in printed format.
PageLayout
The________ function sums the number in the specified range and then divides the sum by the number of cells with the numeric values in the range.
average
An _______ 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.
indirect
All of following are valid Excel arithmetic operators EXCEPT
side arrow
A company or department may standardize with a specific _____ so that all of their documents have a similar appearance.
theme
A______ is a pre-written formula that is built into Excel
function
A______is text and graphics that print at the top of each page.
header
When Excel follows the order of operations, the formula, 8*3+2,equals_____?
26
If you do not assign a format to a cell or cells in a column, the column width will remain _______ characters.
8.43
The ______ button assigns fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Accounting number format
_____, means that the width of a column will be increased or decreased so the widest entry will fit in the column.
Best fit
______colors jump out of a dark background and are easiest to see.
Bright
The default view in Excel is called_______ view
Normal
You can use the ______ to check which cells are referenced in the formula assigned to the active cell.
Range Finder
The adjusted cell references in a copied and pasted formula are called______ cell references.
Relative
True or False: Cooler colors tend to pull away from the reader.
True
True or False: Excel has more than 400 functions that perform just about every type of calculation you can imagine.
True
True or False: Moving from left to right, the first calculation in order of operations is negation(-).
True
True or False: Point mode allows you to select cells for use in a formula by using your finger or the pointer.
True
True or False: The AVERAGE function requires that the argument be included within parentheses following the function name.
True
True or False: The most common error when entering a formula is to reference the wrong cell in the formula.
True
True or False: To sum button menu allows you to enter one of five often-used functions easily into a cell.
True
A formula in a cell that contains a reference back to its self is called a
circular reference
The / arithmetic operator indicates____
division
The____is the small black square located in the lower-right corner of the heavy border around the active cell.
fill handle
A____ is text and graphics that print at the bottom of every page.
footer
One of the reasons Excel is such a valuable tool is that you can assign a(n) _____ to a cell, and Excel will calculate the result.
formula
The_____ function displays the highest value in the range.
max
The____ function determines the lowest number in a range.
min.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.
operations
Of warmer and cooler colors, the kind that tend to reach toward the reader are_____colors.
warmer