Scribd
Upload
3 views1 page

HTC ICT Hub Excel Practical Test Guide

The document outlines a practical test for creating and manipulating a spreadsheet for Zintech Company Limited's orientation meeting budget. It includes instructions for entering data, performing calculations, using logical functions, copying sheets, renaming them, and creating a bar chart. The test emphasizes spreadsheet skills such as data entry, formula application, and chart creation.

Uploaded by

htcicthub
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
3 views1 page

HTC ICT Hub Excel Practical Test Guide

The document outlines a practical test for creating and manipulating a spreadsheet for Zintech Company Limited's orientation meeting budget. It includes instructions for entering data, performing calculations, using logical functions, copying sheets, renaming them, and creating a bar chart. The test emphasizes spreadsheet skills such as data entry, formula application, and chart creation.

Uploaded by

htcicthub
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

HTC ICT HUB EXCEL PRACTICAL TEST

Figure one shows an extract of a spread sheet showing details of items used by Zintech Company
Limited. Use it to answer the questions that follow

A) Open a spread sheet program and key in the information in figure one as it appears save the work
book as Orientation Budget in your Name Folder.

A B C D E F
1 Item Time needed Quantity (KG) Price Total price REMARKS
2 Beef Lunch 5 400
3 Rice Lunch 6 130
4 Water Lunch 24 20
5 Fruits Lunch 24 10
6 Potatoes Lunch 6 120
7 Onions Lunch 2 60
8 Snacks Tea Break 10 20
9 Milk Tea Break 7 50
10 Tea Leaves Tea Break 2 20
11 Sugar Tea Break 4 100
12

(B) (i) Insert a row above row one and merge it across cell A1 to F1.

(ii) Type the following text in row one “ZINTECH ORIENTATION MEETING BUDGET”

(C) (i)Using the cell reference only, determine the total sale for beef

(ii)Compute the total price for each of other items

(iii)In cell B12 determine the number of times was needed for Lunch

(D) (i)Using a logical function compute the remarks based on the following criteria

Total Price Remarks


Greater Expensive
Below 1500 Ok

(E) (i) Copy the content of sheet1 to sheet2

(ii) Rename sheet1 and sheet2 to as budget and chart respectively

(F) Create an embedded bar chart in the sheet named chart showing the sub totals of the items in
the budget. The chart should have the following properties:

(i) Chart title: Budget totals

(ii) Legend shows at the bottom

You might also like