Inserting, Deleting Columns & Rows

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 14,934
Questions: 10 | Attempts: 95

SettingsSettingsSettings
Inserting, Deleting Columns & Rows - Quiz


Questions and Answers
  • 1. 

    Do we have more than one way to insert or delet row and column on Excel worksheet ?

    • A.

      Yes

    • B.

      No

    • C.

      None of above

    Correct Answer
    A. Yes
    Explanation
    Yes, we have more than one way to insert or delete rows and columns on an Excel worksheet. One way is to right-click on the row or column header and select the "Insert" or "Delete" option from the context menu. Another way is to use the "Insert" or "Delete" button in the "Home" tab of the Excel ribbon. Additionally, we can also use keyboard shortcuts such as Ctrl + "+" to insert rows or columns and Ctrl + "-" to delete rows or columns.

    Rate this question:

  • 2. 

    You cannot insert comments on each cell.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given correct answer is "True". However, without any context or specific question, it is difficult to provide an explanation for why this answer is correct.

    Rate this question:

  • 3. 

    Which of the following keyboard shortcut is used to cut text?

    • A.

      Ctrl-C

    • B.

      Alt-X

    • C.

      Ctrl-X

    • D.

      Alt-C

    Correct Answer
    C. Ctrl-X
    Explanation
    Ctrl-X is the correct keyboard shortcut used to cut text. This shortcut is commonly used in various applications and text editors to remove selected text and place it in the clipboard. By using Ctrl-X, the selected text is removed from its original location and can be subsequently pasted elsewhere using the Ctrl-V shortcut. This shortcut is widely known and used, making it an essential tool for editing and manipulating text efficiently.

    Rate this question:

  • 4. 

    In Excel, you can organize data to perform mathematical calculations.  Data is organized in rows and ___________________ .

    • A.

      Columns

    • B.

      Rows

    • C.

      None of Above

    Correct Answer
    A. Columns
    Explanation
    In Excel, data is organized in rows and columns. Rows are horizontal and contain individual records or data points, while columns are vertical and represent different variables or attributes of the data. This organization allows for easy manipulation and analysis of the data, as mathematical calculations can be performed on specific rows or columns, or across the entire dataset.

    Rate this question:

  • 5. 

    Once you hide a row, it remains hidden as long as the workbook is active.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    When you hide a row in a workbook, it does not remain hidden as long as the workbook is active. The hidden row will only remain hidden until it is unhidden manually or if a specific action or command is executed to unhide all hidden rows in the workbook. Therefore, the correct answer is False.

    Rate this question:

  • 6. 

    After Excel displays an existing entry in the column that matches the characters you type, press the ______ key to accept the entry

    • A.

      Shift

    • B.

      Tab

    • C.

      Esc

    Correct Answer
    B. Tab
    Explanation
    After Excel displays an existing entry in the column that matches the characters you type, pressing the Tab key will accept the entry. This is because the Tab key is used to move the cursor to the next cell in Excel, and when an existing entry matches the characters typed, pressing Tab will select and accept that entry, allowing the user to move to the next cell for input.

    Rate this question:

  • 7. 

    How are rows labeled in an Excel 2007 spreadsheet?

    • A.

      Across the top with consecutive numbers

    • B.

      Across the top with consecutive letters

    • C.

      Down the side with consecutive numbers

    • D.

      Down the side with consecutive letters

    Correct Answer
    C. Down the side with consecutive numbers
    Explanation
    Rows in an Excel 2007 spreadsheet are labeled down the side with consecutive numbers. This labeling system allows users to easily identify and reference specific rows within the spreadsheet. Each row is assigned a unique number, starting from 1 and continuing consecutively downwards. This labeling convention is consistent with the way rows are labeled in most spreadsheet software, making it intuitive for users to navigate and work with their data.

    Rate this question:

  • 8. 

    what is the shortcut key for inserting Rows and Columns ?

    • A.

      Crt +

    • B.

      Crt -

    • C.

      Crt /

    Correct Answer
    A. Crt +
    Explanation
    The correct answer is "Crt +". This is the shortcut key for inserting rows and columns in various software applications, including spreadsheet programs like Microsoft Excel. By pressing "Crt +" simultaneously, users can quickly add a new row or column to their existing data set without having to manually insert them. This shortcut saves time and improves efficiency when working with large amounts of data.

    Rate this question:

  • 9. 

    What is the Shortcut key for deleting the Rows and Columns ?

    • A.

      Crt +

    • B.

      Crt -

    • C.

      Crt *

    Correct Answer
    B. Crt -
    Explanation
    The shortcut key "Crt -" is used for deleting rows and columns in various applications, including Microsoft Excel and Google Sheets. By pressing the "Ctrl" key and the "-" key simultaneously, users can quickly remove selected rows or columns from a spreadsheet or table. This shortcut is efficient and time-saving, allowing users to easily modify the structure of their data without the need for manual deletion.

    Rate this question:

  • 10. 

    Do we have a cell group in Home Tab ?

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Yes, we have a cell group in the Home Tab.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Dec 05, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 07, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.