Take This Interesting Microsoft Excel Quiz
Settings
Excel Test
- 1.Microsoft Excel is what type of program?
- A.
A.Database
- B.
B.Email
- C.
C.Spreadsheet
- D.
D.Word processor
- 2.A cell:
- A.
A.is an intersection of a colunand a row
- B.
B.has a unique cell address
- C.
C.Neither A or B
- D.
D.Both A and B
- 3.A document was saved to your disk and you want to open it for editing, Which menu do you select?
- A.
A.Edit
- B.
B.File
- C.
C.Open
- D.
D.View
- 4.All formulas in Excel begin with the following symbol:
- A.
A.=
- B.
B.+
- C.
C.%
- D.
D.#
- 5.
- A.
A.=B2+C3
- B.
B.=C3+B2
- C.
C.=SUM(B2+C3)
- D.
D.All of the above
- 6.The Auto Sum function is used to create a formula that includes a range of cells.
- A.
True
- B.
False
- 7.A dialog box will appear before you delete a workdheet even if the worksheet does not contain data.
- A.
True
- B.
False
- 8.A workbook defaults to three worksheets. Additional worksheets can be created
- A.
True
- B.
False
- 9.Grouping worksheets allows you to:
- A.
A.apply identical formulas across all the worksheets in a group
- B.
B.apply identical formulas across all the worksheets in a group
- C.
C.make changes to all the worksheets in a group bychanging only one of the worksheets
- D.
D.All of the above
- 10.You want to inset a column between column A and column B. Which of the following needs to be done?
- A.
A.All the information in the worksheet needs to be retype
- B.
B.Insert a column by selecting the Columns selection on the Edit menu
- C.
C.Insert a cplumn by selecting the Columns selection on the Insert menu
- D.
D.It cannot be done. A new worksheet needs to be created
- 11.The eadiest way to select an entire row is to ______.
- A.
A.Choose the Select option in the Edit menu
- B.
B.Click both the first entry and last entry in the row
- C.
C.Click the row heading
- D.
D.Double-click any cell in the row
- 12.If a cell shows #####, it means you mush insert a column
- A.
True
- B.
False
- 13.The merge and center button:
- A.
A.is only available when worksheets are grouped
- B.
B.is used to center vertically only
- C.
C.allows you select one or more cells and merge them into a larger cell
- D.
D.is a button on the Drawing Toolbar
- 14.Which of the following operations cannot be performed in the Alignment tab of the Format Cells dialog box?
- A.
A.Change text orientation
- B.
B,Color a cell background
- C.
C.Merge cells
- D.
D.Wrap text
- 15.The Source Data is:
- A.
A.the range of cells that make up a chart
- B.
B.the same thing as an axis
- C.
C.Both A and B
- D.
D. Neither A and B
- 16.The quickest way to create and edit your charts is to use:
- A.
A.the Tools Menu
- B.
B.the Chart Toolbar
- C.
C,the View function
- D.
D.the Format Dialog box
- 17.Which of the following is not a chart type in Excel?
- A.
A.Bar Chart
- B.
B.Pie Chart
- C.
C.Pin Chart
- D.
D.Line Chart
- 18.A chart created on the same worksheet as the soure data is called a chart sheet.
- A.
True
- B.
False
- 19.
- A.
A.use the arrow keys on your keyboard
- B.
B.use the mouse to drah the sizing handles until the chart is the desired size
- C.
C.use the nouse to drah the blinking cursor through the choices smal(50%), medium (75%), and large (100%)
- D.
D.delete the original chart and insert a new chart with the correct measurements
- 20.Which dialog box allows you to add headers and footers to a documents.
- A.
A.Save As
- B.
B.Page Setup
- C.
C.View Options
- D.
D.Filter Data
Back to top