facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Shortcuts for Inserting & Deleting Rows, Columns & Cells Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013

* Selecting Rows and Columns
* Deleting Rows and Columns
* Inserting Rows and Columns
* Resizing Rows and Columns


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Shortcuts for Inserting & Deleting Rows,
Columns & Cells Test

1) If you quickly wanted to select a column to, for example, apply shading to the entire column, which of the following shortcut key combinations could you use?
a) Ctrl+a to select the entire column.
b) Ctrl+Shift+Space to select the entire column.
c) Ctrl+Space to select the entire column.
d) Ctrl+c to select the entire column.
2) What will happen if I select a row and press Ctrl+- on my keyboard?
a) It will insert the hyphen or minus symbol '-'.
b) It will delete the contents of the first cell in the selection.
c) It will delete all the contents contained in cells in the selection.
d) It will delete the row.
3) Study the screenshot of a timesheet below.  Britney wishes to insert multiple rows to add her lunch breaks for the whole year.  How can she quickly insert rows by using a shortcut key combination?
a) By selecting a row and pressing Ctrl+Shift+r repeatedly to insert rows.
b) By selecting a row and pressing Ctrl+Shift+ repeatedly to insert rows.
c) By selecting a row and pressing Alt+ repeatedly to insert rows.
d) All of the above methods will work.
Question 3 - Excel Shortcuts for Inserting and Deleting Rows, Columns and Cells Test

4) Study the screenshot of a worksheet below.  Many of the columns contains content that is hidden.  Which of the following shortcut combinations could you use to quickly resize all the columns to ensure the content is displayed?
a) Pressing Ctrl+a and then Ctrl+ will resize all the columns.
b) Pressing Alt+r will resize all the rows and columns.
c) Pressing Ctrl+a and then Alt+oca will resize all the columns to fit their contents.
d) There is no shortcut combination to do this.  You would have to manually resize columns using her mouse.
Question 4 - Excel Shortcuts for Inserting and Deleting Rows, Columns and Cells Test
5) Study the screenshot of a section of a worksheet below.  The current selected cell is B5.  What will happen if the shortcut combination Shift+Space is pressed with this cell selected?
a) The entire Row 5 will be selected.
b) The contents of B5 will be deleted.
c) The cell size of B5 will increase or decrease to match the contents of the cell.
d) The cell contents will be duplicated.

Question 5 - Excel Shortcuts for Inserting and Deleting Rows, Columns and Cells Test

6) What happens if you select a column, hold down the Alt key and press the letters ocw in quick succession?
a) The contents of the first cell in the selected column will be replaced with the letters 'O-C-W'.
b) The contents of the entire column will be deleted.
c) The column width will be adjusted to fit its contents.
d) The column width dialogue box opens allowing you to set the exact width of the column.

7) Study the screenshot of a section of a worksheet below this question.   It appears some of the content is missing or squashed within the row.  Which of the following shortcut combinations will quickly fix this problem?
a) By pressing Ctrl+a to select the worksheet and then pressing Alt+owa the rows will be resized to fit the contents.
b) By pressing Ctrl+a to select the worksheet and then pressing Alt+ora, the rows will be resized to fit the contents.
c) By pressing Ctrl+a to select the worksheet and then pressing Alt+Shift+owa, the rows will be resized to fit the contents.
d) None of the above options are correct.
Question 7 - Excel Shortcuts for Inserting and Deleting Rows, Columns and Cells Test

8) Which shortcut key combination can you use to launch the Row Height dialogue box?
a) Shift+Alt+owa will launch the Row Height dialogue box.
b) Ctrl+Alt+ore will launch the Row Height dialogue box.
c) Alt+ore will launch the Row Height dialogue box.
d) Alt+ocw will launch the Row Height dialogue box.

9) Which of the following best describes the function of the Alt+oca shortcut combination?
a) It increases the width of columns to fit its contents.
b) It increases the height of rows in order for content to fit.
c) It launches the row height and/or column width dialogue boxes.
d) All of the above options are correct.

10) Study the screenshot of a worksheet with the Insert Dialogue box circled in yellow, below.  What is the shortcut combination for launching this very useful dialogue box?
a) Selecting a cell and pressing Shift+
b) Selecting a cell and pressing Ctrl+
c) Selecting a cell and pressing Alt+ocw
d) Selecting a cell and pressing Ctrl+Shift+
Question 10 - Excel Shortcuts for Inserting and Deleting Rows, Columns and Cells Test