This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 63 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 63 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. A spreadsheet is like a filing system and a calculator A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 2. How can I move an image around the page? A) The Arrange Tool. B) The Effect Tool. C) The Crop Tool. D) The Adjust Tool. Show Answer Correct Answer: A) The Arrange Tool. 3. The lines that run across the plot area are known as ..... A) Sparklines. B) Slice. C) Cross lines. D) Gridlines. Show Answer Correct Answer: D) Gridlines. 4. Tools that work to copy text or objects are ..... A) Copy. B) Paste. C) Format Painter. D) Replace. Show Answer Correct Answer: A) Copy. 5. The shortcut key to return to the first cell in a worksheet is A) Ctrl+Backspace. B) Ctrl+Page Up. C) Ctrl+Home. D) Ctrl+Up Arrow. Show Answer Correct Answer: C) Ctrl+Home. 6. What is the formula to find the lowest number in cells C1:C4? A) =average(C1:C4). B) =max(C1:C4). C) =min(C1:C4). D) =sum(C1:C4). Show Answer Correct Answer: C) =min(C1:C4). 7. An excel file is saved with ..... extension. A) .xlsx. B) .pptx. C) All the above. D) None of the above. Show Answer Correct Answer: A) .xlsx. 8. To quickly add a set of number you can use the ..... feature? A) Plus Sum Button. B) Add Sum Button. C) Quick Add Button. D) Auto Sum Button. Show Answer Correct Answer: D) Auto Sum Button. 9. Microsoft Excel is one of the number processing software that is part of A) Worksheet. B) Wordpad. C) Linux. D) Microsoft Office. E) Windows. Show Answer Correct Answer: D) Microsoft Office. 10. What is the extension of ms excel? A) .txt. B) .xls or.xlsx. C) .ppt. D) All of these. Show Answer Correct Answer: B) .xls or.xlsx. 11. Which among following is secondary storage device? A) Hard Disk. B) RAM. C) Diode. D) Semi Conductor. Show Answer Correct Answer: A) Hard Disk. 12. ..... command is used to change the colour of text and graphics. A) Screen. B) Color. C) Line. D) None of the above. Show Answer Correct Answer: B) Color. 13. In a spreadsheet, a ..... is the intersection of a column and a row A) Formula. B) Column. C) Cell. D) Row. Show Answer Correct Answer: C) Cell. 14. Where is Microsoft Office button located in MS Excel window? A) Top left. B) Top right. C) Bottom left. D) Bottom right. Show Answer Correct Answer: A) Top left. 15. Insert Merge Field works after ..... A) Both files are connected. B) New data is created. C) New Master's document is made. D) New data typed. Show Answer Correct Answer: A) Both files are connected. 16. Unique address of a cell that is the coordinate of the intersection of a row and a column: A) Entry bar. B) Cell reference. C) Name box. D) None of the above. Show Answer Correct Answer: B) Cell reference. 17. How do you insert a new row in Excel? A) Right-click on an existing row and select 'Insert Row'. B) Use the shortcut Ctrl + R. C) Select the 'New Row' option from the Home tab. D) Drag the bottom edge of an existing row downwards. Show Answer Correct Answer: A) Right-click on an existing row and select 'Insert Row'. 18. Where are the buttons for common tasks such as saving, printing, and spelling located in Excel? A) Title Bar. B) Row. C) Toolbar. D) Bar menu. Show Answer Correct Answer: C) Toolbar. 19. What function offers you the possibility to view different results depending on the entered condition? A) =if(). B) = sumif (). C) =sum(). D) = TRUEFALSE (). Show Answer Correct Answer: A) =if(). 20. Below that is not a number processing software (spread sheet) is ..... A) Lotus 123. B) Start office spreadsheet. C) Open office.org Calc. D) Microsoft Outlook. E) Microsoft Excel. Show Answer Correct Answer: D) Microsoft Outlook. 21. The address of the web page is called ..... A) HTTP. B) HTML. C) UTP. D) URL. Show Answer Correct Answer: D) URL. 22. ..... analysis is done on a range of cells that displays how changing one or two variables affects the results. A) Solver. B) Data Table. C) Goal seek. D) Sub total. Show Answer Correct Answer: B) Data Table. 23. Compound formulas are used when only one operator is used to perform calculations A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 24. You can perform calculations in Excel using formulas. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 25. When entering text in Excel, it is automatically (by default): A) Left Justified. B) Right Justified. C) Center Justified. D) Full Justified. Show Answer Correct Answer: A) Left Justified. ← 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