Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The manager would like a quick way to see a guest's room total ( AFTER Add - On and Tax ) . Use the IFERROR,

The manager would like a quick way to see a guest's room total (AFTER Add-On and Tax). Use the IFERROR, INDEX and MATCH functions to display the room total with tax for the guest with the last name Vazquez.
[-6.8]
The grader found the following:
-2.7 Only 1 of the 3 values in range Q19:Q21 is correct.
-0.7 The formula in cell Q19 does not appropriately reference N4:N85 on the December Guests worksheet.
-0.7 The formula in cell Q19 does not appropriately reference P19 on the December Guests worksheet.
-0.7 The formula in cell Q19 does not appropriately reference D4:D85 on the December Guests worksheet.
-2 At least one formula in range Q19:Q21 is not reused.

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

Step: 3

blur-text-image

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

Expert Oracle Database Architecture

Authors: Thomas Kyte, Darl Kuhn

3rd Edition

1430262990, 9781430262992

More Books

Students also viewed these Databases questions