Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Microsoft Excel Guide: Data Manipulation and Analysis, Exams of Business Administration

Chamberlain College of NursingBusiness Administration

A detailed guide on how to perform various tasks in microsoft excel, such as importing data from csv files, linking cell contents, merging cells, applying conditional formatting, expanding chart data ranges, copying worksheets to new workbooks, replacing text, repeating rows for printing, inserting formulas, modifying charts, removing duplicate records, freezing panes, adding document properties, inserting functions to join text, enabling total rows, inserting formulas for maximum values, creating tables, and applying styles to charts. It is designed to help users enhance their skills in using excel for data management and analysis. The guide includes step-by-step instructions and hints to ensure users can successfully complete each task. Useful for anyone looking to improve their proficiency in microsoft excel and efficiently manage data.

Typology: Exams

2024/2025

Available from 06/17/2025

TheHub
TheHub 🇺🇸

3.9

(33)

11K documents

1 / 24

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
MOS Exam SG 2 with 100%
VERIFIED SOLUTIONS
2025/2026 STUDY GUIDE
Beginning at cell A16 on Sheet1, import the list from the comma delimited source file
MoreToys.csv located in the GMetrixTemplates folder. (Accept all other defaults)
1. On the Sheet1 worksheet, click cell A16 to select it.
2. On the DATA tab, in the Get External Data group, click From Text. (Hint: If you do not see these
options listed in the Data Tab you may need to enable the Legacy Import Wizards. To do this, go to File >
Options > Data > Show legacy data import wizards and check From Text. Once this is complete you can
use the Get Data drop-down to select the Legacy Wizards and select From Text.)
3. Browse to the GMetrixTemplates folder.
4. Select the MoreToys.csv file and click the Import button.
5. In the Text Import Wizard - Step 1 of 3 pop-up window, accept the default data type as Delimited and
click the Next button.
6. In the Text Import Wizard - Step 2 of 3 pop-up, change the Delimiter from Tab to Comma by clicking on
the box next to Tab to clear it, then clicking on the box next to Comma to select it. (Hint: Notice how you
can preview how the data will be separated in the window below).
7. Accept all other defaults and click the Finish button.
8. In the Import Data pop-up accept the defaults and click OK.
(Hint: If you do not see these options listed in the Data Tab you may need to enable the Legacy Import
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18

Partial preview of the text

Download Microsoft Excel Guide: Data Manipulation and Analysis and more Exams Business Administration in PDF only on Docsity!

MOS Exam SG 2 with 100%

VERIFIED SOLUTIONS

2025/2026 STUDY GUIDE

Beginning at cell A16 on Sheet1, import the list from the comma delimited source file MoreToys.csv located in the GMetrixTemplates folder. (Accept all other defaults)

  1. On the Sheet1 worksheet, click cell A16 to select it.
  2. On the DATA tab, in the Get External Data group, click From Text. (Hint: If you do not see these options listed in the Data Tab you may need to enable the Legacy Import Wizards. To do this, go to File > Options > Data > Show legacy data import wizards and check From Text. Once this is complete you can use the Get Data drop-down to select the Legacy Wizards and select From Text.)
  3. Browse to the GMetrixTemplates folder.
  4. Select the MoreToys.csv file and click the Import button.
  5. In the Text Import Wizard - Step 1 of 3 pop-up window, accept the default data type as Delimited and click the Next button.
  6. In the Text Import Wizard - Step 2 of 3 pop-up, change the Delimiter from Tab to Comma by clicking on the box next to Tab to clear it, then clicking on the box next to Comma to select it. (Hint: Notice how you can preview how the data will be separated in the window below).
  7. Accept all other defaults and click the Finish button.
  8. In the Import Data pop-up accept the defaults and click OK. (Hint: If you do not see these options listed in the Data Tab you may need to enable the Legacy Import

Wizards. To do this, go to File > Options > Data > Show legacy data import wizards and check all that apply. Once this is complete you can use the Get Data drop-down to select the Legacy Wizards and select the Wizard that applies.) On the Carriers and Coolers worksheet, link the contents in cell C10, C11, and C12 to cell A4 on the Tackle worksheet.

  1. Select cell C10 on the Carriers and Coolers worksheet
  2. On the INSERT tab, in the Links group, click Hyperlink.
  3. In the Link to: section, select Place in This Document.
  4. In the "Type the cell reference" field, type "A4"
  5. In the "Or select a place in this document" field, under Cell Reference, highlight Tackle
  6. Click OK.
  7. Repeat steps 1 through 6 for cells C11 and C12. Join cells A1:E1 of the Tackle worksheet. Do not change the alignment of the contents.
  8. Select cell range A1:E1 on the Tackle worksheet.
  9. On the HOME tab, in the Alignment group, click the Merge & Center drop-down arrow and select Merge Across. On the Carriers and Coolers worksheet, apply the 3 Flags Icon Set Conditional Formatting to the contents in the Inventory column.
  10. Select cell range D4:D19 on the Carries and Coolers worksheet.
  11. On the HOME tab, in the Styles group, click Conditional Formatting to open the menu.
  12. Select Icon Sets and click 3 Flags. On the Carriers and Coolers worksheet, expand the chart data range to include the rest of the rows in the table
  13. On the Carriers Coolers worksheet, click in the center of the chart to select it.
  14. Click the Chart Tools Design contextual tab.
  15. In the Data group, click Select Data.
  16. In the Select Data Source pop-up window, in the Chart data range field, change the last value to $D$19.

(Hint: You can see the result by clicking Print Titles again, then clicking Print Preview. The first page will display in the Print Preview window. At the bottom of the window, advance to the second page by clicking the Next Page arrow located right of 1 of 2. You should see the column headings displayed at the top of the table on both pages. Click the return arrow in the upper left corner of the window to go back to the spreadsheet.) In cell B28 on the Profits worksheet, insert a formula that displays the number of Sales greater than 250.

  1. Click the Profits worksheet tab to select that worksheet.
  2. Click cell B28 to select it.
  3. On the FORMULAS tab, on the far left click Insert Function.
  4. In the Insert Function pop-up window, in the Search for a function: field, type COUNTIF. Click Go.
  5. In the Select a function: window, select COUNTIF and click OK.
  6. In the Function Arguments pop-up window for COUNTIF, type the following in the fields: Range: D4:D Criteria: ">250"
  7. Click OK. (Hint: The completed entry in the Formula Bar should read =COUNTIF(D4:D26,">250") ) Modify the chart on the Profits worksheet so the Flavors are displayed as Horizontal Axis Labels and Expense and Income are the Legend Series.
  8. If the Profits worksheet Is not already displayed, click the Profits worksheet tab to select it.
  9. Click the chart to reveal the CHART TOOLS tabs.
  10. On the CHART TOOLS DESIGN tab, in the Data group, click Switch Row / Column. Modify the chart on the Profits worksheet so the Legend appears at the Top.
  11. If the Profits worksheet Is not already displayed, click the Profits worksheet tab to select it.
  12. Click the chart to reveal the CHART TOOLS tabs.
  13. On the far left of the CHART TOOLS DESIGN tab, in the Chart Layouts group, click Add Chart Element, select Legend and click Top. Simultaneously remove all duplicate records in the Wired Networks table.
  1. Click any cell within the Wired Networks table.
  2. On the DATA tab, in the Data Tools group, click Remove Duplicates. (Hint: Notice the entire table is automatically selected.)
  3. Accept all defaults and click OK. (Hint: A pop-up window should confirm that 2 duplicate records were removed.)
  4. Click OK. Configure the Q1 Sales worksheet so rows 1 through 3 remain visible as you scroll vertically.
  5. On the Q1 Sales worksheet, select row 4. (Hint: When freezing frames vertically, select the row below the last row you want to remain visible.)
  6. On the View tab, in the Window group, click the Freeze Panes down-arrow and select Freeze Panes. Add the Subject Equipment Draft to the document properties.
  7. Click the FILE tab.
  8. In the bottom right corner of the Info page, click the Show All Properties link.
  9. In the Subject field, type Equipment Draft.
  10. Click the return arrow in the upper-left corner of the Info window to display the document. In cell B4 on the Q1 Sales worksheet, insert a function that joins Description and Style from the Catalog worksheet, separated by a hyphen. Include a space on both sides of the hyphen. (Example: Cross Country - Hardtail).
  11. On the Q1 Sales worksheet, select cell B4.
  12. Click the FORMULAS tab and click Insert Function.
  13. In the Search for a function field, type the keyword, Join and then click GO.
  14. In the Select a function field, select CONCATENATE. Click OK.
  15. In the Function Arguments pop-up window for CONCATENATE, do the following: a. Click in the Text1 field. b. Click the Catalog worksheet tab. In the Description column, select cell D4. c. Click in the Text2 field d. Type a set of quotes containing a space, a hypen, and a space. Example: " - " e. Click in the Text3 field.

Insert a formula into cell G4 on the Employee Bonuses worksheet that evaluates whether the amount in Parts, Accessories, or Services exceed the Quarterly Goal. For each column that exceeds the goal, apply the Quarterly Bonus Rate.

  1. On the Employee Bonuses worksheet, select cell G4. (Hint: Always put your formula in the cell where you want the result to be displayed)
  2. On the FORMULAS tab, in the Function Library, click Insert Function.
  3. In the Search for a function: field, type Sumif and click GO.
  4. In the Select a function field, click SUMIF and click OK.
  5. In the SUMIF pop-up window, configure the following: Range: B4:D Criteria: > Sum_Range: B4:D (Hint: You can leave this field blank and the cells in the Range field will be used by default.)
  6. Click OK.
  7. In the Formula Bar, to the right of the SUMIF formula, multiply it by the ""Quarterly Bonus Rate"" so it reads as follows: =SUMIF(B4:D4,">100000")*$B$
  8. Press the Enter key to accept the formula and calculate the result. On the Employee Bonuses worksheet, disable the headings on the Rates table.
  9. Click anywhere on the Rates table to select it.
  10. On the TABLE TOOLS DESIGN tab, in the Table Styles Options group, click the Header Row box to clear it and disable the option. In cell F4 on the Parts worksheet, insert a line that graphs the trend of sales from Jan through Mar.
  11. Select cell F4 on the Parts worksheet.
  12. Select the INSERT tab.
  13. In the Sparklines group, click Line.
  14. In the Create Sparklines pop-up window, configure the fields as follows: Data range: B4:D

Location range: $F$

  1. Click OK. Modify the scaling of the Sales Commissions worksheet so it fits on a single page when printed.
  2. Click the FILE tab.
  3. In the category column, click Print.
  4. At the botton of the Settings section, click the down-arrow to change No Scaling to Fit Sheet on One Page.
  5. Click the circled arrow located in the upper-left of the FILE tab to return to the Sales Commissions worksheet. In the Sales Commissions worksheet, use an automatic formatting method to apply Orange Gradient Fill Data Bars to the Total Sales column that changes the cell formatting whenever the cell values change.
  6. Select cell range F4:F10 on the Sales Commissions worksheet,
  7. On the HOME tab, in the Styles group, click Conditional Formatting to open the menu.
  8. Select Data Bars and beneath the Gradient Fill section, click Orange Data Bar. In the Sales Commissions worksheet, insert a formula in cell G4 that references the data in the Total Sales column and the Commission Rate in cell J3 to calculate the values in the Commission column. Copy the formula into all the cells in the Commission column.
  9. Select cell G4.
  10. In the Formula Bar, type the following: =F4*J$3 (Hint: The result should be $ 4,599)
  11. In the lower-right corner of the G4 cell, click the small square (a.k.a, the Fill Handle) and drag down the Commission column to copy the formula into cells G5 through G10. (Hint: If the copied formula fails to display a value, check your absolute referencing to cell J3. You must include the $ symbol in front of the row reference to prevent relative referencing which changes the row value.) Outline both the columns and rows of the table on the Summary worksheet.

(Hint: You can see the result by clicking Print Titles again, then clicking Print Preview. The first page will display in the Print Preview window. At the bottom of the window, advance to the second page by clicking the Next Page arrow located right of 1 of 2. You should see the column headings displayed at the top of the table on both pages. Click the return arrow in the upper left corner of the window to go back to the spreadsheet.) Apply the Orange, Accent 2 Fill Color and White, Background 1 Font Color and apply the bold format to cell range A2:B2 on the Cookie Sales worksheet.

  1. At the bottom of the workbook, click the Cookie Sales worksheet.
  2. Select cell range A2:B2.
  3. On the HOME tab, in the Font group, click the Fill Color icon and in the first row select Orange, Accent
  5. In the Font group, click the Font Color icon and in the first row select White, Background 1.
  6. In the Font group, click the Bold icon. On the Fundraiser worksheet, configure the table to display only records of the Blazing Broncs club members.
  7. At the bottom of the workbook, click the Fundraiser worksheet.
  8. On the table, click the autofilter down-arrow of either of the color filled cells A3 or B3.
  9. Select Filter by Color and click the blue icon. (Hint: Blue is the fill color that identifies records of the Blazing Broncs club members.) Insert Page 1 of? page numbering in the header of the Q1 Sales worksheet.
  10. At the bottom of the workbook, click the Q1 Sales worksheet tab to select it.
  11. On the INSERT tab, in the Text group, click Header & Footer.
  12. Click on the text, Click to add header, to reveal the HEADER & FOOTER TOOLS DESIGN tab.
  13. In the Header & Footer group, click Header and select Page 1 of?
  14. On the VIEW tab, in the Workbook Views group, click Normal to close the Page Layout View (header and footer view). Copy the data from cell range A8:E13 on the Q1 Sales worksheet and transpose it to the cell range beginning at A8 on the Seedling Sales worksheet.
  1. At the bottom of the workbook, click the Q1 Sales worksheet tab to select it.
  2. Select all cell range A8:E13. (Hint: Do not include the Total column).
  3. Right-click and select Copy. (Note: You can also copy the range either by clicking Copy in the Clipboard group on the Home page, OR by using the short-cut key combination CTRL + C. )
  4. At the bottom of the workbook, click the Seedling Sales worksheet tab to select it.
  5. Click on cell A8.
  6. Right-click and below the Paste Option section, click Transpose (4th icon). (Note: There are several alternative solutions: You can right-click and select Paste Special... and Paste Special.. again. At the bottom of the Paste Special pop-up window, click Transpose to enable the option and click OK. - OR- On the HOME tab, in the Clipboard group, click Paste and select the Transpose icon (7th icon), or at the bottom of the Paste drop-down menu select Paste Special... and in the Paste Special pop-up window click Transpose to enable the option and click OK.) Remove the table formatting from the Small Tree Sales worksheet. Keep the cell formatting.
  7. At the bottom of the workbook, click the Small Tree Sales worksheet tab.
  8. Click anywhere within the table to select it (Hint: You must click within cell range A8:F18.)
  9. Click on the TABLE TOOLS DESIGN tab.
  10. In the Tools group, click Convert to Range.
  11. When prompted, Do you want to convert the table to a normal range? Click, Yes. (Hint: When the table converts to a normal range, the autofilters will disappear and so will the TABLE TOOLS tab. On the Small Tree Sales worksheet, insert a formula in cell F20 that uses a built-in Excel function to return the value of the smallest value in the Total column.
  12. On the Small Tree Sales worksheet, select cell F20.
  13. Click the FORMULA tab.
  14. In the Function Library group, click the AutoSum down-arrow and select MIN.
  15. In the Formula Bar adjust the selected cell range to include only cells F9:F18.
  16. Press the Enter key to accept the formula and calculate the results.
  1. Right-click and below the Paste Option section, click Transpose (4th icon). (Note: There are several alternative solutions: You can right-click and select Paste Special... and Paste Special.. again. At the bottom of the Paste Special pop-up window, click Transpose to enable the option and click OK. - OR- On the HOME tab, in the Clipboard group, click Paste and select the Transpose icon (7th icon), or at the bottom of the Paste drop-down menu select Paste Special... and in the Paste Special pop-up window click Transpose to enable the option and click OK.) On the New Releases worksheet, navigate to the cell range NewestTitles and delete the contents. Retain all other cells on the worksheet.
  2. Click on the New Releases worksheet to select it.
  3. Above the worksheet to the left of the formula bar, click the Name Box down-arrow.
  4. Select NewestTitles. (Hint: cell range A17:E19 should now be selected).
  5. Right-click and select Delete.
  6. Click OK. On the New Releases worksheet, adjust the height of row 2 to 34.5.
  7. On the New Releases worksheet, click row 2 to select it.
  8. On the HOME tab, in the Cells group, click Format and select Row Height.
  9. In the Row Height pop-up box, type 34.
  10. Click OK. In cell I7 of the New Releases worksheet, use a function to calculate the average of the Review Score column where the System type is YCube 720.
  11. On the New Releases worksheet, click cell I7.
  12. In the Formula Bar, type =AVERAGEIF, then press the tab key on your keyboard.
  13. To the left of the Formula Bar, click fx to open the Function Arguments wizard.
  14. In the Function Arguments wizard, configure the following: Range: B7:B (Note: This will be B7:B16 if you have completed Task 1)
  15. Click OK. Remove the table functionality from PreOrders. Retain the font and cell formatting.
  1. Above the worksheet to the left of the formula bar, click the Name Box down-arrow.
  2. Select PreOrders.
  3. On the TABLE TOOLS DESIGN tab, in the Tools group, click Convert to Range..
  4. Click Yes. Add a new worksheet named Specials with a tab color Blue.
  5. At the bottom of the workbook, to the right of the Pre-Orders worksheet tab, click the New Sheet button (+)
  6. Right-click the new worksheet tab named Sheet1, and select Rename.
  7. Replace the name, Sheet1, by typing the new name, Specials. Press Enter on your keyboard to accept the change.
  8. Right-Click the Specials worksheet and select Tab Color. Under standard Colors, select Blue. On the Home-Made Pet Food worksheet, in cell A9, import New Flavors.txt located in the GMetrixTemplates folder as a tab-delimited file without headers.
  9. On the Home-Made Pet Food worksheet, click cell A9 to select it.
  10. On the DATA tab, in the Get External Data group, click From Text.
  11. Browse to the GMetrixTemplates folder.
  12. Select the New Flavors.txt file and click the Import button.
  13. In the Text Import Wizard - Step 1 of 3 pop-up window, accept the default data type as Delimited, clear the box My data has headers, and click the Next button.
  14. In the Text Import Wizard - Step 2 of 3 pop-up, accept the default Delimiter as Tab. (Hint: Notice how you can preview how the data will be separated in the window below).
  15. Accept all other defaults and click the Finish button.
  16. In the Import Data pop-up accept the defaults and click OK. (Hint: If you do not see these options listed in the Data Tab you may need to enable the Legacy Import Wizards. To do this, go to File > Options > Data > Show legacy data import wizards and check all that apply. Once this is complete you can use the Get Data drop-down to select the Legacy Wizards and select the Wizard that applies.)
  1. Select the VIEW tab.
  2. In the Workbook Views group, click Page Layout.
  3. Scroll down the page and select row 21 Raspberry Chocolate.
  4. On the PAGE LAYOUT tab, in the PAGE SETUP group, click Breaks.
  5. Select Insert Page Break. (Hint: The first page should now end with the flavor Cracker Jacker and the next page should begin with the flavor Raspberry Chocolate)
  6. On the VIEW tab, in the Workbook Views group, click Normal to return to normal view. In the Flavors column of the Costs worksheet, replace all instances of the misspelled word Purge with Splurge.
  7. Click the A at the top of the column on the Costs worksheet to select the entire Flavors column.
  8. On the HOME tab, in the Editing group, click Find & Select and click
  9. Click Replace...
  10. In the Find & Replace pop-up, on the Replace tab, configure the following: Find what: Purge Replace with: Splurge
  11. Click Replace All (Hint: You should see a message that 3 replacements were made.)
  12. Click Close. On the Profits worksheet, enter a formula in cell A29 that uses an Excel function to return the average costs of the fudge flavors based on the values in the Cost column.
  13. Select cell A29 on the Profits worksheet.
  14. In the Formula Bar, type =AVERAGE, then press the tab key on your keyboard.
  15. To the left of the Formula Bar, click fx to open the Function Arguments wizard.
  16. In the Function Arguments wizard, configure the following: Number1: B4:B
  17. Click OK. (Hint: The result should be 1.73 )

On the Profits worksheet, include the Total Profit data on the Flavor Expenses, Income and Profit chart

  1. On the Profits worksheet, click in the center of the chart to select it.
  2. Click the CHART TOOLS DESIGN contextual tab.
  3. In the Data group, click Select Data.
  4. In the Select Data Source pop-up window, in the left window pane click the box Total Profit to enable it.
  5. Click OK. (Hint: Total Profit should now be added to the legend representing a third column on the chart). Locate the table that has the name Table1 and change the name to Costs.
  6. Above the worksheet to the left of the formula bar, click the Name Box down-arrow.
  7. Select Table1. (Hint: the entire table on the Costs worksheet should now be selected).
  8. Select the TABLE TOOLS DESIGN contextual tab.
  9. In the Properties group, in the Table Name field, replace Table1 by typinging Costs.
  10. Press Enter on your keyboard to accept the name change. Rename the Renters worksheet to Customers.
  11. At the bottom of the workbook, right-click the Renters tab and select Rename.
  12. Type Customers and press Enter on your keyboard to accept the change Add the value New Rates to the Title property of the document.
  13. Click the FILE tab.
  14. Locate the list of Properties on the right side of the Info page.
  15. In the Title property field, type New Rates.
  16. Click the return arrow in the upper-left corner of the Info window to return to the worksheet. Set cells A1:F10 in the Computer Rooms worksheet so that they will be the only cells that print.
  17. On the Computer Rooms worksheet, select cell range A1:F10.
  18. Click the PAGE LAYOUT tab.
  19. In the Page Setup group, click Print Area and select Set Print Area. (Hint: You can check your print area setting under the FILE tab by selecting Print and viewing it in the Preview pane.)

Add subtotal to: Price

  1. Click the box Page break between groups to enable it. (Accept all other defaults)
  2. Click OK. On the Sold worksheet, format the table so that every other row is shaded. Use a technique that automatically updates the formatting if you insert a new row.
  3. On the Sold worksheet, click anywhere in the table to select it.
  4. On the TABLE TOOLS DESIGN contextual tab, in the Table Styles Options group, click the box Banded Rows to enable it. On the Vehicles worksheet, in the Code column cell B4, create a formula that returns the two leftmost letters of the vehicle style displayed in cell D4.
  5. On the Vehicles worksheet, select cell B4.
  6. In the Formula Bar, type =LEFT, then press the tab key on your keyboard.
  7. To the left of the Formula Bar, click fx to open the Function Arguments wizard.
  8. In the Function Arguments wizard, configure the following: Text: D Num_chars: 2
  9. Click OK. (Hint: The result should be Se ) Make a copy of the Qtr 2 worksheet to the right of the Qtr 2 worksheet.
  10. At the bottom of the workbook, right-click the Qtr 2 tab, and select Move or Copy...
  11. In the Move or Copy pop-up window, configure the following: Before sheet: (move to end) Click the box Create a copy box to enable it.
  12. Click OK. (Hint: The copy will automatically be named, Qtr 2 (2) and will appear to the right of the original worksheet. ) Display the formulas that are in the cells of the Qtr 2 worksheet.
  1. Select the Qtr 2 worksheet.
  2. On the FORMULAS tab, in the Formula Auditing group, click Show Formulas. On the Qtr 1 worksheet, apply a number format to display the numbers in columns B through E to two decimal places with the US Dollar symbol ($) left-aligned and the decimal points aligned.
  3. On the Qtr 1 worksheet, select columns B through E.
  4. On the HOME tab, in the Number group, click the $ symbol. In the Qtr 1 worksheet change the configuration of the Q1 Taco Revenue chart so that it displays the months on the x-axis and the revenue on the y-axis.
  5. Click the Qtr 1 worksheet tab to select it.
  6. Click the chart to reveal the CHART TOOLS tabs.
  7. On the CHART TOOLS DESIGN tab, in the Data group, click Switch Row / Column Without using the New Sheet button, move the pie chart on the Qtr 2 worksheet to its own chart sheet named Qtr 2 Chart.
  8. On the Qtr 2 worksheet, click anywhere on the pie chart to select it.
  9. On the CHART TOOLS DESIGN contextual tab, in the Location group, click Move Chart.
  10. In the Move Chart pop-up window, select New Sheet and type the name Qtr 2 Chart.
  11. Click OK. On the Average Call Time worksheet, use an Excel feature to copy the sparkline into all the vacant cells of the Trend column.
  12. On the Average Call Time worksheet, select cell G4.
  13. In the lower-right corner of cell G4, click-drag the fill handle down the Trend column beginning with cell G4 through G16. On the Employee Hours worksheet, add a row to the table that automatically calculates total hours worked by all employees.
  14. On the Employee Hours worksheet, click on any cell in the table to select the table.
  15. On the TABLE TOOLS DESIGN tab, in the Table Style Options group, click the Total Row to enable it. Add a function to the Overtime column cell H4 on the Employee Hours worksheet that will display the word Yes if the value in cell J4 is higher than 40, otherwise display the word No.