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

A family member who hasnít worked with computers before has decided to change jobs. Youíve been asked to explain some of the basics. You begin by explaining the basic idea of word processing software, spreadsheets, databases, and presentation software. You sense that the following question is coming: ìWhy so many different things? Why canít there just be one software that you could use for everything?î How would you answer?

Answers

There are too many diverse forms of media. For all of them to be suited under one program would make every server monotonous and pretty much the same. With different programs, different forms of diverse media are created.

pls go to my account and answer my question

Answers

Answer:ok I couldn’t find the question do you mind maybe copy pasting it and asking it.

Explanation:

Answer:

ok

Explanation:

types of computer that we use in our daily life​

Answers

Answer:

all coumputers

Explanation:

i just like coumputers

The answer would be all computers
Hope this helps :)

Complete the sentence.
use only apps acquired from app stores.
PLEASE HELP

Answers

Answer:

that's a hard one maybe u should email ur teacher bc the punctuation on that is fine and it's not an incomplete sentence

Ccccccccccccccccccccccc

um can anyone who is really into science and physics answer this question

Answers

Answer:

What question?

Explanation:

Software as a Service refers to

software that you put on your computer.

software you can access using any device.

a server.

a web browser.

Answers

Answer:a,b,d,e

Explanation: The other top ones are right but it's a multiple choice answer

Jack follows the steps below.
Step 1: He clicks the Design tab on the ribbon.
Step 2: He navigates to the Document Formatting command group.
Step 3: He clicks the Themes icon.
Step 4: He clicks the Office Theme option in the themes gallery.

Which task is Jack trying to do?
A. He is sharing the Office theme with others.
B. He is creating a new theme for his document.
C. He is saving an existing theme to the themes gallery.
D. He is applying an existing theme to his document.

Answers

Answer:

D is my answer to this question.

Answer:

D, He is applying an existing theme to his document.

Explanation:

got the answer correct on edge.

what is the 3rd streak fun fact from brainly

Answers

Answer:

it is something like you life time saliva can fill up two swimming pools i think

Answer:

During your lifetime, you will produce enough saliva

+20 POINTS!!!~~~~~When adding delegates to his mailbox, which role should Joel use if he would like the user to be able to read and create items in a particular folder?

Editor
Publishing Editor
Author
Manager

Answers

Answer:

B) Publishing Editor

Explanation:

Joel should use the publishing editor tool. The correct option is B.

What is a mailbox?

A mailbox is where electronic mail messages found on a remote server or downloaded to the user's hard drive are stored.

In this scenario, the role he should assign to the delegates is the publishing editor. This role grants them the ability to create, read, modify, and delete all items within a given folder, as well as create subfolders.

The other options listed either do not grant access to create/modify existing files or simply grant all of these rights to files created by the user but not to files already present in the folder. As a result, this would be the most appropriate role for Joel's goals.

To know more about mailbox follow

https://brainly.com/question/13276817

#SPJ6

Computer hardware is best described as

Answers

Computer hardware is best described as any physical component of a computer system that contains ICs, Circuit boards , or any other type of electronic.

A folder is one icon considered a short cut true or false

Answers

Answer:

True

Explanation:

A shortcut can be an icon that points to a certain app or website.

Write any four "Change Case" options available in OpenOffice writter

Answers

Answer:

please mark me as a brainliest

Answer:

In OpenOffice Writer you can change any text to sentence case, lowercase, uppercase, capitalize every word, or toggle case by following the steps below.

Highlight the text you want to change.

Once highlighted click Format and then Change Case.

Within Change Case select the type of capitalization you want.

would a interactive book be considered a game?

Answers

[tex]\huge\bold\red{Answer:-}[/tex]

✮With its anthology of Interactive Fiction, Studio Oleomingus creates an interplay of text and built environments.

✮The readers/viewers are given the freedom to tailor the story according to their own sensibilities.

FOLLOW ME ♥️

Answer:

No i wouldn’t say so

Explanation:

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:

What process should be followed while giving a reference?
sam

Answers

Keep the information factual. Avoid opinions about issues such as personal conflicts
Qualify what you say. For example, “It was our experience or “In this situation
Make your praise specific. ...
Refer to specific tasks or projects
Avoid examples that highlight a candidate's weaknesses.

I will brainlist

LEAN manufacturing is mostly used in automobile
manufacturing?

True or False

Answers

Answer:

True

Explanation:

Answer:true

Explanation:

Help please I’m on a time limit

Answers

Answer:

4, Im pretty sure. but not 100%

Explanation:

Maria has designed an app for a shopping mall. She is planning to use Google’s cloud testing facility. What will this facility do?
A.
It will offer actionable insights about users.
B.
It will enable her to manage a staged rollout.
C.
It will test the app on a wide range of physical devices.
D.
It will help her acquire new users.

