home & schedule | syllabus | contact | grades

Pull data from a second worksheet into a formula on another worksheet

Still using your downloaded workbook ...

We will demonstrate facility with functions and formatting of the resultant data

1. On the 05-Summary worksheet,
   in cell B4 enter the words "Highest Number of Jewish Veterans."
   In cell K4, insert a function that will return the highest number of Jewish veterans from the data on the 06-VA-Religion worksheet.
2. On the 05-Summary worksheet,
   in cell B5 enter the words "Lowest Expenditure on Medical Care."
   In cell K5 insert a function that will return the lowest expenditure on medical care from the data on the 07-State Level Expenditures worksheet.
3. On the 05-Summary worksheet,
   in cell B6 enter the words "Number of programs at Idaho National Laboratory".
   In cell K6, display the number of programs for which the Idaho National Laboratory is the source.
   Find the data on the 08-Inventory worksheet.
   Use your help tool to find the right function.

Still using your downloaded workbook ...

We will demonstrate facility with formulas, by pulling vectored data from two different worksheets into a new formula

1. Copy cells A4 through A54 from the 09-USA-OASDI worksheet.
   Paste these cells into cells B7 through B57 on the Summary worksheet.
   Then, in cell D7, insert a formula that will draw values from two other worksheets.
   The formula should divide Alabama's "65 or older" from the 09-USA-OASDI worksheet by Alabama's "Total Living Korean War Veterans as of September 30, 2017" from the 10-KoreanWar_State worksheet.

Then we will demonstrate cell formatting skills based on the type of data the cells contain

2. Once you have created the formula,
   format the cell to display percentages to two decimal places.

We will conclude by demonstrating understanding of how and why to drag formatting information from one cell to another

3. Once you have formatted the data in the cell,
   drag the cell down the column to apply the same formula and formatting for all state rows

week of 30 March lab | setting up a worksheet | setting up a workbook | other tools | functions, formulas, formatting