Global MCQ Practice

🌐 Total MCQ
🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books

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

Quiz Instructions

Select an option to see the correct answer instantly.

1. Where are the buttons for common tasks such as saving, printing, and spelling located in Excel?
2. What function offers you the possibility to view different results depending on the entered condition?
3. Below that is not a number processing software (spread sheet) is .....
4. The address of the web page is called .....
5. ..... analysis is done on a range of cells that displays how changing one or two variables affects the results.
6. Compound formulas are used when only one operator is used to perform calculations
7. You can perform calculations in Excel using formulas.
8. When entering text in Excel, it is automatically (by default):
9. One terabyte (1 TB) is equal to
10. On an Excel sheet the active cell is indicated by:
11. What do you call a statement that requires a computation?
12. The source of the data is .....
13. What is the name of a computer program used for organising information in rows and columns?
14. To calculate the average using the formula
15. WWW stands for .....
16. Spreadsheet Software is a program that lets you organize data in rows and columns.
17. Which is the correct symbol to use when multiplying in a spreadsheet?
18. The function used to take several characters in the middle of the text data
19. Numbers in Excel is automatically aligned .....
20. Formula = Count (50:50:50:50:50:50) is
21. Microsoft Excel has a worksheet called .....
22. A "page" within an Excel workbook that contains columns, rows, and cells.
23. Toolbar which contains several groups and consists of several commands such as home, insert, view, etc.
24. Toolbar icons that work to combine cells are .....
25. Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is
26. The sum function
27. Audio visual presentation
28. MS Program.Excel is more suitable for .....
29. The command to insert the column is .....
30. Shortcut key to insert new worksheet is
31. You accidentally erased a record in the sheet. What command can be used to restore it immediately?
32. The process of joining text values in a sequence within a formula is called .....
33. What do we call the currently selected cell with thick green borders?
34. Rolling one screen to the right on Ms.Excel we can use the command via the keyboard that is the button .....
35. Status bar shows the name of the currently selected command or current activity.
36. You can only work in one cell at a time. The actual cell that you are working in is called what?
37. What kind of tools do we choose to make diagrams on ms.word?
38. One of the functions of Mail Merge is, making a letter with a format ..... but the variable is .....
39. This data type can be any type like whole integers or with decimals.
40. ..... are predefined formulas thatperform calculations using specific values in a particular order.
41. A collection of web pages is called a .....
42. What is the pictorial representation of worksheet data?
43. A worksheet contains ..... columns.
44. How is the COLUMN in a MS Excel Spreadsheet named?
45. What function do you press to center a title in 5 cells in one row?
46. Combining cells in Excel using .....
47. What feature is particularly useful when you want to add all numbers in a row or column
48. A word processing software developed by Microsoft.
49. The commands that belong to the quick access toolbar are Save, Undo and .....
50. If you don't want a cell reference to change when copied to other cells, use ..... references
51. Apart from the Mailings itself, we can create a database in other programs, namely
52. What is a formulas in excel sheet
53. Title bar displays the address of the active cell.
54. In addition to the MS.OnFice application to make a chain letter we can use the application from Google, namely .....
55. What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.
56. Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?
57. To count both numbers and text based data's, ..... function is used.
58. In a fraction the number at the top is called numerator while the number below is called
59. Quick Access Toolbar & Status Bar are available in Top of the Excel sheet
60. ..... resizing markers are present on the borders of chart to resize a chart.
🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books