Excel Chapter 1 Study Guide

How many chart types does Excel offer?

10

The characters that Excel displays on the screen are a specific ____.

ALL

You use ____ to view an XPS file.

XPS Viewer

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

merging

Excel remembers the last ____ actions you have completed.

100

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

AutoCalculate

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

AutoCorrect

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

CTRL+B

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

CTRL+HOME

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

Displays cell contents with 2 decimal

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places that align vertically

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

Clicking the ____ box completes an entry.

Enter

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Exploded

A single point is about 1/32 of one inch in height.

FALSE

In a worksheet, columns typically contain information that is similar to a list. _________________________

FALSE

Live preview is available on a touch screen.

FALSE

The Top status bar command is used to display the highest value in the selected range in the AutoCalculate area. _________________________

FALSE

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

FALSE

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

FALSE

When you tap or 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

You should press the SPACEBAR to clear a cell.

FALSE

If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.

FILE

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

HOME

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

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Standard

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

TRUE

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

TRUE

If you accidentally undo an action, you can use the Redo button to redo it. _________________________

TRUE

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

TRUE

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

TRUE

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. _________________________

TRUE

The opposite of merging cells is splitting a merged cell. _________________________

TRUE

With Excel in Edit mode, you can edit cell contents directly in the cell.

TRUE

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

TRUE

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

TRUE

The ____ button allows you to erase recent cell entries.

Undo

____ is an electronic image format, sometimes called a fixed format.

XPS, PDF

The date you change a file is an example of a(n) ____ property.

automatically updated

To enter data in a cell, you must first select the ____.

cell

The range of cells receiving the content of copied cells is called the ____.

destination area

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

equal sign (=)

A ____ is information that exists on a physical medium such as paper.

hard copy, printout

By default, text is ____ in a cell.

left-aligned

The range of cells receiving copied content is called the ____ area.

paste

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu

You can insert a function in a cell by ____.

tapping, clicking

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

worksheet