Spreadsheet important MCQs in English/Hindi | Nielit Notes | PDF

In this post, we cover all important Questions from the topic "Spreadsheet".

These MCQs will definitely help to pass IT and Computer students in any exam and interview that have a Spreadsheet topic.

The Spreadsheet chapter covers the following topics:

1. Elements of Spread Sheet, Creating of Spread Sheet.

2. Concept of Cell Address[Row and Column] and selecting a Cell.

     Entering Data [text, number, date] in Cells.

3. Page Setup, Printing of Sheet, Saving Spreadsheet, Opening and Closing,

    Manipulation of Cells & Sheet.

4. Modifying / Editing Cell Content , Formatting Cell (Font, Alignment, Style ).

5. Cut, Copy, Paste & Paste Special, Changing Cell Height and Width.

6. Inserting and Deleting Rows, Column, AutoFill, Sorting & Filtering.

7. Freezing panes, Formulas, Functions and Charts, Using Formulas for Numbers          (Addition, Subtraction, Multiplication & Division),

8. AutoSum, Functions (Sum, Count, MAX, MIN, AVERAGE),Sort, Filter, Advanced           Filter.

9. Database Functions ( DSUM, DMIN,DMAX, DCOUNT, DCOUNTA), What-if                     Analysis, Pivot table Charts (Bar, Column, Pie, Line).

After completion of the Spreadsheet unit, Students are expected to be familiar with the:

• Basic Knowledge of Spreadsheet Processing, their usage, details of Spreadsheet screen.
• Opening, saving and printing a Spreadsheet
• Spreadsheet creation, inserting and editing data in cells, sorting and filtering of data.
• Inserting and deleting rows /columns.
• Applying basic formulas and functions.
• Preparing charts to represent the information in a pictorial form.

Spreadsheet important MCQs

Here are the 63 most important and frequently asked MCQs from the  "Spreadsheet" topic.

1. Shortcut key for reach to last edit cell in LibreOffice calc?

a) Ctrl+Home 

b) Alt+Ctrl+O

c) Ctrl+End 

d) Ctrl+H

Ans.c) Ctrl+End 

2. How many number of columns are in the LibreOffice Calc Spreadsheet?

a) 1000

b) 1024

c) 1020

d) 1025

Ans.b) 1024

3. Output of the Calc expression is =100/10/2 .

a) 25 

b) 50

c) 5 

d) 200

Ans.c) 5 

4. Which shortcut key is used to insert a cell in LibreOffice Calc?

a) Ctrl+-

b) Ctrl+=

c) Ctrl++

d) Ctrl+|

Ans.c) Ctrl++

5. Shortcut key used to opens the Function Wizard in LibreOffice Calc.

a) Alt + F1 

b) Ctrl +F6

c) F2 

d) Ctrl+F2

Ans.d) Ctrl+F2

6. The files that are created with Spreadsheet software are called

a) Package

b) Program

c) Worksheet

d) Spreadsheet

Ans.c) Worksheet

7. ............................ option is found in Edit Menu in LibreOffice Calc.

 a) Find

 b) Replace

 c) Share

 d) Both Find & Replace

Ans.d) Both Find & Replace

8. What is the minimum font size in LibreOffice Calc?

a) 1

b) 2

c) 3

d) 5

Ans.b) 2

9. The combination of the column letter and row number for a cell in a Calc spreadsheet is called.

a) Cell across

b) Cell identification number

c) Cell reference

d) Cell identify

Ans.c) Cell reference

10. Which shortcut key is used to delete a cell?

a) Ctrl+-

b) Ctrl++

c) Ctrl+=

d) Ctrl+|

Ans.a) Ctrl+-

11. Which is used to calculate and analyze a set of numbers?

a) Improve

b) StarCalc

c) Spreadsheet

d) Database

Ans.c) Spreadsheet

12.  Key used to Opens Manage Template in LibreOffice Calc.

a) Ctrl + Shift+N 

b) Ctrl + T

c) Ctrl + F1 

d) Ctrl + O

Ans.a) Ctrl + Shift+N

13. ............... is used to highlight cells containing numeric valuses.

 a) Ctrl+F7

 b) Ctrl+F6

 c) Ctrl+F8

 d) Ctrl+F5

Ans. c) Ctrl+F8

14.  Extension of LibreOffice calc spreadsheet.

a) .ods 

b) .xlx

c) .odp 

d) .odt

Ans.a) .ods

15. The LibreOffice Calc is similar to Microsoft Excel, with almost the same abilities.

a) True

b) False

Ans.a) True

16. What is the maximum number of Characters in one cell in the calc spreadsheet?

a) 32767 

b) 1024

c) 6000 

d) 255

Ans.a) 32767

17. Which shortcut key is used to insert a comment in LibreOffice Calc?

a) Ctrl+Alt+C

b) Ctrl+Shift+J

c) Ctrl+Alt+S

d) None of the above

Ans.a) Ctrl+Alt+C

18.  How many spreadsheets are on Libreoffice calc by default?

