1) What should a formula start with? a) * b) = c) / d) : 2) What is the symbol used when writing a formula to multiply? a) * b) / c) + d) : 3) What is a 'Worksheet'? a) A page in a spreadsheet b) A blank document c) A sheet to show calculations d) A photocopy from a text book 4) What is a cell reference? a) The shape of a cell b) The colour of a cell c) A column number and row leter used to identify a cell d) The column letter and row number to identify a cell 5) What function should you use when adding up a lot of numbers? a) MAX b) COUNT c) SUM d) TOTAL 6) Money in cells should be formatted as what? a) Euro b) £ c) $ d) Currency 7) A word document finishes with the extension .doc. What does a spreadsheet finish with? a) .docx b) .cvs c) .xls d) .jpg 8) Which is the correct format for a cell reference? a) 4B b) 44 c) BB d) B4 9) What function should you use working out the highest number in a list? a) AVERAGE b) MAXIMUM c) MINIMUM d) COUNT 10) Formulas allow you to enter --------------- on the numbers in your spreadsheet a) rows b) columns c) calculations d) divide 11) Horizontal and vertical lines on a worksheet are called? a) Gridlines b) Worksheets c) Cells d) Blocklines 12) What application software do you use to create a spreadsheet? a) Excel b) Word c) PowerPoint d) Outlook 13) Which of the following can you create using a spreadsheet? a) A chart b) A calculation c) A table d) All of them 14) What is the image showing? a) A column b) A row c) A workbook d) The active cell 15) You can draw attention to a table by formatting with... a) Colours b) Borders c) Gridlines

Spreadsheet Basics 1

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?