Recent

  • Show all results for ""

🎧 New: AI-Generated Podcasts Turn your study notes into engaging audio conversations. Learn more

Excel Functions Quiz
9 Questions
1 Views

Excel Functions Quiz

Created by
@PositiveSeal

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What does the hlookup function do?

  • Lookup information in a row or column
  • Remove specific row or column from a data set
  • Retrieve the reference of the cell at the intersection of a particular row and column
  • Find data in a horizontal table (correct)

    • What is the purpose of the index function?

  • Lookup information in a row or column
  • Remove specific row or column from a data set
  • Retrieve the reference of the cell at the intersection of a particular row and column (correct)
  • Find data in a horizontal table

    • What does the vlookup function return if the condition is not met?

  • True
  • Error message
  • False (correct)
  • Null

    • What is the purpose of the round up function?

    <p>Round decimal numbers to the closest higher number</p> Signup and view all the answers

    What does the even function do?

    <p>$f(x) = 2*INT(x/2)$</p> Signup and view all the answers

    What does the decimal function do?

    <p>$f(x) = \text{Converts a number into its decimal representation}$</p> Signup and view all the answers

    What does INT function do?

    <p>Converts the number into an integer</p> Signup and view all the answers

    What is the purpose of product function?

    <p>Multiplies the number with a specific digit.</p> Signup and view all the answers

    What type of functions are we moving on to after finishing math functions?

    <p>Statistical functions.</p> Signup and view all the answers

    More Quizzes Like This

    Excel Lookup Formulas and Functions Quiz
    3 questions

    Excel Lookup Formulas and Functions Quiz

    PamperedUnderstanding avatar
    PamperedUnderstanding
    E-Tech Quiz Reviewer
    55 questions

    E-Tech Quiz Reviewer

    SafeOrange avatar
    SafeOrange
    Excel Study Guide – Part 1
    30 questions

    Excel Study Guide – Part 1

    WorldFamousPointillism avatar
    WorldFamousPointillism
    Excel Chart and Sparkline Manipulation
    12 questions

    Excel Chart and Sparkline Manipulation

    ExceedingSodalite avatar
    ExceedingSodalite
    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser