(1)在工作表Sheet1中,将A1:E1单元格合并及居中;
(2)将第B列的列宽设置为12字符;
(3)假设每次商品均按6折购入,用公式法计算每次“小计”(小计=单价*数量*0.6),并将结果存放到E3:E9单元格区域;
(4)用函数计算“班费支出合计”,并将结果填充在E10单元格内;
(5)为Sheet1表中A2:E9区域单元格添加所有框线。

同类型试题

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

