Excel Final Exam

When creating a folder, what happens when you use the keyboard command Ctrl + F12? Select one: a. The Save As dialog box displays. b. The Save As backstage are displays. c. The Open backstage area displays. d. The Open dialog box displays.

The Open dialog box displays

Which keyboard shortcut displays the Go To dialog box? Select one: a. F9 b. Ctrl + G c. F4 d. Ctrl + T

Ctrl + G

The keyboard command to cut selected data is Select one: a. Ctrl + V. b. Ctrl + X. c. Ctrl + C. d. Ctrl + P.

Ctrl + X.

If you want to apply the formatting you have just applied to one cell to other cells in your worksheet, you can use the Repeat command, which is executed by pressing Select one: a. the Tab key. b. the F9 function key. c. Ctrl + R. d. Ctrl + Y.

Ctrl + Y.

Use this function key to update a NOW or TODAY function. Select one: a. F9 b. F6 c. F3 d. F12

F9

Use the Function Arguments dialog box by clicking the Logical button in the Function Library group on the _____ tab to help you write an IF function. Select one: a. Formulas b. Insert c. Data d. Home

Formulas

Which of these Excel features would be best for creating company logos and headlines? Select one: a. WordArt b. SmartArt c. Charts d. Shapes

WordArt

Generally, the most recent _____ opened workbook names display in the Recent option list. Select one: a. 50 b. 10 c. 15 d. 25 Feedback

25

When you select cells in your worksheet and then click the Copy button, what happens? Select one: a. The cells are erased. b. The contents are cleared from the cells. c. The formatting is removed from the cells. d. A moving dashed line border appears around the cells.

A moving dashed line border appears around the cells.

What happens if you select a column in a worksheet and then click Insert Page Break on theBreaks button? Select one: a. The Page Setup dialog box is displayed. b. A page break is inserted to the left of the column. c. A page break is inserted immediately above the active row. d. A vertical page break is inserted to the right of the column.

A page break is inserted to the left of the column

The function that returns the arithmetic mean of the arguments is called Select one: a. SUM. b. AVERAGE. c. COUNT. d. MAX.

AVERAGE

In the worksheet area, the cell containing the insertion point is surrounded by a thick, green border and is known as the _____ cell. Select one: a. working b. title c. main d. active

Active

Which tab would you use to apply a WordArt style to one of your chart elements? Select one: a. Page Layout b. Chart Tools Design c. Chart Tools Format d. Chart Tools Layout

Chart Tools Format

When a chart on Sheet1 is moved to a new sheet, the default name for that worksheet is Select one: a. Sheet2. b. Sheet4. c. Sheet1-Chart. d. Chart1.

Chart1

If you want to sort data by a column other than the default column, which method would you choose? Select one: a. Filter the data first, then sort it. b. Press Ctrl + S. c. Click the Sort & Filter button, then click Custom Sort. d. Click the Sort & Filter button, then choose the sort order.

Click the Sort & Filter button, then click Custom Sort.

A(n) _____ chart uses bars to compare separate (noncontinuous) items as they vary over time. Select one: a. Bar b. Column c. Line d. Radar

Column

The AutoCorrect feature in Excel automatically corrects Select one: a. errors in cell formatting. b. every misspelling. c. common typing errors. d. errors in formulas.

Common typing errors

Which button lets you remove unnecessary parts of an image you have inserted into a document? Select one: a. Picture Borders b. Compress Pictures c. Crop d. Picture Effects

Crop

If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle. Select one: a. Shift b. Ctrl c. Tab d. Alt

Ctrl

Select nonadjacent worksheet tabs by clicking the first tab, holding down this key, and then clicking any other desired tabs. Select one: a. Ctrl b. Enter c. Shift d. Alt

Ctrl

To select specific characters within a cell (rather than the whole cell), begin by Select one: a. clicking in the desired cell. b. double-clicking in the desired cell. c. pressing the Tab key to navigate to the desired cell. d. right-clicking in the desired cell.

Double-clicking in the desired cell

Once a shape has been inserted into a worksheet, the _____ tab displays. Select one: a. Chart Tools Layout b. Chart Tools Format c. Drawing Tools Format d. Page Layout

