Electronic Spreadsheet MCQ Class 10 with answer

Electronic Spreadsheet MCQ Class 10 with answer

In this section we will cover unit 2 Electronic Spreadsheet Multiple choice questions for CBSE Class 10 Information Technology (402).  

 

1. Computer spreadsheet cell that is highlighted with heavy border is :

a) Active cell

b) Passive cell

c) Locked cell

d) Formatted cell

 

2. Rohan selected the 4th row and 3rd column in a spreadsheet. Then what is the cell address?

a) 3C

b) C3

c) 4C

d) C4

 

3. Data available in other sheets in a workbook , can be consolidate by :

a) Row label

b) Column Label

c) Both a & b

d) None of the mentioned

 

4. Macros must be saved with extension in MS Excel:

a) .xls

b) .xlsm

c) .vba

d) .xlsx

 

5. Which programming language does VBA is based on :

a) Visual Basic

b) Visual studio

c) Visual Base

d) Visual .Net

 

6. Which of the following is not a type of referencing in a spreadsheet?

a) Absolute

b) Physical

c) Relative

d) Mixed

 

7. Shortcut to open the list of recorded Macros in MS Excel are

a) Alt+F8

b) Alt+F5

c) Alt+F4

d) Alt+F7

 

8. Macros options is available in Openoffice (Oo) Calc in which tab:

a) Insert

b) Tools

c) Data

d) Format

 

9. In Data consolidate what are the operations we can perform___

a) Sum

b) Average

c) Max

d) All of the above

 

10. In a Subtotal function what are the functions can be performed on the group of cells:

a) Sum

b) Count

c) Average

d) All of the above

 

11. To edit a Scenario, right click the name in the Navigator and select________.

a) Properties

b) Scenario ✓

c) Window

d) Edit

 

12. A_________ is a What if Analysis tool that allows you to substitute set of values automatically in a worksheet.

a) Navigator

b) Scenario ✓

c) Subtotal

d) Goal Seek

 

13. Goal Seek command is found in_________

 a) Data

b) Tools ✓

c) Format

d) Edit

 

14. Shortcut to Navigator is ______

a) F10

b) F8

c) F6

d) F5 ✓

 

Electronic Spreadsheet Class 10 MCQ

15. Rename option is present under Sheet option of____ menu.

a) Insert

b) Data

c) Format ✓

d) Edit

 

16. To refer a cell from another worksheet, use worksheet number followed by___________ sign and cell address.

a) period (.) ✓

b) equal (=)

c) colon (:)

d) semi colon (;)

 

17. To create a hyperlink to a webpage, FTP server of Telnet connection, click on________icon.

a) Internet Explorer

b) Document

c) Internet ✓

d) New Document

 

18. Hyperlink icon is present in ____toolbar.

a) Formattin

b) Hyperlink

c) Drawing

d) Standard ✓

 

19. To remove a hyperlink, right- click on the hyperlink and select

a) Data Formatting

b) Absolute formatting

c) Default Formatting ✓

d) None of these

 

20. The Share Document option is present under _____menu.

a) Data

b) Tools

c) Format

d) Insert

 

#TRENDING

Important MCQ on Digital Documentation Class 10 IT

Imp0rtant MCQ on Database Management System Class 10 IT

 

 

21. To ______ the comment, hover the mouse pointer over the cell that has comment.

a) edit

b) view

c) hide

d) none of these

 

22. To password protect a worksheet, click on Edit → Changes →______

a) Password

b) Protect Records

c) Password Protect

d) Password

 

23. Comment option is present under______ menu.

a) Edit

b) File

c) Insert

d) Tools

 

24. Compare Document option is present under ________menu.

a) File

b) Data

c) Insert

d) Edit

 

25. The Record Macro option is present under _____menu.

a) Tools

b) Data

c) Format

d) Insert

Electronic Spreadsheet Class 10 MCQ

26. You can save time by_____ a series of action to create macro.

a) Joining

b) grouping

c) creating

d) none of these

 

27. Sort option is present under

a) Data menu

b) Insert menu

c) Edit menu

d) Format menu

 

