Question: Is Income same? It should be same, if not, your earlig steps needs to be corrected. Is formula in E 2 4 and E 2

Is Income same? It should be same, if not, your earlig steps needs to be corrected.
Is formula in E24 and E25 reads similar? {Hint Click: E24 and look at the formula bar, do the same for E25!}
The formula in E25 is sturctured Reference, see below for more explanation from Excel Help.
Using structured references with Excel tables
When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. Here's an example of what Excel does:
Instead of using explicit cell references i.e.=SUM(E18:E22)
Excel uses table and column names i.e.=SUM(Name of the Table[Field Name to Sum])

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!