Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In the Excel extract below, the current year-end of 31 December 2021 has been input in E3. Which one of the following formulae would code
In the Excel extract below, the current year-end of 31 December 2021 has been input in E3. Which one of the following formulae would code a text string that states - "The current year end is 31/12/2021"?
a) ="The current year end is "&(E3,dd/mmm/yyyy)
b) ="The current year end is "&text(E3,"dd/mm/yyyy")
c) ="The current year end is "E3
d) ="The current year end is "&E3
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