facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Formatting Text Test

Free Online Microsoft Excel Tests
Excel 2010 - Entering Data

* Font Options  
* Fitting Text to a Cell
* Setting Text Alignment
* Copy Formatting

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Excel Formatting Text Test

1) To change the font of your entire spreadsheet, to make it bold, italic or underline it, you must first:
a) Select the font you wish to use.
b) Go to the Insert tab on the Ribbon and select:  "Insert Font Options".
c) Select all the cells to which you wish to apply the formatting changes.
d) Click the bold, underline or italic buttons in the home tab.

Question 2 - Microsoft Excel Tests
            Entering Data - Formatting Text Test

2) Study the example of a spreadsheet in the image above.  Which steps do I need to take to ensure the title that is cut off in row 1 appears centered across column A, B and C?

a) Resize the cells until the title fits across these columns.
b) Double click the column divider line in column C to adjust it.
c) Select the cell containing the title text (A1).  Click Merge & Centre.
d) Select the three cells (A1:C1).  Click Merge & Centre.


Question 3 - Microsoft Excel Tests
            Entering Data - Formatting Text Test

3) In the example above, some of the contents in column B is cut-off. How would you go above fixing it so that all the text is displayed?

a) Select column B by clicking on the B.  Double click on the divider line on the right-hand side of the B.
b) Launch the Format Cells Alignment dialogue box, check the box next to 'Shrink to fit'.
c) Select column B and drag the divider line on the right-hand side to the right, to resize the column.
d) All of the above options are correct.


Question 4 - Microsoft Excel Tests
            Entering Data - Formatting Text Test

4) Study the example above.  What action would you take to display the second sentence in each cell in column C on a second line?

a) Select column C and click the Wrap Text button in the Alignment group.
b) Position the cursor before each second sentence and press: Alt + Enter on your keyboard.
c) Select column C and click the Wrap Text button in the Alignment group.  Position your cursor before each of the second sentences and press:  Enter.
d) None of the above options are correct.


5) Where will you find options to change the font type, size and color?
a) On the Home tab in the Text group.
b) On the Review tab in the Font group.
c) On the Page Layout group in the Font dialogue box.
d) On the Home tab in the Font group.


6) Which of the following two options allow you to copy formatting from one cell to another?
a) The format painter and the Fill handle.
b) The copy and paste function and the format painter.
c) The font group functions and the Wrap Text button.
d) The format painter and the Copy Formatting button.

Question 7 - Microsoft Excel Tests
            Entering Data - Formatting Text Test
7) Study the example above.  You will note the contents in many of the cells are not lining up and look inconsistent.  What is a quick way of fixing this?
a) Select the whole spreadsheet and click on the Merge & Centre button.
b) Select the whole spreadsheet and click on the Wrap Text button.
c) Select the whole spreadsheet and click on one of the horizontal alignment buttons and one of the vertical alignment buttons.
d) Select the whole spreadsheet, click on the Wrap Text button and then on one of the horizontal alignment buttons.



Question 8 - Microsoft Excel Tests
            Entering Data - Formatting Text Test

8) Study the button circled in orange on the picture of a section of the Ribbon above.  If I select text and press this button, what will happen to my text?

a) The text will be underlined with a blue line.
b) The font color of text will change to blue.
c) The selected text will change to capital letters.
d) Text will be lifted slightly above the gridline underneath it.

Question 9 - Microsoft Excel Tests
            Entering Data - Formatting Text Test

9) What will happen to cells I have selected if I press the button circled in orange in the section of the Ribbon pictured above?

a) Nothing. Pressing this button will give you options to change the orientation of text in your cell(s).
b) The alignment of text in your selected cell(s) will change to match that of the 'ab' pictured on the button.
c) Your text will change to lowercase letters
d) None of the above options are correct.


10) In order to use the Format Painter to replicate formatting over multiple non-adjacent cells, what additional step(s) do I need to take?
a) Hold down the control button on your keyboard whilst using the Format Painter.
b) Double click the Format Painter button when copying formatting.
c) Hold down the left mouse button whilst using the Format Painter.
d) Hold down the control button on your keyboard and click the Format Painter button when copying formatting.