(1)将第1行设置为“最适合的行高”;
(2)将A2:D13区域单元格的对齐方式设置为“水平居中”;
(3)用函数计算出金牌总数最大值,并将结果填在单元格B14中;
(4)用函数计算出每个班的“奖牌总数”,并将结果分别填充在E2:E13内;
(5)在Sheet1中制作图表:选取A1:A13和E1:E13单元格区域,插入图表,样式选择“簇状柱形图”,图表标题为“各班级获得奖牌总数”。

同类型试题

y = sin x, x∈R, y∈[–1,1],周期为2π,函数图像以 x = (π/2) + kπ 为对称轴
y = arcsin x, x∈[–1,1], y∈[–π/2,π/2]
sin x = 0 ←→ arcsin x = 0
sin x = 1/2 ←→ arcsin x = π/6
sin x = √2/2 ←→ arcsin x = π/4
sin x = 1 ←→ arcsin x = π/2


y = sin x, x∈R, y∈[–1,1],周期为2π,函数图像以 x = (π/2) + kπ 为对称轴
y = arcsin x, x∈[–1,1], y∈[–π/2,π/2]
sin x = 0 ←→ arcsin x = 0
sin x = 1/2 ←→ arcsin x = π/6
sin x = √2/2 ←→ arcsin x = π/4
sin x = 1 ←→ arcsin x = π/2

