facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Using Data Outline Tools Excel Test

Excel 2010 Training - Working with Data
Free Online Microsoft Excel Test

* Creating an Outline
* Viewing Sections of an Outline
* Inserting Subtotals
* Clearing an Outline


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Using Data Outline Tools Excel Test

Question 1 - Using Data Outline Tools Excel Test
1) Study the screenshot above.  James wishes to automatically outline sections in a worksheet and display a sum total for each section.  He keeps clicking on the button highlighted in yellow in the screenshot above, but this is not having the desired effect.  What is he doing wrong?
a) He didn’t select the cell ranges to outline before trying to AutoSum them.
b) He needs to first create an Outline using the Group button and then use the AutoSum function.
c) He needs to use the Subtotal function in the Outlining group, not the AutoSum function.
d) None of the options listed above are correct.

Question 2 - Using Data Outline Tools Excel Test

2) Study the screenshot above.  What happens when you press the minus symbol (circled in yellow)?
a) This will expand the section of the Outline that has been applied to the worksheet.
b) This will collapse the section of the Outline that has been applied to the worksheet.
c) This will close the section of the Outline that has been applied to the worksheet.
d) This will restore the section of the Outline that has been applied to the worksheet.

3) Where would you find the Subtotal function?
a) Under the Formula tab on the Ribbon in the Function Library group.
b) Under the Home tab on the Ribbon in the Quick Sum gallery.
c) Under the Insert tab on the Ribbon in the Outlining group.
d) Under the Data tab on the Ribbon in the Outlining group.

4) Sally impressed her boss by creating an Outline of data in a worksheet with each section containing a Subtotal.  Her boss wishes to print each of the 300 sections and their totals on a separate page.  Which of the following options will succeed in doing this in most EFFICIENT way?
a) This is a print setting.  Set the printer to print each page on a separate piece of paper.
b) Insert manual page breaks by using the Insert Page Break function located under the Page Layout tab on the Ribbon.
c) Select the data, launch the Subtotal dialog box and tick the box for Page Break Between Groups.
d) All of the options listed above are correct.

Question 5 - Using Data Outline Tools Excel Test

5) Study the screenshot above.  What are the numbers circled in yellow?
a) These are column and row level symbols.  Pressing them will expand/collapse sections that have been grouped together.
b) These are column and row labels.  They indicate in which row or column the cursor is located.
c) These are worksheet minimizing and maximizing buttons.  They allow you to view multiple worksheets at the same time.
d) These are Subtotal buttons.  They allow you to quickly sum and subtract sections that have been grouped together.


6) How can you remove Subtotals that have been applied using the Outline tool?
a) Select the worksheet, click on the Ungroup button and select Remove Outline.
b) Select the worksheet, click on the Ungroup button and select Remove All.
c) Click on the Subtotal button and in the Subtotal dialog box select Remove All.
d) All of the options listed above are correct.

7) Kristy wishes to add the average sales for each sales person per product to a worksheet.  Where can she find the option to insert Subtotals as averages?
a) In the Subtotal dialog box she needs to change the option below the label, Use Function, to Average.
b) After grouping sections using the outline tools, she needs to change the function in each formula from Sum to Average.
c) She needs to insert the formula:  =Average() into the Outline dialog box.
d) None of the options listed above are correct.


Question 8 - Using Data Outline Tools Excel Test
8) Study the screenshot above.  Are the options listed in the area circled in yellow the ONLY options for places to add a Subtotal to in Excel?
a) Yes, these are built into the Outline function in Excel and cannot be changed.
b) No, these are the default options only. If you right-click and select Add Option, you can manually add more options.
c) It only applies to the current worksheet. New worksheets will allow you to create new options.
d) No. These options are based on the column headings in the worksheet which are included in the cell range selection.  If you change the column headings, these options will change to match the new column headings.

Question 9 - Using Data Outline Tools Excel Test
9) Study the screenshot above.  Will pressing Ungroup CLEAR only the Outline applied to the selected cell range (shaded in blue and circled yellow) or the entire worksheet?
a) It will remove all the outlines, groups and subtotals applied to the worksheet.
b) It will remove all the outlines and groups applied to the worksheet.
c) It will remove all the outlines and groups applied to the selected cell range only.
d) It will not remove any outlines or groups as the whole worksheet is not selected.

Question 10 - Using Data Outline Tools Excel Test
10) Study the worksheet above.  Grace is trying to insert a Subtotal for each client, but the sections are not grouping together correctly and not adding up the totals for each client.  What appears to be the problem?
a) The worksheet has been sorted according to Contractor and not Client.
b) The subtotals have been added to the Client instead of the Contractor column.
c) The worksheet has been grouped incorrectly with outlines applied to all the data.
d) The worksheet has been sorted from highest to lowest amounts in the Last Year and Current Year columns.