Cursor Highlighting in Excel

What are the Average and the Sum of the cells that are highlighted when you put the cursor on cell A10, hold down Ctrl and Shift, and press the up arrow one time? Round your answers to the nearest whole number.

a. 816,2449

b. 1007,6043

c. 849,8492

d. 944,8492

Answer:

The correct answer is d. 944,8492.

Placing the cursor on cell A10, pressing and holding Ctrl and Shift, then pressing the up arrow would highlight nine cells from A10 to A2. The sum of the highlighted cells is 8492 and the rounded-off average is 944.

When you highlight cells in Excel by positioning the cursor at one endpoint, holding down Ctrl and Shift, and pressing the up arrow key, you essentially highlight all the cells from your current position to the top of the column. In this case, you're starting at cell A10 and moving upwards.

Therefore, the highlighted cells are those which include numbers 480, 275, 96, 30, 718, 4444, 984, 66, and 1399.

To find the sum of these numbers, you simply add them all together. The sum of these numbers is 8492. To find the average, you divide the sum by the number of highlighted cells (which is 9 in this case). So, the average rounds off to 944. Therefore, the correct answer is d. 944,8492.