On the Cities worksheet, click cell F13. The lodging is based on a multiplier by City Type. Some cities are more expensive than others. Insert a VLOOKUP function that looks up the City Type (B13), compares it to the City/COL range (A7:B10), and returns the COL percentage. Then multiply the result of the lookup function by the Total Base Lodging (B5) to get the estimated lodging for the first city. Copy the function from cell F13 and use the Paste Formulas option to copy the function to the range F14:F18 without removing the border in cell F18.

Answers

Answer 1

Answer:

I have found and attached a spreadsheet (cities.xlsx) that matches this question.

First we remember the VLOOKUP sintax:

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

We need to look up the City Type (B13),

compare it to the City/COL range (A7:B10),

and return the COL percentage (2nd column of City/COL)

so the VLOOKUP function on cell F13 has to be:

=VLOOKUP(B13,$A$7:$B$10,2)

Next, to multiply the result by the Total Base Lodging (B5):

=VLOOKUP(B13,$A$7:$B$10,2) *$B$5

Finally que copy the formula to the F14:F18 cells

Notice the use of $  to make cells static and avoid errors while copying the formulas to different cells.

I have attached the completed spreadsheet as "cities final.xlsx"


Related Questions

Checking account a charges a mouthly service fee $23 and wire transfer fee of $7.50 while checking account b charges a monthly service fee of $14 and wire transfer fee of $9.50 which checking account is the better deal if four wire transfers are made per month

Answers

Answer:

Checking account b is the better deal, because the total monthly fees amount to $52, while those for checking account a amount to $53.

Explanation:

Given:

monthly service fee of checking account a = $23

wire transfer fee of a = $7.50

monthly service fee of checking account b = $14

wire transfer fee of b = $9.50

To find:

which checking account is the better deal if four wire transfers are made per month?

Solution:

If four wire transfers are made per month then total monthly fees of both accounts is computed as follows:

Account a:

service fee of a + four wire transfers fee of a

23 + 4(7.50) = 23 + 30 = $ 53

Account b:

service fee of b + four wire transfers fee of b

14 + 4 (9.50) = 14 + 38 = $ 52

From the above results checking account b is the better deal because the total monthly fees amount to $52 while total monthly fees for checking account a amount to $53.

what do you call the two parts of lift that go down a mine

Answers

The sheave wheel is a pulley wheel that sits above the mine shaft. The hoist cable passes over the sheave wheel and then down the shaft of the mine.
(copied from google)

which of the following defines a network

Answers

A network, in computing, is a group of two or more devices or nodes that can communicate. The devices or nodes in question can be connected by physical or wireless connections. The key is that there are at least two separate components, and they are connected.

what dose a bios system do?

Answers

BIOS instructs the computer on how to preform basic functions such as booting and keyboard control. It is also used to identify and configure the hardware in a computer
Bios tells computer how to do basic functions

PLEASE HELP!! WILL MARK FIRST ANSWER BRAINLIEST!!~~~Amy needs to configure the Clutter option in Outlook 2016. Where should she go to activate the option?

Outlook Options
View tab
Outlook Web App
Ask an administrator

Answers

Outlook options I’m pretty sure

She needs to go enable the Outlook Options feature. Then, choice A is the best one.

What is the outlook?

The preferred email client for sending and receiving emails from Exchange Server 2010 is Microsoft Outlook. Accessibility to contact, mail, schedule, and task management systems is also provided by Outlook.

Microsoft Outlook is the electronic mail application for emails sent and received from Exchange Server by Microsoft. Outlook also makes contact, email, schedule, and activity management functions available.

In Outlook, select the File tab to access the backstage area; The Message Options dialogue box appears when you click the Info button in the left-hand menu after you've clicked the Properties button in the middle section.

She should go to activate the option will be Outlook Options. Then the correct option is A.

More about the outlook link is given below.

https://brainly.com/question/17457799

#SPJ6

Pick a number
You will write a program that will simulate the game where two players try to guess a number and the one who's closest wins.
1. Random secret number from 1 to 10 or any larger range if you want.
2. Two players will guess
3. Determine who was closest.
4. Display the results of the round in a neat and organized fashion.
5. Add some kind of style to your print outs so that your display is nice

Answers

In python 3+:

import random

secret_number = random.randint(1,10)

guess_one = int(input("Enter player one's guess: "))

