EXCEL-Chapter 1: Creating a Worksheet and an Embedded Chart

Terms in this set (70)

You know a cell is selected when a _____ surrounds the cell.

The horizontal axis for a chart is called the x-axis, or the _____.

The _____ function adds all of the numbers in a range of cells.

Excel helps you organize and identify your files by using _____ , which are the details about a file.

document properties

A _____ is a collection of cell styles and other styles that have common characteristics.

A _____ is a collection of fonts and color schemes.

A _____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for a worksheet.

A _____ conveys a visual representation of data.

A chart is _____ when it is drawn on the same worksheet as the data.

_____ typically contain information that is similar to terms in a list.

_____ in a worksheet typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

To split a merged cell, select the cell and click the _____ button.

The _____ command in the Auto Calculate area displays the highest value in the selected range.

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

insertion point

The _____ feature of Excel works behind the scenes, correcting common mistakes.

You can select any cell by entering its cell reference in the _____ box on the left side of the formula bar.

The range of cells receiving a copy is called the _____ area.

To toggle between insert mode an overtype mode press the _____ key.

In _____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.

The opposite of merging cells is _____ cells.

_____ properties include file system properties, such as the date you can change or create a file, and statistics, such as the file size.

Automatically updated

The _____ on a worksheet is one in which you can enter data.

A _____ chart is used to illustrate changes in data over time.

If automatic recalculation is disabled, press _____ to redraw charts.

To do in-cell editing, select the cell, then press the _____ key.

To enter a number as text, start the entry with an _____ .

You _____ an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.

_____ can include information such as the project author, title, subject, and keywords.

The procedure of editing a cell contents directly in the cell is called _____ .

in-cell editing

With in-cell editing, you move the insertion point to the beginning of data in a cell by pressing _____ .

A _____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

A _____ is a word or phrase that further describes a document.

_____ mode is when Excel replaces the character to the right of the insertion point with what you are currently typing.

_____ cells involves creating a single cell by combining two or more selected cells.

To erase recent cell entries, use the _____ command on the Quick Access Toolbar.

The Auto Correct feature works behind the scenes correcting which of the following mistakes?

all
two initial capital letters,
capitalizes the names of the days, and
replaces commonly misspelled words with their correct spelling

Which of the following document properties include title, author, and subject?

_____ allow data easily to be summarized and charted.

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

In Excel, any set of characters containing a letter, hyphen, or space is considered _____ .

The _____ contains areas where you can view and enter document properties.

document information panel

AutoCalculate area

easily can obtain a total, an average, or other information about the numbers in a range

AutoCorrect feature

Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell

cancels an entry

cell being copied

Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell

completes an entry

or font face, defines the apperance and shape of the letters, numbers, and special characters

defines the color of the characters

specifies the size of the characters on the screen

indicates how te characters are emphasized

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

green computing

which involves reducing the enviromental waste generated when using a computer

is information that exists on a physical medium such as paper

which indentifies the colors assigned to each bar inthe chart

proposed range to sum surrounded by a moving border

can contain only the following characters: 0123456789 + - () , / . $ % E e

the range of cells receiving the copy

of 10 is about 10/72 of one inch in height

is information that exists on a physical medium such as paper

relative reference

Each adjusted cell references

store a workbook permentaly

the edge of the chart area to the worksheet gridlines

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

splitting a merge cell

the opposite of merging cells

standard properties

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

to select a cell

is to use the mouse to move the block plus sign mouse pointer to the cell and then click

horizantal axis

;