Q97.
b
Section
1-1 Corporate activities
Answer
Explanation
From the performances shown for each sales office, it is evident that the Yokohama office had
the highest sales. Also, the Hamamatsu office had the highest estimate comparison and the
sales closest to its estimate.
a): The sales office with the highest growth in sales compared to the previous year is the
Hamamatsu office, with a year-to-year comparison of 107%.
)
c : Sales have grown compared to the previous year at the Kawasaki branch and the Hamamatsu office, where the year-to-year comparisons exceed 100%.
d): The Shizuoka branch reported sales closest to the previous year’s sales.
Q98.
b
Section
1-1 Corporate activities
Answer
Explanation
In the list of sales performance by division, the sales offices where both the estimate and the
year-to-year comparison do not reach 100% are the Yokohama office and the Mishima office.
Also, the only place where the estimate comparison is below 80% is the Yokohama office.
Therefore, B is the Yokohama office.
Q99.
d
Section
8-3 Software
Answer
Explanation
The composition ratio of sales performance by sales office can be found by dividing the performance of each sales office by the total performance.
In order to copy the formula entered in Cell D3 to Cells D4 to D7, it is necessary to fix Row 7
of Column D in which the total performance is entered. Therefore, the correct answer is d),
=C3/C$7.
Q100.
c
Section
1-1 Corporate activities
Answer
Explanation
A pie chart is the most suitable type of graph for displaying the composition ratios.
75