Lab Insight: In Excel, there are three primary ways to organize data: a range, a table, and a pivottable. There are advantages to all three. In this lab, we will explore how and why to work with data in range and table formats.

Required:

Create a new column in the Sales$\_$Transactions$\_$Range for Invoice$\_$Amount.

Create a new column in the Sales$\_$Transactions$\_$Table for Invoice$\_$Amount.

Ask the Question: What is the best format to work with the data?

Master the Data: The dataset contains information about sales transactions to different customers. There are $132$ un transactions, but $149$ rows$-$this is because some of the transactions had multiple products on them. This data is simi the data used in several of the labs in Chapter $3$; however, in Chapter $3,$ the data had already been transformed.

Software needed

Excel

Screen capture tool $($Windows: Snipping Tool; Mac: Cmd$+$Shift$+4)$

Data: Lab $4-1$ Data.xIsx