Test your knowledge of Excel functions and formulas with this quiz based on the...
5 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which function can be used to display the current date in Excel?

  • DATE
  • TODAY (correct)
  • NOW
  • TIME

    • What tool can be used to enter formulas and data and complete a series in Excel?

  • AutoFill (correct)
  • Goal Seek
  • Quick Analysis
  • Insert Function dialog box

    • How can cell references be changed between relative and absolute in Excel?

  • By adding a dollar sign before the column letter and row number (correct)
  • By pressing Ctrl + Shift + A
  • By using the Quick Analysis tool
  • By using the AutoFill tool

    • Which function can be used to return a value based on a condition in Excel?

    <p>IF</p> Signup and view all the answers

    Which function can be used to find the next weekday after a specified date in Excel?

    <p>WORKDAY</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser