Scribd
Upload
16 views1 page

Excel

The document outlines a practical examination for an Office (Excel) course, focusing on data entry and calculations related to sales. It includes tasks such as entering sales data, calculating sales values, commissions, and grading based on sales performance. The exam is structured to assess proficiency in Excel functions and data analysis within a 45-minute timeframe.

Uploaded by

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

Excel

The document outlines a practical examination for an Office (Excel) course, focusing on data entry and calculations related to sales. It includes tasks such as entering sales data, calculating sales values, commissions, and grading based on sales performance. The exam is structured to assess proficiency in Excel functions and data analysis within a 45-minute timeframe.

Uploaded by

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

`

[Estd. by Govt. of Kerala]


Practical Examination-Aug 2009 OF7
Part I – OFFICE (Excel)
(Time: 45 Minute) Marks: 50

Question 1:
1. Enter following data in Sheet 1 of the Workbook
(1 x 10 marks=10 Marks)
A B C D E F
DETAILS OF SALES
1 ITEM CODE UNITS RATE SALES COMMISSION REMARKS
2 4501 1000 5.50
3 4502 1200 6.75
4 4503 1300 2.00
5 4504 800 4.00
6 4505 1200 5.00
7 4506 1800 0.50
8 4507 145 2.00
9 4508 1900 3.50
10 4509 1550 2.25
11 4510 2000 2.00
12 4511 2200 3.00
13 Commission (%)
14

(10 x 4 marks=40 Marks)


1. Calculate the value of sales (unit x rate) in column D.
2. Calculate the total sales at the bottom of Column D13.
3. In Column D14, calculate highest, lowest & average sale value.
4. Calculate the commission to sales man for each item, depending on the sales
value of each item in column E.

SALES COMMISION
<1000 0
1000 TO 5000 3.2% of sales
5. Based on Above 5000 4.3% of sales sales in Column D,
GRADE is to be shown in the REMARKS column.
Sales Remarks
<1000 POOR
1000 to 5000 GOOD
Above 5000 EXCELLENT

6. Count for grade = EXCELLENT using COUNT IF. Similarly count for grade = GOOD
as well as Grade = POOR.
7. Count the number of items having the rate other than 2.00
8. Sum the commission for grade = EXCELLENT using SUM IF.
9. Count for units greater than 1000.
10. Calculate the total sales of items having units greater than 1000.

You might also like