New Day Global Class® - Excel Pe-Test

Question 1 of 20

Microsoft Excel is what type of program?

A. Database
B. Email
C. Spreadsheet
D. Word processor

Question 2 of 20

A document was saved to your disk and you want to open it for editing. Which menu do you select?

A. Edit
B. File
C. Open
D. View

Question 3 of 20

A cell:

A. is an intersection of a column and a row.
B. has a unique cell address.
C. Neither A or B.
D. Both A and B.

Question 4 of 20

The autosum command is used to find the average of a range of numbers.

A. True
B. False

Question 5 of 20

All formulas in Excel begin with the following symbol:

A. =
B. +
C. %
D. #

Question 6 of 20

Which formula below will add the value of B2 to the value of C3?

A. =B2+C3
B. =C3+B2
C. =SUM(B2+C3)
D. All of the above

Question 7 of 20

The easiest way to select an entire row is to _____.

A. Choose the Select option in the Edit menu
B. Click both the first entry and last entry in the row
C. Click the row heading
D. Double-click any cell in the row

Question 8 of 20

A dialog box will appear before you delete a worksheet even if the worksheet does not contain data.

A. True
B. False

Question 9 of 20

A workbook defaults to three worksheets. Additional worksheets can be created

A. True
B. False

Question 10 of 20

Grouping worksheets allows you to:

A. apply identical formulas across all the worksheets in a group.
B. apply identical formatting across all the worksheets in a group.
C. make changes to all the worksheets in a group by changing only one of the worksheets.
D. All of the above.

Question 11 of 20

If a cell shows ######, it means you must insert a column.

A. True
B. False

Question 12 of 20

Which of the following operations cannot be performed in the Alignment tab of the Format Cells dialog box?

A. Change text orientation
B. Color a cell background
C. Merge cells
D. Wrap text

Question 13 of 20

You want to insert a column between column A and column B. Which of the following needs to be done?

A. All the information in the worksheet needs to be retyped.
B. Insert a column by selecting the Columns selection on the Edit menu.
C. Insert a column by selecting the Columns selection on the Insert menu.
D. It cannot be done. A new worksheet needs to be created

Question 14 of 20

The merge and center button:

A. is only available when worksheets are grouped.
B. is used to center vertically only.
C. allows you to select one or more cells and merge them into a larger cell.
D. is a button on the Drawing Toolbar.

Question 15 of 20

The Source Data is:

A. the range of cells that make up a chart.
B. the same thing as an axis.
C. Both A and B.
D. Neither A and B.

Question 16 of 20

The quickest way to create and edit your charts is to use:

A. the Tools Menu.
B. the Chart Toolbar.
C. the View function.
D. the Format Dialog box.

Question 17 of 20

Which of the following is not a chart type in Excel?

A. Bar Chart
B. Pie Chart
C. Pin Chart
D. Line Chart

Question 18 of 20

A chart created on the same worksheet as the source data is called a chart sheet.

A. True
B. False

Question 19 of 20

To resize a chart:

A. use the arrow keys on your keyboard.
B. use the mouse to drag the sizing handles until the chart is the desired size.
C. use the mouse to drag the blinking cursor through the choices small (50%), medium (75%) and large (100%).
D. delete the original chart and insert a new chart with the correct measurements.

Question 20 of 20

Which dialog box allows you to add headers and footers to a document?

A. Save As
B. Page Setup
C. View Options
D. Filter Data