Exam 7: Excel: Creating a Worksheet and a Chart

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

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

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

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

If the next entry you want to make is in an adjacent cell,use the ____________________ keys to complete the entry in the current cell and make the adjacent cell the active cell.

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

If a major error is made when typing data into a cell,tap or 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.

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

When text is longer than the width of a column,Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

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

The ____ button allows you to erase recent cell entries.

Worksheet titles and subtitles should be as wordy as possible.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Deletes characters to the left of the insertion point.

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

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

____________________ involves reducing the electricity consumed and environmental waste generated when using computers,mobile devices,and related technologies.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+PAGE DOWN f.END b.ARROW g.INSERT c.CTRL+HOME h.SHIFT+RIGHT ARROW d.HOME i.BACKSPACE e.CTRL+F j.SPACEBAR -Moves the insertion point to the end of data in a cell.

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

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