facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Formatting Text and Numbers in Excel 2016 Test
Excel 2016 Training
Data Entry & Formatting in Excel 2016
Free Online Microsoft Excel Quiz

* Selecting a font type, color and size
* Using bold, italic and underline
* Selecting and applying built-in cell styles
* Using the format painter
* Clear formatting from cells

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Formatting Text and Numbers in Excel 2016 Quiz


1) What does the Format Painter in Excel do?
a) It deletes all formatting in a worksheet.
b) It replicates formatting from one cell to another.
c) It checks what formatting is applied to a cell.
d) It inserts rows and columns.

2) What does the shortcut combination Ctrl + U achieve?
a) It bolds the content of the selected cell.
b) It moves the content of the selected cell.
c) It underlines the content of the selected cell.
d) It deletes the formatting applied to the selected cell.

Question 3 - Formatting Text and Numbers in Excel 2016 Test
3) Study the screenshot above. What is the function of the box outlined in orange Cell Styles?
a) It contains a gallery of built in styles that you can apply to your worksheet.
b) It contains the Format Painter options.
c) It contains options for resizing rows and columns.
d) All of the options listed above are correct.


4) Which of the following options will quickly remove formatting from an entire worksheet?
a) The Clear Formats option found under the Clear button in the Editing group.
b) The Delete Formats option found in the Cell Styles gallery.
c) Pressing Shift + Delete on your keyboard.
d) All of the options listed above are correct.

5) Which of the following is the shortcut key combination for applying the Bold format to a selected cell?
a) Ctrl + Alt + B
b) Shift + B
c) Ctrl + B
d) None of the options listed above are correct.


Question 6 - Formatting Text and Numbers in Excel 2016 Test
6) Study the screenshot above. What is the function of the two buttons outlined in orange?

a) Use them to change the font type.
b) Use them to change the font color.
c) Use them to apply bold formatting.
d) Use them to increase and decrease font size.


7) How can you increase the font size of a heading in Excel from size 12 to 95?

a) It is not possible to increase the size of a font beyond 72.
b) Press the Increase Font button repeatedly until you reach 95.
c) Type 95 into the Font size box and press Enter.
d) Change the Font type to one that is 95.



Question 8 - Formatting Text and Numbers in Excel 2016 Test
8) What is the function of the box outlined in orange in the screenshot above?
a) It is the Font box. Click on the dropdown arrow next to it to view, select and apply other fonts.
b) It is the Clear Formats button. It will remove all instances of the selected font.
c) It is the Cell Styles option box. Select a style from the list to apply to your cell.
d) It is the name of the worksheet. Click to change the worksheet name.


9) How can you use the Format Painter to replicate the formatting from one cell to many different cells?
a) It is not possible. The Format Painter allows you to copy the formatting from one cell to another cell once only.
b) Double click the Format Painter and then click in cells to apply the format.
c) Press Ctrl+Shift+F to permanently activate the Format Painter.
d) Click the Format Painter once and then click in cells to apply the format.



Question 10 - Formatting Text and Numbers in Excel 2016 Test
10) What is the function of the button outlined in orange in the screenshot above?
a) Use it to change the color of the font.
b) Use it to increase the size of the font.
c) Use it to underline cell contents.
d) Use it to highlight cell contents.