Question

2
PART B: SHORT ANSWER TYPE SUBJECT SPECIFIC QUESTIONS Answer
any 4 of the given 6 questions (2 x 4 = 8 marks)
11. An automobile showroom wants to calculate the total car sales of the first quarter of the
years 2020 and 2021 as given. Show the complete consolidate data dialogue box to
generate consolidated report:
SALES OF THE YEAR 2020
CARS
JAN
FEB
MARCH
Santro
340
200
350
Wagon R 456
800
230
i10
790
300
160
Swift
100
290
167
SALES OF THE YEAR 2021
CARS
JAN
FEB
MARCH
Santro
122
250
110
450
Wagon R
120
150
ilo
100
320
165
300
Swift
100
200

Answer 1

Consolidation Means To Combine Given Data Together Hence It Is Given In The Question Only Just Have To Write The Whole Data Together.

Answer 2

Answer:Consolidation Means To Combine Given Data Together Hence It Is Given In The Question Only Just Have To Write The Whole Data Together.