excel speadsheet with questions must be answered.

EXAM 1 INSTRUCTIONS

Tab 1 - Use the basic Excel functions (i.e. VLOOKUP, SUMIF,etc.) to calculate the missing values including:

 1a. #Unemployed (having 0 months of employment)  1b. #New Car/$5000+ Checking (Use Loan Purpose and Checking)  1c. Total Savings - Women (Use Savings and Gender)  1d. Employment (Use Months Employed to indicate "YES" or "NO")  1e. Value (Use Checking and Savings to find total)

Tab 2-4 Use Data Visualization to create a PivotTable and insert a minimum of 2 of the chart\visualization types (i.e. Line, Bar, Pie, Column, Area, Scatter, Bubble, Conditional Formatting, and Frequency Distribution) on each tab to display a graphical depiction of the data. PLEASE NOTE: YOU MUST USE DIFFERENT CHART TYPES ON EACH TAB.

Tab 5 Calculate the values below (Use HLOOKUP etc.)

 5a. Find Item Cost and Order Date  5b. Find Item Description and Cost per order

Tab 6 What can you conclude about internet usage based on the data for each? (Use your knowledge of evaluating data)

 6aii. 35-44 year age group  6aiii. 55 and over age group  6bii. Less than High School Graduates  6biii. Bachelor’s Degree or higher

Tab 7 Create a formula that will use MATCH and COUNTIF based on the Input Field to calculate the following:

 7a. Row Number - First  7b. Row Number - Last  7c. Cost per Order for First Row  7d. Cost per Order for Last Row

HINT: You will need to reference the Input Field in your formula so that you can change only that field and update all values.