Scribd
Upload
381 views2 pages

Computer Studies Practical

This document contains instructions for two questions on a mid-term computer studies practical exam. Question 1 involves using Microsoft Excel to perform various formatting and formula tasks on a spreadsheet. These include changing page layout, entering header information, typing data, identifying the active cell, adding a title and formulas, replicating a formula, changing font attributes, deleting a column, and entering a formula to calculate totals. Question 2 involves using Microsoft Word to enter header information, type formatted text on computer system elements, capitalize and change font sizes for headings, make words bold and capitalized, underline headings, and save to a folder.

Uploaded by

Mark
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
381 views2 pages

Computer Studies Practical

This document contains instructions for two questions on a mid-term computer studies practical exam. Question 1 involves using Microsoft Excel to perform various formatting and formula tasks on a spreadsheet. These include changing page layout, entering header information, typing data, identifying the active cell, adding a title and formulas, replicating a formula, changing font attributes, deleting a column, and entering a formula to calculate totals. Question 2 involves using Microsoft Word to enter header information, type formatted text on computer system elements, capitalize and change font sizes for headings, make words bold and capitalized, underline headings, and save to a folder.

Uploaded by

Mark
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/ 2

ARISE CHRISTIAN SCHOOL

MID-TERM
COMPUTER STUDIES PRACTICAL
40MARKS
QUESTION 1

You are required to use Microsoft excel spreadsheet program for this question.

a) Open a new worksheet and change the page layout to landscape. [1]
b) Type your name, examination number and school name in the header. [2]
c) Type the data as shown in the worksheet below. [4]

i. Identify the active cell and change it to 10. [1]


ii. Type the title “COMPUTER EQUIPMENTS” in cell A1 and merge and center through cell
H1. [2]
iii. Type the formula in cell H3 to calculate the average number of printers over six
months. [2]
iv. Replicate the formula from H3 through H7. [2]
v. Change the font attributes of the title to forte 15 bold. [1]
vi. Delete column F. [1]
vii. In cell B9 type the formula used to calculate the total number of items purchased in JAN
up to JUNE. [2]
viii. Show formula and save. [1]
QUESTION 2

You are required to use Microsoft word for this question

a) Open a blank word processing document and type in your name, examination number and
school name in the header. [2]
b) Type in the text below in an arranged manner with a font size of 12pts and font face Times new
roman. [10]

Basic elements of a computer system


1. Input – this is the producing of results after processing it.
2. Process – this is the entering of data into a computer system.
3. Storage – this is the transformation of data into information.
4. Output – this is the location in the computer system where data is kept.

i. Capitalize and change the font size for the main title to 20pts and font face to Algerian.
[2]
ii. Make bold and capitalize the words input, output, processing and storage with a font
size of 16. [3]
iii. Underline the title of the document including the words input, output, processing and
storage. [2]
iv. Create a folder with your name on the desktop and save. [2]

You might also like