New Perspectives Excel 2019 | Excel Module 6 SAM Textbook project Non-graded - Handling Data in Excel     Non-graded - Using Panes to View Data     Locating Duplicate Records         To highlight duplicate employee IDs in the Employees worksheet     To find and delete duplicate records in the Employees worksheet     To remove the Duplicate Values conditional formatting rule Sorting Records in a Data Range         To sort the employee data by the Office, Dept, and Base Salary fields     In the Employees worksheet, the range A5:P534 should be sorted second by the Dept column

Subject:MS ExcelPrice:20.99 Bought12

Share With

New Perspectives Excel 2019 | Excel Module 6 SAM Textbook project

Non-graded - Handling Data in Excel    
Non-graded - Using Panes to View Data    
Locating Duplicate Records    
    To highlight duplicate employee IDs in the Employees worksheet
    To find and delete duplicate records in the Employees worksheet
    To remove the Duplicate Values conditional formatting rule
Sorting Records in a Data Range    
    To sort the employee data by the Office, Dept, and Base Salary fields
    In the Employees worksheet, the range A5:P534 should be sorted second by the Dept column. (This will be marked correct after performing step 8.)
    To create and apply a custom list to sorting
    In the Employees worksheet, the range A4:P534 should be sorted first by the Office column in the following custom sorting list order: Boston, Chicago, Denver, San Francisco, Dallas. (This will be marked correct after performing step 8.)
Calculating Subtotals    
    To remove the subtotals from the Employees worksheet
Non-graded - Locating Cells Within a Worksheet    
Non-graded - Filtering Data    
Creating an Excel Table    
    To convert the employees data range to an Excel table
    In the Employees worksheet, the range A4:P534 should be formatted as a table.
    To rename the Table1 Excel table
    In the Employees worksheet, the range A5:P534 should be formatted as a table.
    To apply styles to the Employees_Tbl table
    In the Employees worksheet, the range A4:P534 should be formatted as a table.
    To add a Total Row to the Employees Excel table
    In the Employees worksheet, the range A4:P534 should be formatted as a table. (This will be marked correct after completing step 8.)
    To modify the Employees_Tbl table by adding and deleting records
    In the Employees worksheet, the range A4:P534 should be formatted as a table.
    To add the Full Name calculated field to the Employees_Tbl table
    In the Employees worksheet, the range A4:P534 should be formatted as a table.
    To add the Hire Year field to the Employees_Tbl table
    In the Employees worksheet, the range A4:P534 should be formatted as a table.
    To add the Wages field to the Employees_Tbl table
    In the Employees worksheet, cell M4 should contain the text ''WAGES''.
Non-graded - Filtering Data with Slicers    
Creating a Dashboard    
    To apply the SUBTOTAL function
    In the Dashboard worksheet, cell E21 should contain the number of records that match the filter criteria in the slicers.
    To add a histogram to the dashboard
    The Dashboard worksheet should contain a histogram chart.
    To format the histogram chart
    The Dashboard worksheet should contain a histogram chart.
    To look up data from the Employees_Tbl table from the dashboard
    In the Dashboard worksheet, the formula in cell H22 should use the VLOOKUP function to look up the value from cell H21 in the Employees_Tbl table, and return the value in the fourth column using an exact match.