Grade 6 Excel Test Quiz

Question Number 1 The autosum does the following: A. Multiplies a column of figures B. Subracts figures. C. Adds figures in a column or row Question Number 2 To make a double line under a number, you must click on the ... A. Underline button B. The currency button C. The format painter D. The tools button E. The borders button Question Number 3 To select a whole column, you have to... A. Click on a number on the left side B. Click on a cell C. Click on one of the letters at the top of the sheet. Question Number 4 To create a chart, you must click on the .... A. Drawing button B. The currency button C. The format painter D. The tools button E. The sort ascending button F. The chart wizard Question Number 5 MS Excel is also known as a ... A. Document B. Publication C. Presentation D. Chart E. Workbook Question Number 6 The little blocks in the Worksheet are called A. blocks B. lines C. cells D. windows Question Number 7 The fx bar is to do the following... A. Indicates which cell you are in. B. Stands for formula bar. C. Indicates which sheet you are in. Question Number 8 If your cell shows 100, then the formula bar could show... A. one hundred B. =50*2 C. 50x2 D. Nothing Question Number 9 You are not able to put pictures into Excel. Is this true or false? A. False B. True Question Number 10 To create a change from Dollars to Rands, you must click on the... A. Formula button B. Format Button C. Currency button D. The file button Question Number 11 In Excel, you are able to rename sheets A. True B. False Question Number 12 A formula ALWAYS has to start with an... A. + sign B. - sign C. / sign D. = sign Question Number 13 / in a formula means A. equals B. Multiplying C. Adding D. subtracting E. dividing Question Number 14 You must always save your spreadsheets in... A. Common on Server K: B. The Desktop C. My documents D. Anywhere. It really doesn't matter as long as you save. Question Number 15 You cannot put more sheets into an Excel workbook. A. True B. False C. Sometimes you can. D. Sometimes you cant. Question Number 16 In Excel, you are able to Insert new columns or rows A. False B. True Question Number 17 =50*20. In this formula, you are... A. Adding 50 and 20 B. Subtracting 20 from 50 C. Multiplying 50 by 20 D. Subtracting 2 from 100 Question Number 18 Is Excel the same as MS WORD? A. Yes B. No Question Number 19 The area that you work in is called... at the bottom of the page (Select the missing word) A. Pages B. Sheets C. Documents D. Books