Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete the following 4 tasks: a ) Enter the following HARD CODED DATA ( type these data values into the cells specified ) Enter your
Complete the following tasks:
a Enter the following HARD CODED DATA type these data values into the cells specified
Enter your first name B:
Enter your last name BS:
Enter a birthdate you can enter any birthdate B
b Enter a date function in cell that retums the current date and time:
c Call the DATE, YEAR, MONTH, and DAY functions in cell B to display the date year, months, and days from today's date.
NOTE: the function all in cell B MUST reference the value in cell
d Enter the following FUNCTION calls:
Enter a function in cell B that retums only the current date
Use the EDATE function in cell B to display the date months from today.
NOTE: the function all in cell B MUST reference the value in cell B
d Create a concatenated string in cell B with the following properties:
The CONCAT function is used to create the string
The YEARFRAC function is used to compute each of the ages
The YEARFRAC function call uses Actual Actual for the Basis argument
The TEXT function is used to format both the current and the future age
The current and future age are each always displayed with at least one digit to the left of the decimal place and decimal places of precision
Function calls within the concatenated string reference values entered above in cells B:B and B:B
All function call and calculations are completed within cell B
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started