This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 73 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 73 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Name of a cell is also known as Cell reference A) TRUE. B) FALSE. C) All the above. D) None of the above. Show Answer Correct Answer: A) TRUE. 2. What is the shortcut key for GoTo option in Excel? A) Ctrl + G. B) Ctrl + T. C) ALT + G. D) Alt + T. Show Answer Correct Answer: A) Ctrl + G. 3. ..... automatically fills your data when it senses a pattern A) Copy cells. B) Fill formatting only. C) Fill without formatting. D) Flash fill. Show Answer Correct Answer: D) Flash fill. 4. Applications used to process data in the form of numbers are called? A) Microsoft Excel. B) Microsoft Power Point. C) Microsoft Word. D) Microsoft Bing. Show Answer Correct Answer: A) Microsoft Excel. 5. To count any fields containing numbers we use: A) CountIF function. B) Counta function. C) Count function. D) CountIFs function. Show Answer Correct Answer: C) Count function. 6. Text in Excel is automatically aligned ..... A) Right. B) Left. C) Center. D) Justify. Show Answer Correct Answer: B) Left. 7. In a new worksheet, you must start by typing in cell A1 A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 8. Ctrl+S is a shortcut key to bring up the dialog box ..... A) Save. B) Page setup. C) Format Cell. D) Print. Show Answer Correct Answer: A) Save. 9. An Excel File is genericly called A / AN:Excel file is commonly called A) E-Spreadsheet. B) Worksheet. C) Workbook. D) Sheet. Show Answer Correct Answer: C) Workbook. 10. ..... operator, combines multiple references into one reference. A) Ampersand. B) Space. C) Comma. D) Colon. Show Answer Correct Answer: C) Comma. 11. To insert a column between Column B & C, Which column is to be selected first? A) B. B) C. C) Both. D) Any Cell. Show Answer Correct Answer: B) C. 12. Which of the following is not a part of MS-Excel 2013 window? A) Ribbon. B) Tabs. C) Groups. D) Images. Show Answer Correct Answer: D) Images. 13. The following is an order to open a document (workbook) Ms.Excel is ..... A) Ctrl + N. B) Ctrl + S. C) Ctrl + O. D) Ctrl + Z. Show Answer Correct Answer: C) Ctrl + O. 14. Which tab in the spreadsheet is used to insert picture? A) File tab. B) Home tab. C) Insert tab. D) None of the above. Show Answer Correct Answer: C) Insert tab. 15. To combine 2 or more cells, it can be done by ..... A) Format. B) Insert. C) Mail merge. D) Merge¢er. Show Answer Correct Answer: D) Merge¢er. 16. How many columns are there in MS-EXCEL? A) 15384. B) 16383. C) 16385. D) 16384. Show Answer Correct Answer: D) 16384. 17. To select random multiple cell hold down ..... key as click on each cell. A) Alt. B) Shift. C) Ctrl. D) All of the above. Show Answer Correct Answer: C) Ctrl. 18. You can edit a cell by ..... A) Clicking the formula button. B) Double clicking the cell. C) Selecting Edit>Edit Cell from the menu. D) None of above. Show Answer Correct Answer: B) Double clicking the cell. 19. The image that works to speed up an order is ..... A) Ikon. B) Pill-down menu. C) Keyboar. D) Hard drive. E) Mouse. Show Answer Correct Answer: A) Ikon. 20. To make a chain letter we can use a pair of applications ..... A) Word and Docs. B) Word and Excel. C) Excel and Slide. D) Excel dan spreadsheet. E) Drive dan classroom. Show Answer Correct Answer: B) Word and Excel. 21. What is a spreadsheet and what does it contains? A) A spreadsheet is a chart with many pie chart. B) A spreadsheet is a table with many lines. C) A spreadsheet is a document with many rows and columns. D) A spreadsheet is a table with many rows and columns. Show Answer Correct Answer: D) A spreadsheet is a table with many rows and columns. 22. They are used to perform calculation without typing long and complex formulas A) Functions. B) Auto calculator. C) Operations. D) None of these. Show Answer Correct Answer: A) Functions. 23. A vertical line of cells is A) Row. B) Column. C) All the above. D) None of the above. Show Answer Correct Answer: B) Column. 24. File Extension.xlsx was introduced in Excel A) 2003. B) 2007. C) 2010. D) 2013. Show Answer Correct Answer: B) 2007. 25. The two options to do the reverse calculation process A) Scenario manager and Goal seek. B) Goal seek and Solver. C) Solver and Data table. D) Data table and Scenario manager. Show Answer Correct Answer: B) Goal seek and Solver. ← PreviousNext →Related 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 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books