View the step-by-step solution to:

Question

In Excel.

In A1 type 36

In A2, Use an IF formula to put "Youngblood" if the value in cell A5 is less

than or equal to 21, "SlapShot" if the value is over 21 and under 35 and "Mystery, Alaska" if the value is over 35.

Your answer should have two Ifs, and the default for not matching either criteria should be Slapshot.

In A3, type 251612.

In cell A4, use only the LEFT, RIGHT and MID formulas, along with separators (/) to convert the number in cell A3 to the date for Christmas in 2016.

Need help being shown how to do these.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes