MCQ Electronic Spreadsheet Class 9 IT
1. In a spreadsheet, letters are used to represent _____________
a) Cells
b) Rows
c) Columns
d) Blocks
2. A numeric data analysis tool that allows us to create a computerized ledger.
a) Word processing package
b) Mathematical package
c) Graphics package
d) Spread Sheet Package
3. Spreadsheets cannot:
a) do calculations
b) create graphics
c) plot graphs
d) plot charts
4. An easier way to set up complicated calculations.
a) Functions
b) Fractions
c) Booleans
d) Fractions
5. ______________ help us to see patterns.
a) Charts
b) Graphs
c) Spreadsheets
d) Calculations
6. In a computer spreadsheet, to choose built in function we used is
a) defined function
b) function finder
c) built in function
d) paste function
7. In a computer spreadsheet, tool used to construct formulas is called
a) formula bar
b) filter
c) auditing toolbar
d) format printer
8. By default, worksheets that are present in a computer excel workbook are
a) 10
b) 4
c) 3
d) None
9. In a computer spreadsheet, absolute cell reference can be represented as
a) B3
b) $B$3
c) B$3
d) $B3
10. Computer spreadsheet cell that is highlighted with a heavy border is a
a) active cell
b) cell containing a formula
c) locked cell
d) cell
11. Vertical dimension of a computer spreadsheet is called
a) row
b) column
c) record
d) field
12. Which of the following isn’t a part of a spreadsheet?
a) row number
b) column number
c) column letter
d) cell address
13. The placement of information within a cell at the left edge, right edge, or centered is :
a) Indentation
b) Placement
c) Identification
d) Alignment
14. In a computer spreadsheet, block of cells is called
a) range
b) column
c) workbook
d) function
15. In computer spreadsheet, a workbook is a group of
a) many rows
b) many columns
c) worksheet
d) least number of column
16. Faster way to change horizontal alignment in a computer document is
a) align left
b) center
c) align right
d) all of these
17. An entry in a spreadsheet cell like”=(B2+B)/2″ is be an example of:
a) Function
b) Calculation
c) Formula
d) Letters
18. A block of cells is called:
a) Function
b) Calculation
c) Formula
d) Range
19. Title bar in MS-Excel displays name of the
a) worksheet
b) workbook
c) formula
d) location
20. In a computer, cell’s address that is included in range C5:E7 is
a) C8
b) D6
c) E4
d) D9
21. In a computer, correct row address is
a) AA
b) 25
c) 3B
d) C5
22. In a computer, if custom format is #, # # # then 1500 will be displayed as
a) 150,00
b) 15,00
c) 1,500
d) 15,000
23. In a computer spreadsheet, a preprogrammed Formula is basically a
a) function
b) cell
c) graph
d) range
24. In a computer, page orientation is changed through
a) page setup dialog box
b) setup dialog box
c) paper dialog box
d) print dialog box
25. In a computer, graphics representation of data is named as
a) chart
b) graphics
c) picture
d) figure
26. Which of the following isn’t a part of a spreadsheet?
a) row number
b) column number
c) column letter
d) cell address
27. Spreadsheets cannot:
a) do calculations
b) create graphics
c) plot graphs
d) plot charts
28. An easier way to set up complicated calculations.
a) Decimals
b) Fractions
c) Booleans
d) Functions
29. The cell that is in use.
a) Active cell
b) Highlighted cell
c) Main cell
d) Formula cell
30. The placement of information within a cell at the left edge, right edge, or centered is :
a) Alignment
b) Identification
c) Indentation
d) Placement
31. A change in the appearance of a value or label in a cell.
a) Alteration
b) Format
c) Indentation
d) Design
32. An entry in a spreadsheet cell representing wages or test scores is most likely a
a) label
b) value
c) formula
d) calculation
33. Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as
a) decoration
b) data appearance
c) functions
d) charting
34. In a computer, element which is not a part of chart is
a) plot area
b) fill handler
c) series
d) chart area
35. In a computer spreadsheet, value of formula (7- 3)x(1+6)/4 is
a) 7
b) 12
c) 1.5
d) None
36. In a computer spreadsheet, first part of number format describes
a) text values
b) negative number
c) positive number
d) zero values
37. Extension of computer MS-Excel file is
a) .wrd
b) .xls
c) .doc
d) .jpg
38. Cell in a computer spreadsheet that contain a formula or function will show
a) formula or function
b) cell’s address
c) resulting display value
d) range
39. In a computer spreadsheet, function which is used to count numbers of entries in given range is called
a) length
b) counter
c) counting
d) count
40. Main window in a computer spreadsheet is called
a) work sheet
b) work
c) account book
d) work book
41. In a computer, fourth part of number format describes
a) text values
b) positive number
c) negative number
d) zero values
42. In a computer spreadsheet, each cell contain a
a) formula
b) value
c) label
d) all of these
43. In a computer spreadsheet, number of arguments which SUM function require are
a) 4
b) 3
c) 1
d) None
44. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of
a) functions
b) calculations
c) formulas
d) relative addressing
45. In a computer spreadsheet, cell range A3 through G3 should be keyed in as
a) A3:G3
b) A3 to G3
c) A3-G3
d) A3?.G3
46. Actual working area of computer’s Microsoft Excel is
a) worksheet
b) workbook
c) notesheet
d) notebook
47. An entry in a spreadsheet cell like “Monthly Wages” or “Final Approval Rating” would most likely to be a
a) calculation
b) value
c) label
d) formula
48. In a computer spreadsheet, number of arguments in SQRT function are
a) equal to column no
b) equal to range
c) one
d) two
49. The placement of information within a cell at the left edge, right edge, or centered is :
a) Alignment
b) Identification
c) Indentation
d) Placement
50. The cell that is in use.
a) Highlighted cell
b) Main cell
c) Active cell
d) Formula cell
51. A change in the appearance of a value or label in a cell.
a) Alteration
b) Format
c) Indentation
d) Design
52. Absolute reference is created by adding:
a) $ sign
b) * Siggn
c) @ Sign
d) # Sign
53. The tool used for constructing a formula is called:
a) FormulaFilter
b) Formula Painter
c) Formula Bar
d) Formula Wizard
Comments are closed.