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

Quiz Instructions

Select an option to see the correct answer instantly.

1. Excel would be the ideal program to type out a book report.
2. A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
3. What is the extension of the MS-Excel 2016 file?
4. Which character is used in a spreadsheet formula to represent division?
5. IT LETS YOU ENTER OR EDIT DATA, FORMULA OR A FUNCTION IN ANY CELL.
6. We use this to 'lock in' a value in a cell so that replicating formula is accurate.
7. What symbol should be used to perform an adding calculation?
8. All functions on Google Sheet begin with symbols?
9. Which shows the beginning and end of a flowchart, is .....
10. Sort the contents of the cell from small up or a-z called
11. The steps to keep the workbook are .....
12. Rows on a spreadsheet are identified by a .....
13. What is correct way to find sum of two cells "a1" and "b1" ?
14. Who is the developer of MS Excel?
15. ..... allows you to perform calculations on data entered into a spreadsheet?
16. The area where the writing excel formula is disbut .....
17. Adding a new worksheet can be done using a shortcut .....
18. We use ..... format to add money symbols ($ , SAR, LBP ..... )
19. Cell J14 is .....
20. Which co-operation developed MS-Excel?
21. If you type =2*(6-4) in cell A1, what will be the display value?
22. There are ..... modes of the screen in BASIC.
23. What symbol is used for subtraction (take away)?
24. Example of spreadsheet software
25. This is an act of creating, editing, and producing a text document.
26. MS Excel is the most widespread ..... package.
27. Facilitate the making of a large amount of letters is .....
28. 30-Spreadsheets (Excel) are used by Painters while drawing tables
29. The key combination used to move to the first cell:
30. In compiling a program, the first step that must be taken is .....
31. The keyboard combination used to store new documents is .....
32. Horizontal line of cells
33. An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
34. How to activate the absolute address is
35. What does the mouse look like in a spreadsheet?
36. The function used to get a value of a table vertically is called function .....
37. Which function can find the highest value in a cell range?
38. How to open a workbook that has been saved in the way .....
39. Using the ..... feature, sum of the numbers can be calculated easily.
40. Row headings are represented by .....
41. Below that includes the MS-Excel Worksheet is, except .....
42. Which menu tab contains the font option in excel 2016?
43. Spreadsheet can perform calculations.
44. What type of chart will you use to compare performance of two employees in the year 2016?
45. In spreadsheet, the formula starts with an equal sign.
46. Where can we find the tabs, groups, and commands in the MS Excel window?
47. The number of rows and columns in Microsoft Excel 2013 is .....
48. Multiple Worksheet makes a .....
49. Each box in the spreadsheet is called?
50. Short key to save as on an excel worksheet is
51. The function in the excel used calculates the number of a group of values .....
52. ..... function is used to find the maximum value
53. Paying your bills on time will help you increase your credit score
54. Which formula would you use to calculate how many sales are over $ 20 from a series.
55. What do you call the document created using spreadsheet program?
56. Ctrl + S button, functioning for
57. (*) The sign is a sign of the calculation operation .....
58. Which formula would you use to multiply cell B4 by cell C4?
59. Use to create words and pictures for presentation of information.
60. Ctrl + C and Ctrl + P in Microsoft Power Point, Microsoft Excel and Microsoft Word are functioning as