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

S1 Spreadsheets Formula

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?