facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Excel Advanced Worksheet Formatting Test

Free Online Microsoft Excel Tests
Excel 2010 - Worksheets

* Freeze Window Panes
* Split Screens
* Naming Cell Ranges
* Transposing Rows and Columns
* Inserting Comments

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Advanced Worksheet Formatting Test

Question 1 - Excel Test - Advanced Worksheet Formatting
1) Study the screenshot above.  In order to freeze the panes for both the row and first column of this worksheet, which cells, rows or columns should you select to achieve this?
a) Hold down the Ctrl key whilst selecting the first row and first column before clicking on the Freeze Panes button.
b) Select Freeze Row and then select Freeze Columns from the Freeze Panes options.
c) Select the whole worksheet before clicking on the Freeze Panes button.
d) Select cell B2 before clicking on the Freeze Panes button.

Question 2 - Excel Test - Advanced Worksheet Formatting
2) Study the screenshot above.  The data set has been selected and copied.  What are the next actions to take in order to transpose this data set?
a) Move to a blank cell, click on the Paste button and select Transpose.
b) Select the same number of blank cells as the copied selection then click on the Transpose button in the Data group.
c) Click on the Paste button and select Transpose.
d) All of the above options are correct.

Question 3 - Excel Test - Advanced Worksheet Formatting
3) Study the screenshot above. What are the red triangles located in many of the cells above?
a) These are formula errors.
b) These are comments that have been inserted on the cells.
c) These are formatting errors.
d) These are transposed cells.

4) Where in Excel will you find the Freeze Panes function?
a) Under the Home tab in the Cells group.
b) Under the Insert tab in the Tables group.
c) Under the View tab in the Window group.
d) Under the Page Layout tab in the Sheet Options group.


5) How do you insert a comment on a cell?
a) Select the cell, right-click and select Insert Comment from the menu list.
b) Select the cell, in the Comments group under the Review tab, click on New Comment.
c) Select the cell and press Shift+F2 on your keyboard.
d) All of the options listed above are correct.

6) What is a Named Cell Range?
a) This is the heading inserted for each column or row in a Worksheet.
b) This is the row (1,2,3, etc) and column (A, B, C, etc) labels on every Excel worksheet. 
c) This is a name assigned to a cell or range of cells using the Name Box.
d) This is a name assigned to columns and rows in Excel that is used in formulas.
Question 7 - Excel Test - Advanced Worksheet Formatting
7) Study the screenshot above.  How would you go about assigning the name Cost Price to the selected cell range above?
a) Type Cost_Price into the Name Box and press the Enter key.
b) The range has already been named Cost Price.
c) Type Cost Price into the Name Box and press the Enter key.
d) None of the options listed above are correct.


8) How do you delete a Named Range that is no longer needed?
a) Click in the Name Box and press delete to remove the name of the Named Range.
b) Select all the cells in the worksheet, right-click and select Delete Named Ranges.
c) Under the Formulas tab, click on Name Manager and then select the Name to delete from the list.
d) Right click in the Name Box and select Delete from the menu list.


Question 9 - Excel Test - Advanced Worksheet Formatting
9) Study the worksheet above.  Which view function is applied to the worksheet and how do you remove it?
a) Freeze Panes has been applied.  Click on the View tab and click on Freeze Panes to deactivate it.
b) Split Screen has been applied.  Click on the View tab and click on Split to deactivate it.
c) Borders and shading has been applied.  Click on Format Cells to deactivate it. 
d) None of the above options are correct.

10) Which of the options listed below will allow you to quickly view all the Named Ranges applied to a worksheet?
a) Select different sections of the worksheet to observe the name applied to each section in the Name Box.
b) Click on the Name Manager button under the Formulas tab and review the names applied to different cell ranges.
c) Click on the dropdown arrow located next to the Name Box.
d) Insert a formula and observe the available Named Ranges in the Formula suggestion label.