In cell H8, create a formula using the DCOUNT function to count the number of tours...
In cell H8, create a formula using the DCOUNT function to count the number of tours priced under $2,000, using the range A1:E22 as the database, “Price” as the field, and the range G6:G7 as the criteria.
| Tour Code | Tour | Depart Date | Price | Seats Reserved | Tour Information | ||
| 758H | Pacific Odyssey | 1/12/2018 | $ 2,255 | 20 | Tour Code | 966W | |
| 120A | Amazing Amazon | 1/13/2018 | $ 2,466 | 18 | Tour | ||
| 431V | Amazing Amazon | 2/22/2018 | $ 2,134 | 15 | Depart Date | ||
| 762N | Hiking Patagonia | 2/28/2018 | $ 2,812 | 15 | |||
| 215C | Pearls of the Orient | 3/13/2018 | $ 2,350 | 15 | Price | ||
| 251D | Silk Road Travels | 3/19/2018 | $ 2,110 | 19 | < 2000 | ||
| 966W | Photographing France | 3/20/2018 | $ 1,755 | 20 | Number of Tours | ||
| 830L | Old Japan | 3/23/2018 | $ 2,450 | 22 | |||
| 245M | African National Parks | 4/8/2018 | $ 3,115 | 10 | |||
| 334Q | Experience Cambodia | 4/11/2018 | $ 2,441 | 21 | Tour | ||
| 325B | Biking in France | 4/15/2018 | $ 1,900 | 19 | Amazing Amazon | ||
| 754Q | Amazing Amazon | 4/23/2018 | $ 1,925 | 20 | Average Price | ||
| 543Y | Catalonia Adventure | 5/9/2018 | $ 2,587 | 17 | |||
| 556J | Treasures of Ethiopia | 5/18/2018 | $ 1,638 | 5 | |||
| 675Y | Monasteries of Bulgaria | 5/20/2018 | $ 1,663 | 11 | |||
| 544T | Biking in France | 5/23/2018 | $ 1,635 | 10 | |||
| 778W | Magnificent Montenegro | 5/27/2018 | $ 1,890 | 4 | |||
| 446R | Catalonia Adventure | 6/9/2018 | $ 2,100 | 15 | |||
| 677Y | Nepal Trekking | 6/9/2018 | $ 4,200 | 18 | |||
| 433Q | Corfu Sailing Voyage | 6/10/2018 | $ 2,190 | 10 | |||
| 335V | Amazing Amazon | 8/23/2018 | $ 2,877 | 18 | |||
Homework Answers
Add Answer to:
In cell H8, create a formula using the
DCOUNT function to count the number of tours...
A guide to SQL 9th edition Colonial Adventure Tours chapter 3 page 90-92 Odd numbered exercises...
A guide to SQL 9th edition
Colonial Adventure Tours chapter 3 page 90-92
Odd numbered exercises only
figure 3-39(Guide, trip, customer, reservation and
Trip_Guides)
figure 1-5 chapter 1:
7. Review me on TUI UTILIVUDIJ types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND. and STOREHOUSE fields and explain your recommendation Colonial Adventure Tours Use SQL to complete the following exercises 1. Create a table named ADVENTURE TRIP. The table has...
In cell J4, create a formula without using a function that subtracts the value in cell...
In cell J4, create a formula without using a function that
subtracts the value in cell I4 from the value in cell H4 to
determine how much of the mortgage principal is being paid off each
year.
А в Camp Millowski Mortgage Loan Payment Calculator 15-Aug-18 Rate Campground Term (Years) IS 486,000.00 Monthly Payment $ $ 97,200.00 Total Interest $ $ 388,800.00 Total Cost $ 5.750% Year 15 Date Item Price 6 Down Payment 7 Loan Amount 3,228.63 192,354.20 678,354.20...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty pl...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
Partial Question 10 1/2 pts Give the SQL statement to list the trip name and state...
Partial Question 10 1/2 pts Give the SQL statement to list the trip name and state for each trip that occurs during one of the Fall seasons that is Early Fall, Spring and Late Fall. Sort by State. Use the wildcard for the season. SELECT TripName, State FROM Trip WHERE Season LIKE '%Fall' OR SEA ORDER BY State: Answer 1: LIKE '%Fall' OR SEASON LIKE 'Spring' Answer 2: ORDER BY Partial Question 11 1/2 pts Give the SQL statement to...
On the Transactions worksheet, in cell H10, replace the static value by entering a VLOOKUP function...
On the Transactions worksheet, in cell H10, replace the static
value by entering a VLOOKUP function to retrieve the Item's price
from the Product_List table and then multiply it by the quantity to
calculate the gross revenue. Use the fill handle to copy the
formula down through H30.
On the Transactions worksheet, in cell J10, replace the static
value by entering a HLOOKUP function to retrieve the discount value
from the range B4:D6 based on the coupon code used in...
In cell N5, enter an INDEX function that will retrieve the name of the movie with...
In cell N5, enter an INDEX function that
will retrieve the name of the movie with the highest gross sales.
Write the function using the INDIRECT function as the array
argument and then copy the formula across to P5.
015 D E F H 1 J K L M N O P Q 1 2 Company Genre Movie Name Highest Grossing Movie Year 1986 1988 1990 1993 1994 1998 1999 2000 2001 2002 2004 2010 PG-13 2011 2012 2013 2014...
USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30),...
USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30), ADDRESS CHAR(35), CITY CHAR(35), STATE CHAR(2), POSTAL_CODE CHAR(5), PHONE CHAR(12) ); CREATE TABLE RESERVATION (RESERVATION_ID CHAR(7) PRIMARY KEY, TRIP_ID DECIMAL(3,0), TRIP_DATE DATE, NUM_PERSONS DECIMAL(3,0), TRIP_PRICE DECIMAL(6,2), OTHER_FEES DECIMAL(6,2), CUSTOMER_NUM CHAR(4) ); CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20), SEASON CHAR(20) ); CREATE TABLE TRIP_GUIDES (TRIP_ID DECIMAL(3,0), GUIDE_NUM CHAR(4), PRIMARY KEY (TRIP_ID, GUIDE_NUM)...
USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30),...
USE colonial; CREATE TABLE CUSTOMER (CUSTOMER_NUM CHAR(4) PRIMARY KEY, LAST_NAME CHAR(30) NOT NULL, FIRST_NAME CHAR (30), ADDRESS CHAR(35), CITY CHAR(35), STATE CHAR(2), POSTAL_CODE CHAR(5), PHONE CHAR(12) ); CREATE TABLE RESERVATION (RESERVATION_ID CHAR(7) PRIMARY KEY, TRIP_ID DECIMAL(3,0), TRIP_DATE DATE, NUM_PERSONS DECIMAL(3,0), TRIP_PRICE DECIMAL(6,2), OTHER_FEES DECIMAL(6,2), CUSTOMER_NUM CHAR(4) ); CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20), SEASON CHAR(20) ); CREATE TABLE TRIP_GUIDES (TRIP_ID DECIMAL(3,0), GUIDE_NUM CHAR(4), PRIMARY KEY (TRIP_ID, GUIDE_NUM)...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company produces a beach towel and incurs the fallowing variable manufacturing costs 5 Std Price/Rate Б Std Qty 7 1.80 per yd 8Direct material (clath) 3 yds Direct labor 9 12.00 per hour 0.75 hours 10 Variable /H (based an direct labor haurs) 4.00 ner bour 0.75 hours 11 12 Standard Cost per Unit: Std Cast per towel 13 14 Direct Material S.4D 15 Direct...
Question 2 (Using PHStat) A young researcher wants to know what factors affect the Number of...
Question 2 (Using PHStat) A young researcher wants to know what factors affect the Number of weekly riders. You are asked to help the young researcher to make statistical analysis. Develop two (2) hypotheses Using simple linear regression analysis with a significance level of 5% as the basis of your analysis, please conduct the analysis and interpret the results for both of the hypotheses that you developed. City Number of weekly riders Price per week Population of city Monthly income...
A guide to SQL 9th edition
Colonial Adventure Tours chapter 3 page 90-92
Odd numbered exercises only
figure 3-39(Guide, trip, customer, reservation and
Trip_Guides)
figure 1-5 chapter 1:
7. Review me on TUI UTILIVUDIJ types used to create the ITEM table in Figure 3-34. Suggest alternate data types for the DESCRIPTION, ON HAND. and STOREHOUSE fields and explain your recommendation Colonial Adventure Tours Use SQL to complete the following exercises 1. Create a table named ADVENTURE TRIP. The table has...
In cell J4, create a formula without using a function that
subtracts the value in cell I4 from the value in cell H4 to
determine how much of the mortgage principal is being paid off each
year.
А в Camp Millowski Mortgage Loan Payment Calculator 15-Aug-18 Rate Campground Term (Years) IS 486,000.00 Monthly Payment $ $ 97,200.00 Total Interest $ $ 388,800.00 Total Cost $ 5.750% Year 15 Date Item Price 6 Down Payment 7 Loan Amount 3,228.63 192,354.20 678,354.20...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
Partial Question 10 1/2 pts Give the SQL statement to list the trip name and state for each trip that occurs during one of the Fall seasons that is Early Fall, Spring and Late Fall. Sort by State. Use the wildcard for the season. SELECT TripName, State FROM Trip WHERE Season LIKE '%Fall' OR SEA ORDER BY State: Answer 1: LIKE '%Fall' OR SEASON LIKE 'Spring' Answer 2: ORDER BY Partial Question 11 1/2 pts Give the SQL statement to...
On the Transactions worksheet, in cell H10, replace the static
value by entering a VLOOKUP function to retrieve the Item's price
from the Product_List table and then multiply it by the quantity to
calculate the gross revenue. Use the fill handle to copy the
formula down through H30.
On the Transactions worksheet, in cell J10, replace the static
value by entering a HLOOKUP function to retrieve the discount value
from the range B4:D6 based on the coupon code used in...
In cell N5, enter an INDEX function that
will retrieve the name of the movie with the highest gross sales.
Write the function using the INDIRECT function as the array
argument and then copy the formula across to P5.
015 D E F H 1 J K L M N O P Q 1 2 Company Genre Movie Name Highest Grossing Movie Year 1986 1988 1990 1993 1994 1998 1999 2000 2001 2002 2004 2010 PG-13 2011 2012 2013 2014...
Variance Analysis 2 Insert a formula into each cell containing a ? 3 4 chatham Company produces a beach towel and incurs the fallowing variable manufacturing costs 5 Std Price/Rate Б Std Qty 7 1.80 per yd 8Direct material (clath) 3 yds Direct labor 9 12.00 per hour 0.75 hours 10 Variable /H (based an direct labor haurs) 4.00 ner bour 0.75 hours 11 12 Standard Cost per Unit: Std Cast per towel 13 14 Direct Material S.4D 15 Direct...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago