1) How would you calculate the total of values in cells A1 to A5 in Excel? a) =SUM(A1+A5) b) =TOTAL(A1:A5) c) =A1+A2+A3+A4+A5 d) =SUM(A1:A5) 2) Which function would you use to find the average of values in cells A1 to A10 in Excel? a) =AVERAGE(A1-A10) b) =MEAN(A1:A10) c) =TOTAL(A1:A10) d) =AVERAGE(A1:A10) 3) If cell A1 contains the value 10 and cell A2 contains the value 5, what is the result of the formula =A1 - A2 in Excel? a) 10 b) -5 c) 15 d) 5 4) How would you multiply the values in cells A1 and A2 in Excel? a) =A1 * A2 b) =MULTIPLY(A1:A2) c) =PRODUCT(A1, A2) d) =SUM(A1:A2) 5) What function would you use to find the maximum value in cells A1 to A10 in Excel? a) =MAX(A1:A10) b) =LARGEST(A1:A10) c) =MAXIMUM(A1:A10) d) =HIGHEST(A1:A10)
0%
Microsoft Excel_Easy Calculations
共享
共享
共享
由
Alidavanwyk
编辑内容
打印
嵌入
更多
作业
排行榜
显示更多
显示更少
此排行榜当前是私人享有。单击
，共享
使其公开。
资源所有者已禁用此排行榜。
此排行榜被禁用，因为您的选择与资源所有者不同。
还原选项
随堂测验
是一个开放式模板。它不会为排行榜生成分数。
需要登录
视觉风格
字体
需要订阅
选项
切换模板
显示所有
播放活动时将显示更多格式。
打开成绩
复制链接
QR 代码
删除
恢复自动保存：
？
