# MCQ Electronic Spreadsheet Class 9 IT

### MCQ Electronic Spreadsheet Class 9 IT

1. In a spreadsheet, letters are used to represent _____________

a) Cells

b) Rows

c) Columns

d) Blocks

a) Cells

2. A numeric data analysis tool that allows us to create a computerized ledger.

a) Word processing package

b) Mathematical package

c) Graphics package

a) do calculations

b) create graphics

c) plot graphs

d) plot charts

b) create graphics

4. An easier way to set up complicated calculations.

a) Functions

b) Fractions

c) Booleans

d) Fractions

a) Functions

5.  ______________ help us to see patterns.

a) Charts

b) Graphs

d) Calculations

a) Charts

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

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

a) formula bar

8. By default, worksheets that are present in a computer excel workbook are

a) 10

b) 4

c) 3

d) None

c) 3

9. In a computer spreadsheet, absolute cell reference can be represented as

a) B3

b) \$B\$3

c) B\$3

d) \$B3

b) \$B\$3

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

a) active cell

11. Vertical dimension of a computer spreadsheet is called

a) row

b) column

c) record

d) field

b) column

12. Which of the following isn’t a part of a spreadsheet?

a) row number

b) column number

c) column letter

b) column number

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

d) Alignment

14. In a computer spreadsheet, block of cells is called

a) range

b) column

c) workbook

d) function

a) range

15. In computer spreadsheet, a workbook is a group of

a) many rows

b) many columns

c) worksheet

d) least number of column

c) worksheet

16. Faster way to change horizontal alignment in a computer document is

a) align left

b) center

c) align right

d) all of these

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

c) Formula

18. A block of cells is called:

a) Function

b) Calculation

c) Formula

d) Range

d) Range

19. Title bar in MS-Excel displays name of the

a) worksheet

b) workbook

c) formula

d) location

b) workbook

20. In a computer, cell’s address that is included in range C5:E7 is

a) C8

b) D6

c) E4

d) D9

b) D6

21. In a computer, correct row address is

a) AA

b) 25

c) 3B

d) C5

b) 25

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

b) 15,00

23. In a computer spreadsheet, a preprogrammed Formula is basically a

a) function

b) cell

c) graph

d) range

a) function

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

a) page setup dialog box

25. In a computer, graphics representation of data is named as

a) chart

b) graphics

c) picture

d) figure

a) chart

26. Which of the following isn’t a part of a spreadsheet?

a) row number

b) column number

c) column letter

b) column number

a) do calculations

b) create graphics

c) plot graphs

d) plot charts

b) create graphics

28. An easier way to set up complicated calculations.

a) Decimals

b) Fractions

c) Booleans

d) Functions

d) Functions

29. The cell that is in use.

a) Active cell

b) Highlighted cell

c) Main cell

d) Formula cell

a) Active 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

a) Alignment

31. A change in the appearance of a value or label in a cell.

a) Alteration

b) Format

c) Indentation

d) Design

b) Format

32. An entry in a spreadsheet cell representing wages or test scores is most likely a

a) label

b) value

c) formula

d) calculation

b) value

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

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

b) fill handler

35. In a computer spreadsheet, value of formula (7- 3)x(1+6)/4 is

a) 7

b) 12

c) 1.5

d) None

a) 7

36. In a computer spreadsheet, first part of number format describes

a) text values

b) negative number

c) positive number

d) zero values

c) positive number

37. Extension of computer MS-Excel file is

a) .wrd

b) .xls

c) .doc

d) .jpg

b) .xls

38. Cell in a computer spreadsheet that contain a formula or function will show

a) formula or function

c) resulting display value

d) range

c) resulting display value

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

c) counting

40. Main window in a computer spreadsheet is called

a) work sheet

b) work

c) account book

d) work 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

a) text values

42. In a computer spreadsheet, each cell contain a

a) formula

b) value

c) label

d) all of these

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

c) 1

44. In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of

a) functions

b) calculations

c) formulas

a) functions

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

a) A3:G3

46. Actual working area of computer’s Microsoft Excel is

a) worksheet

b) workbook

c) notesheet

d) notebook

a) worksheet

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

c) label

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

c) one

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

a) Alignment

50. The cell that is in use.

a) Highlighted cell

b) Main cell

c) Active cell

d) Formula cell

c) Active cell

51. A change in the appearance of a value or label in a cell.

a) Alteration

b) Format

c) Indentation

d) Design

b) Format

52. Absolute reference is created by adding:

a) \$ sign

b) * Siggn

c) @ Sign

d) # Sign

a) \$ sign

53. The tool used for constructing a formula is called:

a) FormulaFilter

b) Formula Painter

c) Formula Bar

d) Formula Wizard

c) Formula Bar