Computers and Technology, 02.03.2021 07:10, quanntwann2873

1. Write your name in cell C2 2. Change the font size of Cell range B2:C2 and highlight them by adding a background colour
3. Write VLOOKUP in H3 cell to write the capital of a country given in cell G3
4. Link “February 2020” worksheet to write the weather in the cell range B9:K10
5. Link “February 2021” worksheet to write the weather in the cell range B13:K14
6. Write a formula to find out the Average Temperature for 1st February based on the data for 2020 and 2021 in cell B17
7. Write a formula to find out the highest temperature in February 2021 in cell B18
8. Write a formula to find out the lowest temperature in February 2021 in cell B19
9. Add data for 11th February 2021 as: a. Max Temperature: 31° b. Min Temperature: 16°
10. Now write an updated formula to find out the highest temperature in February 2021 in cell B21
11. Now write an updated formula to find out the lowest temperature in February 2021 in cell B22
12. If the temperature of a day is 28° or more, it will be considered a hot day. If the temperature of the day is 12° or below, it will be considered a cold day. Write an IF formula in cell range B15:K15 to tell if the day in February 2021 was a hot day or a cold day.

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 22:40, bartekpiglo

Write an assembly program with the following specifications. a). in the main block, you should have two registers r4 and r5. they should be checked in an infinite loop. if r4 is greater than r5, then the greater subroutine will be called. if r4 is less than r5, then the less subroutine will be called. if r4 equals r5, then no operations will be done

Answers: 1

continue

Computers and Technology, 22.06.2019 08:00, Leggett8152

What best describes a career pathway in a lodging career? a worker starts out as an amusement attendant, then becomes a recreation worker, and then becomes a gaming worker within five years. a worker starts out as a bell hop, then becomes a night clerk, and then becomes a hotel manager within five years. a worker starting out as a tour guide, then becomes a travel clerk, and then becomes a travel agent within five years. a worker starts out as a server, then becomes a food preparer, and then becomes a head chef within five years.

Answers: 1

continue

Computers and Technology, 22.06.2019 22:30, juliangarcia0002

Which of the following factors would your hypothetical supervisor look at when deciding whether to test a biological material sample for dna? the amount of other evidence you have implicating a suspect in a crime the annual budget for the crime lab both of the above none of the above; you would almost always order a test

Answers: 3

continue

Computers and Technology, 24.06.2019 08:20, brinks7994

Which type of entity describes a fundamental business aspect of a database? a. linking b. lookup c. domain d. weak

Answers: 3

continue

Do you know the correct answer?

1. Write your name in cell C2 2. Change the font size of Cell range B2:C2 and highlight them by ad...