PAUSE & PRACTICE: EXCEL 5-2

  1. Open the [your initials] PP E5-1.xlsx workbook completed in Pause & Practice 5-1. Because the workbook includes links, you will see a security warning or a message box.
  2. Click Update in the message box or click Enable Content in the warning bar.
  3. Save the workbook as [your initials] PP E5-2.
  4. Build a custom format.
    1. Click the FormatCodes sheet tab. You will modify the checklist codes to display “PVR” followed by a four-digit number.
    2. Select cells A5:A16.
    3. Click the Number launcher [Home tab, Number group] to open the Format Cells dialog box.
    4. Click Custom as the Category on the Number tab.
    5. Select the 0 code, a single zero in the list. You will build your code starting from this.
    6. Click the Type box and type 000 so that the code is four zeros. The Sample displays 0001.
    7. Click in front of the first zero and type PVR and press the Spacebar. The Sample box updates to include the text prefix (Figure 5-35).
    8. Click OK. The formulas include the prefix and insignificant zeros as needed.
  5. Enter data using a custom format.
    1. Select cell A16, type 12, and press Tab.
    2. Type Cooking pan set, press Tab, type 1, and press Enter.
  6. Assign the Geography data type.
    1. Click the DataTypes sheet tab. Notice that Tennessee and Virginia are spelled incorrectly.
    2. Select cells A2:A11.
    3. Click the Geography button [Data tab, Data Types group]. You may see an expanded set of data types or only two or three available types based on your Excel version (Figure 5-36).
    5. Get data from a data type cell.
      1. Select cells A2:A11.
      2. Format the cells as an Excel table using White, Table Style Light 1. The table does not have headers.
      3. Select cell A3 and click the Add Column button. The Insert Data button becomes the Add Column button when the cells are formatted as a table.
      4. Choose Median household income in the field list. The linked data displays for the column.
      5. Select cell A5 and click the Add Column button. You can select any cell in column A to add a new column of data to the table.
      6. Choose Persons per household. (Figure 5-38).
        ALTERNATE INSTRUCTION: Format data as a table and edit labels.
        1. Select cells A2:C12 and format the cells as a table with White, Table Style Light 1. The data does not have headers.
        2. Edit the label in cell B2 to Median household income.
        3. Edit the label in cell C2 to Persons per household.
        4. Format values in column B as Accounting with zero decimals.
  1. Edit and format labels.
    1. Select cell A2.
    2. Type State.
    3. Select cells B2:C2 and click the Wrap Text button [Home tab, Alignment group].
    4. Select columns A:C and set column width to 12.
    5. Select cells A2:C2 and center align them.
  2. Save and close the workbook (Figure 5-39).

Do you need help with this assignment or any other? We got you! Place your order and leave the rest to our experts.

Place Your Order

Quality Guaranteed

Any Deadline

No Plagiarism