This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 47 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 47 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Referencing in =$ B3+B$ 4 formula is A) Absolute. B) Relative. C) Mixed. D) Proper. Show Answer Correct Answer: C) Mixed. 2. For writing formulas in Ms.Excel starts with a sign ..... A) +. B) =. C) #. D) *. Show Answer Correct Answer: B) =. 3. To apply formatting on cells, select the option "Cells" from ..... menu A) Edit. B) Format. C) Home. D) Allignment. Show Answer Correct Answer: B) Format. 4. The box on the MS.Excel worksheet that is lined up is marked by a number called ..... A) Line. B) Sel. C) Grid. D) Sheet. Show Answer Correct Answer: A) Line. 5. Copy files, texts, or objects using ..... A) Paste. B) Copy. C) Cut. D) Find. Show Answer Correct Answer: B) Copy. 6. Which option allows you to apply a format to a cell or a range of cells based on certain criteria? A) Number Formats. B) Conditional Formatting. C) Percent Style. D) Cell Formats. Show Answer Correct Answer: B) Conditional Formatting. 7. The bar that displays the data being entered in the active cell: A) Status bar. B) Entry bar. C) Windows Task Bar. D) None of the above. Show Answer Correct Answer: B) Entry bar. 8. The active cell group is mentioned A) Range Cell. B) Cell address. C) Kolom Cell. D) Cell line. Show Answer Correct Answer: A) Range Cell. 9. The ..... function is used to determine how many pupils were able to get a passing score in a test. A) COUNT. B) Counta. C) Countif. D) COUNTBLANK. Show Answer Correct Answer: C) Countif. 10. To enter the delivery destination, for example name and address entrance to the sub menu ..... A) Edit recipient. B) Start mail merge. C) Insert merge field. D) Preview results. E) Finish and merge. Show Answer Correct Answer: C) Insert merge field. 11. The name of the cell is determined by the name of the row and the column intersecting, such as A8. A) Formula. B) Formula Bar. C) Cell Address. D) Cell Grid. Show Answer Correct Answer: C) Cell Address. 12. Below that is not included in the statistical function is ..... A) =if(). B) Max(). C) =min(). D) =count(). E) =sum(). Show Answer Correct Answer: A) =if(). 13. A ..... IS A MEETING POINT OF A ..... AND A ..... A) CELL-ROW-FILE. B) CELL-COLUMN-ROW. C) CELL-WORKSHEET-WORKBOOK. D) CELL-TAB-GROUP. Show Answer Correct Answer: B) CELL-COLUMN-ROW. 14. Click ..... group in DESIGN tab to move a chart to a new worksheet. A) Location. B) Data. C) Type. D) Layouts. Show Answer Correct Answer: A) Location. 15. The number processing application issued by IBM is ..... A) Gnumeric. B) Xxl. C) Ms Excel. D) Lotus 123. Show Answer Correct Answer: D) Lotus 123. 16. What part of Microsoft Excel Window is a text field where you can enter words and phrases about what you want to do next and quickly get to features you want to use or actions you want to perform? A) Quick Access Toolbar. B) Formula Bar. C) Tell Me. D) File Tab. Show Answer Correct Answer: C) Tell Me. 17. What is the column header name for 28th Column A) Z. B) AB. C) AA. D) BA. Show Answer Correct Answer: B) AB. 18. Numbers on the side, run horizontally A) Column. B) Row. C) Cell. D) None of the above. Show Answer Correct Answer: B) Row. 19. Features to create a table of contents on Ms.Word is called ..... A) Table Of Content. B) Recording. C) Merge Cell. D) Mail Merge. E) Mailings. Show Answer Correct Answer: A) Table Of Content. 20. In the intercourse, can we find clipart tools? A) Insert. B) Page Layout. C) File. D) Design. Show Answer Correct Answer: A) Insert. 21. What do you mean by the term workbook, in MS Excel? A) It is a collection of excel files. B) Collection of cells. C) Collection of rows and columns. D) Collection of worksheets. Show Answer Correct Answer: D) Collection of worksheets. 22. The letters in Excel represent the ..... A) Rows. B) Columns. C) Cells. D) Data. Show Answer Correct Answer: B) Columns. 23. Spreadsheet rows are easily identified by: A) Numbers. B) Letters. C) Roman numerals. D) Colors. Show Answer Correct Answer: A) Numbers. 24. The last column name in a worksheet is A) XFD. B) FXD. C) Dfx. D) FXD. Show Answer Correct Answer: A) XFD. 25. Google Drive Function? A) Creating Excel Documents. B) Saving offline documents. C) Save documents online. D) Print documents. Show Answer Correct Answer: C) Save documents online. ← 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