A drop-down menu that automatically appears when you click inside a text box or highlight text. This toolbar lets you format and manipulate text even if the top menu ribbon is hidden.
When text is longer than the width of a column,
Excel displays the overflow characters in adjacent cells to the right.
When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the
destination area or paste area.
If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the
selected range when the Sum button is clicked.
To use the Name box to select any cell, click the
Name box and enter the cell reference of the cell you want to select.
can be used in place of a calculator or formula to view the sum, average, or other types of totals of a group of numbers on the worksheet
In this default mode, when you enter new text in front of existing text, the existing text shifts to the right to make room for the new text.
In Insert mode, Excel replaces the character to the right of the insertion point with the character typed. T OR F?
What tool do you use to check which cells are referenced in formulas that are assigned to the active cell?
formats the number with the default Accounting format using the U.S. dollar sign; it applies thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, applies two decimal places, and leaves a small amount of space at the right edge for the cell to accommodate a paranthesis for negative numbers.
Decrease indent button
decreases indentation one character of space for each click
Location: Home tab, Alignment group
When a number is entered with a format symbol, Excel immediately
displays it with the assigned format
The horizontal and vertical lines on the worksheet are called ______ and make it easier to see and identify each cell.
The __________ presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
As you type, Excel displays the entry in the __________, and also displays the active cell reference in the Name box on the left.
In Excel, any set of characters containing a letter, hyphen (as in a telephone number), or space is considered __________.
A(n) __________ is a series of two or more adjacent cells in a column or rectangular group or cells.
When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a __________.
You __________ a worksheet to emphasize certain entries, change the font size, add color to areas, and make the worksheet easier to read and understand.
The __________ specifies the size of the characters on the screen and is gauged by a measurement system called points. A single point is about 1/72 of one inch in height.
The opposite of cell merging is cell __________, which is done by selecting a merged cell and clicking the Merge and Center button.
Excel remembers the last 100 actions you have completed. Thus, you can undo up to 100 previous actions by clicking the __________ button arrow to display the Undo list and then clicking the action to be undone.
As you are clearing cell entries, always remember that you should never press the __________ to clear a cell.
The ____________________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
Excel places a small purple triangle, called a ______________, in a cell to indicate that a smart tag is available.
Smart tag indicator
The ____________________ function sums the numbers in the specified range and then divides the sum by the number of non-zero cells in the range
The ____________________ inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths.
Comma style format
A ____________________ is a dollar sign that appears immediately to the left of the first digit in a cell with no spaces.
Floating Dollar Sign
Formatting that appears only when the value in a cell meets specified conditions is called ____________________.
A ____________________ is defined as a letter, number, symbol, or punctuation mark in the default font used by Excel.
____________________ means that the width of a column will be increased or decreased so the widest entry will fit in the column.
____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.
To correct a word throughout a worksheet, click the ____________________ in the Spelling dialog box shown in the accompanying figure.
change all button
The ____________________ of a worksheet is the version that shows the results of the formulas entered, rather than the actual formulas.
The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.
____________________ are values in cells that can be changed to determine new values for formulas.
The ____________________ is a special place in the computer's memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document.
You can ensure correctness in your ____________________ by carefully checking them using Range Finder.
The Formula Auditing group on the Formulas tab on the Ribbon also can be helpful when verifying ____________________.
Before creating a worksheet, you should have a good understanding of the ____________________ document.
When you first enter text, its angle is ____________________ degrees, and it reads from left to right in a cell.
The ____________________ Indent button decreases the indent by three spaces each time you click it.
A versatile method of copying a source area is to use the Copy button and Paste button on the Home tab on the ____________________.
The dollar sign ($), comma (,), and percent sign (%) are called ____________________ symbols.
To freeze both column headings and row titles, select the cell that is the intersection of the column and row titles before you click the ____________________ button on the View tab on the Ribbon.
A simple way to create a date stamp is to use the ____________________ function to enter the system date tracked by your computer in a cell in the worksheet.
Viewing the ____________________ version of the worksheet allows you to check the formulas assigned to the range.
In accounting, ____________________ numbers often are shown with parentheses surrounding the value
Using the ____________________ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or a range of cells.