28. To delete a Scenario, right click the name in the ________ window and select Delete.

a)Properties

b) Scenario

c) Navigator

d) None of these

 

29. Name the menu which is used to create scenarios.

a) File

b) Edit

c) Tools

d) Data

 

30. _________ hyperlink contains a full URL..

a) Absolute

b) Relative

c) Both (a) and (b)

d) none of these

 

#TRENDING

Solved Sample Paper Class 10 IT(402) Set-1 

Solved Sample Paper Class 10 IT(402) Set-2

 

31. __________ tab in the Accept or Reject changes dialog box is used to specify the filter criteria.

a)Tools

b)Data

c) Filter

d)Criteria

 

32. Which of the following option tells a summary of a macro in the macro dialog box?

a) Macro Name

b) Description

c) Buttons

d) List of macros

 

33. Spreadsheet software can find the changes by________ sheets.

a) adding

b)changing

c) differentiate

d) comparing

 

34. Which tool you can use in Calc to make an estimate of output values for different input values?

i)Multiple Operations

ii)Macros

iii) Scenarios

iv) Goal Seek

 

a) Only (i) and (iii)

b) only (ii) and (iv)

c) (i), (iii) and (iv)

d) All of the above

 

35. In spreadsheet, to apply Goal Seek your cell pointer must be in

a) The Changing cell whose value you need to find.

b) The Result Cell where formula is entered

c) The cell where your targeted value is entered

d) None of above

 

36.Which of the following tools deals with multiple unknown values?

a) Goal Seek

b) Scenario

c) Solver

d) Data Table

 

 

37. In Oo Calc , Which options should be used to accept/reject the changes in the shared sheet.

a) Edit->Accept

b) Edit->Changes->Record

c) Edit->Changes->show

d) Edit->Changes-Accept/Reject

 

38. What are the operation we can do on the shared documents

a) View the changes

b) Accept/Reject Changes

c) Edit the sheet

d) All of the above

 

 

39.  ____is the default extension of Openoffice calc.

a) .ode

b) .ods

c) .odh

d) .odg

 

40. In a spreadsheet,absolute reference will be referred to..

a) $A$4

b) $A4

c) A$4

d) A4

 

 

#TRENDING

Solved Sample Paper Class 10 IT(402) Set-1 

Solved Sample Paper Class 10 IT(402) Set-2

 

 

CASE STUDY QUESTIONS

41. Ramesh wants to solve one variable problem, Suggest him which of the data analysis tools is best suited for him.

a) Solver

b) Goal Seek

c) Scenario

d) Data table

 

42. Shovit wants to combine and find the sum/average of marks obtained by the students in the previous three periodic tests. The data is stored in various sheets of a workbook. Which of the following tools is best suited for him?

a) Data Range

b) Data Consolidation

c) Data Review

d) Data Merge.

43. Rakesh wants to apply a formula in the entire column of the spreadsheet,with respect to only one cell. What referencing he will use to get the correct result.

a) Relative Referencing

b) Absolute Referencing

c) Mixed Referencing

d) HyperLink

 

44. Sravan wants to do the same set of tasks to be done repeatedly like formatting or applying a similar formula in a similar range of data.Suggest him a suitable tool for that.

a) Goal Seek

b) Solver

c) Scenario

d) Macros

 

 

45. What is the shortcut key for row hide?

a) Ctrl + 9

b) Ctrl + F9

c) Shift + F9

d) Ctrl + shift + 9

 

 

45. What will do by filter?

a) Displays the records that meet the criteria

b) Displays only one record to delete

c) Modify all the records at once                           

d) All of the above

 

46. How many sheets are there in excel?

a) 3

b) Many                     

c) 2

d) 1

 

47. What happen when selecting record pressing delete key?

a) Row will be deleted                      

b) Content will be deleted

c) Row moves one step up

d) None of the above

 

48. What is the name of Excel File?

a) Workbook

b) Worksheet

c) Spread Sheet

d) Spread Book

 

49. What is the function of workspace?

a) Contain multiple workbooks

b) Contain multiple worksheets

c) Spread Sheet                              