guess_two = int(input("Enter player two's guess: "))

if abs(guess_one - secret_number) < abs(guess_two - secret_number):

   print(f"The secret number is {secret_number} and player 1 was closest")

elif abs(guess_one - secret_number) > abs(guess_two - secret_number):

   print(f"The secret number is {secret_number} and player 2 was closest")

else:

   print(f"The secret number is {secret_number} and it was a tie")

I hope this helps!

Samuel plans to use images of babies for a calendar. Which options should he choose?
A.
seek permission from the parents of the baby but do not mention the commercial use
B.
seek permission from no one, as it is the imageer’s duty to capture images
C.
seek permission from parents before using the baby’s image for commercial gains
D.
seek permission from the parents of the babies without telling them about where it will be used

Answers

Answer:

The answer to this question is given below in the explanation section.

Explanation:

The correct option for this question is (C) -seek permission from parents before using the baby’s image for commercial gains

Because Samuel using images of babies for a calendar and use it for commercial purpose. So, she needs to seek permission from parents before using the baby's image for commercial gains. It is also required for her to tell babies' parents about the use of pictures commercially.  

Other options are not correct because legally and ethically she is bound to take permission from babies' parents before using it commercially.

I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
Select the statements that describe working with text in presentation programs.

Working with text in presentation programs requires learning a new set of rules.
Working with text in presentation programs is similar to working with text in other applications.
The alignment of text in placeholders cannot be changed.
Font size and font color can be changed in presentations.
Audience size influences font size.

Answers

Answer:

Your answer is 1, 3, and 4.. Working with text in presentation programs requires learning a new set of rules, The alignment of text in placeholders cannot be changed, and Font sizes and color can be changed in presentations... Hope this helps!

Explanation:

Search engines are used to find a specific entry in a database.

True or false?

Answers

True true true true I think

Answer:

True

Explanation:

My answer is true no explanation but i think its trueeeeeee

What is the quickest way to remove all filters that have been applied to a worksheet?

Answers

Answer:

Click the Filter button in the Sort & Filter group.

Explanation:

Quizlet

Go to the filter option, click sort/filter and unfilter.

help !!!!!
Aziz is purchasing a new laptop. The salesperson asks him if he requires any software, as he will get a discount if purchased together. What is that “software” the salesperson is referring to?

• a type of insurance that covers light wear and tear to the laptop for a specified number of years

• a type of protective covering to prevent the laptop from damage in case of falls

• a detailed list of all the hardware connected to the laptop as well as hardware on the laptop

• a set of instructions that enables the laptop to perform certain functions or operations

Answers

I believe it’s D because software is the programs and other operations used by a computer

Answer:

its d

Explanation:

i just did it

After the results of an experiment, a scientist decides that a long-held scientific theory must be revised. The scientist modifies the theory and tells other scientists. Predict the scientists' reaction, and explain why they might react that way. Your answer:

Answers

Answer:

Other scientists will be surprised at him/her

Explanation:

Science is totally empirical in its approach to knowledge. Models and theories are proposed and revised based on the available mass of experimental evidence.

However, all scientific findings must go through a rigorous process of verification and replication by other scientists in other parts of the world before they become  widely accepted in the world of science.

The scientist ought not to have modified the existing theory based on his findings as an individual. His findings ought to go through rigorous verification because other extraneous factors that he may not have controlled adequately may have led to the results he obtained.

Other scientists will be surprised and disregard his claims about the long held scientific theory until his findings are satisfactorily verified by other scientists working in different parts of the world.

What is the value of numC when this program is executed?
numA = 4
numB = 10
if numA == 2:
numC = 10
elif numA > numB:
numC = 20
else:
numC = 30

Answers

numA = 4 and numB = 10

for the if statement to run, numA has to equal 2, which it doesn't.

for the elif statement to run, numA has to be greater than numB, which it isn't.

That leaves the else statement, therefore, numC = 30

Answer:

30

Explanation:

Why is computer called an information processing machine?

Answers

Answer:

A computer is an information processing machine. Computers process data to produce information. The sets of instructions that humans give computers are called programs or software. Computers never lose or misplace information.

hope this helped youuu:)

A program for a computer is a “collection of code.”
True
False

Answers

Answer: true

Explanation: computer is all about code

Answer:

False, Took the test.

Which is the faster cpu and why?

Answers

Answer:

