Question: Greetings I am currently stuck on Chapter 5 level 2-Calculating Travel Cost at America Travels of the text book Succeeding in Business with Microsoft Excel

Greetings

I am currently stuck on Chapter 5 level 2-Calculating Travel Cost at America Travels of the text book Succeeding in Business with Microsoft Excel 2013.

The question reads.....

"The discount worksheet contains a two-dimensional table that has been set up to find the category of a ticket based on the weekday of travel and the fare category. In cells J3, write a formula that determines the discount category for this ticket. Copy the formula to cells J4:J6."

I need help finding a formula for this question.

Screenshots of the tables

Greetings I am currently stuck on Chapter 5 level 2-Calculating Travel Cost

at America Travels of the text book Succeeding in Business with Microsoft

That is the full question; it is bolded.

E12 Discount Category Fare Category 3 Weekday! 4 1AA 7 yo 10 13 14 15 16 re City 17 sc 18 19 20 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Greetings I am presently stuck on Chapter 5 level 3-Creating a Cost Estimate Form for CKG Auto of the textbook Succeeding in Business with Microsoft Excel 2013. Please provide me Step by Step...

I am currently stuck on problem numbers 8-14. This came from the book Succeeding in Business with Microsoft Excel 2013 Chapter 5 Case Problem level 2. 12. In cell N3, compare the America Travels...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

Do question 4 for JAN 2013 and question 3 and 4 for July 2012.This module is income tax for singapore.Do it in microsoft word. ACC213 Examination - January Semester 2013 Introduction to Income Tax...

I need help with answering these questions, please. 1) Ryanair is considering increasing its average fares to 45 euros. Give two reasons for and two reasons against. Based on these four items, what...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Hi I know you opted out of an earlier question. I have several open questions. I really need to get them in. Would you be willing to take any of these questions? I have been waiting for 3 days. I...

summary for this article :key theme, major findings, and key implications Harvard Business Review www.hbr.org A classic boxing match offers useful lessons for seizing How to Thrive in opportunities...

12 Chapter A4148 23218 6/8/01 6:25 PM Page 361 12Initiating Objectives After reading this chapter, you will be able to: 1. Understand the importance of initiating projects that add value to an...

What is the difference between exercising due care and exercising professional skepticism.?

Acquisition Costs of Trucks Shabbona Corporation operates a retail computer store. To improve delivery services to customers, the company purchases four new trucks on April 1, 2010. The terms of...

A business takes a fire insurance policy to cover the loss of asets including A liabilities B stock C none of these

https://media.cheggcdn.com/media/e59/e5900ba1-02b0-44ab-8246-fb980e24e7c1/phpDkQ6Ux

2. It is a fact that (1 + 0.12)3 = 1.40. Knowing that to be true, what is the present value of $140 received in three years if the annual interest rate is 12 percent? LO37.2 a. $1.40. b. $12. c....

6. Why is it reasonable to ignore diversifiable risk and care only about nondiversifiable risk? What about investors who put all their money into only a single risky stock? Can they properly ignore...

1. Identify each of the following investments as either an economic investment or a financial investment. LO37.1 a. A company builds a new factory. b. A pension plan buys some Google stock. c. A...