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:
Active Ribbon Tab: Home
Active Font: Aptos Narrow at size
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