Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open the NP_EX_7-2.xlsx workbook located in the Excel7 > Review folder included with your Data Files. Save the workbook as NP_EX_7_Facebook in the location specified
Open the NP_EX_7-2.xlsx workbook located in the Excel7 > Review folder included with your Data Files. Save the workbook as NP_EX_7_Facebook in the location specified by your instructor. 2. In the Documentation sheet, enter your name and the date. 3. In the Lookup Tables worksheet, use data in Figure 753 to complete the lookup table in the range B4:C8, and then give the lookup table the defined name Character_Lookup. 4. In the Media Posts worksheet, in column G of the Facebook table, apply the VLOOKUP function to categorize the size of each post, using the value of the Characters field for the lookup value, the Character_Lookup table as the lookup table, and the second column of the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started