Microsoft Office Packages : Practice Questions

MICROSOFT OFFICE
PRACTICE QUESTIONS




, MICROSOFT OFFICE PRACTICE QUESTIONS


TABLE OF CONTENTS



SPREADSHEETS ................................. 1



WORD PROCESSING ........................ 51



DATABASES ...................................... 84



POWERPOINT .................................. 106




i

,MICROSOFT OFFICE PRACTICE QUESTIONS
BLANK PAGE




ii

, MICROSOFT OFFICE PRACTICE QUESTIONS

SPREADSHEETS

QUESTION
a) Create a spreadsheet with the following entries:
 B2 = CHICKEN INN  B4 = QUANTITY
 A4 = FOOD ITEM  B5 = 3
 A5 = PORTION CHIPS  B6 = 1
 A6 = SADZA & STEW  B7 = 1
 A7 = RICE & CHICKEN  B8 = 2
 A8 = HAMBURGER  B9 = 3
 A9 = SOFT DRINKS  C4 = UNIT COST
 C10 = SUB TOTAL  C5 = $135.00
 C11 = SUB TAX @ 15%  C6 = $180.00
 C12 = TOTAL COST  C7 = $200.00
 C8 = $170.50
 C9 = $65.00
 D4 = COST

AND PERFORM THE FOLLOWING:

i. Make B2 bold, underlined and size 16.
ii. Make all headings, i.e. A4 – D4, bold.
iii. Put borders on all entries of the sheet.
iv. Save document as Qn2data and print it. (10 marks)

b) Input the formulae for the cost price of each item D5 – D9(5 marks)

c) Input the formulae for the calculated amounts for subtotals, sales tax and total cost in D10 – D12
respectively. (3 marks)

d) Create the Pie Graph for the Food Item and Quantity Columns. The pie chart should have an
appropriate title, legend, and each portion should show the percentage occupied by each item. (6
marks)

e) Save the document as Qn2chicken and print it.(1 mark)

f) Show formulas you have used in a new sheet and save it as formulas. (5 marks)


All your field names or cells must fit on one page otherwise marks will be deducted. Use your print preview regularly.




1