Create an account
use Excel to creathe 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______.
A data stamp shows the date a workbook, report, or other document was created or the period it represents.
A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.
Changing the order of sheets in a workbook allows you to postition the most important worksheet first.
If worksheet, column, and row titles are frozen above and to the left of cell B13, B13 can be selected by pressing CTRL+HOME.
If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded.
If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series.
The Increase Indent Button indents the contents of a cell to the right by three spaces each time you click it.
The range of entries that determines the size of the slices in a Pie chart is called the category names.
When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.
When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip containing the name of the item.
With a three-dimensional chart, you can change the view to better show the section of the chart you are trying to emphasize.
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.
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