Lecture2-AA.wmv

Overview of Data Setup in Microsoft Excel

The dataset is established in Microsoft Excel inside the workbook Book2 - Excel on Sheet1. The table contains column headers in Row 1 designated for tracking individual pay parameters:

  • Cell A1: Name

  • Cell B1: Rate

  • Cell C1: Hours

Entry Records and Grid Positions

The dataset lists three individual names in Column A:

  • Cell A2: Dave

  • Cell A3: Rob

  • Cell A4: Mary

The active cell focus is set on cell B2, which corresponds to the rate entry position for Dave.

Workspace Interface and Environment Settings

The workspace reflects the following application settings, media metadata, and ribbon configurations:

  • Media File Name: Lecture2-AA.wmv

  • Stream Timestamp: 0:00/1:14:130:00 / 1:14:13

  • Active Ribbon Tab: Home

  • Active Font: Aptos Narrow at size 1111

  • Cell Formatting: General

  • Navigation Ribbon Tabs: File, Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Automate, Developer, Help, XBRL Filed Data

  • Active Sheet: Sheet1