Name: Excel Lessons 7 and 8 Study Guide Multiple Choice



Download 191,56 Kb.
Date conversion16.06.2018
Size191,56 Kb.
Name:_____________________________
Excel Lessons 7 and 8 Study Guide
Multiple Choice

Identify the choice that best completes the statement or answers the question.
____ 1. To rename a worksheet, double-click its sheet tab, type the new name, and then press the ____ key.

a.

Ctrl

c.

Enter

b.

F3

d.

Tab

____ 2. You can reposition a worksheet by dragging its ____ to a new location.



a.

sheet tab

c.

file name

b.

cells

d.

right border

____ 3. You can create a copy of a worksheet by pressing the ____ key as you drag and drop its sheet tab.



a.

Ctrl

c.

F3

b.

Tab

d.

Enter

____ 4. To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.



a.

Insert

c.

Worksheet

b.

Sheet

d.

Insert Sheet

____ 5. When working with cell references, any change you make to the ____ cell also changes the value in the destination cell.



a.

source

c.

main

b.

primary

d.

active

____ 6. The Print what option called ____ prints the range or ranges selected within a single worksheet.



a.

Active Sheet(s)

c.

Entire workbook

b.

Selection

d.

Range

____ 7. The Print what option called ____ prints all of the worksheets in a workbook.



a.

Active Sheet(s)

c.

Entire workbook

b.

Selection

d.

All Sheet(s)

____ 8. To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group.



a.

Tab

c.

F2

b.

Ctrl

d.

F3

____ 9. To arrange all the open workbooks, click the ____ button in the Window group on the View tab of the Ribbon.



a.

Arrange All

c.

Cascade

b.

Align All

d.

Tile

____ 10. You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.



a.

red

c.

blue

b.

white

d.

Green


____ 11. To make a workbook active, just click ____.



a.

its title bar

c.

either a. or b.

b.

anywhere in the worksheet

d.

neither a. nor b.

____ 12. To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.



a.

Move or Copy

c.

New

b.

Relocate

d.

Location



Excel Case 7-2

Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. Please answer the questions below.


____ 13. How does Ron go about renaming his worksheet?

a.

Right-click its sheet tab, and then click Rename on the shortcut menu

b.

Double-click its sheet tab, type the new name, and then press the Enter key

c.

either a. or b.

d.

neither a. nor b.

____ 14. The chart types are available on the ____ tab in the Charts group.



a.

Data

c.

Worksheet

b.

Edit

d.

Insert

____ 15. You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.



a.

Charts

c.

Worksheet

b.

Cells

d.

Edit

____ 16. The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.



a.

Design

c.

Style

b.

Layout

d.

Format

____ 17. The chart element called ____ is a symbol that represents a single data point or value from the corresponding worksheet cell.



a.

Chart area

c.

Data marker

b.

Plot area

d.

Data symbol

____ 18. A selected chart element is surrounded by a ____.



a.

fill box

c.

text box

b.

selection box

d.

border

____ 19. A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____.



a.

workbook

c.

data file

b.

database

d.

report

____ 20. You switch between a chart sheet and a worksheet by clicking the appropriate ____.



a.

sheet tab

c.

icon

b.

file name

d.

data marker

____ 21. A ____ chart shows the relationship of a part to a whole.



a.

pie

c.

line

b.

column

d.

scatter

____ 22. The quickest way to select a chart element is to ____.



a.

navigate using the Ribbon

c.

click it with the pointer

b.

use the shortcut menus

d.

none of the above

____ 23. A chart ____ specifies which elements are included in a chart and where they are placed.



a.

style

c.

theme

b.

layout

d.

gallery

____ 24. You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.



a.

Format

c.

Styles

b.

Edit

d.

Design

____ 25. You can also use the Layout or Format tab under Chart Tools on the Ribbon to select a chart element. In the ____ group, next to the Chart Elements box, click the arrow.



a.

Current Chart

c.

Active Elements

b.

Current Selection

d.

Active Chart

____ 26. A pie chart shows the relationship of a part to a whole. Each part is shown as a ____ of the pie.



a.

bowl

c.

serving

b.

slice

d.

dish

____ 27. To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.



a.

Format

c.

Format Selection

b.

Selection

d.

Chart Selection

____ 28. You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.



a.

Type

c.

Text

b.

Format

d.

Style

FIGURE 8-1



Excel Case 8-1

Candace wants to create a chart sheet similar to the one shown above. Please refer to the figure above while answering the questions below.


____ 29. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?

a.

In the New sheet box

c.

either a. or b.

b.

In the Object in box

d.

neither a. nor b.



Excel Case 8-2

Paco wants to change some of the elements in his chart, including the fill and border color. Please answer the questions below.


____ 30. On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend. First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.

a.

Layout

c.

Data

b.

Page Layout

d.

Format



Short Essay
31. What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

32. Please briefly describe these chart elements: Data series, Data marker, Data label, and Data table


The database is protected by copyright ©sckool.org 2016
send message

    Main page