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.