🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

What happens if you select the first and second slides and then click on the New Slide button on the toolbar?

  • A. A new slide is inserted as the first slide in the presentation
  • B. A new slide is inserted as the second slide in the presentation
  • C. A new slide is inserted as the third slide in the presentation
  • D. None of these
Explanation:
New slides are added after the selected slide.

Which of these is the page setup orientation by default for the slides in PowerPoint?

  • A. Landscape
  • B. Portrait
  • C. Vertical
  • D. None of the above
Explanation:
PowerPoint default slide orientation is Landscape.

The slide that is used to introduce a topic and set the tone for the presentation is called the ____.

  • A. Table slide
  • B. Bullet slide
  • C. Title slide
  • D. Graph slide
Explanation:
The Title slide is the first slide that introduces the presentation.

MS PowerPoint is an example of ____.

  • A. Multimedia software
  • B. Graphics software
  • C. Spreadsheet
  • D. Entertainment software
Explanation:
PowerPoint is a presentation/multimedia software.

Which command can be set to prohibit or allow a cell entry?

  • A. Background error checking
  • B. Data validation
  • C. Go to the special
  • D. Evaluate formulas
Explanation:
Data Validation restricts or controls what can be entered in a cell.

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
Explanation:
Data must be prepared (organized in a table) before creating a PivotChart.

Which feature is used in summarizing, analyzing, exploring, and presenting data in a report format?

  • A. Pivot Chart
  • B. Pivot Filter
  • C. Pivot Table
  • D. Pivot Field
Explanation:
A PivotTable summarizes and analyzes large datasets.

Which Excel tool allows you to set specific conditions for data entry, ensuring accuracy and consistency in your analysis?

  • A. Scenario Manager
  • B. Goal Seek
  • C. Data Validation
  • D. Pivot Table
Explanation:
Data Validation enforces rules on data entry.

Which of the following is not one of Excel’s “what-if” functions?

  • A. Goal seek
  • B. Data Table
  • C. Scenario manager
  • D. Auto Outline
Explanation:
Auto Outline is not a what-if analysis tool.

A smart tag will be removed from a cell when ____.

  • A. The cell is hidden
  • B. The data in the cell is changed or deleted
  • C. The cell is moved
  • D. The formatting of the cell is changed
Explanation:
Smart tags disappear when the triggering data is modified or removed.