1) Excel is .. ? a) A database b) A word processor  c) A presentation program d) A spreadsheet program 2) A spreadsheet is ... ? a) A program that modifies pictures b) A program that performs mathematical work c) A program that creates text based documents d) A website to watch videos 3) A spreadsheet workbook consists of ? a) Boxes b) Squares c) Cubes d) Cells 4) Which of the following is a correct cell reference (name)? a) %4 b) XX c) 4C d) C4 5) Using _________ in spreadsheets can allow you to quickly make calculations? a) Formulas b) Images c) Charts d) WordArt 6) A formula always starts with? a) - b) = c) * d) / 7) What is the symbol for multiplication on a spreadsheet? a) - b) + c) * d) / 8) What is the symbol for division on a spreadsheet? a) - b) + c) * d) / 9) When a number is changed on a spreadsheet the formula does automatically calculate the new answer? a) True b) False 10) What button can you click on to create a SUM formula? a) CreateSum b) AutoSum c) TotalSum d) Sum 11) What does 'Sorting' mean on a Spreadsheet? a) Puts the data in order b) Having the rows in number order c) Having the columns in order d) Puts the workbooks in order 12) What does 'Filtering' mean on a Spreadsheet a) Highlights data using colour b) Shrinks the columns c) Only show the relevant data  d) Opens all rows and columns to show the data in full 13) What is the correct formula for the SUM function? a) =A4+B4 b) =SUM(A4:B4) c) =SUM(A4+B4) d) =A4*B4 14) What are axis titles? a) Main title on a chart b) Labels within a chart c) Colour code label at the side of a chart d) Labels along the bottom and side of a chart 15) What is a legend? a) Main title on a chart b) Labels within a chart c) Colour code label at the side of a chart d) Labels along the bottom and side of a chart 16) What are data labels? a) Main title on a chart b) Labels within a chart c) Colour code label at the side of a chart d) Labels along the bottom and side of a chart

Basic Excel Quiz

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?