A chart is a picture of numeric data and is sometimes referred to as a

$(1$ Point$)$

report.

range.

table.

graph.

$6.$You can move to a different worksheet in your workbook by

$(1$ Point$)$

pressing Ctrl $+$ Tab.

clicking the desired worksheet tab.

pressing the Page Down key.

sliding the horizontal scroll bar.

$7.$The first step in creating a chart is to

$(1$ Point$)$

decide where the chart will be placed.

select a name for your chart.

determine the titles for your chart.

select the cells that contain the data you want to chart.

$8.$A$($n$)\_\_\_\_\_$ chart uses bars to compare separate $($noncontiguous$)$ items as they vary over time.

$(1$ Point$)$

Bar

Column

Line

Radar

$9.$Which ribbon tab do you click to display the most recently opened workbooks?

$(1$ Point$)$

File

View

Insert

Review

$10.$What displays when you insert a picture or clip art image in a worksheet?

$(1$ Point$)$

the SmartArt Tools Design tab

the Format Picture dialog box

the Picture Tools Format tab

the Drawing Tools Format tab

$11.$Which of these keyboard shortcuts will create a chart from the selected cells?

$(1$ Point$)$

F$9$

Ctrl $+$ F$2$

Shift $+$ F$5$

Alt $+$ F$1$

$12.$A menu with options for managing worksheets is displayed when you

$(1$ Point$)$

click the Sheet Options button on the Page Layout tab.

right$-$click a worksheet tab.

double$-$click a worksheet tab.

press Ctrl $+$ M$.$

$13.$Workbooks deleted from your hard drive are automatically

$(1$ Point$)$

backed up on your local hard drive.

copied to disk.

backed up on the Microsoft Office servers.

sent to the Windows Recycle Bin.

$14.$You can resize an inserted image by selecting the image

$(1$ Point$)$

then clicking in the middle of the image and dragging in the desired direction.

and clicking the Zoom button.

and using the Up$,$ Down, Left, and Right Arrow keys to expand or contract it$.$

and dragging the sizing handles.

$15.$The first step for copying cells is

$(1$ Point$)$

selecting the location where the cells are to be copied.

checking to make sure that the destination for the copied cells does not already contain data.

clicking the Copy button.

d$.$ selecting the cells to be copied.

$16.$You can create a new folder by clicking the New folder button, which is available

$(1$ Point$)$

in the Open and Save As dialog boxes.

on the Quick Access Toolbar.

when you click the Close button.

when you click the Save button.

$17.$You can create organizational charts and other types of graphics by using the

$(1$ Point$)$

WordArt button.

Chart Wizard.

SmartArt button.

Picture toolbar.

$18.$When setting up a logical scheme for storing your workbooks, you can create a subfolder, which is a folder

$(1$ Point$)$

within a folder.

on any non$-$local drive.

that can store only one file.

on the network drive.

$19.$Select nonadjacent worksheet tabs by clicking the first tab, holding down this key, and then clicking any other desired tabs$.$

$(1$ Point$)$

Enter

Shift

Alt

Ctrl

$20.$You can insert symbols and special characters into a workbook by clicking the $\_\_\_\_\_$ button in the Symbols group on the Insert tab.

$(1$ Point$)$

WordArt

Text Box

Symbol

Shapes

$21.$When a chart on Sheet$1$ is moved to a new sheet, the default name for that worksheet is

$(1$ Point$)$

Sheet$2.$

Chart$1.$

Sheet$1-$Chart.

Sheet$4.$

$22.$When you $$pin$$ a workbook in Excel, what are you pinning it to$?$

$(1$ Point$)$

the Task bar

the Quick Access Toolbar

the Status bar

the Recent option list

$23.$Which of the following chart types shows the relationship of parts to a whole?

$(1$ Point$)$

Line

Stock

Bar

Pie

$24.$To modify a hyperlink, begin by $\_\_\_\_\_$ the hyperlink.

$(1$ Point$)$

deleting

right$-$clicking

double$-$clicking

following

$25.$To change the color of a worksheet tab, begin by $\_\_\_\_\_$ the desired tab.

$(1$ Point$)$

right$-$clicking

double$-$clicking

clicking

double right$-$clicking

$26.$When you copy a workbook into the same folder using the Copy and Paste options in the Open dialog box, Excel adds the word$($s$)\_\_\_\_\_$ to the name of the new workbook to distinguish it from the original workbook

$(1$ Point$)$

Copy

Version $2$

Duplicate

New

$27.$Use the Bing Image Search feature to search for $\_\_\_\_\_$ online.

$(1$ Point$)$

themes

outlines

images

templates

$28.$What displays around a chart when it is selected?

$(1$ Point$)$

a border with sizing handles

a wavy green border

a thick blue marquee border

a dashed line border

$29.$With default settings, a new workbook contains $\_\_\_\_\_$ worksheet$($s$).$

$(1$ Point$)$

seven

five

one

three

$30.$The styles you define in a workbook are available

$(1$ Point$)$

in any workbook.

in any workbook in the same folder as the workbook where they were created.

only in the worksheet that was active in the workbook where they were created.

only in that workbook.