1. News » 
  2. General » 
  3. IT Electronic Spreadsheet Class 10 MCQ With Answers: Find Out Class 10 IT Electronic Spreadsheet Questions And Answers

IT Electronic Spreadsheet Class 10 MCQ With Answers: Find Out Class 10 IT Electronic Spreadsheet Questions And Answers

IT Electronic Spreadsheet Class 10 MCQ With Answers-  MCQ refers to Multiple Choice Questions, which is a form of objective assessment in which respondents are asked to select only correct answers from the choices offered as a list. People are eagerly searching for IT Electronic Spreadsheet Class 10 MCQ With Answers. You can get to know IT Electronic Spreadsheet Class 10 MCQ With Answers on our website, under the information given below.   

by Divya M | Updated Nov 25, 2021 10:18 AM

IT Electronic Spreadsheet Class 10 MCQ With Answers: Find Out Class 10 IT Electronic Spreadsheet Questions And Answers
Source: Twitter

IT Electronic Spreadsheet Class 10 MCQ With Answers

The recent search among the people is about the electronic spreadsheet class 10 MCQ with answers. To know the electronic spreadsheet class 10 MCQ with answers, continue reading the information given on our website, under the information given below. Now get to know the electronic spreadsheet class 10 MCQ with answers in the information given below, on our website. No need to worry about the answers. You can also get the electronic spreadsheet class 10 MCQ online test on the same website under it electronic spreadsheet class 10 MCQ. You can get the MCQ of electronic spreadsheet class 10 under each question. Scroll down to get the IT Electronic Spreadsheet Class 10 MCQ With Answers.

Class 10 IT Spreadsheet MCQ Questions And Answers

The answers for IT Electronic Spreadsheet Class 10 MCQ are given in bold for the respective questions. 

Q1. What does it mean by Goal seek in a spreadsheet?

a) To draw the curve for a given cell value

b) To determine the value of a cell for a given result

c) To omit the cell data for a given graph

d) None of the above

a) Row

b) Column

c) Lookup 

d) Cell

Q3.From which menu, you can hide the sheet?

a) View

b) Insert

c) Format 

d) Window

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

a) Table 

b) Field                     

c) Record

d) Database

Q5. What do you use to create a chart?

a) chart wizard on the toolbar

b) insert>chart on the menu bar 

c) insert>diagram on the menu bar

d) both a and b

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

a) label

b) value

c) formula

d) all of the above

Q7. Electronic spreadsheet is also known as

a) Data processor

b) Word processor 

c) Presentation package

d) None

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

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

a) Alt + K

b) Ctrl + H

c) Ctrl + K

d) Ctrl + Shift + K

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

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

Q13.Graphical representation of worksheet data

a) Pivot table

b) Goal seek    

c) Graph 

d) Scenario

Q14.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)

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

a) Shading 

b) Border

c) Fonts

d) Protection

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

a) Ctrl + *

b) Ctrl +:

c) Ctrl +; 

d) Ctrl + Shift +;

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

a) IF function

b) MAX function

c) DATE function

d) MID function

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

Q19.Which of the following is relative cell reference?

a) $C7            

b) C7                 

c) C$7

d) $C$7

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

a) ABS function

b) INT function 

c) ABC function

d) INTEGER function

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

a) AutoFormat

b) AutoText

c) AutoSum 

d) AutoCorrect

Q22.To paste range names into worksheet, choose

a) Insert, Name, Paste

b) Insert, Name, Define

c) Edit, Name, Paste

d) Edit, Name, Define

Q23.How can you format the cell?

a) Cell command    

b) Font command

c) Alignment command 

d) Conditional formatting command

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

a) Max            

b) Min

c) Count

d) All of the above

Q25.Which is the correct cell address

a) 1A

b) $A              

c) 1#A

d) A1

Q26.Which shortcut key is used to insert chart?

a) F10

b) F11      

c) F2

d) F8

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

a) Protect Sheet

b) Protect Workbook

c) Protect Workspace 

d) All of above

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

a) Decimal places

b) Use 1000 separator

c) Negative numbers

d) Currency symbol

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

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

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

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

a) Ampersand (&)

b) Apostrophe (‘) 

c) Exclamation (!)

d) Hash

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

a) Functioning

b) Accessing

c) Referencing 

d) Updating

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

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

a) Java

b) Visual Basic

c) Access

d) Visual C++

Q36. Excel displays the current cell address in the

a) Title bar

b) Formula bar

c) Status bar

d) Name box

Q37.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 ( ) 

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

a) F9 

b) F2

c) F7

d) F3

Q39.‘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

Q40. The cell reference $A$5 is

a) Relative cell reference

b) Absolute cell reference

c) Mixed cell reference

d) None

Q41.Shortcut key to bring format cells dialog box is

a) Ctrl + F           

b) Ctrl + E

c) Ctrl + 1

d) Ctrl + D

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

a) Smart tip

b) Cell tip

c) Web tip

d) Soft tip

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

a) Number

b) Character

c) Label             

d) Date/time

Q44.Which of the following formulas is true in MS Excel?

a) B6+C6

b) =B6+C6         

c) A6+B6

d) A6+C6=

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

a) 65              

b) 75 

