Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

Using formulas, how could I combine text resulting in "Check # 1234 paid 02/15/2013 - pending cash application"? Cell B4 refers to the date.

=SUMALL("Check # ",VALUE("1234"),"paid",DATE(B4,"mm/dd/yy")," - pending cash application")
=TEXT(Check # 1234 paid, ADD(02/15/2013)," - pending cash application"END)
=CONCATENATE("Check # 1234 paid ",TEXT(B4,"mm/dd/yyyy")," - pending cash application")
=+VALUE("Check #",IF(1234),DATE(02/15/2013) =("- pending cash application")
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon