LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
34 views
in General by (54.3k points)
closed by
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

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
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).

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...