c) 85            

d) 95

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

a) Data, subtotals

b) Data, sort       

c) Data, form

d) Data, table

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

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

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

a) A webpage on company internet

b) A webpage on the internet

c) Other office 97 application documents

d) All of above 

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

Q52.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)

Q53.Which symbol must all formula begin with

a) @

b) =            

c) +

d) (

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

a) A1

b) !A!1

c) $A$1 

d) #a#1

Q55.The default header for a worksheet is

a) The sheet tab name

b) Your name

c) The date and time

d) None of these

Q56. An excel workbook is a collection of

a) Worksheets and charts 

b) Workbook

c) Worksheets

d) Charts

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

a) Space

b) & (ampersand) 

c) = (equal)

d) None of the above

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

Q59.The intersection of row and column is called

a) An equation  

b) Data

c) A field

d) A cell

a) Lotus 1-2-3         

b) Word   

c) Smart Cell

d) Excel

Q61.In Ms-Excel B7:B9 indicates

a) Cell B8 only         

b) Cell B7 and B9 only

c) Cell B7 through B9 

d) None

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

a) Time ()

b) Date ()

c) Today ()

d) Now ()

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

a) =Sum(A1:A2) 

b) =A1+A2               

c) A1+A2

d) =add(A1:A2)

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

Q65.To arrange Name list in sequential order is

a) Format

b) Sorting 

c) Order

d) List

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

Q67.Types of filter are

a) Auto filter

b) Advanced filter

c) Standard filter

d) Both a and b

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

a) Smart formula

b) Standard formula

c) Array formula 

d) Complex formula

Q69.Merge is the process of

a) Combing      

b) Splitting

c) Sending

d) Receiving

Q70.Charts holds all the information except

a) Legend

b) Data table 

c) Axis

d) Data label

Q71.The information of cell gives on

a) Formula bar

b) Name bar

c) Name box

d) Formatting bar

Q72.Table is

a) Row & Column

b) Field/Column

c) Row & Chart

d) None of above

Q73. Filter is available on

a) Tools menu

b) Record menu

c) Edit menu 

d) View menu

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

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

a) Legend            

b) Label             

c) Series

d) Data marker

Q76.Where is Merge Cell Tab allocated?

a) Alignment             

b) Font

c) Border

d) Number

Q77.To delete cell contents

a) Ctrl + d 

b) Alt + d

c) Delete

d) Esc

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

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

a) 7.5 

b) 5

c) =

d) 6

Q80.Which character fixes row or column?

a) &

b) $ 

c) =         

d) @

Q81.Workspace is a

a) collection of workbook

b) collection of sheet

c) collection of documents

d) all

Q82. While typing, number in cell margin is

a) Right align

b) Justify

c) Left align 

d) Center align

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

a) 3     

b) 5

c) 7

d) Unlimited

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

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

a) Active cell

b) Passive cell

c) Locked cell

d) Formatted cell

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

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

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

a) .xls

b) .xlsm 

c) .vba

d) .xlsx

Q89.Which programming language does VBA is based on :

a) Visual Basic 

b) Visual studio

c) Visual Base

d) Visual .Net

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

a) Absolute

b) Physical 

c) Relative

d) Mixed

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

a) Alt+F8 

b) Alt+F5

c) Alt+F4

d) Alt+F7

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

a) Insert

b) Tools 

c) Data

d) Format

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

a) Sum

b) Average

c) Max

d) All of the above 

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

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

a) Properties

b) Scenario 

c) Window

d) Edit

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

a) Navigator

b) Scenario 

c) Subtotal

d) Goal Seek

Q97.Goal Seek command is found in_________

a) Data

b) Tools 

c) Format

d) Edit

Q98.Shortcut to Navigator is ______

a) F10

b) F8

c) F6

d) F5 

a) Formattin

b) Hyperlink

c) Drawing

d) Standard 

Q100.The Share Document option is present under _____menu.

a) Data

b) Tools 

c) Format

d) Insert

  • electronic spreadsheet class 10 MCQ online test

  • it electronic spreadsheet class 10 MCQ

  • class 10 it spreadsheet MCQ

  • information and communication technology class 10 MCQ

  • electronic spreadsheet class 10 MCQ with answers

  • MCQ of electronic spreadsheet class 10

  • electronic spreadsheet class 10 MCQ

  • electronic spreadsheet MCQ

  • electronic spreadsheet class 10

Disclaimer: The above information is for general informational purposes only. All information on the Site is provided in good faith, however we make no representation or warranty of any kind, express or implied, regarding the accuracy, adequacy, validity, reliability, availability or completeness of any information on the Site.

IT Electronic Spreadsheet Class 10 MCQ With Answers- FAQs

1. What is MCQ?  

The multiple-choice format is most frequently used in educational testing, market research, and elections when choosing between multiple candidates, parties, or policies. Although E. L. 

2. What is the full form of MC?  

Multiple-choice is the full form of MC.

3. What is the full form of MCQ?  

Multiple-choice Questions is the full form of MCQ.

4. What is Workspace?

Workspace is a collection of workbook, sheets and documents. 

5. Where is Merge Cell Tab allocated?  

Alignment is Merge Cell Tab allocated.