(1)在工作表sheet1中,将A1:C1单元格合并及居中;
(2)用函数计算出“学习时长”的平均值,并将结果填写在C9单元格内;
(3)制作图表:选取区域A2:A8和C2:C8,插入图表,样式为“簇状柱形图”,图表标题为“自习时长”,图表放在“Sheet1”工作表中;
(4)以“学习时长”为主要关键字对A2:C8单元格区域进行“降序”排序;
(5)为A2:C9区域单元格设置:“6.5%灰色”(第一行第六个)图案填充。

同类型试题

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

