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 代碼
刪除
恢復自動保存:
?
