Podcast
Questions and Answers
Which function can be used to display the current date in Excel?
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?
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?
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?
Which function can be used to return a value based on a condition in Excel?
Which function can be used to find the next weekday after a specified date in Excel?
Which function can be used to find the next weekday after a specified date in Excel?