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 23:30, jcollings44

You picked the corridor which led you here. if the guards find you, they're going to be really angry! what is the synonym of angry

Answers: 1

continue

Computers and Technology, 22.06.2019 08:50, najashohatee1234

Can online classes such as gradpoint track your ip location like if im taking a final and i give somebody else my account and they take the final for me will it show where they are taking the final from? and can this be countered with a vpn

Answers: 1

continue

Computers and Technology, 22.06.2019 23:30, Molly05

In my email i got a message it says a quick message and in message details on who its from its says nicole and under nicole is 50e0bf08e5b671@ualwgypg91wa5wl. uzo9kbud3qjwddygd5.vng -

Answers: 1

continue

Computers and Technology, 24.06.2019 00:00, marika35

Visualizing a game of “tag” to remember the meaning of contagious

Answers: 3

continue

You know the right answer?

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