Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH

Interactive Video
•
Information Technology (IT), Architecture, Business
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the EO Month function primarily calculate?
The start of the year
The middle of the month
The end of the month
The first day of the month
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which method can be used to quickly fill a series of numbers in a spreadsheet?
Typing each number manually
Using the fill handle and series option
Copy-pasting the first number
Using a calculator
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of locking a cell reference when using the EO Month function?
To prevent the cell from being edited
To ensure the reference does not change when dragging the formula
To make the cell bold
To highlight the cell
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How does the EO Month function handle leap years?
It automatically accounts for the 29th day in leap years
It always assumes February has 28 days
It requires manual adjustment for leap years
It ignores leap years
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the E Date function return?
A date a specified number of years before or after
A date a specified number of weeks before or after
A date a specified number of months before or after
A date a specified number of days before or after
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you format cells to display dates correctly when using the E Date function?
Change the cell format to percentage
Change the cell format to text
Change the cell format to currency
Change the cell format to short date
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to calculate a date three months before a given date using E Date, what should you input?
E Date(start date, 3)
E Date(start date, -3)
E Date(start date, 0)
E Date(start date, 1)
Similar Resources on Wayground
2 questions
The Complete Excel Guide: Beginners to Advanced - How Date and Time Works

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Calculate Dates with EDATE and EOMONTH

Interactive video
•
University
8 questions
The Complete Excel Guide: Beginners to Advanced - Basic Date and Time Functions

Interactive video
•
University
8 questions
Correctly

Interactive video
•
KG - University
4 questions
Excel VBA Programming The Complete Guide - More Date and Time Functions

Interactive video
•
University
2 questions
Excel VBA Programming The Complete Guide - More Date and Time Functions

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Understanding How Dates are Stored in Excel

Interactive video
•
University
6 questions
EXCEL DATA: TODAY, NOW, DATEVALUE

Interactive video
•
KG - University
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade