facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Formatting Excel Worksheets ~ How to Add Excel Borders & Shading to Cells Test
Excel 2016 Training - Data Entry & Formatting

Free Online Microsoft Excel Quiz

* How to add Excel Borders to Cells
* Deleting Borders from cells in Excel
* Applying Colored Shading to Cells
* Deleting Colored Shading
* Applying Built-In Formats - save the styles you create

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

How to Add Excel Borders & Shading to Cells in Excel 2016 Quiz

Question 1 - Formatting Excel Worksheets ~ How to Add Borders & Shading to Cells Test
1) Study the screenshot above. Where on the Excel menu list (Ribbon) will you find an option to add lines to a worksheet?
a) Under the Home tab on the Ribbon in the Borders group.
b) Under the Home tab on the Ribbon in the Alignment group.
c) Under the Home tab on the Ribbon in the Font group.
d) Under the Insert tab on the Ribbon in the Cell Lines group.


2) Which of the following is NOT a border option:
a) Right and Left borders
b) Top and Bottom borders
c) Thick Outside borders
d) Circular Outside borders


3) How can you save custom borders and/or fill color formats that you create in your worksheet?
a) Select the formatted cells then click File - Save As and then save the border and/or fill color formats with a name.
b) Select the formatted cells then click on the Cell Styles button in the Styles group, then on New Cell Style and give the style a name.
c) Click on the Insert tab on the Ribbon and in the Save Styles group, click on New Cell Style and give the style a name.
d) None of the options listed above are correct.


4) How can you remove all the border lines applied to a worksheet?
a) Select the entire worksheet and select No Border from the Borders menu list.
b) Select the entire worksheet and press Ctrl + B to delete the borders.
c) Select the entire worksheet and press Ctrl + Delete to delete the borders.
d) Select the entire worksheet and select Remove Borders from the Cell Styles gallery.


Question 5 - Formatting Excel Worksheets ~ How to Add Borders & Shading to Cells Test
5) Study the screenshot above. Where can you find the function to create the orange shading applied to the worksheet?
a) Under the Insert tab in the Fill Colors group.
b) Under the Home tab in the Font group.
c) Under the Page Layout tab in the Fill Colors group.
d) Under the Format tab in the Font group.


Question 6 - Formatting Excel Worksheets ~ How to Add Borders & Shading to Cells Test

6) Study the screenshot above. How can you create and apply this blue gradient fill to cells in a worksheet?

a) Right click selected cells, select Format Cells then Fill Effects. Set a color gradient in the Fill Effects dialog box and press OK to apply.
b) Select cells, click the Fill Colors button then More Colors. Select Fill Effects and set the gradient. Press OK to apply.
c) Select cells, click the Fill Colors button then More Colors, hold down the Ctrl key and select the blue and white colors to apply.
d) All of the options listed above are correct.



7) Harry is creating a worksheet for his company and wants to use his corporate colors as shading for cells in his worksheet. Following which of the steps set out below will allow him to do that?

a) Select the cells, click on the dropdown arrow next to the Fill Color button, select More Colors and then use Custom RGB or HSL to select the color.
b) Select the cells, click on the dropdown arrow next to the Fill Color button, select RGB or HSL to select the color, click Cell Styles and apply.
c) Select the cells, click on the Insert button, select Insert Corporate Colors and then select the color to apply.
d) All of the options listed above are correct.


8) Which steps can you follow to change the color of border lines in a worksheet?
a) Select the cells and use the Fill Color gallery to select a color for the borders.
b) Select a color from the Fill color gallery and then use the Pencil tool to draw the borders.
c) Click on the dropdown arrow next to the Borders button then click on Line Color and select a color for the borders. Use the Pencil tool to draw the borders.
d) All of the options listed above are correct.

9) Which steps do you need to take to remove a Fill Color applied to cells in a worksheet?
a) Select the Cells, click the dropdown arrow next to the Fill Color button and select No Fill.
b) Select the Cells, click the Merge and Centre button in the Alignment group to clear the fill.
c) Select the Cells and press delete on your keyboard.
d) Select the cells, click the Data button and select No Fill.

Question 10 - Formatting Excel Worksheets ~ How to Add Borders & Shading to Cells Test
10) Study the screenshot above. Cells that are no longer applicable have been crossed out. How can you do this using border formatting tools?
a) Select the line shape from the Shapes gallery in the Illustrations group under the Insert tab and draw the cross using 2 line shapes.
b) In the Format Cells dialog, under the Border tab, select two diagonal lines to create the cross out in the Border box. Press OK to apply.
c) Under the Insert tab select Insert Table and select a table with diagonal lines.
d) Use the Draw Border tool to create diagonal cross out lines.

 

More from TestsTestsTests.com