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

d) Spread Sheet Package

d) Spread Sheet Package

 

 

3. Spreadsheets cannot:

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

c) Spreadsheets

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

d) cell address

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

d) cell address

b) column number

 

 

27. Spreadsheets cannot:

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

b) cell’s address

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

d) relative addressing

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

 

One Reply to “MCQ Electronic Spreadsheet Class 9 IT”

Leave a Reply

Your email address will not be published. Required fields are marked *