Inserting, Deleting Columns & Rows
10 Questions
| Total Attempts: 47
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
- 2.You cannot insert comments on each cell.
- A.
True
- B.
False
- 3.Which of the following keyboard shortcut is used to cut text?
- A.
Ctrl-C
- B.
Alt-X
- C.
Ctrl-X
- D.
Alt-C
- 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
- 5.Once you hide a row, it remains hidden as long as the workbook is active.
- A.
True
- B.
False
- 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
- 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
- 8.what is the shortcut key for inserting Rows and Columns ?
- A.
Crt +
- B.
Crt -
- C.
Crt /
- 9.What is the Shortcut key for deleting the Rows and Columns ?
- A.
Crt +
- B.
Crt -
- C.
Crt *
- 10.Do we have a cell group in Home Tab ?
- A.
True
- B.
False
Questions: 22 | Attempts: 5250 | Last updated: Dec 16, 2020
-
Sample QuestionWhich formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
After taking the Excel tutorial, take this quiz.
Questions: 8 | Attempts: 3119 | Last updated: Jun 7, 2019
-
Sample QuestionThe advantage of using a spreadsheet is:
CLICK HERE to access the training videos for this course.
Questions: 29 | Attempts: 2970 | Last updated: May 4, 2016
-
Sample QuestionFrom the following list, select the choice that is a 3D formula in Excel.
Back to top