Core i7 unlocked

Explanation:

This is known to not only be faster but also more stable.

Answer:

Intel Core i7 Unlocked has more GHz (gigahertz) along with an Octa core.

Explanation:

More gigahertz means your CPU would run all applications at a faster speed and be more efficient. Not only that, an octa core is much more efficient than a quad core. (Octa meaning 8 while Quad being 4).  

Would X-ray waves carry a lot of energy? And do they have a high frequency?

Answers

Answer:

X-rays are very high frequency waves, and carry a lot of energy. They will pass through most substances, and this makes them useful in medicine and industry to see inside things.

what is digestion?
1. breathing
2.removing waste
3.breathing down food for energy
4.growing in size

Answers

Answer:

3

Explanation:

I'm assuming you mean " breaking" not "breathing"

Answer:

Digestion is the process of breaking down food for energy and creating waste

Explanation:

Which of the following best describes the purpose of a design specification?

A. Tracking errors that arise through user testing
B. Documenting comments that will need to be added to a program
C. Describing the requirements for how a program will work or users will interact with it
D. Listing detailed questions that will be asked of users during interviews

Answers

Answer:

The correct option is;

C. Describing the requirements for how a program will work or users will interact with it

Explanation:

A design specification is the document that specifies how a program or system carries out the prerequisite tasks defined in the functional requirements information

The design specification outlines points, including factors concerning the functioning of the program, product, for the proper functioning of the program or product.

The design specification can be used for the financial evaluation of the cost of a project.

Stating what is required of a code in terms of the functions it should perform and the inputs needed to perform are embedded in the design specification of a program.

Design specification may be described as the functions and capabilities required of a program to be built.

For interactive programs, the design specification will involve creating inputs to be given by the user, this inputs will have rules such that only those which will allow proper functioning of the program is allowed.

Tracking errors and documenting comments are attached program debugging and program readability

Therefore, program specification is useful for describing what is required of a program in terms of it's function or how user's interact with it.

Learn more :https://brainly.com/question/18505492

I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
How do you add text to a blank slide layout?

Select text from the Insert menu.
Click in the Task Pane and insert text.
You can't add text to a blank slide layout.
Draw a text box and enter text.

Answers

\The answer is B; Draw a text box and enter text

By default, we add text to a PowerPoint slide by typing it directly into a placeholder. However, you can use a text box to enter text into a blank slide or outside the placeholders. To add text on a blank slide click on the insert menu and select the Text box option. Click and hold down your mouse button while you drag the mouse. You will then clink inside the text box and starting typing.

Which of the following planets most likely has the coldest surface temperature?
A. Venus
B. Mars
C.
Saturn
D. Mercury

Answers

Answer:

Saturn because it is not that close to the sun

Answer:

Saturn.

I'm dumb i misread the question

Explanation:

full detail about computer and its history


Answers

Answer:

The computer as we know it today had its beginning with a 19th century English mathematics professor name Charles Babbage. He designed the Analytical Engine and it was this design that the basic framework of the computers of today are based on. ... It was called the Atanasoff-Berry Computer (ABC).

Explanation:

Which should be addressed by stakeholders when reviewing the problem statement? Select all that apply.

All possible outcomes have been thoroughly researched and rejected.

The problem as they see it has been addressed.

The solution proposed will meet their needs.

The needs of their colleagues are being met.

All issues and constraints have been identified.

Answers

The statement that should be addressed by stakeholders when reviewing the problem statement are the problem as they see it has been addressed, the solution proposed will meet their needs and all issues and constraints have been identified.

What are the elements of an effective problem statement?

An effective problem statement includes the description of the problem and the method that will be used to solve the problem.

The problem as they see it has been addressed, the solution proposed will meet their needs and all issues and constraints have been identified are the statement that should be addressed by stakeholders when reviewing the problem statement.

Therefore, B, C and E are the correct options.

Learn more about problem statement here:

https://brainly.com/question/11657822

#SPJ1

Why can't you test a program for run-time errors when it has compile-time (syntax) errors

Answers

Answer:

your computer will not allow it

Explanation:

because it is not one of the main dyonostics

what's my favorite color

black

red

purple

yellow

orange

Answers

Answer:

.

Explanation:

Beth wants to add information to her PowerPoint presentation that is hidden from her audience and only she will
see. Which feature should she use?
Notes pane
Title slide
Normal view
Slide Sorter view
Mark this and return

