Question

Modelling (Excel): Quiz
Name: ___________________________________ Roll No: _______________ Date: __________ SIMPLE TRANSPORTATION DATA ANALYSIS
A
B
C
D
E
F
G
1
Ahmedabad
0
2
Baroda
110
0
3
Rajkot
200
270
0
4
Bhavnagar
250
320
175
0
5
Surat
270
150
400
470
0
6
Ahmedabad
Baroda
Rajkot
Bhavnagar
Surat
7
8
Consignment data
9
Fromcity
Tocity
Qty (tons)
From City
To City row no
Distance-km
Ton-km
10
Baroda
Rajkot
100
2
3
270
27000
11
Rajkot
Bhavnagar
80
3
4
175
14000
12
Bhavnagar
Baroda
120
4
2
320
38400
13
Rajkot
Surat
100
3
5
400
40000
14
Surat
Rajkot
200
5
3
400
80000
15
Ahmedabad
Bhavnagar
80
1
4
250
20000
16
17
City
Sent
Received
18
Ahmedabad
20000
0
19
Baroda
27000
38400
20
Rajkot
54000
107000
21
Bhavnagar
38400
34000
22
Surat
80000
40000
Study the above Excel model and answer questions given below. TIME: 5 minutes WRITE THE FORMULA FOR CELLS (WITH CORRECT, NO EXTRA DOLLARS).
(Your formula, when copied to cells below, should yield correct answers for all rows.)
Q1 D10:____________________________________________________________ (_____ / Max 5)
Q2 E10:____________________________________________________________ (_____ / Max 5)
Q3 F10:____________________________________________________________ (_____ / Max 5)
Q4 G10:____________________________________________________________ (_____ / Max 5)
Q5 B18:____________________________________________________________ (_____ / Max 5)
Q6 C18:____________________________________________________________ (_____ / Max 5) Selecting the whole range B18:C22, a single formula with CTRL+ENTR can be entered and all figures obtained. What would that formula be? (15 mks, No partial marks here)
Q7 B18:C22:_______________________________________________________ (_____ / Max 15)

Answer 1

Answer:

.......................