1) What formula is used in cells I4 (yellow) to find the total number of sightings for Chimera? a) =(B4:H4) b) =SUM(B4:H4) c) =B4*H4 2) What formula is used in cell B13 (Pink) to calculate the total number of sightings in New York? a) =B4:B12 b) =SUM(B4*B12) c) =SUM(B4:B12) 3) What formula is used in cell l13 (blue) to find the total number of sightings that have been reported? a) =SUM(B4:B12) b) =SUM(B4:H4) c) =SUM(I4:l12) 4) In spreadsheets, what is the operator used to multiply numbers together? a) / b) * c) + 5) Every formula begins with.... a) = b) - c) * 6) D4 a) =SUM:B4+C4 b) =B4+C4 c) =AVERAGE(B4:G4) 7) H4 a) =SUM(B4:G4) b) =MAX(B4:G4) c) =AVERAGE(B4:G4) 8) E4 a) =B6*C6 b) =C4/D4 c) =D8+F8 9) G8 a) =C4/D4 b) =B6*C6 c) =D8+F8 10) D6 a) =D8+F8 b) =C4/D4 c) =B6*C6 11) To find Total Price, we use.. a) * b) / c) =SUM 12) What formula is used in E8 to calculate the QUANTITY? a) F8*D8 b) =F8/D8 c) F8/D8

S1 Spreadsheets Formula Recap 3

印刷
埋め込み

リーダーボード

表示スタイル

オプション

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

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