a) 2 

b) 3

c) 1 

d) 0

Ans.c) 1 

19.  In the LibreOffice package, a spreadsheet is called ...............

a) Excel

b) Row

c) Column

d) Calc

Ans.d) Calc

20.  ______________ help us to see patterns.

a) Spreadsheets

b) Calculations

c) Charts

d) Graphs

Ans. c) Charts

21. In a computer spreadsheet, formula that equates to 6 is

a. 9-2×3+4/2

b. 1+2×3-8/2

c. 8-2×3+8/2

d. 2×3-4/2

Ans.c.

22.  What is the maximum number of cells per spreadsheet in calc?

a) 1073741824 

b) 1000

c) 6000 

d) 1,048,576

Ans.a) 1073741824 

23. The placement of information within a cell at the left edge, right edge, or centered is :

a. Alignment

b. Identification

c. Indentation

d. Placement

Ans.a.

24. Cells are identified by a combination of letters and numbers.

a) True

b) False

Ans.a

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

a) Word processing package

b) Spreadsheet package

c) Graphics package

d) Mathematical Package

Ans. b

26. Spreadsheets cannot:

a) do calculations

b) create graphics

c) plot graphs

d) plot charts

Ans. b

27. The placement of information within a cell at the left edge, right edge, or centered is :

a. Alignment

b. Identification

c. Indentation

d. Placement

Ans.a.

28. The cell that is in use.

a) Highlighted cell

b) Main cell

c) Active cell

d) Formula cell

Ans. c

29.  . ............. menus are found in LibreOffice Calc.

a) 5

b) 6

c) 7

d) 9

Ans.d) 9

30. Extension of computer MS-Excel file is

a. wrd

b. xls

c. doc

d. jpg

Ans.b.

31. 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

Ans.c.

32. 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

Ans.c.

33. An easier way to set up complicated calculations.

a) Decimals

b) Fractions

c) Booleans

d) Functions

Ans. d

34. Main window in a computer spreadsheet is called

a. work sheet

b. work

c. account book

d. work book

Ans.d.

35. In a computer, fourth part of number format describes

a. text values

b. positive number

c. negative number

d. zero values

Ans.a.

36. In a computer spreadsheet, each cell contain a

a. formula

b. value

c. label

d. all of these

Ans.d.

37. In a computer spreadsheet, number of arguments which SUM function require are

a. 4

b. 3

c. 1

d. None

Ans.c.

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

a) Cells

b) Rows

c) Columns

d) Blocks

Ans.c

39. What is the maximum zoom percentage in LibreOffice Calc?

a) 100%

b) 200%

c) 400%

d) 500%

Ans.c) 400%

40. The placement of information within a cell at the left edge, right edge, or centered is :

a) Indentation

b) Placement

c) Identification

d) Alignment

Ans. d

41. Spreadsheets cannot:

a) do calculations

b) create graphics

c) plot graphs

d) plot charts

Ans. b

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

a) Alteration

b) Format

c) Indentation

d) Design

Ans. b

43. ______________ help us to see patterns.

a) Spreadsheets

b) Calculations

c) Charts

d) Graphs

Ans. c

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

a. functions

b. calculations

c. formulas

d. relative addressing

Ans.a.

45. Portrait is used to refer to page orientation which is ..........

a) flip

b) vertical

c) horizontal

d) upside down

Ans.b) vertical

46. 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

Ans.a.

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

a. worksheet

b. workbook

c. notesheet

d. notebook

Ans.a.

48. What will result from adding =A1+A2 to Calc?

a) ### 

b) 5

c) 1 

d) 0

Ans.d) 0

49. 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

Ans.c.

50. In a computer spreadsheet, number of arguments in SQRT function are

a. equal to column no

b. equal to range

c. one

d. two

Ans.c.

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

a) row number

b) column number

c) column letter

d) cell address

Ans. b

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

a. Alteration

b. Format

c. Indentation

d. Design

Ans.b.

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

a. label

b. value

c. formula

d. calculation

Ans.b.

54. 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

Ans.d.

55. In a computer, element which is not a part of chart is

a. plot area

b. fill handler

c. series

d. chart area

Ans.b.

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

a. 7

b. 12

c. 1.5

d. None

Ans.a.

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

a. text values

b. negative number

c. positive number

d. zero values

Ans.c.

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

a) row number

b) column number

c) column letter

d) cell address

Ans. b

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

a) Word processing package

b) Spreadsheet package

c) Graphics package

d) Mathematical Package

Ans. b.

60. An easier way to set up complicated calculations.

a) Decimals

b) Fractions

c) Booleans

d) Functions

Ans. d

61. The cell that is in use.

a) Highlighted cell

b) Main cell

c) Active cell

d) Formula cell

Ans. c

62. The placement of information within a cell at the left edge, right edge, or centered is :

a) Indentation

b) Placement

c) Identification

d) Alignment

Ans. d

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

a) Alteration

b) Format

c) Indentation

d) Design

Ans. b