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 (A)</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 (A)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Browser