Drawing Tools Format

Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab. Select one: a. Calculation; Formulas b. Formula Auditing; Formulas c. Editing; Home d. Cells; Home

Editing; Home

You can determine the way you want to paste your data using the Select one: a. Insert button in the Cells group on the Home tab. b. Fill button in the Editing group on the Home tab. c. Format painter. d. Paste Options button.

Paste Options button

What is the first step in unhiding a row with the mouse? Select one: a. Release the mouse button b. Drag down to display the row. c. Position the mouse pointer on the slightly thicker gray line in the row header. d. Click and hold down the left mouse button.

Position the mouse pointer on the slightly thicker gray line in the row header.

When writing a formula by pointing, how do you end the formula? Select one: a. Press the Enter key. b. Click in an empty cell. c. Press the Esc key. d. Double-click the active cell.

Press the Enter key

When you select a chart and then display the Print backstage area, the first gallery in the Settings category is automatically changed to Select one: a. Print Data Only. b. Print Selected Chart. c. Print Chart and Data. d. Print Active Worksheet.

Print Selected Chart

Click the Tell me more hyperlink text or press the F1 function key and the Excel Help window opens with information about the button feature when accessed from _____. Select one: a. the Help Window b. Quick Access Toolbar c. a ScreenTip d. the Status bar Feedback

ScreenTip

To maintain the proportions of an image while resizing it with the sizing handles, hold down the _____ key while dragging the sizing handle. Select one: a. Alt b. Esc c. Ctrl d. Shift

Shift

What is the keyboard command for inserting a new worksheet into a workbook? Select one: a. Shift + F5 b. Ctrl + F7 c. Shift + F11 d. Ctrl + F1 Feedback

Shift + F11

You can resize a shape with the Shape Height and Shape Width measurement boxes in the _____ group on the _____ tab. Select one: a. Size; Drawing Tools Format b. Chart Layouts; Chart Tools Design c. Charts; Insert d. Editing; Home

Size; Drawing Tools Format

What is the name of the area at the bottom of the Excel screen that shows the Zoom level, the viewing mode, and the current mode? Select one: a. scroll bar b. sheet tab c. Status bar d. ribbon

Status bar

To change a chart's data series, make the chart active, then in the Data group on the Chart Tools Design tab, click the _____ button. Select one: a. Axes b. Move Chart c. Change Chart Type d. Switch Row/Column

Switch Row/ Column

What does it mean for a formula to have relative cell references? Select one: a. The cell references do not change when the formula is copied to a new cell. b. The formula only references cells that are adjacent to the active cell. c. The formula contains only actual numbers, not cell addresses. d. The cell references change when the formula is copied to a new cell.

The cell references change when the formula is copied to a new cell.

If you specify more than one print area on a worksheet, how will they print? Select one: a. They will print on as few pages as possible. b. They will print on separate pages. c. The areas will shrink to fit on one page. d. Only the first print area specified will print.

They will print on separate pages

Can you specify more than one print area? If so, how? Select one: a. Yes, by selecting the first print area, clicking the Print Area button, clicking Set Print Area, and then selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area. b. Yes, but the print areas must be on different worksheets. c. No, you can only specify one print area. d. Yes, by repeating the same steps used to specify the first print area.

Yes, by selecting the first print area, clicking the Print Area button, clicking Set Print Area, and then selecting the next print area, clicking the Print Area button, and then clicking Add to Print Area.

Will moving a worksheet from one workbook to another affect formulas in the source workbook that are not on the sheet that is moved? Select one: a. No, the formulas that reference the sheet that was moved will be updated automatically. b. No, Excel will not allow you to move a sheet if it contains formulas that depend on its contents. c. Yes, if the formulas depend on the contents of cells in the sheet that was moved. d. Yes, all formulas in the source workbook will have to be updated.

Yes, if the formulas depend on the contents of cells in the sheet that was moved.

What displays when you hover your mouse pointer over a hyperlink in your workbook? Select one: a. a ScreenTip with the address of the hyperlink b. a dialog box with instructions on how to follow the link c. the Mini toolbar d. a thumbnail of the destination web page or document

a ScreenTip with the address of the hyperlink

What displays around a chart when it is selected? Select one: a. a dashed line border b. a border with sizing handles c. a thick blue marquee border d. a wavy green border

