facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Adding Text and Numbers to a Worksheet in Excel 2016 Test
Excel 2016 Training - Data Entry & Formatting in Excel 2016
Free Online Microsoft Excel Test

* How to add text or numbers to cells
* How to align cell content
* Resizing rows and columns to fit cell contents
* Fitting contents to column width
* How to add paragraphs to cells
* How to edit and delete cell contents

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Adding Text and Numbers to a Worksheet in Excel 2016 Test

Question 1: Adding text and numbers to a worksheet Test - Excel 2016 Test
1) Study the screenshot above. How can you ensure the surnames in Column B are all visible and not cut off?
a) This is not possible in Excel as cells are set to a default size.
b) You must click the Center alignment option button to ensure the surnames are all visible.
c) You can double-click the line on the right-hand side of the grey Column B label to automatically increase the column width to fit the longest surname in the column.
d) None of the options listed above are correct.

2) What does the keyboard shortcut combination Alt + Enter do when pressed whilst adding text to a cell?
a) It deletes the cell content.
b) It moves to the next blank cell.
c) It adds a new cell below the selected cell.
d) It inserts a paragraph within the same cell.

Question 3: Adding text and numbers to a worksheet Test - Excel 2016 Test
3) Study the screenshot of a blank Excel worksheet above.  How would you add the word COMPLETED to cell A1?
a) Go to the Formulas tab and select the INSERT TEXT function. Wait for the dialog box to open and then type COMPLETED to insert it into cell A1.
b) Click or double-click cell A1 and type the word COMPLETED. Press the Enter or Tab key to finalize the entry.
c) Right-click cell A1 and select Insert from the menu. Type COMPLETED in the Insert dialog box to insert it into cell A1.
d) All the options listed above are correct.


4) Where would you find options to align cell contents in the center, right or left?
a) Under the Home tab on the Ribbon in the Alignment group.
b) Under the Format tab on the Ribbon in the Alignment group.
c) Under the Insert New Alignment option located in the bottom right-hand corner of the Excel screen.
d) None of the options listed above are correct.

5) What is the purpose of the Wrap Text function located in the Alignment group?
a) Wrap text creates a heading for the text located within the cell and inserts it as the column heading.
b) Wrap text ensures extra-long lines of text is wrapped into multiple lines so you can see all of it.
c) Wrap text ensures that all letters within a selected cell is capitalized.
d) Wrap text deletes extra lines of text that do not fit within the cell.

Question 6: Adding text and numbers to a worksheet Test - Excel 2016 Test
6) Study the screenshot above. What happens if you double-click the column line to the right of column E?

a) It will hide column E and its contents from view.
b) It will resize all the columns (A, B, C & D) to be the same width as column E.
c) It will delete the contents of column E.
d) It will increase the column width to automatically fit the length of the longest line of text in column E.

Question 7: Adding text and numbers to a worksheet Test - Excel 2016 Test

7) Study the screenshot above. How was a paragraph space inserted between the two lines of text in cell E3 (in the orange box)?

a) The paragraph space was created by pressing Alt + Enter once or more after the word modules. in cell E3.
b) The paragraph space was created by increasing the row height.
c) The paragraph space was created by pressing Enter once or more after the word modules. In cell E3.
d) The paragraph space was created by merging two cells into one.


8) Where on the Ribbon can you find options to Delete Cells, Delete Sheet Rows, Delete Sheet Columns and Delete Sheet?
a) These options are not found on the Ribbon and the only way to delete cells or their contents is to press the Delete button on your keyboard.
b) These options can be found under the Formulas tab on the Ribbon in the Formula Auditing group.
c) These options can be found under the Review tab on the Ribbon in the Accessibility group.
d) These options are found under the Home tab on the Ribbon in the Cells group.


9) How can you ensure that all the rows in an address list you created in Excel are the same height?
a) To ensure that all the rows in the worksheet are the same height, use the Excel ruler to set row and column tab stops.
b) It is not possible to make all rows in an Excel worksheet the same height.
c) Select all the rows or the whole worksheet and drag the row label line of any of the selected rows downwards or upwards to adjust the row height.
d) In the Format group on the Ribbon select the Set Table Height option to ensure the worksheet rows are the same height.



Question 10: Adding text and numbers to a worksheet Test - Excel 2016 Test
10) Study the screenshot above. What is the function of the icon outlined in orange?
a) It is the Center alignment button.
b) It is the Select Column button.
c) It is the Delete Cell Contents button.
d) It is the Hide Column button.