MS Excel 2007 Test Answers

 1. What is the option on the Document Inspector that finds the content type information?

Answers: • Document Properties and Personal Information

2. How can a chart be modified?

Answers: • By modifying the display of chart axes

3. State whether true or false:

If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.

Answers: • True

4. How would you select an entire PivotTable report?

Answers: • On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"

5. Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

Answers: • Scoping by value field

6. When does the triangle appear in the top-left corner of the cell, as shown in the picture?

Answers: • When there is an error in the formula

7. How will you display the Go To dialog box?

Answers: • You will press F5

8. Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.

Answers: • B

9. Which tab should be used to display or hide axes?

Answers: • Layout tab

10. When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?

Answers: • It enters the time as AM

MS Excel 2007 Upwork Test Answer 2015

Question: 01

How would you locate the last cell on a worksheet?

a. Click anywhere in the worksheet, and then press CTRL+HOME
b. Click anywhere in the worksheet, and then press CTRL+INSERT
c. Click anywhere in the worksheet, and then press CTRL+END
d. None of the above

Question: 02

How will you display the Go To dialog box?

a. You will press F4
b. You will press F5

c. You will press F6
d. You will press F7

Question: 03
How would you assign a Macro to a graphic?

a. On the Developer tab, in the Controls group, select Macro name
b. On the View tab, click on Macros and then click ‘Assign Macro’ on the shortcut menu. In the Macro name box, click on the macro that you want to assign
c. On a worksheet, right-click on the graphic, then click ‘Assign Macro’” on the shortcut menu. In the Macro name box, click on the macro that you want to assign

d. All of the above