Data Processing 2020 Waec Past Questions and Answers

Question 41 :

• WAEC 2020

(a) What is a function in MS Excel?
(b) List two categories of functions in MS Excel.
(c) What is the cell referencing in MS Excel.
(d)(i) State two types of cell referencing in MS Excel.
(ii) Give one example of each type in 1(d)(i)

Question 42 :

• WAEC 2020

Ciroma Chukwuma Adekunle has just opened a computer business centre within a school environment.
(a) State three computer services that may be provided in the business center
(b) List three devices required in the business centre
(c) Give two applications software needed in the business centre.
(d) Outline two precautions that must be taken by Ciroma Chukwuma Adekunle to ensure the safety of this computer if he accepts documents in movable devices from his customers.

Question 43 :

• WAEC 2020

(a) State the keyboard shortcut keys to;
(i) rotate an object in CorelDraw
(ii) position an object in CorelDraw
(iii) navigate to cell A1 in MS Excel worksheet
(b) Give one reason for including the plus sign (+) in the search text in a search engine.
(c) With the aid of diagrams, differentiate between LAN and WAN.

Question 44 :

• WAEC 2020

A school decides to harmonize the operation of its two campuses using a distributed database system as well as install air conditioners and uninterrupted power supply in the computer laboratory.
(a) State three (i) Importance of using distributed database (ii) disadvantages of using computer processing information in the school
(b) Give two reasons for installing the; (i) air conditioners (ii) uninterrupted power supply devices

Question 45 :

• WAEC 2020

A Director gave a manuscript to the secretary for typesetting. The secretary is expected to provide the total number of words, lines of text, number of pages and number of paragraphs contained in the documents. After proofreading the printout, the Director effected certain corrections on the printout and instructed that the corrected version be saved with the filename "initial".
(a) Outline the steps the secretary would take to display the numbers of words, lines of text, number of pages and number of paragraphs contained in the corrected version of the document.
(b) Highlight the steps the secretary would take to display the original and corrected versions of the screen for the Director to see at the same for comparison.
(c) List the three steps to secure the document with password in order to prevent unauthorized access to the document.