Here you will find the most important 11th class Computer Science solved exercise MCQs with answers from chapter 9 (Spreadsheet Software). All the correct answers have been bold.
1st Year Computer Chapter 9 MCQs With Answer
Here are the mcqs of first-year computer science Chapter 9 Spreadsheet Software:
1. Which of the following is a spreadsheet?
a. MS Word
b. MS Excel
c. MS PowerPoint
d. None
2. The actual working area in Microsoft Excel is:
a. Workbook
b. Worksheet
c. Spreadsheet
d. Notesheet
3. Which of the following is an absolute address
a. A1
b. A1$
c. $A$1
d. $A1
4. Formula can only be applied on:
a. Values
b. Labels
c. Unmerged cells
d. None
5. Which of the following functions is used to get the current date?
a. Exact()
b. Today()
c. Month()
d. Year()
6. Which of the following is spreadsheet software?
a. LOTOUS 123
b. MS Excel
c. a and b
d. Word
7. Another name for an electronic spreadsheet is:
a. Workbook
b. Worksheet
c. Document
d. Database
8. How many worksheets are contained in a workbook by default?
a. 3
b. 4
c. 5
d. 1
9. The extension of the MS Excel file is:
a. wrd
b. xls
c. jpg
d. doc
10. The default name of the first worksheet in a workbook is:
a. First sheet
b. Sheet 1
c. Sheet one
d. One
11. The title bar in MS Excel displays the names of the:
a. Worksheet
b. Workbook
c. Formula
d. Location
12. A spreadsheet is a grid of:
a. Rows
b. Columns
c. Rows and columns
d. Lines
13. The horizontal dimension of a spreadsheet is called:
a. Dimension
b. Cell
c. Row
d. Column
14. The vertical dimension of a spreadsheet is called:
a. Field
b. Record
c. Row
d. Column
15. The intersection of a row and a column is called:
a. Intersection
b. Cell
c. Field
d. Address
16. Each cell in a spreadsheet has a unique:
a. Row
b. Column
c. Address
d. a and b
17. The columns in a spreadsheet are labeled by:
a. Letters
b. Numbers
c. Cell references
d. Digits
18. The rows in a spreadsheet are labeled by:
a. Letters
b. Numbers
c. Cell references
d. Digits
19. The combination of letters and numbers such as A5, B9, D15 refers to:
a. Row identifier
b. Cell address
c. Function
d. Formula
20. A spreadsheet cell highlighted with a heavy border is the:
a. Active cell
b. Absolute Cell
c. Locked cell
d. Passive cell
21. Which of the following is a correct cell address?
a. AA
b. 25
c. 3B
d. C5
22. Which of the following is a correct row address?
a. AA
b. 25
c. 3B
d. C5
23. Which of the following is a correct column address?
a. AA
b. 25
c. 3B
d. C5
24. Each cell can contain a:
a. Label
b. Value
c. Formula
d. All of the above
25. The row numbers used in a spreadsheet are called:
a. Labels
b. Reference
c. Formulas
d. Values
26. The data in a spreadsheet cell representing wages or test scores should be a:
a. Calculation
b. Value
c. Formula
d. Label
27. An entry in a spreadsheet cell-like “Monthly Wages” or “Final Approval Rating” would most likely be a:
a. Label
b. Calculation
c. Formula
d. Value
28. An entry in a spreadsheet cell-like “=(B2+B3)/2” is be an example of a:
a. Label
b. Value
c. Formula
d. Function
29. The cell that contains a formula or function will show:
a. Formula or function
b. Cell’s address
c. The result value
d. Range address
30. B2:E3 is an example of a cell:
a. Range
b. Location
c. Command
d. Style