d) Spread Book

 

50. What is there in Record?

a) Collection of Fields

b) Collection of Number

c) Collection of Rows

d) All

 

51. What happen when you cut in excel

a) The content of cell will be removed after paste

b) The value of cell will be remained after paste

c) The content of cell will not be removing

d) None of the above

 

52. You can create only a horizontal page break by first selecting

a) A row below the row where you want the page break to occur

b) A cell in Row 1

c) A cell in Column A

d) Both a. and b.

 

53. How many sheets will open when excel is loaded?

a) 3              

b) 5

c) 7

d) Unlimited

 

54. While typing, number in cell margin is

a) Right align

b) Justify

c) Left align

d) Center align

 

55. Workspace is a

a) collection of workbook

b) collection of sheet

c) collection of documents

d) all

 

56. Which character fixes row or column?

a) &

b) $

c) =         

d) @

 

57. What is integer value of 3/2+5*0.5+A1 where A1=0.75

a) 7.5

b) 5

c) =

d) 6

 

58. What would be content of A8 if A4 has count (A1:A7) and if A1=1, A2=2, A3=4, A11=12, A6=Blank, A7=Text

a) 7

b) 5            

c) 17

d) 29

 

59. To delete cell contents

a) Ctrl + d

b) Alt + d

c) Delete

d) Esc

 

60. Where is Merge Cell Tab allocated?

a) Alignment               

b) Font

c) Border

d) Number

 

#TRENDING

Important MCQ on Digital Documentation Class 10 IT

Imp0rtant MCQ on Database Management System Class 10 IT

 

61. The box which is appear right side of chart is called

a) Legend                 

b) Label                 

c) Series

d) Data marker

 

62. When you insert a column in excel when does the previous column moves?

a) Left side

b) Left most side

c) Right side

d) Right most side

 

63. Filter is available on

a) Tools menu

b) Record menu

c) Edit menu   

d) View menu

 

64. Table is

a) Row & Column

b) Field/Column

c) Row & Chart

d) None of above

 

65. The information of cell gives on

a) Formula bar

b) Name bar

c) Name box

d) Formatting bar

 

66. Charts holds all the information except

a) Legend

b) Data table

c) Axis

d) Data label

 

67. Merge is the process of

a) Combing                 

b) Splitting

c) Sending

d) Receiving

 

68. Which formula returns multiple calculations to a single formula?

a) Smart formula

b) Standard formula

c) Array formula

d) Complex formula

 

69. Types of filter are

a) Auto filter

b) Advanced filter

c) Standard filter

d) Both a and b

 

70. Function of Goal Seek

a) Method of finding input value

b) Method of finding input value to meet target

c) Method of accumulating data

d) All of the above

 

71. To arrange Name list in sequential order is

a) Format

b) Sorting

c) Order

d) List

 

 

72. The cell level F5 levels to

a) Function key F5

b) Row F Column 5

c) Column 5 Rows 5

d) Function available in cell

 

73. Which is an example of a formula in Ms-Excel?

a) =Sum(A1:A2)

b) =A1+A2               

c) A1+A2

d) =add(A1:A2)

 

74. How do you display current date and time in Ms Excel?

a) Time ()

b) Date ()

c) Today ()

d) Now ()

 

75. In Ms-Excel B7:B9 indicates

a) Cell B8 only         

b) Cell B7 and B9 only

c) Cell B7 through B9

d) None

 

76. Which of the following is a popular DOS based spreadsheet package?

a) Lotus 1-2-3             

b) Word   

c) Smart Cell

d) Excel

 

77. The intersection of row and column is called

a) An equation  

b) Data

c) A field

d) A cell

 

78. In MS Excel, what happens when dollar sign ($) are entered in a cell address? (ex $B$2: $B$10)

a) The status bar does not display the cell address

b) An absolute cell address in created         

c) The Sheet tab is changed

d) Cell address will change when it is copied to another cell

 

79. Which operator will combine text from two cells into one cell?

a) Space

b) & (ampersand)

c) = (equal)

d) None of the above

 

80. An excel workbook is a collection of

a) Worksheets and charts