Answers

Answer:

She should use Notes pane

Explanation:

Notes pane is for notes only the creator will see.

Answer:

A. Notes Pane

Explanation:

Eureka! (Part 1) Eureka! is a telephone- and Internetbased concierge service that specializes in obtaining things that are hard to find (e.g., Super Bowl tickets, first-edition books from the 1500s, Fabergé eggs). It currently employs 60 staff members who collectively provide 24-hour coverage (over three shifts). They answer the phones and respond to requests entered on the Eureka! website. Much of their work is spent on the phone and on computers searching on the Internet. The company has just leased a new office building and is about to wire it. What media would you suggest the company install in its office and why?

Answers

Explanation:

bypassing, use more precise words

Edhesive 1.7 Data Types and Variables.
How do I do this correctly

Noun= input (“Enter a noun”)
adjective = input(“Enter an adjective:”)
Print (“the” +noun “is” + adjective)

Answers

Here's how I would do it in python 3+

noun = input("Enter a noun: ")

adjective = input("Enter an adjective: ")

print(f"The {noun} is {adjective}")

I hope this helps!

"Currency" is a field data type ,it represents Date or time values
True or false tho?

Answers

Answer:

true

Explanation:

Electronic medical charts make it easier for doctors to

share information on patients with other doctors.
share information on patients with the government.
communicate with patients about medical issues.
track infectious diseases through a database.

Answers

Answer:

Share information on patients with other doctors

Explanation:

Got it right on edge test

Answer:

Share information on patients with other doctors

Explanation:

Other Questions
Whats a good summary for rich dad poor dad chapter 5? Which event from "Seventh Grade" is part of the story's rising action? Victor waits in line to receive his computer card. Victor lingers in his homeroom so he can be near Teresa. Victor agrees to help Teresa learn the French language. Victor goes to the library and checks out French textbook 50 POINTS!!!! ILL MARK BRAINLIEST !!!! Mexico Immigration BriefingInformationTopic1. Brief summary ofthe immigrationpolicy2. Response toimmigrants - howmany immigrantsdo they allow peryear?3. Response toillegal immigrants- how manyillegal immigrantsare there? What isthe penalty forillegalimmigrants?no ASAP Describe the difference between each of these terms and the structure of each kind of fat- Saturated fats, Unsaturated fats, Polyunsaturated fats How do you show that an inequality is true on a number line? Samuel feels nervous to give a presentation. He normally doesn't get this way about giving speeches, but this time, hisapprehension is high. Which type of communication apprehension does he have?trait anxietyaudience anxietysituational anxietycontext anxiety If the smallest angle of rotation for a regular polygon is 18, how many sides does polygon have?2024 what is the summary for Electrons and protons Why was the search for a Northwest Passage so important? What was the result of all those sailors and explorers efforts to discover a route through the New World? What is a carbon hydrate molecule? Hereditary diseases are passed from one generation to the next through mutated genes.Please select the best answer from the choices provided.OF Find The Difference.1)5-15=2)-13-7=3)-19-7=4)36-(-12)=5)-29-(-11)=6)-7-(-5) At a concert stadium tickets purchasers have a choice between sitting in the floor seats or in the bleachers seats. In the floor section, there are 16 rows of 48 seats. The bleachers section has 86 rows with 72 seats in each. How many seats are there in all stadium? Evan is borrowing a friend's laptop to check out some groovy music files. What can Evan look for to quickly identifymusic files?a messaging appthe hardwarethe file extensionsthe systems software Al saves pennies. He agreed to give 3/7 of his pennies to Bev if she would give 3/7 of what she got from Al to Carl and if Carl in turn would give 3/7 of what he got from Bev to Dani. Bev, Carl, and Dani agreed and Dani received pennies. How many pennies did Al have initially which of the two pure substance consists of different types of Element Select the correct answer.Which fracture allows the bone to stay in alignment and continue to move?A. Closed fractureB. Displaced fractureC. Non-displaced fractureD. None of the above 4x - 1 = 2(2x + 2) what is the answer? You're driving your car at a constant speed in a straight line which of the following can be used to cause your car to experience a centripetal acceleration A)brake pedal B) steering wheel C)gas pedal D)All of the above HELP PLEASE BTW ITS NOT C I JUST PUT ANY ANSWER