in) Suge
Type B: Application Oriented Questions
1. Below is part of a spreadsheet, WICH
School
(2) Whi
() Wh
o
ra spreadsheet, which contains data about the sales of sandwiches in Hilltop HEM
(a) Sug
as
18
12
3. Gina sp
month.
26
23
25
(a) N
Boiled Potato
3 Cherese
$ Cheese Capsicum
7 Banana Cheese Sev
Potato Onion Tomato
Cabbage Cheese
15 Salad
0 Tomato
12 Tuna
33 Tung and Onion
FAVOURITE LUNCHTIME SANDWICHES
Sandwich Cost Selling Price Predicted Actual Total income
(in Rs.)
Com Rs.) Sales Sales (in Rs.)
13
25
12
40
40
560
52
624
31
36
540
28
28
19
228
550
13
30
50
600
16
25
32
44
396
28
SO
35 30
660
26
45
12
228
(b) E
16
20
51
55
4. A fina
14
3 Totals
350
350
4530
WIN
Answer the following questions (i) to (id) based on above spreadsheet:
List two ways in which the cells in the first row have been formatted.
(ii) Can you predict after looking at above worksheet whether the values shown in range B4:F15
have default alignment or a different one given through Formatting ?
(iii) What option/setting has been chosen for B3:F3 that they are able to display multi-line text in
these cells?
(id) What command has facilitated the setting of previous question i.e., multi-line text?
Answers
Explanation:
in) Suge
Type B: Application Oriented Questions
1. Below is part of a spreadsheet, WICH
School
(2) Whi
() Wh
o
ra spreadsheet, which contains data about the sales of sandwiches in Hilltop HEM
(a) Sug
as
18
12
3. Gina sp
month.
26
23
25
(a) N
Boiled Potato
3 Cherese
$ Cheese Capsicum
7 Banana Cheese Sev
Potato Onion Tomato
Cabbage Cheese
15 Salad
0 Tomato
12 Tuna
33 Tung and Onion
FAVOURITE LUNCHTIME SANDWICHES
Sandwich Cost Selling Price Predicted Actual Total income
(in Rs.)
Com Rs.) Sales Sales (in Rs.)
13
25
12
40
40
560
52
624
31
36
540
28
28
19
228
550
13
30
50
600
16
25
32
44
396
28
SO
35 30
660
26
45
12
228
(b) E
16
20
51
55
4. A fina
14
3 Totals
350
350
4530
WIN
Answer the following questions (i) to (id) based on above spreadsheet:
List two ways in which the cells in the first row have been formatted.
(ii) Can you predict after looking at above worksheet whether the values shown in range B4:F15
have default alignment or a different one given through Formatting ?
(iii) What option/setting has been chosen for B3:F3 that they are able to display multi-line text in
these cells?
(id) What command has facilitated the setting of previous question i.e., multi-line text?
A2 ka work
Answer:
njgfesdyioyyioxxyhjn