Test 1

If you want to see the formula stored in a specific cell, click the cell and then ____. a. look in the formula bar b. look at the contents of the cell c. choose View>Workbook Views>Page Layout d. choose View>Workbook Views>Normal

A

Which of the following is a Dialog Box Launcher?

A.

Which of the following is not a tab on the Excel Ribbon? a. Print b. Home c. View d. Formulas

A. Print

If the last row you can see on your screen is row 26 and you want to see row 27, click

B

Which of the following buttons would you click to add together a row of numbers?

B

Which of the following steps lets you calculate the total of the numbers in cells C1 through C10? a. Click cell D10 and choose Home>Formulas>AutoSum. b. Click cell C11 and choose Formulas>Function Library>AutoSum. c. Click cell C1 and choose Home>Formulas>AutoSum. d. Click cell C1 and choose Formulas>Function Library>AutoSum.

B. Click cell C11 and choose Formulas>Function Library>AutoSum.

Another name for a worksheet is a... a. tab b. spreadsheet c. file d. folder

B. Spreadsheet

To see a greater amount of a worksheet on your screen at one time, you can ____. a. increase the zoom percentage b. decrease the zoom percentage c. use the horizontal scroll bar d. use the vertical scroll bar

B. decrease the zoom percentage

Worksheets are made up of boxes called ____. a. formulas b. cells c. columns d. cell references

C. Columns

Which of the following steps lets you create a new folder? a. Open the Save As dialog box and key New Folder into the File name box. b. Click the New Folder button on the Home tab. c. Open the Save As dialog box and click the New Folder button. d. Click New Folder in the Office menu.

C. Open the Save As dialog box and click the New Folder button.

Which of the following contains the Undo button? a. Home tab b. View tab c. QAT d. Office menu

C. QAT

By default, a new workbook contains how many worksheets? a. One b. Two c. Three d. Four

C. Three

How must the pointer appear before you can increase the width of a column?

D

This screen shows the

D Office Menu

The formula ____ will add together the contents of cells A5 through A8. a. +AUTOSUM A5-A8 b. =AUTOSUM (A5-A8) c. +SUM(A5-A8) d. =SUM(A5:A8)

D.=SUM(A5:A8)

A worksheet cell cannot contain letters

False

Scroll bars let you move up and down in a worksheet, but not to the right and left.

False

The primary purpose of spreadsheet software is to let users create documents such as business letters

False

When you print a workbook, you always must print every one of its worksheets.

False

Worksheets can contain several workbooks.

False

If you want a worksheet to take up the entire screen, which of these buttons would you click?

Looks like a TV

You can print a worksheet by choosing a. Home>Editing>Print b. Home>Cells>Print c. Office>Save As d. Office>Print

Office Print

12. Which of the following buttons closes Print Preview?

The Red X

A synonym for the verb "to illustrate" is "to show."

True

A worksheet can contain data such as numbers and formulas

True

If you want to display a worksheet named Fourth Quarter Sales on the screen, click that worksheet's tab.

True

One reason that Excel is so popular is its accuracy when performing calculations.

True

You can undo multiple actions by clicking the Undo button multiple times.

True

If you want to learn how to use a particular built-in formula, you can enter that formula's name the Help window's ____ box. a. Search c. Find b. Save d. Open

a

The individual buttons on a tab are also called ____. a. commands c. Ribbons b. groups d. menus

a

To access the Font Color button, click the ____ tab. a. Home c. Formulas b. Page Layout d. View

a Home

Which of the following could you use to find instructions on how to use the Open command? a. Help feature b. Question feature c. QAT d. Formulas feature

a. Help feature

Where would you click to specify the folder in which this workbook should be stored? a. A c. C b. B d. D

b

The ____ contains a command that lets you minimize the Ribbon. a. Office menu c. status bar b. QAT d. Home tab

b QAT

If you want to quickly see what percentage of zoom the screen is at, look at the ____. a. title bar c. vertical scroll bar b. status bar d. horizontal scroll bar

b Status Bar

The Open dialog box lets you ____. a. display a worksheet in Print Preview b. specify the name of the workbook to be opened c. perform calculations on worksheet cells d. use the Excel Help feature

b specify the name of the workbook to be opened

If you want to permanently store your workbook so that you can modify it again at a later time, choose ____. a. Redo on the QAT b. Office>Save As c. Office>Print d. Office>Open

b. Office>Save As

When you choose Office>Open, ____. a. the Ribbon displays the Insert tab b. a menu appears c. a dialog box appears d. the last workbook you saved appears

c

When you first start Excel, what is the name of the workbook that appears? a. New c. Book1 b. New Workbook d. Excel 1

c Book1

You can exit the Excel program by ____. a. choosing Office>Save As b. choosing Office>Close c. choosing Office>Exit Excel d. clicking the Close Window button in a workbook's upper-right corner

c Closing the window

If you want to create a workbook from scratch, choose ____. a. QAT>Open c. Office>New b. Office>Open d. Home>Cells>Insert

c Office>New

The following is the

c QAT

A worksheet's row heads ____. a. appear in the Formula bar b. contain labels that describes the worksheet's contents c. run down the left edge of the worksheet d. run across the top of the worksheet

c run down the left edge of the worksheet

Which of the following is a reason you might want to minimize the Ribbon? a. To make on-screen letters and numbers larger. b. To make on-screen letters and numbers smaller. c. to allow more room for a worksheet to be displayed d. to close an existing workbook

c to allow more room for a worksheet to be displayed

As you key data into a cell, the data appears both in the cell itself and in the ____. a. column heading c. status bar b. row heading d. formula bar

d

Which cells are used in calculating the results of "=SUM(G14:G18)"? a. G14 c. G14 and G18 b. G18 d. G14 through G18

d

If you have chosen Undo by mistake, you can bring back your previous action by choosing ____. a. Repeat c. New b. Open d. Redo

d Redo

Label "A" is pointing to the a. Zoom feature c. formula bar b. Full Screen button d. Select All button

d Select all

The Zoom command is located on the ____ tab. a. Home c. Formulas b. Insert d. View

d Veiw

The Help button is located on the ____. a. status bar c. title bar b. Office menu d. Ribbon

dRibbon