Microsoft Office Excel
1. By default, how many worksheets are in a workbook when it is first created?
A. 1
B. 2
C. 3
D. 4
2. To select a cell that is adjacent to the currently selected cell, press
A. Enter.
B. Tab.
C. an arrow key.
D. All of the above are correct.
3. Column headings are identified with letters.
A. True
B. False
4. Which character is not allowed in file names?
A. !
B. *
C. &
D. ‘
5. To use the Ask A Question feature, you simply type your question or keyword in the text box and press Enter.
6. You can print a worksheet from the Print Preview window.
7. To rename a worksheet, use the Save As command.
8. You can insert and delete
A. ranges of cells.
B. rows.
C. columns.
9. All Date formats display dates with four-digit years.
10 You can apply cell formatting
A. only after you enter the data in cells.
B. only before you enter the data in cells.
C. Both A and B are correct.
D. Neither A nor B is correct.
11. If you want a column’s width to match the widest entry in the column, you must drag the column divider to the right of the column until the column is the correct width.
12 You can align cell content
A. vertically.
B. horizontally.
C. diagonally.
13 To replace all occurrences of a value in a worksheet, you can
A. click Find Next to find all occurrences of the value and replace each one individually.
B. click Replace All.
C. drag the mouse to select the entire worksheet and then use the Search option on the Tools menu.
D. Both A and B are correct.
14 With the Find and Replace feature, you can also replace cell formats.
15 Clearing a cell’s format deletes all of the data from the cell.
16 You can change the height of a row by clicking the bottom of any cell in the row and dragging up or down.
17 You can format the __________ of cell data.
A. color and size
B. font and decimal places
C. alignment and tilt
18 The Comma Style button on the Formatting toolbar inserts commas between groups of thousands.
19 You can format cells in Currency Style without using the Format Cells dialog box.
20. You can merge two or more cells in adjoining columns, but you cannot merge two or more cells in adjoining rows.
21. Which magnification level indicates that you have zoomed in on a worksheet?
A. 0%
B. 50%
C. 100%
D. 125%
22. Freezing rows and columns is used primarily to
A. prevent anyone from changing or entering data in their cells.
B. keep a row or column of labels from scrolling off the edge of the screen.
C. refer to cells in different worksheets or workbooks.
D. display all of a large worksheet simultaneously on the screen.
23. To navigate between worksheets in a workbook, you click the sheet tab of the worksheet that you want to display.
24 When you insert a worksheet, it appears to the left of the selected sheet tab by default.
25 You can use the Chart Wizard to create charts embedded in worksheets but not to create chart sheets.
26 To add an arrow to a chart,
A. use the Arrows tab in the Chart Options dialog box.
B. use the Arrow button on the Drawing toolbar.
C. click the Arrow button on the Standard toolbar.
D. drag the sizing handle on the text box.
27. A chart updates automatically when you change the source data.
28. To change the chart type,
A. right-click the Chart Area and click Chart Options.
B. delete the chart and use the Chart Wizard to create the type that you want.
C. right-click the Chart Area and click Chart Type.
D. double-click the chart and select the type that you want.
29. To enter a formula in a cell,
A. click the cell, type an equal sign, type the formula, and press Enter.
B. click the cell, click the Insert Formula button on the Standard toolbar, use the Formula Arguments dialog box to build the formula, and then click OK.
C. click the cell and type the formula.
30. Which of the following formulas will compute the average of values in cells A1:A3?
A. =(A1+A2+A3)/3
B. =AVERAGE(A1+A2+A3)
C. =AVERAGE(A1:A3)
D. Both A and C are correct.
31. To make a cell reference absolute, you enclose the formula in parentheses and put a dollar sign ($) to the left of the first parenthesis.