This quiz works best with JavaScript enabled. Home > Cbse > Class 7 > Computer Science > Ms Excel Spreadsheet > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 18 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 18 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Excel would be the ideal program to type out a book report. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 2. A combination of numbers and symbols used to express a calculation. Always begins with an = sign. A) Cell Address. B) Worksheet. C) Formula. D) None of the above. Show Answer Correct Answer: C) Formula. 3. What is the extension of the MS-Excel 2016 file? A) .xlsx. B) .xls. C) .docx. D) .doc. Show Answer Correct Answer: A) .xlsx. 4. Which character is used in a spreadsheet formula to represent division? A) -. B) !. C) /. D) *. Show Answer Correct Answer: C) /. 5. IT LETS YOU ENTER OR EDIT DATA, FORMULA OR A FUNCTION IN ANY CELL. A) FORMULA BAR. B) FORMULA GROUP. C) FORMULA RIBBON. D) FORMULA TAB. Show Answer Correct Answer: A) FORMULA BAR. 6. We use this to 'lock in' a value in a cell so that replicating formula is accurate. A) Named cell. B) Cell reference. C) The cell. D) Same cell. Show Answer Correct Answer: A) Named cell. 7. What symbol should be used to perform an adding calculation? A) *. B) /. C) +. D) -. Show Answer Correct Answer: C) +. 8. All functions on Google Sheet begin with symbols? A) %. B) -. C) =. D) +. Show Answer Correct Answer: C) =. 9. Which shows the beginning and end of a flowchart, is ..... A) Process. B) Terminator. C) Data. D) Decision. Show Answer Correct Answer: B) Terminator. 10. Sort the contents of the cell from small up or a-z called A) Sorting. B) Descending. C) Format. D) Ascending. Show Answer Correct Answer: D) Ascending. 11. The steps to keep the workbook are ..... A) Klik file $\rightarrow$ new. B) Klik file $\rightarrow$ page setup. C) Klik file $\rightarrow$ save as. D) Klik File $\rightarrow$ Print. E) Klik file $\rightarrow$ exit. Show Answer Correct Answer: C) Klik file $\rightarrow$ save as. 12. Rows on a spreadsheet are identified by a ..... A) Smiley face. B) Symbol. C) Letter. D) Number. Show Answer Correct Answer: D) Number. 13. What is correct way to find sum of two cells "a1" and "b1" ? A) = below (A1+B1);. B) Sum(a1+b1). C) Sum(a1, b1). D) =sum(a1, b1). Show Answer Correct Answer: D) =sum(a1, b1). 14. Who is the developer of MS Excel? A) Charles Simonyi. B) Microsoft. C) Steve Jobs. D) Bill Gates. Show Answer Correct Answer: A) Charles Simonyi. 15. ..... allows you to perform calculations on data entered into a spreadsheet? A) Data. B) Cell reference. C) Formulas. D) Cell. Show Answer Correct Answer: C) Formulas. 16. The area where the writing excel formula is disbut ..... A) Functional. B) Toolbar. C) Menubar. D) Formulabar. E) Titlebar. Show Answer Correct Answer: D) Formulabar. 17. Adding a new worksheet can be done using a shortcut ..... A) Ctrl + W. B) Shift + F5. C) Shift + F11. D) Ctrl + O. Show Answer Correct Answer: C) Shift + F11. 18. We use ..... format to add money symbols ($ , SAR, LBP ..... ) A) Currancy. B) Date. C) Time. D) None of the above. Show Answer Correct Answer: A) Currancy. 19. Cell J14 is ..... A) Column J row 14. B) Row 14 column J. C) Column 14 row J. D) Row J column 14. Show Answer Correct Answer: A) Column J row 14. 20. Which co-operation developed MS-Excel? A) Macrotech. B) Macromax. C) Apple. D) Microsoft. Show Answer Correct Answer: D) Microsoft. 21. If you type =2*(6-4) in cell A1, what will be the display value? A) 6. B) 4. C) 8. D) 2. Show Answer Correct Answer: B) 4. 22. There are ..... modes of the screen in BASIC. A) Two. B) Four. C) Three. D) One. Show Answer Correct Answer: A) Two. 23. What symbol is used for subtraction (take away)? A) -. B) *. C) /. D) +. Show Answer Correct Answer: A) -. 24. Example of spreadsheet software A) Lotus 32-4. B) Powerpoint. C) Lotus 1-2-3. D) Ms access. Show Answer Correct Answer: C) Lotus 1-2-3. 25. This is an act of creating, editing, and producing a text document. A) Placeholder. B) Dragging. C) Word wrapping. D) Word processor. Show Answer Correct Answer: D) Word processor. 26. MS Excel is the most widespread ..... package. A) Table. B) Presentation. C) Spreadsheet. D) Word processor. Show Answer Correct Answer: C) Spreadsheet. 27. Facilitate the making of a large amount of letters is ..... A) Mail Merge Benefits. B) Mail Merge loss. C) Mail Merge function. D) Understanding Mail Merge. Show Answer Correct Answer: A) Mail Merge Benefits. 28. 30-Spreadsheets (Excel) are used by Painters while drawing tables A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: B) FALSE. 29. The key combination used to move to the first cell: A) Ctrl + Enter. B) Ctrl + Insert. C) Ctrl + End. D) Ctrl + Home. Show Answer Correct Answer: D) Ctrl + Home. 30. In compiling a program, the first step that must be taken is ..... A) Process. B) Bought a computer. C) Create an algorithm. D) Make a program. Show Answer Correct Answer: C) Create an algorithm. 31. The keyboard combination used to store new documents is ..... A) Ctrl + O. B) Ctrl + A. C) Ctrl + N. D) Ctrl + S. Show Answer Correct Answer: D) Ctrl + S. 32. Horizontal line of cells A) Cell. B) Column. C) Spreadsheet. D) Row. Show Answer Correct Answer: D) Row. 33. An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information A) Cell. B) Spreadsheet. C) Workbook. D) Entry. Show Answer Correct Answer: B) Spreadsheet. 34. How to activate the absolute address is A) Press F1. B) Press F4. C) Press F2. D) Be a verb. Show Answer Correct Answer: B) Press F4. 35. What does the mouse look like in a spreadsheet? A) Selection cross. B) Arrow. C) Pointer. D) Two headed arrow. Show Answer Correct Answer: A) Selection cross. 36. The function used to get a value of a table vertically is called function ..... A) VLOOKUP. B) HLOOKUP. C) AVERAGE. D) Countif. Show Answer Correct Answer: A) VLOOKUP. 37. Which function can find the highest value in a cell range? A) HIGHEST. B) TOP. C) MAX. D) MAXVALUE. Show Answer Correct Answer: C) MAX. 38. How to open a workbook that has been saved in the way ..... A) Ctrl + P. B) Ctrl + O. C) Ctrl + B. D) Ctrl + D. E) Ctrl + E. Show Answer Correct Answer: B) Ctrl + O. 39. Using the ..... feature, sum of the numbers can be calculated easily. A) Autofill. B) Autoosum. C) All the above. D) None of the above. Show Answer Correct Answer: B) Autoosum. 40. Row headings are represented by ..... A) Alphabets. B) Numbers. C) Alphanumeric. D) None of the above. Show Answer Correct Answer: B) Numbers. 41. Below that includes the MS-Excel Worksheet is, except ..... A) Menubar. B) Toolbar. C) Titlebar. D) Excelbar. E) All wrong. Show Answer Correct Answer: D) Excelbar. 42. Which menu tab contains the font option in excel 2016? A) File. B) Home. C) Insert. D) View. Show Answer Correct Answer: B) Home. 43. Spreadsheet can perform calculations. A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 44. What type of chart will you use to compare performance of two employees in the year 2016? A) Pie Chart. B) Line Chart. C) Dot Chart. D) Column Chart. Show Answer Correct Answer: B) Line Chart. 45. In spreadsheet, the formula starts with an equal sign. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 46. Where can we find the tabs, groups, and commands in the MS Excel window? A) Ribbon. B) Quick access toolbar. C) Name box. D) None of the above. Show Answer Correct Answer: A) Ribbon. 47. The number of rows and columns in Microsoft Excel 2013 is ..... A) 1, 048, 576 and 16, 384. B) 16, 384 and 1, 048, 576. C) 16, 333 and 10, 048. D) 65, 576 and 253. Show Answer Correct Answer: A) 1, 048, 576 and 16, 384. 48. Multiple Worksheet makes a ..... A) Sheet Tab. B) Work book. C) Spreadsheet. D) None of the above. Show Answer Correct Answer: B) Work book. 49. Each box in the spreadsheet is called? A) Column. B) Kotak. C) Line. D) Sel. Show Answer Correct Answer: D) Sel. 50. Short key to save as on an excel worksheet is A) FZ. B) ALT + F4. C) F12. D) Fg. Show Answer Correct Answer: C) F12. 51. The function in the excel used calculates the number of a group of values ..... A) MIN. B) SUM. C) COUNT. D) AVERAGE. E) MAX. Show Answer Correct Answer: B) SUM. 52. ..... function is used to find the maximum value A) Min. B) Average. C) Percentage. D) Max. Show Answer Correct Answer: D) Max. 53. Paying your bills on time will help you increase your credit score A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 54. Which formula would you use to calculate how many sales are over $ 20 from a series. A) Sum. B) SUMIF. C) Countif. D) Count. Show Answer Correct Answer: C) Countif. 55. What do you call the document created using spreadsheet program? A) WORKBOOK. B) DOCUMENT. C) All the above. D) None of the above. Show Answer Correct Answer: A) WORKBOOK. 56. Ctrl + S button, functioning for A) Open files. B) Keep files. C) Doubling the data. D) Move data. Show Answer Correct Answer: B) Keep files. 57. (*) The sign is a sign of the calculation operation ..... A) Distribution. B) Multiplication. C) Reduction. D) Addition. Show Answer Correct Answer: B) Multiplication. 58. Which formula would you use to multiply cell B4 by cell C4? A) = BC*cf. B) = (Bc:CSH). C) = B4xc4. D) B4xc4 =. Show Answer Correct Answer: A) = BC*cf. 59. Use to create words and pictures for presentation of information. A) Spreadsheet software. B) Word and data processing software. C) Presentation software. D) None of the above. Show Answer Correct Answer: C) Presentation software. 60. Ctrl + C and Ctrl + P in Microsoft Power Point, Microsoft Excel and Microsoft Word are functioning as A) Format text + exposure. B) Shut Down + Print. C) Copy and print. D) Control Format + Print. Show Answer Correct Answer: C) Copy and print. ← PreviousNext →Related QuizzesComputer Science QuizzesClass 7 QuizzesClass 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 1Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 2Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 3Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 4Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 5Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 7Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 8 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books