a border with sizing handles

Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column? Select one: a. Percentage b. Accounting c. Number d. Currency

accounting

To enter data in a cell, the cell must be Select one: a. unformatted. b. active. c. empty. d. formatted.

active

The Page Break Preview allows you to view Select one: a. and adjust your worksheet page breaks and margins. b. and adjust your worksheet page breaks. c. and adjust your worksheet page breaks, margins, and headers/footers. d. but not edit your worksheet page breaks.

and adjust your worksheet page breaks

When you insert rows into a worksheet, all references affected by the insertion Select one: a. are automatically adjusted. b. are deleted. c. are adjusted only after you press F9 or save the workbook. d. must be updated.

are automatically adjusted

As you accumulate more and more workbooks, it becomes important that they Select one: a. are grouped logically and stored in folders. b. each contain only one worksheet. c. be opened and closed regularly. d. are all stored in the same folder.

are grouped logically and stored in folders

Where can you preview your headers and footers before printing? Select one: a. in Normal view b. at the Print backstage area c. at the Info backstage area d. in Page Break view

at the Print backstage area

You can print multiple worksheets with options Select one: a. at the Shortcut menu. b. on the Home tab. c. on the Page Layout tab. d. at the Print backstage area.

at the Print backstage area.

What type of cell values will the AVERAGE function ignore and not use in its calculation? Select one: a. cells with decimal values b. all cells c. cells with zeros d. blank cells

blank cells

To copy a worksheet from one workbook to another, begin by opening Select one: a. neither the source nor the destination workbooks. b. both the source and the destination workbooks. c. only the source workbook. d. only the destination workbook.

both the source and the destination workbooks

You can display the Find and Replace dialog box by Select one: a. clicking the Search button in the Clipboard group on the Home tab, then clicking Find. b. clicking the Find & Select button in the Editing group on the Home tab, then clicking Replace. c. clicking the Filter button in the Sort & Filter group on the Data tab, then clicking Find. d. pressing Ctrl + R.

clicking the Find & Select button in the Editing group on the Home tab, then clicking Replace.

Excel's split window feature is useful for displaying Select one: a. multiple worksheets at the same time. b. different areas of the worksheet on the screen when the whole worksheet will not fit. c. multiple workbooks on the same screen. d. the same cells, but with different formatting applied.

different areas of the worksheet on the screen when the whole worksheet will not fit.

An absolute cell reference _____ change when copied to another cell. Select one: a. does b. can sometimes c. will always d. does not

does not

Which of the following tasks cannot be accomplished at the sheet tab shortcut menu? Select one: a. format a worksheet b. insert a new worksheet c. rename a worksheet d. hide a worksheet

format a worksheet

If you delete a style from the Cell Styles gallery, Select one: a. that style will no longer be available in Excel. b. formatting applied by the deleted style will be removed from all cells in the worksheet. c. the style will be moved to the Recycle Bin. d. formatting applied by the deleted style will be removed from only the active cell.

formatting applied by the deleted style will be removed from all cells in the worksheet.

A built-in formula, such as =SUM, is called a(n) Select one: a. constant. b. operator. c. function. d. argument.

function

To remove the WordArt style but retain the text, click the More Styles button in the WordArt Styles _____, and then click Clear WordArt. Select one: a. group on the SmartArt Tools Design tab b. gallery in the Text group on the Insert tab c. group on the Drawing Tools Format tab d. group on the Picture Tools Format tab

group on the Drawing Tools Format tab

You can create a new folder by clicking the New folder button, which is available Select one: a. when you click the Close button. b. on the Quick Access Toolbar. c. in the Open and Save As dialog boxes. d. when you click the Save button.

in the Open and Save As dialog boxes

How many functions can Excel perform? Select one: a. more than 300 b. around 100 c. 12 d. 255

more than 300

Change the formatting of a SmartArt graphic with options Select one: a. on the SmartArt Tools Design tab. b. at the SmartArt button. c. on the SmartArt Tools Format tab. d. at the Shapes button.

on the SmartArt Tools Format tab

You can adjust a column width to fit the longest entry in the column by double-clicking Select one: a. anywhere in the column header. b. on the longest value in the column. c. on the column boundary line. d. anywhere in the column.

on the column boundary line

