Excel Ch. 1

In general, use no more than _____ font types in a worksheet.

two

Clicking the _____ box completes an entry

Enter

Which of the following keys is an alternative to double-clicking the cell to edit it?

F2

To clear the entire worksheet, click the Clear All button on the worksheet.

False

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

A character with a point size of 10 is about 10/72 of one inch in height.

True

Of the 4 major parts of the Office package, Excel is used the most in business.

True

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

True

Before any employee begins working on an Excel worksheet that he supervises, Perry decides that he should approve _____ of any proposed worksheet.

a sketch

Pressing the _____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

You can apply the Bold font style by pressing the _____ keyboard shortcut keys.

CTRL-B

You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).

False

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

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

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

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.

True

A(n) _____ chart is drawn on the same worksheet as the data. Group of answer choices

embedded

To enter a number as text, precede it with a(n) _____.

apostrophe (')

Combining two or more selected cells into one cell is called _____ cells.

merging

Which of the following is the Ribbon path to the Cell Styles button?

(Home tab I Styles Group)

Excel remembers the last _____ actions you have completed.

100

The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Auto Fill options

The _____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.

AutoCalculate

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

AutoCorrect

Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

AutoCorrect

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Colon (:)

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the _____.

Destination Area

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

Which of the following is the Ribbon path to the Cell Styles button?

Displays cell contents with two decimal places that align vertically

Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

Document Properties

Which of the following keys moves the insertion point to the end of data in a cell?

END

To cancel an entire entry before entering it into the cell, press the _____ key. Group of answer choices

ESC

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.

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 AutoCalculate area to display the Customize Status Bar shortcut menu.

False

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

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.

False

Worksheet titles and subtitles should be as wordy as possible

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.

False

The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Fill Handle

You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Format

Which of the following keys toggles between Insert mode and Overtype mode?

INSERT

The _____ is a blinking vertical line that indicates where the next typed character will appear.

Insertion point

Pressing the _____ key to complete an entry activates the adjacent cell to the right.

Right Arrow

_____ is/are used to add worksheet, column, and row titles on a worksheet.

Text

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

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

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.

True

An Excel _____ allows data easily to be summarized and charted.

Worsheet

In Excel, a number can contain the characters _____.

all of the Above

To enter data in a cell, you must first select or activate the _____.

cell

To remove an embedded chart, you should _____ it and press the DELETE key.

click

By default, text is _____ in a cell.

left-aligned

A _____ reference is an adjusted cell reference in a copied and pasted formula.

related

The person or persons requesting the worksheet should supply their requirements in a _____ document.

requirements

Perry decides that before either of his employees creates a new workbook he must give them a(n) _____.

requirements document

_____ properties are associated with all Microsoft Office documents and include author, title, and subject.

standard

The first step in creating an effective worksheet is to make sure you _____.

understand what is required