Selected MCQ

Current Question
What is the first step in creating a Pivot Chart in Excel?
  • A. Insert a Pivot
  • B. Prepare your data
  • C. Customize the chart
  • D. Add fields to the Pivot Table
Correct Answer: B
Explanation:
Data must be prepared (organized in a table) before creating a PivotChart.
Related Question 1
To insert a chart in MS Excel, which shortcut key is used?
  • A. Alt+F1
  • B. F2
  • C. F3
  • D. F4
Correct Answer: A
Explanation:
Alt+F1 creates a chart from the selected data in Excel.
Related Question 2
In MS Excel, chart wizard term data series refers to _____.
  • A. A chart legend
  • B. A collection of chart data markers
  • C. A set of values you plot
  • D. A data label
Correct Answer: B
Explanation:
A data series is the set of related data points (markers) plotted on the chart.
Related Question 3
To add Equation in the cell of the MS-Excel, we put ____ first.
  • A. Addition sign
  • B. Subtraction sign
  • C. Equal sign
  • D. Parenthesis sign
Correct Answer: C
Explanation:
All formulas begin with the equal sign (=).
Related Question 4
In MS Excel 2016, the “Pivot Tables” option is available in the ____ menu.
  • A. Review
  • B. View
  • C. Insert
  • D. Page Layout
Correct Answer: C
Explanation:
PivotTables are inserted from the Insert tab.
Related Question 5
In Excel, the chart wizard ____.
  • A. Can place a chart on a new sheet or on any sheet in the workbook
  • B. Can only place a chart on a new blank worksheet
  • C. Can only be used to create embedded charts
  • D. None of these (but document marks A)
Correct Answer: A
Explanation:
The Chart Wizard (or Insert Chart) allows placing the chart either embedded on the current sheet or on a separate new sheet.