Question

Suppose the A1 cell of an MS-Excel worksheet contains the formula " =C5+A4". If A1 cell is copied and pasted into D5 cell, then what will be formula in D5?
1. C5+A4
2. C10+A9
3. F5+D4
4. F9+D8

Answer 1

Correct Answer - Option 4 : F9+D8

The correct answer is F9+D8.

• If cell A1 is copied in cell D5.
• Then, the same pattern will be followed in the D5 cell.
• It means C5 cell is horizontally and vertically 3 and 5 cells down respectively.
• Similarly, F9 is horizontally and vertically 3 and 5 cells down respectively from D5 cell.
• A4 is three cells downward from the A1 cell.
• In the same way, D8 is three cells downward from the D5 cell.
• Hence, the formula is in the D5 cell is F9+D8.

Some important shortcuts used in MS Excel:

• Ctrl + N Create a new workbook.
• Ctrl + O Open an existing workbook.
• Ctrl + S Save the active workbook.
• F12 Save the active workbook under a new name, displays the Save as dialog box.
• Ctrl + W Close the active workbook.
• Ctrl + C Copy the contents of the selected cells to Clipboard.
• Ctrl + X Cut the contents of the selected cells to Clipboard.
• Ctrl + V Insert the contents of the Clipboard into the selected cell(s).