Description
Simple excel homework using vlookup/hlookup and match. There are 3 sheets in the workbook that you must complete.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Question 1
Input:
Input your age:
Input your younger sibling's age:
Question
Can you vote for president?
For how many years have you been eligible to vote?
Are both me and my younger sibling eligible to vote?
25,0
17,0
Answer
Yes
7,0
No
IF Formula
Input:
Input expected company revenue:
Input actual company revenue:
300,0
400,0
Input expected company EBITDA:
Input actual company EBITDA:
50,0
60,0
Question
Did the company exceed revenue expectations?
Did the company exceed both revenue and EBITDA expectations?
IFERROR - is "NM"
Net earnings
Shares outstanding
Earnings per share (EPS)
Answer
Ye...