Earlyface

[9/11, 9:52 AM] Micheal A: *DATA PROCESSING*


NO 1) Excel functions includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
[9/11, 9:52 AM] Micheal A: (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. =A1+B1
(ii)Absolute
[9/11, 9:52 AM] Micheal A: 1.A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

1b Compatibility,
Cube, Database, Date and Time, Engineering, Financial, Information, Logical (pick any two)
 1c A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.


(1di)
(i)Relative
(ii)Absolute

(1dii)
(i)Relative. =A1+B1
(ii)Absolute
[9/11, 9:58 AM] Micheal A: (2a)
(i)Typing
(ii)Laminating
(iii)Photocopying

(2b)
Printer
Photocopy machine
Computer system

(2c)
(i)Ms Excel
(ii)Ms word

(2d)
=====================================

(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. =A1+B1
(ii)Absolute
[9/11, 9:58 AM] Micheal A: *DATA PROCESSING*

NO 1) Excel functions includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
=================================
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").
[9/11, 9:58 AM] Micheal A: 1.A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.

1b Compatibility,
Cube, Database, Date and Time, Engineering, Financial, Information, Logical (pick any two)
 1c A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.


(1di)
(i)Relative
(ii)Absolute

(1dii)
(i)Relative. =A1+B1
(ii)Absolute

2a data storage
   Network utility

2b multifunctional printer
  Computer network

2c Msword
    Excel
[9/11, 10:02 AM] Micheal A: (1a)
A function in MS Excel is a predefined formula that performs calculations using specific values in a particular order.

(1b)
(i) Compatibility
(ii) Database

(1c)
A cell referencing in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.

(1di)
(i) Relative reference
(ii) Absolute reference

(1dii)
(i) Relative: =G2*H2
(ii) Absolute:  =$A$2
[9/11, 10:06 AM] Micheal A: 2020 Waec Data Processing Answers
=======================================
Obj:
Loading...
=======================================
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. =A1+B1
(ii)Absolute

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

(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 

=======================================
*DATA PROCESSING*
=================================
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)
[9/11, 10:16 AM] Micheal A: 4ai Easy to access
      Easy to retrieve
      Efficient maintenance


4aii Financial Difficulties
       Spelling and Hand writing skill
       Technical problems

(5a)
He would follow these steps:
-Open the "updated" document MS Excel
-Go to Menu bar
-Click on reference
-Click on view menu
-Click on the document summary. It will display number of words, lines of text, number of pages and number of paragraphs

(5b)
He would follow these steps:
-Open the two documents
-Click on the menu bar
-Then point to view with the mouse pointer
-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 protect
-Type a password to protect the document