Scribd
Upload
98 views3 pages

Excel & PowerPoint Task Guide

The document provides instructions for completing an Excel worksheet and PowerPoint presentation. For the Excel worksheet, it instructs the user to: change the page layout to landscape; add identifying information to the header; type data into cells; add formulas to calculate totals, spending amounts, and averages; create a pie chart; and print the worksheet. For the PowerPoint presentation, it instructs the user to: add title and subtitle placeholders; add identifying information; duplicate the slide; add centered and formatted headings on slide 1; create a table listing computer services; and create a clustered column chart displaying monthly costs of services.

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
98 views3 pages

Excel & PowerPoint Task Guide

The document provides instructions for completing an Excel worksheet and PowerPoint presentation. For the Excel worksheet, it instructs the user to: change the page layout to landscape; add identifying information to the header; type data into cells; add formulas to calculate totals, spending amounts, and averages; create a pie chart; and print the worksheet. For the PowerPoint presentation, it instructs the user to: add title and subtitle placeholders; add identifying information; duplicate the slide; add centered and formatted headings on slide 1; create a table listing computer services; and create a clustered column chart displaying monthly costs of services.

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)Open a new worksheet and change the page layout to landscape [1]

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

c)Type the data as shown in the worksheet below [4]

A B C D E F G H
1 Units Price Purchases Transport Amount Surplus AVERAGE
Spent
2 Item
3 Printer 2 50 10
4 Modem 1 200
5 Router 1 60
6 Scanner 1 40
7 Speaker 2 30
Total
9 Budget 1000

10

(i) Type the formula in cell D2 to calculate purchases from D3 through D7. [1]
(ii) Type the formula in cell F2 to calculate Amount spent from F2 through F7 [1]
(iii) Change the font attributes of the title to italics [1]
(iv) Type the formula in cell G2 to calculate amount spent from G2 through G7 [2]
(v) Type the formula in cell F2
[1]
(vi) Delete column F2. [1]
(vii) In cell B2 type the function to find the total [2]
(viii) Using column A to H only,create an exploded pie chart,add category name and percentage
attributes to the pie chart. [3]
(ix) Click on show [1]
Print the worksheet

1
You are required to use Ms Powerpoint presentation program for this question.

(a) Open a new blank slide the title and subtitle place holders [1]
(b) Type your name,examination number and school/centre name in the [1]
(c) Duplicate the slide [1]
(d) On slide 1,Type the heading ‘’COMPUTER CONSULTANT LTD’’ and centre align [1]
(e) Change the font size of heading 48 pts and apply the shadow attribute [2]
(f) Type the subheading ‘’DEALS IN COMPUTER REPAIR AND SOFTWARE
INSTALLATION’’ [1]
(g) Centre-align the subheading and change the font size to 36 pts [1]
(h) Under the subheading,create the table [2]

 Hardware Installation  Settling up a network


 Backing up files  Hardware maintenance
 Software installation  Settling up internet
 Virus Scanning  Data Recovery

(i) Format the table to light style 3


(j) On graph 2 use the data in the below to create a clustered column

Service provided Monthly costs(ZMW)


Hardware Installation 700

Backing up files 200

Software installation 600

Virus Scanning 350


Data Recovery 400

Settling up internet 650

Network setup 850

2
3

You might also like