Test your knowledge of Excel functions and formulas with this quiz based on the...

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Browser