MS Excel
34 questions available
FILTER BY SUBTOPIC
Q1.Which chart shows changes over time?
Correct Answer: C
Q2.An excel workbook is a collection of ?
Correct Answer: A
Q3.An Excel book is a collection of :
Correct Answer: C
Q4.In MS Excel, On the Insert tab includes
Correct Answer: A
Q5.In MS Excel , On the Insert tab includes:
Correct Answer: A
Q6.Default type of chart in Ms Excel :
Correct Answer: B
Q7.In which tab we go to insert Chart in MS Excel:
Correct Answer: A
Q8.For making flow chart and presentation which is used?
Correct Answer: A
Q9.An excel workbook is a collection of?
Correct Answer: D
An excel workbook is a collection of Worksheets and Charts.
Q10.In Excel, a Data Series is defined as what
Correct Answer: C
A collection of related data is the correct factual response to “In Excel, a Data Series is defined as what”.
Q11.Which key is used to create chart in excel?
Correct Answer: C
F11 is used to create chart in excel.
Q12.Which key is used to create a chart in MS Excel?
Correct Answer: C
F11 is used to create a chart in MS Excel.
Q13.In Excel, a Data Series is defined as what?
Correct Answer: C
A collection of related data is the correct factual response to “In Excel, a Data Series is defined as what”.
Q14.Which one of the following options is NOT a chart type of MS-Excel?
Correct Answer: C
CAD Chart is not a standard MS Excel chart type. Bar Chart, Waterfall Chart, and Scatter Chart are standard Excel chart types available in Excel.
Q15.Columns in MS Excel are called?
Correct Answer: D
Columns in MS Excel run vertically and are identified by Letters (A, B, C, ... AA, AB, etc.), while horizontal rows are identified by Numbers.
Q16.In MS Excel, we can add a chart from which tab?
Correct Answer: C
Charts are added to worksheets from the Insert tab in Excel, which includes various visual chart styles (Bar, Pie, Line, Area).
Q17.How to add a filter in Excel?
Correct Answer: B
Filters help display only the data you need in a table. To add a filter: Select your data → Data tab → Filter. Small dropdown arrows appear in the header row of your table.
Q18.What type of chart is useful for showing trends or changes over time in Excel?
Correct Answer: C
A Line Chart displays data points connected by straight lines, making it perfect for representing continuous trends over time.
Q19.What type of chart is useful for comparing values over categories in MS Excel?
Correct Answer: C
A Column Chart uses vertical bars to clearly represent and compare numerical values across different categories.
Q20.An Excel workbook is a collection of __________?
Correct Answer: C
An Excel workbook is primarily a collection of worksheets. A workbook must contain at least one worksheet.