Scribd
Upload
733 views1 page

1navabharat 9605700700

1) The document provides a sales data table with item codes, units, rates, and sales to calculate various metrics. 2) Key metrics to calculate include total sales, highest/lowest sales, average sales, count of rates over 1000, and total sales of rates over 1000. 3) Commission for each item is to be calculated based on a provided commission table that assigns different commission percentages based on sales value.

Uploaded by

aneez
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
733 views1 page

1navabharat 9605700700

1) The document provides a sales data table with item codes, units, rates, and sales to calculate various metrics. 2) Key metrics to calculate include total sales, highest/lowest sales, average sales, count of rates over 1000, and total sales of rates over 1000. 3) Commission for each item is to be calculated based on a provided commission table that assigns different commission percentages based on sales value.

Uploaded by

aneez
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

KERALA STATE RUTRONIX

Practical Examination - Nov 2015


OE2
Part I – Office - Excel
Time: 45 Minute Marks: 50

1. Enter following data in sheet 1 of the workbook

A B C D E
1 ITEM
CODE UNITS RATE SALES COMMISSION
2 100 10 100
3 101 12 250
4 102 13 235
5 103 8 485
6 104 12 50
7 105 18 400
8 106 14 200
9 107 15 350
10 108 19 250
11 109 20 250
12 110 22 350
13
14
15 TOTAL SALES
16 HIGHEST SALES
17 LOWEST SALES
18 AVERAGE SALES
19 COUNT OF RATE>1000
20 TOTAL SALES OF RATE
>1000
21

Calculate by entering proper equations/functions in the respective cells,


1. The value of sales (units * rate) in column D.
2. Total sales in cell D13.
3. Highest, lowest and average sale value, in D16, D17 and D18 respectively.
4. Count for rates greater than 1000 in column D19
5. Calculate the total sales of items having rates >1000.
6. The commission to salesmen for each item, depending on the sales value of each
item as given in the commission table below.
Commission table

SALES COMMISSION
Less than Rs.1000 0
Rs.1000 to Rs.5000 2% of sales value
above Rs.5000 5% of sales value

You might also like