LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
25 views
in Computer by (54.3k points)
closed by

What happens when you select a column and press CTRL SHIFT and Plus (+) at the same time in MS Excel ?


1. The task manager window opens
2. All the numeric values of the selected column are added
3. A new column is added before the selected column
4. A new worksheet is added o the workbook

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 3 : A new column is added before the selected column

The correct answer is A new column is added before the selected column.

  • When you select a column and press CTRL SHIFT and Plus (+) at the same time in MS Excel it adds a new column before the selected column.
  • It is generally used when data is to be inserted in the middle of the table
  • This can also be done by right click on the cell and select the option to add a column before and after the cell.

  • 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

...