Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 12 (60 MCQs)

Quiz Instructions

Select an option to see the correct answer instantly.

1. To Add up entries from D6 to D10, we use the formula?
2. The menu that must be chosen to widen or narrow the size of the column in the worksheet is .....
3. Rows are identified by .....
4. It is a collection of applications dedicated to help accomplish specific tasks.
5. What is basic file of MS Excel?
6. An individual box which contains data.
7. We can use this function to count the number of cells containing words/letters
8. Every formula starts with what?
9. In Excel, what are the individual boxes on the worksheet where you enter your data?
10. A media with an online system whose users can actively interact called .....
11. Function to find the average value of a range .....
12. ..... allows you to set a column's width to fit its content automatically.
13. The columns represent the .....
14. To quickly create a chart press ..... function key.
15. In an excel formula, it means substract
16. When creating a budget, ..... would be best the software program to use
17. What is meant by office applications?
18. Microsoft Word is a .....
19. What symbol is included in the formula in order for it to be computed?
20. ..... software helps us in maintaining a document in a presentable manner.
21. ..... are horizontal
22. Which one of the following is NOT a web browser?
23. The electronic spreadsheet made of cells and organized by rows and columns is Known as the .....
24. The name of a cell is given by the .....
25. Lina needs to make a reference to 5th row and 8 column. What should be the cell address?
26. The ..... is used to enter Predefined data.
27. In a spreadsheet program, which function allows your to add numbers?
28. Mail Merge function is useful for the manufacturing process .....
29. The intersection of a row and a column is called this.
30. Max in Ms.Excel formula for .....
31. Numbers down the left side of the spreadsheet.
32. What is the name of the spreadsheet software developed by Microsoft?
33. The tool for typing letters on a computer is .....
34. Cell is the intersection of .....
35. What does the CONCATENATE function do in Excel?
36. The Name box on to the left of formula bar
37. If some of the content is being cut off by the printer, you can use scaling to fit your workbook to the page automatically.
38. Pressing the ..... key opens the Save As dialog box.
39. Function to find the average in Excel?
40. To edit the contents of cell data as needed, the correct step is .....
41. A column is vertical.
42. The panel on the top of the excel window, just below the title bar, is known as .....
43. Currently selected cell, which is indicated by an outline around the cell.
44. A ..... is a collection of different worksheets.
45. The button to edit cells is .....
46. Click and drag the ..... tool to apply the same formula to neighboring cells.
47. The cell address is the combination of what two things?
48. It is an example of a spreadsheet program.
49. What does this symbol do:/
50. Intersection of rows and columns are called
51. To enter, repair and also display data or formulas in active cells is a function of
52. Spreadsheets have meaning .....
53. Where is the zoom function located in Excel?
54. Excel is a program that is used to prepare a
55. While entering a formula in cell we should start with .....
56. To start the formula in operating the number processing package is .....
57. What is the term used for cells which appear going across the spreadsheet?
58. In MS-Excel numeric value can be treated as a label value if it precedes with
59. In a spreadsheet, a column is denoted by .....
60. The ..... feature is used to extract data from a spreadsheetthat meets specific criteria quickly.