Inserting, Deleting Columns & Rows
(55).webp "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. YesExplanation
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. TrueExplanation
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-XExplanation
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. ColumnsExplanation
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. FalseExplanation
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. TabExplanation
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 numbersExplanation
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. TrueExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 07, 2011Quiz Created by
Nsurani