Answers

Answer:

C I think

Explanation:

Tim is trying to explain to his aunt how her computer works, but she does not understand what a CPU does. Which description will most likely help Tim’s aunt understand the CPU’s role?

Answers

Answer:

CPU is considered as the brain of the computer. CPU performs all types of data processing operations. It stores data, intermediate results, and instructions (program). It controls the operation of all parts of the computer.

Explanation:

Answer:

The CPU processes commands from software.

Explanation:

Learned on edge

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

A researcher wants to publish the results of a study in an open access journal. Which of the following is a direct benefit of publishing the results in this type of publication?


The researcher can allow the results to be easily obtained by other researchers and members of the general public.




The researcher can better anticipate the effect of the results and ensure that they are used responsibly.



The researcher can ensure that any personal information contained in the journal is kept private and secure.


The researcher can prevent copies of the research from being accessed by academic rivals.

Answers

Answer:

A. The researcher can allow the results to be easily obtained by other researchers and members of the general public.

Explanation:

An open access journal can be defined as a publishing model or principles which typically involves publishing scholarly articles or research papers free of charge and devoid of any access barrier to the general public.

The main purpose of an open access journal is to make scholarly articles or research papers available to the general public or other researchers without paying for subscriptions or getting licenses.

In this scenario, a researcher wants to publish the results of a study in an open access journal. Therefore, the direct benefit of publishing the results in this type of publication is that, the researcher can allow the results to be easily obtained by other researchers and members of the general public.

People often publish their works on journals. The direct benefit of publishing the results in this type of publication is that;

The researcher can allow the results to be easily obtained by other researchers and members of the general public.What is open access publication in research?

Open access is known to be a publishing model that is meant for scholarly communication. It is known to makes research information readily available to readers at no cost per charge.

It is different  from traditional subscription model where readers have access to scholarly information only through paying a subscription fee.

Learn more about  open access publication from

https://brainly.com/question/8913038

In a business environment, in which situation would email be more appropriate for communicating than texting?
А
Sending a message to your supervisor for not able to attend social gathering
00
Sending a contract to your supervisor for her review and advice
C с
Sending a message to a friend about meeting at the ballgame later that evening
D
Sending a message to a co-worker about a special delivery at the front desk

Answers

Answer:

The answer to this question would be the second one.

Explanation:

The reason for this is because all of the other answers are not as work-related as the second one.

In a non-linear control structure, the statements are executed depending upon the

Answers

Answer:

test condition

Explanation:

Which of the following are safety rules when using household chemicals?
A. Never mix household products together B. Keep chemicals in their original bottles C. Turn on a fan or open windows when using household chemicals. D. All of the above

Answers

Answer:

D. All of the above.

Explanation:

Answer:

all of the above

Explanation:

js took the test

If you can’t see the Assets panel, which of these three buttons do you press?

A) Plugins
B) Assets
c) Layers

Answers

Answer: B

Explanation:

The answer is B


Explanation

I did it

Write a program that prompts the user to enter the number of students and each student's name and score, and finally displays the student with the highest score (display the student's name and score). Also calculate the average score and indicate by how much the highest score differs from the average. Use a while loop.

Answers

Answer:

Follows are the code to this question:

#include <iostream>//defining header file

using namespace std;

int main()//defining main method

{

int n,s=0,j,number,h=-1;//defining integer variables

string name, nh;//defining string variable

float avg;//defining float variable

cout<<"Enter the number of students: ";//print message

cin>>n;//input value in n

while (j< n) //defining loop for input value

{

getline(cin, name);//use getline method to input value

cout<<"Enter the student name: ";//print message

getline(cin, name);//use getline method to input value

cout<<"Enter the score: ";//print message

cin>>number;//input number value

s+= number;//add numbers into s variable

if(h<number)//defining if block that checks h is greater then number

{

nh= name;//use string variable nh to store name value

h= number;//use integer variable h to store name value

}

j++;//increment j value by 1

}

cout<<name<<endl;//print highest name value

cout<<"score: "<<h<<endl;//print highest score value

avg = (float)s/(float)n;//calculate the average value

cout<<"Average is: "<<avg<<endl;//print average value

cout<<"Difference: "<<(h-avg)<<endl;//print average difference

return 0;

}

Output:

please find attached file.

Explanation:

In the above code, inside the main method four integer variable "n,s,j, number, and h", two string variable "name and nh" and one float variable "avg" is defined.

In the next step, n is defined that is used for the input value. and Inside the main method, a while loop is defined, which uses the "getline" method to the input value, and use s variable to add all numbers.

