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

## No comments: