### 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

A passionate blogger and author of this website having 10+ years of experience in education sector as a CS faculty. His expertise in Python, C++, Java, MySQL, MongoDB and Artificial intelligence. […]

Comments are closed.