Tools for Information Literacy
Pull data from a second worksheet into a formula on a defferent worksheet

On the 05Summary 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 06VAReligion worksheet.

On the 05Summary 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 07State Level Expenditures worksheet.

On the 05Summary 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 08Inventory worksheet.
Use your help tool to find the right function.
using functions
creating formulas
back to top
... by pulling vectored data from two different worksheets into a new formula

Copy cells A4 through A54 from the 09USAOASDI 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 09USAOASDI worksheet
by Alabama's "Total Living Korean War Veterans as of September 30, 2017" from the 10KoreanWar_State worksheet.
Remember, this is a formula, not a function.
Then we will demonstrate cell formatting skills based on the type of data the cells contain

Once you have created the formula,
format the cell to display percentages to two decimal places.
Remember to format the output of all functions and formulas so that the numbers are displayed as the type of number they are.

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
using functions
creating formulas
back to top