b) Workbook

c) Worksheets

d) Charts

 

81. The default header for a worksheet is

a) The sheet tab name

b) Your name

c) The date and time

d) None of these

 

82. Which of the following is an absolute cell reference?

a) A1

b) !A!1

c) $A$1

d) #a#1

 

83. Which symbol must all formula begin with

a) @

b) =                

c) +

d) (

 

84. To add two cells (A1 and A2) together you use the following formula

a) A1 plus A2

b) =A1+A2

c) =add (A1+A2)

d) =together (A1:A2)

 

85. In an excel sheet the active cell is indicated by

a) A blinking border

b) A dark wide border

c) A dotted border      

d) None

 

 

86. You can create hyperlinks from the Excel workbook to

a) A webpage on company internet

b) A webpage on the internet

c) Other office 97 application documents

d) All of above

 

87. The advantage of using a spreadsheet is

a) Calculations can be done automatically

b) More flexibility

c) Changing data automatically updates calculations

d) All of the above

 

88. There as three types of data found in a spreadsheet

a) Numbers, formulas, labels    

b) Data, words, numbers

c) Equations, data, numbers

d) Words, numbers, labels

 

89. To merge the cells which tab do you use from the format, cells menu?

a) Merge tab

b) Number tab   

c) Alignment tab

d) Font tab

 

90. How do you rearrange the data in ascending or descending order?

a) Data, subtotals

b) Data, sort            

c) Data, form

d) Data, table

 

91. The default row height in a MS Excel worksheet is _________ points

a) 75              

b) 75

c) 75            

d) 75

 

92. Which of following formula is true in MS Excel?

a) B6+C6

b) =B6+C6          

c) A6+B6

d) A6+C6=

 

93. Which of the following is not a valid data type in Ms Excel?

a) Number

b) Character  

c) Label             

d) Date/time

 

94. In MS Excel, comments put in cells are called

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

 

95. Shortcut key to bring format cells dialog box is

a) Ctrl + F           

b) Ctrl + E

c) Ctrl + 1

d) Ctrl + D

 

96. The cell reference $A$5 is

a) Relative cell reference

b) Absolute cell reference

c) Mixed cell reference

d) None

 

97. ‘OR’ operator shows ‘True’ value when

a) all conditions are false

b) any one condition is true

c) both conditions are true

d) both b & c

 

 

98. Which of the following keystrokes lets you recalculate the formula?

a) F9  

b) F2

c) F7

d) F3

 

99. To return the remainder after a number is divided by a divisor in Excel we use the function

a) DIV ( )

b) ROUND ( )

c) FACT ( )

d) MOD ( )

 

100. Excel displays the current cell address in the

a) Title bar

b) Formula bar

c) Status bar

d) Name box

 

101. Which language is used to crate macros in excel?

a) Java

b) Visual Basic

c) Access

d) Visual C++

 

102. You can delete text by

a) Selecting the text and pressing the Ext key

b) Selecting the text and pressing the Ctrl key

c) Selecting the text and pressing the Delete key

d) Selecting the text and pressing the Alt + Page up key

 

103. Getting data from a cell located in a different sheet is called

a) Functioning

b) Accessing

c) Referencing

d) Updating

 

104. A numeric value can be treated as a label value if it precedes with

a) Ampersand (&)

b) Apostrophe (‘)

c) Exclamation (!)

d) Hash

 

105. Each excel file is a workbook that contains different sheets. Which of the following cannot be sheet in a workbook?

a) Work Sheet          

b) Chart Sheet             

c) Module Sheet

d) Data Sheet

 

106. You can auto fit the width of column by

a) Double clicking on the column name on column header

b) Double click on the cell pointer in worksheet

c) Double clicking on column right border on column header

d) Double clicking on the column left border of column header

 

107. What is the shortcut key to replace a data with another in sheet?

a) Ctrl + R

b) Ctrl + Shift + R

c) Ctrl + H

d) Ctrl + F

 

108. Formatting a cell in number format you can’t set

a) Decimal places

b) Use 1000 separator

c) Negative numbers

d) Currency symbol

 

