Create an account
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ________ values.
determine the necessary functions and formulas needed
Suggested decision to make when you plan a workbook
use Excel to create the worksheet
With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ________.
Dialog Box Launcher
To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells ________.
When you first enter a text, its angle is ________ degrees, and it reads from left to right in a cell.
Fill Formatting Only
The ________ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.
The Increase Indent button indents the contents of a cell to the right by ________ spaces each time you click it.
The Copy button copies the contents and format of the source area to the Office ________, a reserved place in the computer's memory.
In formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ________ error message.
When assigned to a cell, the ________ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
The ________ function is useful when you want to assign a value to a cell based on a logical test.
A(n) ________ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
A(n) ________ chart provides a simple way to show trends and variations in a range of data within a single cell.
________ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together