Inserting, Deleting Columns & Rows
10 Questions
| Total Attempts: 53
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: 7481 | Last updated: Mar 22, 2022
-
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?
Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...
Questions: 10 | Attempts: 4499 | Last updated: Mar 22, 2022
-
Sample QuestionHow do you spell check an Excel worksheet?
A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a...
Questions: 10 | Attempts: 3584 | Last updated: Mar 22, 2022
-
Sample QuestionWhat add-in program serves as the data analyzing tool in Excel?
Back to top