Question

Note: This worksheet covers TextJoin, Sequence and Sort functions, Tables and Again use of SUM function and structured references Instructions: Type your first name in M2 Type following data on this Worksheet (Sort) Starting with A4 First Last Grade John Doe A Jane Doe A Bill Smith B Bree Smith B Cary Williams C Create(calculate) Full Name in D4 Use TextJoin to create Full Name with space in between e.g. John Doe Use Autofill to complete rest of rows Row D5 thru D8 In E3 thru E8 inset Income using Sequence Function, see below In E3 use Sequence function to input income for five people with starting value of 50000 with step of 10000 In A10, use Sort function to sort by First name Ascending - Sort functions need data i.e. A4:E8, Sort column i.e 1 and sort order i.e. Ascending you will type for 1 for Ascending i.e. =sort(X,X,X) Your Answer Should should look like picture shown below Copy A3:E8 and Paste as Values only in A17 In E24, use SUM formula and Range of E18:E22 for Income In E25, calculate Total Income using structured references, See below more details Is Income same? It should be same, if not, your earlier 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 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]) That combination of table and column names is called a structured reference. Answers Looks like this ... It is screenshot from correctly completed steps.

          Note: This worksheet covers TextJoin, Sequence and Sort functions, Tables and Again use of SUM function and structured references
Instructions: Type your first name in M2
Type following data on this Worksheet (Sort) Starting with A4
First Last Grade
John Doe A
Jane Doe A
Bill Smith B
Bree Smith B
Cary Williams C
Create(calculate) Full Name in D4
Use TextJoin to create Full Name with space in between e.g. John Doe
Use Autofill to complete rest of rows Row D5 thru D8
In E3 thru E8 inset Income using Sequence Function, see below
In E3 use Sequence function to input income for five people with starting value of 50000 with step of 10000
In A10, use Sort function to sort by First name Ascending - Sort functions need data i.e. A4:E8, Sort column i.e 1 and sort order i.e. Ascending you will type for 1 for Ascending i.e. =sort(X,X,X) Your Answer Should should look like picture shown below
Copy A3:E8 and Paste as Values only in A17
In E24, use SUM formula and Range of E18:E22 for Income
In E25, calculate Total Income using structured references, See below more details
Is Income same? It should be same, if not, your earlier 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 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])
That combination of table and column names is called a structured reference.
Answers Looks like this ... It is screenshot from correctly completed steps.

Note: This worksheet covers TextJoin, Sequence and Sort functions, Tables and Again use of SUM function and structured references
Instructions: Type your first name in M2
Type following data on this Worksheet (Sort) Starting with A4
First Last Grade
John Doe A
Jane Doe A
Bill Smith B
Bree Smith B
Cary Williams C
Create(calculate) Full Name in D4
Use TextJoin to create Full Name with space in between e.g. John Doe
Use Autofill to complete rest of rows Row D5 thru D8
In E3 thru E8 inset Income using Sequence Function, see below
In E3 use Sequence function to input income for five people with starting value of 50000 with step of 10000
In A10, use Sort function to sort by First name Ascending - Sort functions need data i.e. A4:E8, Sort column i.e 1 and sort order i.e. Ascending you will type for 1 for Ascending i.e. =sort(X,X,X) Your Answer Should should look like picture shown below
Copy A3:E8 and Paste as Values only in A17
In E24, use SUM formula and Range of E18:E22 for Income
In E25, calculate Total Income using structured references, See below more details
Is Income same? It should be same, if not, your earlier 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 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])
That combination of table and column names is called a structured reference.
Answers Looks like this ... It is screenshot from correctly completed steps.

Added by Eric W.

Question

Please give Ace some feedback