Final answer:
The student is tasked with using UNIQUE to find 3 unique cities and SUMIF to sum values in a spreadsheet based on specific criteria and maintaining proper reference styles.
Step-by-step explanation:
The question that you've been asked to work on involves applying two different functions in a spreadsheet, UNIQUE and SUMIF. For the UNIQUE function, you are tasked with extracting 3 unique cities from cell L16. The SUMIF function will be used in column N, where you will need to sum values in column G based on the criteria that matches the value in L16 to those in column B. While using the SUMIF function, you must ensure to use relative and absolute references appropriately, especially if you're planning to apply the function to multiple cells using the Fill handle.
To find the unique cities in column L16, you can use the UNIQUE function. The formula would be =UNIQUE(L16:L). This will give you a list of the unique cities in column L16.
To use the SUMIF function in column N, you will check the value in L16 against the values in column B and column G. The formula would be =SUMIF(B:B, L16, G:G). This will give you the sum of all values in column G where the corresponding value in column B matches the city in L16.
When using the Fill handle for relative vs absolute references, you need to lock the range of columns B and G by using the absolute reference. The formula in column N would be =SUMIF($B:$B, L16, $G:$G). This will ensure that the range stays the same when dragging the formula down.