FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) INSERT
B) ENTER
C) TAB
D) ALT

E) A) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

Essay

Review LaterAdd Note

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

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.

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

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

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

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

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.

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

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

Worksheet titles and subtitles should be as wordy as possible.

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

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

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

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

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

The ____ button allows you to erase recent cell entries.

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.

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.