In the next step, if a block is defined that checks "h" is greater than the number value if the condition is true, it will print the highest value of the input variable and its average difference.

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

Answers

Answer:

true

Explanation:

4.5 Code Practice


Write a loop that inputs words until the user enters STOP. After each input, the program should number each entry and print in this format:

#1: You entered _____
When STOP is entered, the total number of words entered should be printed in this format:

All done. __ words entered.

Sample Run
Please enter the next word: cat
#1: You entered cat
Please enter the next word: iguana
#2: You entered iguana
Please enter the next word: zebra
#3: You entered zebra
Please enter the next word: dolphin
#4: You entered dolphin
Please enter the next word: STOP
All done. 4 words entered.

Answers

In python 3:

i = 0

while True:

   word = input("Please enter the next word: ")

   if word == "STOP":

       break

   i += 1

   print("#{}: You entered {}".format(i, word))

print("All done. {} word(s) entered.".format(i))

I hope this helps!

The program is an illustration of loops.

Loops are used to perform repetitive operations.

The program in Python, where comments are used to explain each line is as follows:

#This gets input for the first word

word = input("Please enter the next word: ")

#This initializes count to 0

count = 0

#The following iteration is repeated until the user enters "STOP"

while word != "STOP":

   #This prints the word entered

   print("You entered",word)

   #This increments count by 1

   count += 1

   #This gets input for the next words

   word = input("Please enter the next word: ")

   

   

#This prints the count of all words

print("All",count,"words entered!")

At the end of the program, the number of valid inputs is printed.

Read more about similar programs at:

https://brainly.com/question/18283451


You can enter more than one element of data in the same field. *

True
False

Answers

Answer:

true

Explanation:

im smart

How to build aeroplain pls tell me I want to go to amereeca

Answers

Answer:

lol i think it would be cheaper to but a ticket or drive there

Other Questions
rx:x 6 = -3x + 22 Can function notations be simplified? I was working on this equation: f(x) = -6/9x + 300 I was wondering if I can convert the fraction -6/9 into -2/3? escribe el nmero igaul a 5 decenas y 13 unidades why is a 5 rupees coin attracted by a magnet? name the metal present in the coin Make 3 1/2 cakes in 20 minutes how many cakes can you make in two hours Which of the following statements about the technique of hypnotic regression is not true?O Recovered memories are not reliable.Courts often depend upon recovered memories.O Memories may be planted by the hypnotist.The process may create stress for the subject. 2,76,212+2628 = ______ +2,76,212 True or false science is the study of the natural world expand 2t(6t-3) please what is the name of the sculpture below?a.Jamesb.Davidc.Peterd.Daniel I WILL GIVE U BRAINLIESTRead this excerpt from "The Secret Life of Walter Mitty."Walter Mitty stopped the car in front of the building where his wife went to have her hair done. "Remember to get those overshoes while Im having my hair done," she said. "I dont need overshoes," said Mitty. She put her mirror back into her bag. "Weve been all through that," she said, getting out of the car. "Youre not a young man any longer." He raced the engine a little. "Why dont you wear your gloves? Have you lost your gloves?" Walter Mitty reached in a pocket and brought out the gloves. He put them on, but after she had turned and gone into the building and he had driven on to a red light, he took them off again.How does the contrast between Mitty's view of himself and the reader's view of Mitty affect the story in "The Secret Life of Walter Mitty"?It creates sympathy for Mitty since readers recognize that his fantasies show how he'd like to be, not how he actually is.It builds suspense in the story, as each of Mitty's fantasies places him in more and more danger in reality.It adds humor to the story, since Mitty acts out all of his fantasies among people who have no idea what he's doing.It injects tension in the story, as readers wait to see whether Mitty's wife will realize that her husband is unhappy. where does 17 lie between ok i bet none of you guys/girls can get this right there's three states of matter solid liquid solid gas but what is the fourth one? 42 points! Question 1 (4 points)How did Tarry Town get its name? how was Isabel self-reliant in Adventure of Isabel A worker who harvests vegetables would be susceptible to which of the following combinations of hazards?-unsafe equipment and falls-noise and vehicle injuries-unclean conditions and respiratory risks-heat and muscle injuries Please help, Ive been stuck Regal Cinemas sold a total of 8500 movie tickets. Proceeds totaled $64,600. Tickets can be bought in one of 3 ways: a matinee admission cost $5, student's admission is $6 all day, and regular admission are $8.50. How many matinee tickets were sold if twice as many student tickets were sold as matinee tickets? * Only type the number of matinee tickets that were sold What can people determine about a readers dialogue? Who made laws in ancient Greece? *1) the wealthy nobles2) the king3) the people