COMPUTER MCQs

What is the function of the Excel function “IF”?

A) Find the maximum value in a range

B) Count the number of cells in a range

C) Perform conditional calculations based on a specified condition

D) Calculate the average of numbers in a range

Which MS Office application is used for creating and editing equations and mathematical expressions?

A) MS Word

B) MS Excel

C) MS PowerPoint

D) MS Equation Editor

In MS Word, what is the term for a list of frequently used commands or actions that can be accessed with a single click?

A) Toolbar

B) Quick Access Toolbar (QAT)

C) Ribbon

D) Menu

What is the default extension for a PowerPoint presentation?

A) .ppt

B) .pps

C) .pptx

D) .pptx

Which MS Office application is used for creating and editing digital publications, e-books, and interactive documents?

A) MS Word

B) MS Excel

C) MS PowerPoint

D) MS Publisher

In MS PowerPoint, what is the term for a slide that serves as an introduction to the presentation and typically contains the title and subtitle?

A) Layout

B) Master Slide

C) Title Slide

D) Transition

What is the function of the Excel function “VLOOKUP”?

A) Find the maximum value in a range

B) Count the number of cells in a range

C) Calculate the sum of numbers in a range

D) Look up a value in a table and return a corresponding value from another column

Which MS Office application is used for creating and editing diagrams, flowcharts, and organizational charts?

A) MS Excel

B) MS Word

C) MS Visio

D) MS Access

In MS Word, what is the term for a predefined collection of formatting options that can be applied to text or objects?

A) Style

B) Font

C) Format

D) Style

What is the function of the Excel function “COUNTIF”?

A) Calculate the sum of numbers in a range

B) Find the maximum value in a range

C) Count the number of cells that meet a specific condition in a range

D) Calculate the average of numbers in a range