Here is aworksheet with the spending of some people on their meals ina day. Spendings...

Transcribed Image Text:

Here is aworksheet with the spending of some people on their meals ina day. в Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 30 85 25 50 4 Candy 5 Dennis 6 Anthony 7 Amy 22 44 78 92 18 40 49 30 20 38 25 30 80 Cells B3 to E7 are then selected. B. D. Spendings Tea 2 Name Breakfast Lunch Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 Next, a VBA macro is run while the cells are selected. The macro will highlights the names of the people whose spending of any meals is higher than or equal to 50. Here is the VBA macrowith some missing code: Sub HighlightMeals() Dim ThisCell As Range Cells.Interior.Colorindex = x1None For Each Thiscell In If Thiscell.Value >= 50 Then Blank 1 Cells( 8lank 2, 1). Interior.Color = vbYellow End If Next ThisCell End Sub After running the VBA macro, the worksheet becomes: B. D. Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 8. You need to fill in the blanks in the code so that the macro performs as described above. You need to write the answers clearly in the boxes below. Do not add any spaces in the answers. For example, if you need to write an expression such as A+ B, you will write A+B without any spaces in between. Blank 1 is Blank 2 is Here is aworksheet with the spending of some people on their meals ina day. в Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 30 85 25 50 4 Candy 5 Dennis 6 Anthony 7 Amy 22 44 78 92 18 40 49 30 20 38 25 30 80 Cells B3 to E7 are then selected. B. D. Spendings Tea 2 Name Breakfast Lunch Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 Next, a VBA macro is run while the cells are selected. The macro will highlights the names of the people whose spending of any meals is higher than or equal to 50. Here is the VBA macrowith some missing code: Sub HighlightMeals() Dim ThisCell As Range Cells.Interior.Colorindex = x1None For Each Thiscell In If Thiscell.Value >= 50 Then Blank 1 Cells( 8lank 2, 1). Interior.Color = vbYellow End If Next ThisCell End Sub After running the VBA macro, the worksheet becomes: B. D. Spendings 2 Name Breakfast Lunch Tea Dinner 3 Brenda 4 Candy 5 Dennis 6 Anthony 7 Amy 30 85 25 50 22 44 78 92 18 40 49 30 20 38 25 55 30 80 8. You need to fill in the blanks in the code so that the macro performs as described above. You need to write the answers clearly in the boxes below. Do not add any spaces in the answers. For example, if you need to write an expression such as A+ B, you will write A+B without any spaces in between. Blank 1 is Blank 2 is

Answer rating: 100% (QA)

Please find the code below ... View the full answer