🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

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)
Explanation:
The Chart Wizard (or Insert Chart) allows placing the chart either embedded on the current sheet or on a separate new sheet.

The chart wizard term data categories refers to ____.

  • A. A chart plot area
  • B. A horizontal axis
  • C. The organization of the individual values with a chart’s data series
  • D. The data range that supplies chart data
Explanation:
Data categories in Excel charts refer to the labels along the horizontal (category) axis.

In MS Excel, the Insert tab includes ____.

  • A. Chart
  • B. Alignment
  • C. Style
  • D. All of these
Explanation:
The Insert tab in Excel primarily provides options for inserting charts, tables, illustrations, and other objects.

To insert a blank embedded Word object in Excel, ____.

  • A. Click the object command on the Insert menu
  • B. Click the link button on Format Painter
  • C. Click the link button on the standard toolbar
  • D. None of these
Explanation:
The Object command (Insert → Object) lets you embed a blank Word document inside Excel.

If you want to compare the performance of two employees in 2016, which chart will you use?

  • A. Pivot Chart
  • B. Pie Chart
  • C. Line Chart
  • D. Column Chart
Explanation:
Line charts are ideal for showing trends and comparing performance over time.

A ____ is a representation of a frequency distribution by means of rectangles whose widths represent class intervals and whose areas are proportional to the corresponding frequencies.

  • A. Pictograph
  • B. Histogram
  • C. Pie Chart
  • D. Bar Chart
Explanation:
A histogram uses adjacent rectangles to show frequency distribution.

How can we view a cell comment?

  • A. Position the mouse pointer over the cell
  • B. Click the edit comment command on the Insert menu
  • C. Click the display comment on the window menu
  • D. None of these
Explanation:
Hovering the mouse over a cell with a comment shows the comment.

How to duplicate values in a cell range in MS-Excel 2016?

  • A. Select the range of cells in the worksheet
  • B. Click the conditional formatting button in the Styles group of the Home tab
  • C. Both A and B
  • D. None of these
Explanation:
Duplicate values can be highlighted using Conditional Formatting → Highlight Cells Rules → Duplicate Values.

In MS Excel 2016, the “Conditional Formatting” option is available in the ____ menu.

  • A. Insert
  • B. Page Layout
  • C. Formulas
  • D. Home
Explanation:
Conditional Formatting is located on the Home tab.

Which button do you click to add up a series of numbers?

  • A. AutoSum
  • B. Formula Button
  • C. Total Button
  • D. None of these
Explanation:
The AutoSum button (Σ) quickly inserts the SUM function.