Question: Select Cell H 3 using absolute referencing. b . If the value in the cell that is one cell to the left of the active

Select Cell H3 using absolute referencing.
b. If the value in the cell that is one cell to the left of the active cell is greater than or equal to 90, then A should be the value displayed in the current active cell. c. If the value in the cell that is one cell to the left of the active cell is greater than or equal to 80, then B should be the value displayed in the current active cell. d. If the value in the cell that is one cell to the left of the active cell is greater than or equal to 70, then C should be the value displayed in the current active cell. e. If the value in the cell that is one cell to the left of the active cell is greater than or equal to 60, then D should be the value displayed in the current active cell.
f. Otherwise, the value displayed in the current active cell should be F. g. Move down one cell below the active cell using relative referencing. h. Write this macro so steps b, c, d, e, and f will be performed over and over again
until the cell one cell to the left of the active cell is blank. Make sure the loop is written so the statements of code will be executed once before the condition is evaluated to determine if the code should be repeated

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!