Excel uses a PMT function to calculate Select one: a. payment for a loan based on evolving payments and a variable interest rate. b. interest required based on a range of loan amounts. c. payment for a loan based on constant payments and a constant interest rate. d. the future value of an investment.

payment for a loan based on constant payment and a constant interest rate

Excel measures row height in _____ and column width in _____. Select one: a. inches; values b. values; inches c. characters; points d. points; characters

points; characters

If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by Select one: a. pressing Alt + Enter b. pressing Ctrl + Enter. c. clicking the Increase Indent button. d. double-clicking the Align Right button.

pressing Alt + Enter

When you have finished editing the data in a cell, you must get out of Edit mode. Which of the following will not accomplish this? Select one: a. pressing Shift + Tab b. pressing Home c. pressing Enter d. pressing Tab

pressing Home

Complete the process of creating a shape by Select one: a. clicking outside the shape. b. releasing the mouse button. c. double-clicking the mouse button. d. pressing Esc.

releasing the mouse button

The Rename option in the Organize button drop-down list at the Open dialog box Select one: a. renames the workbook and keeps it in the same folder. b. creates a copy of the workbook in a folder you choose. c. renames the workbook and prompts you to enter the name of the folder where you want it stored. d. renames the workbook and moves it to its own new folder.

renames the workbook and keeps it in the same folder.

A menu with options for managing worksheets is displayed when you Select one: a. click the Sheet Options button on the Page Layout tab. b. press Ctrl + M. c. double-click a worksheet tab. d. right-click a worksheet tab.

right-click a worksheet tab

To modify a hyperlink, begin by _____ the hyperlink. Select one: a. deleting b. following c. double-clicking d. right-clicking

right-clicking

What does the Orientation button in the Alignment group do? Select one: a. switches columns to rows and rows to columns b. rotates data in a cell c. toggles the print direction between Portrait and Landscape d. toggles formulas between relative and absolute references

rotates data in a cell

The first step in creating a chart is to Select one: a. determine the titles for your chart. b. select a name for your chart. c. select the cells that contain the data you want to chart. d. decide where the chart will be placed.

select the cells that contain the data you want to chart

The Sort & Filter button on the Home tab will sort data in the Select one: a. entire workbook. b. entire worksheet. c. protected cells. d. selected cells.

selected cells

The Trace Error button is a type of Select one: a. Wizard. b. smart tag. c. ScreenTip. d. tool tip.

smart tag

You can enter text directly into a SmartArt graphic shape or into the Select one: a. text pane. b. worksheet cells behind the SmartArt diagram. c. clipboard. d. watermark.

text pane

What displays when you insert a picture or clip art image in a worksheet? Select one: a. the Format Picture dialog box b. the Picture Tools Format tab c. the Drawing Tools Format tab d. the SmartArt Tools Design tab

the Picture Tools Format tab

To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position. Select one: a. the last row header b. the first row header c. the Select All button d. in the Name box

the Select All button

When using the Screenshot feature, what will display if you do not have another file or program open? Select one: a. an error message b. your root folder and the folders directly under it c. the Windows desktop d. a copy of the active workbook

the Windows desktop

Excel's spell checker checks the worksheet from _____ to _____. Select one: a. cell A1; the last cell in the last worksheet of the workbook b. cell A1; the last cell in the worksheet that contains data c. the active cell; the last cell in the worksheet that contains data d. the active cell; cell Z6000

the active cell; the last cell in the worksheet that contains data

The column width number in the Column Width dialog box represents Select one: a. the width of the column measured in millimeters. b. the average number of characters in the standard font that will fit in a cell. c. the width of the column measured in inches. d. the width of the column measured in the typesetting unit called picas.

the average number of characters in the standard font that will fit in a cell

When using the Sort & Filter button, by which column will the data be sorted? Select one: a. the column containing the active cell b. the first column containing numbers c. the first selected column d. the last column on the worksheet

the first selected column

A file created in Excel is referred to as a Select one: a. database. b. cell. c. table. d. workbook.

workbook

In a workbook with multiple worksheets, by default Excel will print the Select one: a. worksheet that is currently displayed. b. worksheet that comes first alphabetically. c. first worksheet in the workbook. d. last worksheet that was printed.

worksheet that is currently displayed.