Excel Test

Dar es salaam Institute of technology Computer application –Test OD80T evening

02/05/2009

Do all question Time 1 ½ hrs

When you think that you are familiar with each of the buttons answer multiple choice questions below by ticking the correct answer.

A 1

2

B

C

D You have completed the worksheet and want to make certain that you have not made spelling or grammar errors. Which button do you select? Text is highlighted and you want to remove the selection from the active document and place it on the clipboard. Which button do you select?

3

You have made a change to the active document and want to make certain that those changes are saved. Which button do you select?

4

You want to get a quick sum of a column of numbers. Which button do you select?

5

The worksheet had been checked for spelling errors, it has been saved, and now you are ready to print. Which button do you select?

6

A worksheet which has been saved into a folder on your computer is to be opened so changes can be made. Which button do you select?

7

The worksheet had been checked for spelling and has been saved. Before sending it to the printer you want to see how it will look. Which button do you select?

8 To print just part of a sheet, you would select what you want to print and _____ (a) Click the Print button (b) Press the PRINT SCREEN key (c) select Print selection on Page Setup | Sheet and then print (d) select Print selection in the Print dialog and then print

9 .The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _____. (a) (b) (c) (d)

(D4+C2)*B2 D4+C2*B2 =(D4+C2)*B2 =(B2*(D4+C2)

10. Cell A4 =2 and A5 = 4. You select both cells and drag the fill handle down to A8. The contents of cells A6, A7, and A8 are _____. (a) (b) (c) (d)

8,16,32 2,4,2 2,2,2 6,8,10

11 If a cell shows ####### , it means that _____. (a) your formula has a syntax error (b) the row is too short to show the number at the current font size

(c) the column is too narrow to show all the digits of the number (d) either b or c

12.To select a column the easiest method is to _____. a. b. c. d.

double-click any cell in the column drag from the top cell in the column to the last cell in the column click the column heading click the column label

13 .Using the AutoSum button will place in the selected cell _____. (a) (b) (c) (d)

the sum of values in the cell's column nothing until you select a range of cells the sum of the cell's row unless you change the range a formula which will add values in the range Excel guesses you want to add

14. To create a chart with the Chart Wizard, you would use which button?

. (a) (b) © (d)

15. You have drawn a line, and now want to change the color of the selected line.Which button do you select? (a)

(b) © (d)

Section B

16. What is Ms axcel?

(b) From the screen layout above, name all the bars pointed by arrows

17. From the given data below, create

courses students English 34 Biology 32 Calculus 26 Physics 28 History 38

(a) Column chart with (i) Chart title Class size (ii) Category X axis Courses (iii) Category Y axis Number of students (b) Pie chart with

(i) Category names (ii) Values (iii) Percentages