Create an account
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet, as shown is the accompanying figure.
Both the Cancel Box and the Enter Box appear on the formula bar when you begin typing in a cell
When you click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.
When entering dollar values in cells, you also must type the dollar sign ($), commas, and trailing zeros.
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.
You can turn off the Bold formatting for selected text by clicking the Bold Off button ( Home tab / Font group )
Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.
To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab / Charts group ).
You can snap an embedded chart to the worksheet gridlines by holding down the ALT key while you drag the chart to a new position.
To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the Auto Calculate area to display the Customize Status Bar shortcut menu.
If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
You can clear cell contents and formatting by clicking Clear Contents on the Clear button menu.
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