Scribd
Upload
465 views3 pages

Excel Practical Exam Instructions

The document provides instructions for completing a worksheet in Microsoft Excel and modifying a diagram in Microsoft Word. For the Excel worksheet, the instructions are to: enter student data, format cell fonts, enter formulas to calculate total marks, insert a minimum function, sort data, and add a heading. For the Word document, the instructions are to: add a footer, change to landscape, draw and modify a diagram with shapes, format outlines, fill colors, and add centered text.

Uploaded by

Gift Mumba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
465 views3 pages

Excel Practical Exam Instructions

The document provides instructions for completing a worksheet in Microsoft Excel and modifying a diagram in Microsoft Word. For the Excel worksheet, the instructions are to: enter student data, format cell fonts, enter formulas to calculate total marks, insert a minimum function, sort data, and add a heading. For the Word document, the instructions are to: add a footer, change to landscape, draw and modify a diagram with shapes, format outlines, fill colors, and add centered text.

Uploaded by

Gift Mumba
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

You are required to use Ms Excel Spreadsheet program for this question

a)Type your name,examination number and school/centre name in the header [1]

b)Create the worksheet below

A B C D
1
2
3
4
5
6
7 Minimum
TOTAL MARKS
8

(i)Complete the worksheet by entering the following data

- Catherine J,Test 1:71,end of the end test 53,

-Gift M Test 1:69,End of the term test 68,

-Jemes K Test 1:83,End of the term test 69,

-Telepe H Test 1:41,End of the term test 56, [4]

(ii)Change the font of the labels in the cell range A1: D5 to Times New roman [1]

(iii)Type the formula in D2 calculates the total marks scored .


[2]

(iii)Reproduce the formula in cell D2 through the cell D5. [1]

(iV)Insert the function in cell C7 to calculate the minimum TOTAL MARKS. [2]

(V)Delete row 6 [1]

(Vi)Sort the data in the in column A in descendi order [1]

(Vii)Insert a row above row 1 and type the following heading “COMPUTER STUDIES RESULTS” in
cell B1 [2]

1
You are required to use a required to use a word processing program for this question

(a) Open a new document and type your name,examination number school/centre name in
the footer [1]

1
g
Fi
(b) Type Change page layout to landscape [1]
(c) Use the appropriate shapes to draw the following diagram below [2]

Fig 2

Fig 3

Fig 4

i) Fill the Figure 2 with grey color [1]


ii) Insert smaller shape in figure 1,figure2 and figure3 to represents doors [2]
iii) Format the outline of the triangles in the diagram above to line width of 4pts [1]
iv) Format the outline of triangle to line style ‘’double’’. [3]
v) Fill blue colour to shapes representing doors in figure 1 and figure 2 [2]
vi) Type “WELCOME TO MY DREAM HOUSE” in the shape labelled 4 and align
centre [2]
Print the document

2
3

You might also like