Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

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

Financial Accounting

Authors: W. Steven Albrecht, James D. Stice, Earl Kay Stice, K. Fred Skousen, Albrecht S.E.

8th Edition

0324066708, 978-0324066708

More Books

Students also viewed these Accounting questions

Question

=+6. How strong is communication between all parties?

Answered: 1 week ago

Question

Evaluate three pros and three cons of e-prescribing

Answered: 1 week ago