Excel Practice Assignment No 7
Tags :
Share This :
Excel – Assignment No 6
| Assignment -6 | ||
| Use of Formulas – Counta, Countif, Sumif, Hlookup, Conditional Formatting | ||
| Items | Date | Cost |
| BRAKES | 1/1/2016 | 800.00 |
| TYRES | 12/5/2016 | 2000.00 |
| BRAKES | 18/5/2016 | 500.00 |
| SERVICE | 20/5/2016 | 800.00 |
| SERVICE | 10/2/2016 | 1000.00 |
| WINDOW | 8/5/2016 | 1000.00 |
| TYRES | 10/5/2016 | 1200.00 |
| TYRES | 25/5/2016 | 1500.00 |
| CLUTCH | 10/7/2016 | 1800.00 |
| TYRES | 10/1/2016 | 2000.00 |
| CLUTCH | 15/6/2016 | 1500.00 |
| CLUTCH | 12/1/2016 | 1000.00 |
| WINDOW | 1/1/2016 | 1200.00 |
| WINDOW | 10/5/2016 | 1500.00 |
| WINDOW | 10/5/2016 | 1800.00 |
| BRAKES | 10/5/2016 | 1000.00 |
| BRAKES | 14/8/2016 | 1200.00 |
| TYRES | 15/8/2016 | 1500.00 |
| WINDOW | 20/8/2016 | 1800.00 |
Practice Question
| Q.1 HOW MANY ITEMS ? | formulas |
|---|---|
| Q.2 HOW MANY BRAKE, WINDOW & TYRES HAVE BEEN BOUGHTS? | Use of Counta |
| Q.2 HOW MANY BRAKE, WINDOW & TYRES HAVE BEEN BOUGHTS? | Use of Countif |
| Q.3 HOW MANY ITEMS COST IS >1000 & BELOW > = 1500? | Use of Countif |
| Q.4 HIGHLIGHT TYRES ITESM & 1500 BETWEEN 2000 COST. | Use of Conditional F |
| Q.5 ITEMS COLOUMN IS 15, 18 & 20 ITEMS NAME? | Use of Hlookup |
| Q.6 Total Cost of Window and Brakes Items? | Use of Sumif |
Answer
Watch video to know answer
Have Any Question?
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod
- (+62)81 122 4341
- support@domain.com