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

True/False

Review LaterAdd Note

Review Later

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.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

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

A) scroll box
B) sheet tab
C) insertion point
D) split bar

E) A) and B)
F) All of the above

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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

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.

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.

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 clear the entire worksheet,tap or click the Clear All button on the worksheet.

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

The ____ button allows you to erase recent cell entries.

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

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

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

Worksheet titles and subtitles should be as wordy as possible.

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

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

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

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

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

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.