1) Formula =B1+B2 will carry out a) Addition b) Subtraction c) Multiplication d) Division 2) Formula =B1-B2 will carry out a) Addition b) Subtraction c) Multiplication d) Division 3) Formula =B1*B2 will carry out a) Addition b) Subtraction c) Multiplication d) Division 4) Formula =B1/B2 will carry out a) Addition b) Subtraction c) Multiplication d) Division 5) Letters represents a a) Column b) Row c) Cell 6) Number represents a a) Column b) Row c) Cell Reference 7) B1 is an example of a) Column b) Row c) Cell reference / cell address 8) Formula =SUM(B1:B9) will carry out a) Subtraction b) Multiplication c) Addition of B1 to B9 9) Which formula is written correctly  a) =A1xD4 b) A1*D4 c) =A1*D4 10) Which AutoSum function is written correctly a) SUM(B1:B9) b) =SUM(B1:B9) c) =AutoSum(B1:B9)

Excel Formula & Functions Quiz

印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?