facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Aligning Cell Content in Excel 2016 Test
Excel 2016 Training
Data Entry & Formatting in Excel 2016
Free Online Microsoft Excel Quiz

* Horizontal, Vertical and Diagonal Cell Alignment
* Horizontal Cell Alignment
* Vertical Cell Alignment
* Diagonal Cell Alignment
* Wrap Text in a Cell
* Merge and Center Cell Content
* Indent Cell Content

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Aligning Cell Content in Excel 2016 Quiz


Question 1 - Aligning Cell Content in Excel 2016 Test
1) Study the screenshot above. What is the function of the three buttons circled in yellow?
a) These are the increase, center and decrease indent buttons.
b) These are horizontal alignment buttons for left, center and right cell alignment.
c) These are the vertical alignment buttons for top, center and bottom alignment.
d) These are wrap text options for wrapping text around an image (left, center and right).

Question 2 - Aligning Cell Content in Excel 2016 Test
2) Study the screenshot above. What is the purpose of the button outlined in yellow?
a) It is the left indent button.
b) It is the right indent button..
c) It is the vertical alignment button.
d) It is the orientation button..


3) Which function do you use to fit extra-long lines of text over multiple lines to make it easier to read?
a) Use the Wrap Text function.
b) Use the Indent Text function.
c) Use the Diagonal Alignment function.
d) Select the cell and press Alt + Shift + Enter


Question 4 - Aligning Cell Content in Excel 2016 Test
4) Study the heading: My Etsy Shop in the screenshot above. What function(s) do you use to spread a heading over multiple columns like this one is?
a) You only need to use the Center Alignment option.
b) You only need to use the Merge and Centre option.
c) You only need to use the Middle Alignment option.
d) None of the options listed above are correct.


Question 5 - Aligning Cell Content in Excel 2016 Test
5) Carefully study the column outlined in yellow in the screenshot above. What alignment do you think is applied to it?
a) Indent
b) Vertical Alignment: Bottom
c) Horizontal Alignment: Left
d) All of the alignments listed above are applied to the cells.



6) What is the purpose of the Merge and Centre function?

a) To take the contents from multiple worksheets and list it all in the center of a new workbook.
b) To take number values from different columns, total them up and insert the value in the center of the sheet.
c) To combine and center the contents of several cells into one larger combined cell.
d) None of the options listed above are correct.



Question 7 - Aligning Cell Content in Excel 2016 Test

7) Study the screenshot above. Which of these buttons will align text or numbers on the left-hand side of the cell?

a) Button labelled A
b) Button labelled B
c) Button labelled C
d) None of these will align cell contents on the left-hand side of a cell.



Question 8 - Aligning Cell Content in Excel 2016 Test
8) Study the screenshot above. Which of these buttons will align text at the bottom of a cell?
a) Button labelled A.
b) Button labelled B.
c) Button labelled C.
d) It doesn’t matter which one you select, text will automatically align at the bottom of a cell.


9) Where on the Excel menu will you find the Alignment group of functions?
a) Under the View tab on the Ribbon.
b) Under the Page Layout tab on the Ribbon.
c) Under the Home tab on the Ribbon.
d) Under the Data tab on the Ribbon.



10) Which of the following lines best describe the Wrap Text function in MS Excel?
a) It is used to wrap text into a specific shape, for example, a triangle.
b) It is used to set the content of the cell to the left, right or center.
c) It is used to wrap extra-long text into multiple lines so that you can see all of it.
d) None of the descriptions above are correct.