# Excel+Quiz by cuiliqing

VIEWS: 0 PAGES: 4

• pg 1
```									                                                  Quiz

Present graphical solving of system equation x --> [-20; 20] step = 0.02

X3+x2+x+3

2Sinx+2Cosx+30

1- Input initial Table – “Cricket Players” (according to the row’s and column’s number). Fill City
column.

Add new column named “Salary”, and calculate: If Total income >=800, calculate (Total income: 3 –
Total Income*30%), If Total Income < 800, calculate (Total Income: 2.5 + Total Income*25%+PI()) +
log club income else “Salary= “ and Total Income. Find results for each row.

2. Add a new column “Medals”, if total income>800,”Gold”, if total income is<700,”Bronze” else
“Silver”.

3. Add a new column “Efficiency”, if fitness>=90,"Excellent”, if fitness<80,”Normal”, else”Good”.

4. Add a new column”Training”, if fitness>=90,”only for fitness”, if fitness<80,”need training”, else
“little bit”.

5. Calculate Total, Average, Count, CountA, CountBlank, Max, Min, for Total Income, Weight, Height,
Age; Product for Total Income.

6. Add Sum If row, and calculate sum of Age, Weight, Height, and Total Income for Country Pakistan.
Place result in Table1.

7. Find the value of club Income for South Africa in Cape Town, if Average of Profit is increased by 20.
Place result in Table2.

8. Custom sort list by two keys: Age, Height and Weight.

Place result in Table3.

9. Make AutoFilter operation for column Country with simple selection of value=Australia, India,
West Indies and Total income=800.
Place result in Table4.
10. Make custom AutoFilter operation for Total income with selection of values between 600 and 800.
Place result in Table5.

7. Make Advanced Filter operation with criteria: (Country=South Africa) or (total income=<800).
Place result in Table6.

8. Make Subtotal operation for Total Income index at each change in City.
Place result in Table7.

9. Draw Surface chart for function: z=4-x2-y2, (x=y= [1, 10], step=0.2). Keep all tables and charts in the
same (Result) sheet and print.

Cricket Players

Club       Country
Country     City      Club      Age   Height   Weight   Position   income(m   income(mill   Total
illion)    ion)          Income   Fitness
All                                \$
Australia            hanns      33     180      78
rounder    \$ 500.00   \$ 300.00      800.00        92
All                                \$
Australia            hanns      32     176      70
rounder    \$ 450.00   \$ 320.00      770.00        87
\$
Bangladesh            dhaki      38     169      82      Bowler
\$ 370.00   \$ 230.00      600.00        66
\$
England            manchester   34     180      75      Bowler
\$ 460.00   \$ 280.00      740.00        83
\$
England             londish     35     181      78      Bowler
\$ 550.00   \$ 290.00      840.00        96
\$
India              knights     35     179      76      Batsman
\$ 520.00   \$ 290.00      810.00        91
\$
India             mumbaians    37     175      88      Batsman
\$ 480.00   \$ 270.00      750.00        82
\$
India               dehlis     43     175      84      Batsman
\$ 510.00   \$ 290.00      800.00        97
New                                                      All                                \$
planks     37     185      77
Zealand                                                 rounder    \$ 470.00   \$ 280.00      750.00        83
New                                                      All                                \$
planks     40     184      83
Zealand                                                 rounder    \$ 450.00   \$ 270.00      720.00        76
\$
Pakistan           peshawari    38     179      76      Bowler
\$ 480.00   \$ 280.00      760.00        85
All                                \$
Pakistan           peshawari    40     179      80
rounder    \$ 600.00   \$ 280.00      880.00        95
\$
Pakistan            sahiwali    40     180      78      Bowler
\$ 540.00   \$ 280.00      820.00        90
South               opera      37     180      82      Batsman    \$ 550.00   \$ 300.00       \$            98
Africa                                                                     850.00
South                                                                      \$
pkank      39   181    86    Batsman
Africa                                               \$ 480.00   \$ 290.00   770.00   86
All                            \$
West indies   los flash   40   186    88
rounder    \$ 540.00   \$ 260.00   800.00   85
\$
West indies   los angle   36   177    74    Batsman
\$ 400.00   \$ 250.00   650.00   69

Cricket Players

```
To top