Answered step by step
Verified Expert Solution
Link Copied!

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 4 tasks:
a) Enter the following HARD CODED DATA (type these data values into the cells specified)
Enter your first name (B4):
Enter your last name (BS):
Enter a birthdate - you can enter any birthdate (B6)
b) Enter a date function in cell B9 that retums the current date and time:
c) Call the DATE, YEAR, MONTH, and DAY functions in cell B12 to display the date 1 year, 3 months, and 11 days from today's date.
NOTE: the function all in cell B12 MUST reference the value in cell 89
d) Enter the following FUNCTION calls:
Enter a function in cell B18 that retums only the current date
Use the EDATE function in cell B19 to display the date 4 months from today.
NOTE: the function all in cell B19 MUST reference the value in cell B18
d) Create a concatenated string in cell B32 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 2 decimal places of precision
Function calls within the concatenated string reference values entered above in cells B4:B6 and B18:B19
All function call and calculations are completed within cell B32
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions

Question

4-22. Glen monopolizes every meeting by being (a loudmouth)?

Answered: 1 week ago