Question 1 Report
TEST OF PRACTICAL KNOWLEDGE QUESTION
Table 1 shows the list of items and the quantity of the items needed by a student. The table was created on an MS Excel worksheet.
Use the table to answer questions 6(a)(i)-(iv)
Table 1
ITEM | QUANTITY |
TEXTBOOK | 12 |
BIRO | 5 |
EXERCISE BOOK | 18 |
PENCIL | 3 |
CALCULATOR | 2 |
ERASER | 2 |
(a)Outline the steps to; (i) create a bar chart on the worksheet such that the items would be labeled on the chart and the percentage of each item included.
(ii) add to the table a new; A. column B. row
(iii) State one function in MS Excel that can be used to determine the item with the highest quantity.
(b) Outline the steps to add page border to a document using Art Design Tool in MS Word application.
(c) An MS Word document contains the phrase "WAEC Exam". Highlight the steps to link the phrase WAEC website (http://www.waec.org.ng).