Scribd
Upload
4 views2 pages

Excel Practical Test

The document outlines a practical Excel assignment with various tasks including data entry, formatting, calculations, and chart creation. Key tasks involve applying styles, calculating totals and averages, using conditional functions for grading, and creating a pie chart. It emphasizes the use of specific Excel functions like COUNTIF, SUMIF, and PRODUCT for data analysis.

Uploaded by

kcec2077
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Excel Practical Test

The document outlines a practical Excel assignment with various tasks including data entry, formatting, calculations, and chart creation. Key tasks involve applying styles, calculating totals and averages, using conditional functions for grading, and creating a pie chart. It emphasizes the use of specific Excel functions like COUNTIF, SUMIF, and PRODUCT for data analysis.

Uploaded by

kcec2077
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Excel practical assigment

Q.1) Follow the given instruction.


1. Type the given data as shown on the right in
Excel.
2. Apply Bold effect on the heading Plain Credit
Payments
3. Fill Yellow color from A3:D3 and align the data
of A3:D3 into center and middle of the cells.
4. Apply borders around the table
5. Insert $ sign in the Cost and Payment Columns

Q.2) find the total number & Average in all subjects in each student.
Q.3) find the Grade using if Function- if Average Greater >15 then "A" Grade otherwise "B"
Grade
Q.3) How many student "A" and "B" Grade (use of countif)
Q.4) Student Ashok and Manoj Total number (use of sumif)
Q.5) How many students (use of counta)
Q.6) How many student English subject number greater than >20 (use of countif)
Q.7) Using product formula calculate Amount = Qty*Rate
Q.8) Calculate grade if Amount is greater than 100000 then Expensive otherwise Cheap
Q.9) How many List in items. ( use of counta)
Q.10) create the following pie chart in excel.

You might also like