EXCEL IF FUNCTION

check this link for the conditional IF function

https://www.youtube.com/watch?v=yTY60PVZaRg

DATA P[ROCESSING ACTIVITY

DATA P[ROCESSING ACTIVITY
NOTE:send answers as comment on the blog.Thanks.

(a) List: (i) Three application areas of a word  processing program
(ii)  Three  types of data item.

(b) Identify the four data types available in Table 2 below

Table 2
Student I.D.       Name          Date of Birth      Score in Computer studies           Gender
A 00022            Odi, G.A.        13/10/97                   38                                            M
C 00021          Zakari, M.         15/05/98                  71                                            M
B 00023      Ngozi Tella          16/09/96                     62                                           F

AP[P[LICATION P[ACKAGE....

Ndibaba corporation...ICT facilitator and sup[p[ort.

Open Excel to a blank worksheet.

Create a spreadsheet like the one below. Enter all the numbers.

o   Change the formatting of the numbers to dollars.

o   Make the grid around the cells visible.

o   Insert the title “Monthly Budget” and center and merge it.

§  Change the font to Baker Signet, size 18.

§  Make the text white and the fill black.

o   Insert the subtitle “January 2005 – June 2005.”

§  Change the font to Baker Signet, size 10

§  Make text white and fill black.

§  Center and merge it.

o   Total the expenses at the bottom of each month.

§  Widen columns if necessary so numbers can be seen.

o   Put a dark border around the edges of the document.

o   Change the amount for gasoline in June from $60 to $70.

o   Figure out the average for each row. You must know the formula on your own!

o   Center and bold the headings (months and average)

§  Change the font to BakerSignet on the headings

§  Bold the headings in column A.

§  Change the font to BakerSignet.

o   Add a header with your name.

  

NOTE:change the font to available one if you can not find the required font as instructed.

seasons GrEEtInGs..

APPLICATION PACKAGE PRACTICAL

Q1)

 In a new worksheet, create a table and insert the following information. Use different fonts for different columns.

1. Names of people (at least 20)

2. Their ages

3. Number of years they have worked

4. Salary per month

5. Show housing, medical, travel and hardship allowances, and columns


B. Using the table to do the following:

1. (a) Calculate the total salary for each person and grand total for all persons.
(b) Calculate Average, Minimum, Maximum.

2. Show a graph of the their salaries

3. Copy and paste your graph from sheet 1 to sheet 2, name your graph sheet ‘CHARTS’

4. Add columns where necessary to include: leave payment, over time payment and sick off amount, and then calculate the net salary

APPLICATION PACKAGE PRACTICAL REVIEW

ACTIVITY

A spreadsheet is require to predict cash flow for a company over the four quarters of a year. Open a blank spreadsheet, enter in the data below and save it as IBIM ACTIVITY 

Month	Jan-Mar	Apr-Jun	Jul-Sep	Oct-Dec
Opening Bank Balance:	€20000
Expenditures
Wages:	€2340	€2340	€2340	€2340
Electricity:	€760	€860	€960	€1060
Overheads:	€1080	€1280	€1480	€1680
Materials:	€6000	€6500	€7000	€7500
Total (expenditures)
Sales Income:	€13290	€13290	€13290	€13290
Profit this quarter
Closing bank balance:

1. Enter in formulae to calculate 'Total (expenditures) for each quarter. (The sum of all the individual expenditures)
2. Enter in formulae to calculate the 'Profit' for each quarter. (Sales income less Total expenditures)
3. Enter in formula to calculate the closing balance for each quarter (The Opening balance plus the profits)
4. Enter in formulae for the 'Opening balance' for each quarter after the first one (=the closing balance of the previous quarter)

QUESTIONS PREVIEW

Q1) Calculation the following table using appropriate application package

SN	Month	Income	Expenses	Saving
1	January	12000	8000
2	February	18000	12000
3	March	15000	23000
4	April	14000	11000
Total

 Calculate Saving as Income - Expense using Table Formula.

 Calculate Total Income, Expense and Saving.

Q2  Sort  out the following  into :manual input devices,direct input devices,and sensors

                Keyboard,scanner,MICR,OCR,light sensor,remote control,barcode reader,camera,temperature sensor,magnetic stripe reader

MS WORD ACTIVITIES[[[]

MS WORD ACTIVITIES

Q.No.1 

Types of Computers

There are different types of computer systems nowadays for different purpose according to the user needs. However we can classify them into different groups based on different aspects:

Based on Size

We can find four different type of computers based on size.

Super Computers

These are large computers that are most powerful. They can complete tasks very soon and are optimized to complete given tasks quickly.

Mainframe Computers

These are the largest computers and can support hundreds of users simultaneously. These are powerful computers and optimized to run maximum number of applications at one time.

Mini Computers

These are medium sized computers –smaller than mainframe but much larger than personal computers. They can be the best solution for medium scale organizations.

Micro Computers

Micro computers are the smallest when size is concerned. They range from Desktop, Laptop up to the palm top and even smaller ones. Because micro computers are developed to support single person, they are often called personal computers (PCs).

a.) Copy the text above. Make the text italic, text font size 15, line spacing 2, insert page number at left bottom of page, insert drop cap.

b) Insert "Computer Operator Exam 2070" as footer, header, and watermark.

c) Insert following equation.

d) Perform following task.

i) H₂O, CO₂, MNO₂

ii) Zn + H₂SO₄ Ò ZNSO₄ + H₂#

iii) NaOH + HNO₃ Ò NaNO₃ + H₂O

Q.No.2

i.                    Create following Table

Day /	Period I	Period II	Period IV	Period V
Sunday	Math	Science	English	Computer
Monday	Science	Computer	Math	English
Tuesday	English	Math	Computer	Science
Wednesday	Computer	Science	Math	English
Friday	Math	Science	English	Computer

       1.      Create margin at the top & bottom 1.1 inch and right & left 1.5 inch

       2.      Create landscape orientation & A4 paper size 

       3.      Insert Period III column after Period II

       4.      Insert Thursday row bellow Wednesday row

       5.      Insert page number center align and arial font

       6.      Insert watermark "Hello  world"

       7.      Table font times new roman and 13 size