Q99.
Technology
You decide to calculate the composition ratio of each office’s sales performance based on
the by-division sales performance data entered in the spreadsheet software. If you are going
to copy the formula entered in cell D3 to cells D4 to D7, which of the following the appro
priate formula to use?
A
B
C
D
E
1
2
a)
b)
c)
d)
Q100.
Strategy
Compared to
previous year
432
96%
103%
772
605
78%
92%
377
365
97%
107%
Actual
Kawasaki office
451
4
Yokohama office
5
Hamamatsu office
6
Mishima office
7
Total
Composition
ratio
590
523
89%
96%
2190
1925
88%
96%
=C$3 / C$7
=$C$3 / C7
=C3 / $C7
=C3 / C$7
You decide to create a graph showing the composition ratio of each office’s sales performance based on the by-division sales performance data entered in the spreadsheet software.
Which of the following is appropriate as a graph that shows sales performance composition ratios?
a)
b)
c)
d)
399
Compared
to budget
Budget
3
F
Unit: 1,000 yen
Line graph
Stacked bar graph
Pie chart
Scatter plot