Waec 2020/2021 Data Processing Question and Answers Now Available

WAEC 2020/2021 DATA PROCESSING QUESTION AND ANSWERS NOW AVAILABLE

DATA PROCESSING
01-10: BCBDDDBBAA
11-20: AADDBBCDCB
21-30: DCDABCADDD
31-40: CCDADCACAA

 

=======================================

Theory

INSTRUCTION: Answer 4 Questions in all

 

(1a)

A function is a predefine formula that perform calculates using specific value in orderly manner

 

(1b)

(i)Date and time

(ii)Statistics and test

 

(1c)

It the value of a different cell on the current worksheet

 

(1di)

(i)Relative

(ii)Absolute

 

(1dii)

(i)Relative. =G2×H2

(ii)Absolute =$A$2

 

=======================================

 

(2a)

(i)Typing

(ii)Laminating

(iii)Photocopying

 

(2b)

Printer

Photocopy machine

Computer system

 

(2c)

(i)Ms Excel

(ii)Ms word

 

(2d)

(i) Anti virus software

(ii) System Dependency

 

=======================================

 

(3ai)

Press Ctrl + , (comma) while nothing is selected (i.e select Pick tool and click on blank place and then press CTRL+, and then you have permanetly set up default angle to “0”).

 

(3aii)

Align Right: R.

Align Left: L.

Align Center Vertically: C.

Align Center Horizontally: E.

 

(3aiii)

Hold down the Ctrl + Home keys together as following screenshot shown, the cursor will be jump to the cell A1 from anywhere of the worksheet.

 

(3b)

It tell Google or any search engine to find the exact format.

 

=======================================

 

 

(4ai)

(i) Lower Communication Cost

(ii) More Reliable

(iii) Better Response

 

(4aii)

(i) Need for complex and expensive software

(ii) Overheads for improper data distribution

(iii) Data integrity

 

 

4bi)

=Health Issues

=Heat exhaustion due to =heavy sweating.

=Low blood pressure.

=Dehydration due to constant perspiration.

=Fatigue and muscle cramps.

=Nauseating and fainting

 

 

4bii)

=There are many causes of power failures in an electricity network. Examples of these causes include faults at power stations, damage to electric transmission lines, substations or other parts of the distribution system, a short circuit

 

= cascading failure, fuse or circuit breaker operation.

 

=======================================

(4ai)

(i) Lower Communication Cost

(ii) More Reliable

(iii) Better Response

 

(4aii)

(i) Need for complex and expensive software

(ii) Overheads for improper data distribution

(iii) Data integrity

 

 

4bi)

=Health Issues

=Heat exhaustion due to =heavy sweating.

=Low blood pressure.

=Dehydration due to constant perspiration.

=Fatigue and muscle cramps.

=Nauseating and fainting

 

 

4bii)

=There are many causes of power failures in an electricity network. Examples of these causes include faults at power stations, damage to electric transmission lines, substations or other parts of the distribution system, a short circuit

 

= cascading failure, fuse or circuit breaker operation.

 

 

4c)

=pen the Word (Excel or PowerPoint) document.

=Click on File.

=Click on Info.

=On the right side, click the Protect document menu.

 

=Note: In Excel, the option will appear as “Protect Workbook,” and in PowerPoint, it’ll be displayed as “Protect presentation.”

 

=Select the Encrypt with Password option.

 

=Type a password to protect the document.

 

=Click the OK button.

=Retype the password.

 

 

=Click the OK button.

Once you complete these steps, every time you open the document, you’ll be prompted to enter a password to decrypt its contents.

(5a)

The steps the secretary would take to displace the number for f words

– He would go to menu bar

– Click on reference

– Then click on view menu

– Then click on document summary

– This would display number of words lines of text number of pages and number of paragraphs

 

(5b)

– The secretary will open the two documents

– The secretary will click on the menu bar

– The point to view with the mouse pointer

– Then click on cascade the windows

– The two windows will display simultaneously

 

(5c)

– Go to menu bar

– Click on file menu

– Click on document directory

– The right click on the file that has the document you want to protect

– Then click on password protection

(6a)

=Start by opening a “Blank presentation” in PowerPoint.

 

=Select the “Title Slide” option.

 

=Type in your title and subtitle.

 

=Select a background for the entire presentation.

 

=Add new slides.

 

=Set the transitions for your slides.

 

=Add some more pizzazz to your presentation with animation.

 

(6b)

(A) TODAYS DATE

In PowerPoint you can add or remove automatic slide numbers, hide numbering on the title slide, and move slide numbers. You can also add the date and time to slides.

 

(B) SLIDE NUMBER

=On the Insert tab, select Slide Number.

 

=shows the slide number button on the ribbon in powerpoint

 

=On the Slide tab, check the Slide number box.

 

=Show header and footer dialog in powerpoint

 

If you don’t want a number to appear on the title slide, also check the Don’t show on title slide box.

 

= Select Apply to All.

 

=The theme applied to your presentation has a standard location for where the numbers appear on your slides, as illustrated by the two themes picture below. To change that location, see “Change where the page numbers appear on your slides” below.

 

(C) YOUR SURNAME

=Click Header & Footer in the Text group.

 

=In the resulting dialog, click the Footer option and click Apply To All. You can add the footer to individual slides or a group of slides, rather than all-it just depends on your needs.



(Visited 336 times, 1 visits today)
Share this post to your friends & love ones

Be the first to comment

Leave a Reply

Your email address will not be published.


*