How can we help?

You can also find more resources in our Help Center.

SIA Computer Chapter 2 Excel True/False

STUDY
PLAY
True
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.
False
Worksheet titles and subtitles should be as wordy as possible
False
A thin red border indicates the active cell, as shown in the accompanying figure.
True
Both the Cancel Box and the Enter Box appear on the formula bar when you begin typing in a cell
False
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
True
The Auto Correct feature can automatically capitalize the first letter in the names of days
True
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.
True
Excel recognizes the following as text 401AX21, 921-213, 619 321, 883XTY
False
When entering dollar values in cells, you also must type the dollar sign ($), commas, and trailing zeros.
True
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.
False
A single point is about 1/32 of one inch in height
False
Excel can display characters in only three font colors: black, red, and blue.
True
A character with a point sixe of 10 is about 10/72 of one inch in height
False
Excel uses the default Oriel Theme for all new workbooks.
True
You can turn off the Bold formatting for selected text by clicking the Bold Off button ( Home tab / Font group )
True
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.
True
To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab / Charts group ).
True
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.
False
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.
True
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.
True
With Excel in Edit mode, you can edit cell contents directly in the cell.
True
You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.
True
To clear the entire workseet, click the Clear All button on the worksheet
False
You can clear cell contents and formatting by clicking Clear Contents on the Clear button menu.
False
You should press the SPACEBAR to clear a cell.