1) What do we call the individual boxes on a Spreadsheet? a) Columns b) Rows c) Cells d) Formulas e) Functions 2) Letters are at the top of..... a) Columns b) Rows c) Cells d) Formulas e) Functions f) the Library 3) Numbers are at the start of..... a) Columns b) Rows c) Cells d) Formulas e) Functions f) Mr England's math test 4) 'C4' is an example of a...... a) Row b) Column c) Function d) Formula e) Cell Reference 5) A formula ALWAYS begins with what symbol? a) X b) - c) * d) = e) + f) & 6) "We don't talk about....." a) Bruno b) Lanyards c) Mr Coggins d) Sam Redfern e) Tottenham f) why girls are better than boys at computing... 7) Which function adds up a range of selected cells? a) MIN b) MAX (not Craig) c) AVERAGE d) SUM e) COUNT f) COUNTIF 8) Which function finds the average of a range of selected cells? a) SUM b) COUNTA c) COUNTIF d) AVERAGE e) COUNT f) IF 9) Which function checks IF the question is true and gives 1 response if it is, and a 2nd response if it's false?  a) IF b) AVERAGE c) SUM d) COUNTA e) COUNTIF 10) Which function checks a range of cells and counts up the ones that contain certain criteria?  a) IF b) COUNTA c) COUNTIF d) SUM e) AVERAGE 11) When might we use a Spreadsheet in our lives (tick all the correct boxes) a) Adding up weekly sales b) Presenting data in a graphical form c) Keep track of the hours employees have worked d) Check stock levels in a shop e) Tracking our monthly spending budget f) Tracking our fitness targets

9.3.4 - Practical Spreadsheets

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?