Spreadsheets: Functions and Charts — Important Questions

XFD1048576

Step 1: In MS Excel, every cell address is a combination of the column letter(s) and row number. Step 2: MS Excel supports a maximum of 1,048,576 rows, so the last row number is 1048576. Step 3: The last column in MS Excel is XFD (which is the 16,384th column). Step 4: Combining these, the address of the last cell is XFD1048576. Step 5: The other options use incorrect column names or row numbers that do not match Excel's actual limits, making them all incorrect.

=A6*B6*$F$3

Step 1: The requirement is that A6 and B6 should change when the formula is copied (relative references), but F3 (rate) should remain fixed (absolute reference). Step 2: Relative references (A6, B6) will automatically update to A7, B7; A8, B8 etc. when copied down. Step 3: $F$3 uses $ before both column F and row 3, making it absolute — it will not change when copied. Step 4: Option A (=A6*B6*F3) has all relative references — F3 will also change when copied, giving wrong results. Step 5: Option C locks everything — A and B won't update for each row, which is also wrong. Option D (F$3) only loc

11

Step 1: First, apply the MAX() function. MAX(D4:I4) finds the highest value among 88, 87, 91, 90, 94, 98. Step 2: The highest value is 98. So MAX(D4:I4) = 98. Step 3: Next, apply the MIN() function. MIN(D4:I4) finds the lowest value among the same set. Step 4: The lowest value is 87. So MIN(D4:I4) = 87. Step 5: Subtract: 98 - 87 = 11. This operation is called the 'range' in statistics. Options 7, 9, and 10 are all incorrect as they result from wrong identification of max or min values.

Click the first column header, hold Ctrl, click other column headers

Step 1: To select non-consecutive columns, they are not next to each other, so you cannot simply drag. Step 2: The Ctrl key is used in MS Excel to make multiple separate selections that are not adjacent. Step 3: Click the first column header (e.g., column D), then hold Ctrl and click any other column headers (e.g., G, H) to add them to the selection. Step 4: Option A (Shift key) is used for consecutive/continuous selections — it selects everything between the first and last click. Step 5: Option C (Alt key) does not perform multi-column selection. Option D (dragging) selects only consecutive c