109. Which of the following is invalid regarding the protection in Excel?

a) Protect Sheet

b) Protect Workbook

c) Protect Workspace

d) All of above

 

110. Which shortcut key is used to insert chart?

a) F10

b) F11             

c) F2

d) F8

 

111. Which is the correct cell address

a) 1A

b) $A              

c) 1#A

d) A1

 

112. Which of the following is/are available in consolidate dialog box?

a) Max            

b) Min

c) Count

d) All of the above

 

113. How can you format the cell?

a) Cell command    

b) Font command

c) Alignment command

d) Conditional formatting command

 

 

114. To paste range names into worksheet, choose

a) Insert, Name, Paste

b) Insert, Name, Define

c) Edit, Name, Paste

d) Edit, Name, Define

 

115. What is the function of [∑] tool in Excel Sheet?

a) AutoFormat

b) AutoText

c) AutoSum

d) AutoCorrect

 

116. To round a number down to a nearest integer, choose

a) ABS function

b) INT function

c) ABC function

d) INTEGER function

 

117. Which of the following is relative cell reference?

a) $C7                  

b) C7                 

c) C$7

d) $C$7

 

118. To filter the records, choose

a) Data, auto filter, filter

b) Tools, auto filter, filter

c) Data, filter, auto filter

d) Tools, filter, auto filter

 

119. Which of the following functions is a string function?

a) IF function

b) MAX function

c) DATE function

d) MID function

 

120. What is the short cut key to insert current date in a cell?

a) Ctrl + *

b) Ctrl +:

c) Ctrl +;      

d) Ctrl + Shift +;

 

121. Which of the following tabs is not available in Format Cells Dialog box in Excel?

a) Shading     

b) Border

c) Fonts

d) Protection

 

122. Function to get sum of the contents of the cells A1, A2, B1, and B2 is

a) =SUM (A1+A2+B1+B2)

b) =SUM (A1:B2)

c) =TOTAL (A1..B2)

d) =SUM (A1, B2)

 

123. Graphical representation of worksheet data

a) Pivot table

b) Goal seek    

c) Graph        

d) Scenario

 

124. What is the shortcut key to select entire row in Excel sheet?

a) Ctrl + Spacebar

b) Alt + Spacebar

c) Shift + Spacebar

d) Ctrl + Shift + Spacebar

 

125. In Excel worksheet the Name box

a) Appears to the right of the menu bar

b) Appears to the bottom of the menu bar

c) Appears to the left of the formula bar

d) Appears with status bar

 

126. You can add a hyperlink to your worksheet by pressing

a) Alt + K

b) Ctrl + H

c) Ctrl + K

d) Ctrl + Shift + K

 

127. Which command will you choose to convert a column of data into row?

a) Cut and Paste

b) Edit>>Paste Special>>Transpose

c) Both

d) None

 

128. Which of the following action removes a sheet from workbook?

a) Select the sheet, then choose Edit>>Delete Sheet

b) Select the sheet, then choose Format>>Sheet>>Hide

c) Both of the above

d) None of the above

 

129. Electronic spreadsheet is also known as

a) Data processor

b) Word processor

c) Presentation package

d) None

 

130. Type of data in a cell of a worksheet can be of

a) label

b) value

c) formula

d) all of the above

 

131. What do you use to create a chart?

a) chart wizard on toolbar

b) insert>chart on menu bar

c) insert>diagram on menu bar

d) both a and b

 

132. Arrange the information in the row and column is called

a) Table

b) Field                     

c) Record

d) Database

 

133. From which menu, you can hide sheet?

a) View

b) Insert

c) Format

d) Window

 

134. Which of the following is not related to Ms. Excel?

a) Row

b) Column

c) Lookup

d) Cell

 

135. What does it mean by Goal seek in spread sheet?

a) To draw the curve for given cell value

b) To determine the value of cell for given result

c) To omit the cell data for given graph

d) None of the above

 

 

 

#TRENDING

Important MCQ on Digital Documentation Class 10 IT

Imp0rtant MCQ on Database Management System Class 10 IT

 

Leave a Reply

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