# SIA Computer Chapter 2 Excel True/False

### 25 terms by marleelayne24

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

### 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.

Example: