Skip to main content
Login Register

Menu

Home Quizzes Categories Current Affairs GK AI ToolsNEW Play Live Contact
Login Create free account
Easy Free Computer & Technology MS Excel

MS PowerPoint Quiz

Practice the PowerPoint concepts used to create clear and effective presentations.

25 Questions
30 min Duration
40% To pass
1.00 Marks / correct

Instructions

  • This quiz has 25 questions.
  • Questions are picked at random from a bank of 50, so each attempt is different.
  • You have 30 minutes. The quiz submits automatically when time runs out.
  • You need 40% to pass.
  • There is no negative marking.
  • You can mark questions for review and return to them before submitting.
  • Correct answers and explanations are shown after you submit.

Sample Questions & Answers

A preview of 12 questions from this quiz, each with the correct answer and a written explanation. Attempt the full, timed quiz to be scored and earn XP.

  1. Question 1

    In MS Excel, which option best describes Cell?

    • A function that adds values
    • The intersection of a row and column Correct answer
    • A function that returns the smallest value
    • A function that returns results based on a condition
    Explanation: Cell is correctly described by: The intersection of a row and column.
  2. Question 2

    In MS Excel, which option best describes Workbook?

    • An Excel file containing worksheets Correct answer
    • A function that calculates the arithmetic mean
    • A function that counts numeric cells
    • A function that returns an alternative result when a formula errors
    Explanation: Workbook is correctly described by: An Excel file containing worksheets.
  3. Question 3

    In MS Excel, which option best describes Worksheet?

    • A function that returns the largest value
    • A function that counts non-empty cells
    • A function returning the current date
    • A spreadsheet grid within a workbook Correct answer
    Explanation: Worksheet is correctly described by: A spreadsheet grid within a workbook.
  4. Question 4

    In MS Excel, which option best describes Formula?

    • A function that returns the smallest value
    • A function that returns results based on a condition
    • An expression used to calculate a result Correct answer
    • A function returning the current date and time
    Explanation: Formula is correctly described by: An expression used to calculate a result.
  5. Question 5

    In MS Excel, which option best describes SUM?

    • A function that counts numeric cells
    • A function that adds values Correct answer
    • A function that returns an alternative result when a formula errors
    • A function that combines text values
    Explanation: SUM is correctly described by: A function that adds values.
  6. Question 6

    In MS Excel, which option best describes AVERAGE?

    • A function that calculates the arithmetic mean Correct answer
    • A function that counts non-empty cells
    • A function returning the current date
    • A lookup function that searches the first column of a range
    Explanation: AVERAGE is correctly described by: A function that calculates the arithmetic mean.
  7. Question 7

    In MS Excel, which option best describes MAX?

    • A function that returns results based on a condition
    • A function returning the current date and time
    • A flexible lookup function for finding related values
    • A function that returns the largest value Correct answer
    Explanation: MAX is correctly described by: A function that returns the largest value.
  8. Question 8

    In MS Excel, which option best describes MIN?

    • A function that returns an alternative result when a formula errors
    • A function that combines text values
    • A function that returns the smallest value Correct answer
    • A function that sums values meeting a condition
    Explanation: MIN is correctly described by: A function that returns the smallest value.
  9. Question 9

    In MS Excel, which option best describes COUNT?

    • A function returning the current date
    • A function that counts numeric cells Correct answer
    • A lookup function that searches the first column of a range
    • A function that counts cells meeting a condition
    Explanation: COUNT is correctly described by: A function that counts numeric cells.
  10. Question 10

    In MS Excel, which option best describes COUNTA?

    • A function that counts non-empty cells Correct answer
    • A function returning the current date and time
    • A flexible lookup function for finding related values
    • A group of selected cells
    Explanation: COUNTA is correctly described by: A function that counts non-empty cells.
  11. Question 11

    In MS Excel, which option best describes IF?

    • A function that combines text values
    • A function that sums values meeting a condition
    • A cell reference that changes when copied
    • A function that returns results based on a condition Correct answer
    Explanation: IF is correctly described by: A function that returns results based on a condition.
  12. Question 12

    In MS Excel, which option best describes IFERROR?

    • A lookup function that searches the first column of a range
    • A function that counts cells meeting a condition
    • A function that returns an alternative result when a formula errors Correct answer
    • A cell reference fixed with dollar signs
    Explanation: IFERROR is correctly described by: A function that returns an alternative result when a formula errors.

Login/Register to attempt the full quiz and earn XP.

Login Create free account

Explore more: All Computer & Technology quizzes · MS Excel

Microsoft PowerPoint Practice

Good presentations depend on more than adding text to slides. Revise themes, layouts, transitions, animations and multimedia features through questions based on common PowerPoint usage.

Frequently Asked Questions

Each attempt serves 25 questions, drawn at random from a bank of 50, with 30 minutes.

You need at least 40% to pass this quiz.

No, there is no negative marking on this quiz.

Yes. You can attempt this quiz again at any time, though first-attempt XP bonuses apply only once.

Sign in to attempt this quiz and earn XP.

Login to Start Create free account

Related Quizzes