Exam 7: Excel: Creating a Worksheet and a Chart

Explore all topics

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 -Highlights one or more adjacent characters to the right.

(Essay)

4.9/5

(41)

Question 61

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 -Selects the cell at the beginning of the row that contains the active cell.

(Essay)

4.9/5

(35)

Question 62

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

(True/False)

4.9/5

(35)

Question 63

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

(Multiple Choice)

4.9/5

(32)

Question 64

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

(Essay)

4.8/5

(34)

Question 65

How many chart types does Excel offer?

(Multiple Choice)

4.9/5

(35)

Question 66

As you type,Excel displays the entry (and the Cancel box and Enter box)in the ____________________.

(Essay)

4.8/5

(36)

Question 67

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

(True/False)

4.8/5

(31)

Question 68

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

(Essay)

4.9/5

(40)

Question 69

Press ____ to select the entire worksheet.

(Multiple Choice)

4.7/5

(29)

Question 70

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

(True/False)

4.8/5

(34)

Question 71

Live preview is available on a touch screen.

(True/False)

4.9/5

(35)

Question 72

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

(Multiple Choice)

4.8/5

(31)

Question 73

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

(True/False)

4.8/5

(29)

Question 74

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

(Multiple Choice)

4.9/5

(35)

Question 75

The active cell reference appears in the ____________________ on the left side of the formula bar.

(Essay)

4.9/5

(30)

Question 76

Which of the following is the Ribbon path to the Cell Styles button?

(Multiple Choice)

4.7/5

(36)

Question 77

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

(True/False)

5.0/5

(29)

Question 78

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

(Essay)

4.8/5

(46)

Question 79

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

(Multiple Choice)

4.7/5

(32)

Question 80

Showing 61 - 80 of 105

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 -Highlights one or more adjacent characters to the right.

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 -Selects the cell at the beginning of the row that contains the active cell.

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

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

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

How many chart types does Excel offer?

As you type,Excel displays the entry (and the Cancel box and Enter box)in the ____________________.

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

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

Press ____ to select the entire worksheet.

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

Live preview is available on a touch screen.

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

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

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

The active cell reference appears in the ____________________ on the left side of the formula bar.

Which of the following is the Ribbon path to the Cell Styles button?

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

The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.

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

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters