[go: up one dir, main page]
Scribd
Upload
69 views5 pages

Excel Test

1. The document contains 10 questions to be answered in 20 minutes regarding sales, expenses, calculations of student enrollment, tuition fees, and inventory. 2. The questions require using formulas and cell references to calculate outstanding amounts, sort price lists, calculate growth rates, averages, prices after discounts and markups, invoice totals, and a formula for closing inventory. 3. The questions reference customers, centers, price lists, components, costs, quantities, openings stocks, purchases and sales to perform the necessary calculations.

Uploaded by

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

Excel Test

1. The document contains 10 questions to be answered in 20 minutes regarding sales, expenses, calculations of student enrollment, tuition fees, and inventory. 2. The questions require using formulas and cell references to calculate outstanding amounts, sort price lists, calculate growth rates, averages, prices after discounts and markups, invoice totals, and a formula for closing inventory. 3. The questions reference customers, centers, price lists, components, costs, quantities, openings stocks, purchases and sales to perform the necessary calculations.

Uploaded by

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

Please answer the below mentioned 10 questions

Answer the questions in a separate sheet


Duration : 20 mins

Note : Only formulas and cell references to be used

Insert Comment in the below cell C8 with text "Discounted kits


1
sold at 775/-"

2 Calculate the outstanding of Customer C for the month - where ,

Invoice value 4500


Stock return value 675
Cheque amount received 150

Outstanding for the month ?

Sort the price list in ascending order based on rate of each item
3

A new centre in Mumbai has ended December with 48 students


4 . The students during the Jan - March is as given below: 48

January end 10%

February 8%

March 15%
Calculate the total students as on date and the % growth rate till
now for the centre.

5 Chennai Centre's net students as at Q2 end 100


New students added during Q3 42
Total students end of Q3 112
Please find the dropped out students and the centre's drop out
ratio
6 Begumpet centre's Monthly Tuition fee 1200
Ameerpet centre's Monthly Tuition fee 850
Bowenpally centre's Monthly Tuition fee 690
What is the average Tuition fee charged in Hyderabad?

Price charged for the MiKids program at Bhavans in 2017-18 (per


7 student) 175
% increase for the academic year 2018-19 15%
What is the new price?

The discount offered by the Marketing team on the increased fee 10


Price post discount

8 Calculate the Sales price of the Registration kit :


Registration kit components
Cost of Item A 80
Cost of item B 120
Cost of item C 35
Packaging / Transport cost per unit 50
Marketing cost per unit 175
Company want to keep 15% profit margin
The Sales price would be

Find the value of each item and the Total Invoice value for
9
Customer A referring pricelist
Item list Quantity
Amal A book 10
Amal bag New 9
Amal Abacus 5
Fnd Reg Kit 12
Adv Level 1 Kit 7
Bag 15
Abacus 25
Tshirt 10
Abacus Pouch 5
Grand Total Value ?

Derive formula for closing stock of one particular item "Bag"


where "X" is the opening stock , "y" is the purchased stock and
10 "Z"is the stock sold?

Total
pricelist
Correct -
Marks Y/N Score Item list
Tshirt
Teaching
Abacus
1
Fnd Reg Kit
Fnd Level 4 Kit
Fnd Level 3 Kit
2
Fnd Level 2 Kit
Ci bag new
Bag
Amal Tshirt new

Amal C Book
New
Amal bag New
2
Amal B book
New
Amal Abacus
Amal A book
New
total students 5
Adv Level 4 Kit
% growth on Dec base
Adv Level 3 Kit
% growth on Jan base
Adv Level 2 Kit
% growth on Feb base
Adv Level 1 Kit

Abacus Pouch
Abacus
5
1

2
Value of each item ?

30 0
Rate of each item
100

2500
885
247

247
247
250
100

125

125

100

125
120

125

247

247

247

247
50
75

You might also like