https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
Wall Street Prep Excel.pdfhttps://www.stuvia.com/user/allatopnotch
Wall Street Prep Excel
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - ANS-Alt h i w
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360 day
count basis. - ANS-=YEARFRAC(D4,D5,2)
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range lookup'
argument if it is necessary. - ANS-=HLOOKUP(2016,A1:D4,3)
Identify the formula that outputs data from the table based on the user inputs in cells C6 and C7.
- ANS-=OFFSET(A1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
Identify the formula that outputs the sum of property values for properties in Boston that were
built after 1950. - ANS-=SUMIFS(B2:B5,C2:C5,"Boston",D2:D5,">1950")
Identify the formula that sums the property values of properties in Boston. -
ANS-=SUMIF(C2:C5,"Boston",B2:B5)
Identify the formula that will always output a date that is the end-of-month date 3 months after
the date inputted in D5. - ANS-=EOMONTH(D5,3)
Identify the formula that will output 2016 expenses (55). - ANS-=OFFSET(A1,2,2)
Identify the formula that will output 2016 expenses: - ANS-=CHOOSE(2,B3,C3,D3)
Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "animal lover"
for users who have at least 1 dog and at least one cat, and outputs "lonely person" when those
conditions are not met. - ANS-=IF(AND(B1>0,B2>0),"animal lover","lonely person")
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - ANS-1. Group the
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In
the active sheet type in "Company Financials" in A1 and apply the desired width to all columns
3. Remember to hit Ctrl Pageup or Pagedown to make sure that future edits only apply to active
sheet.
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - ANS-1. Group the
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In
the active sheet type in "Company Financials" in A1 and apply the desired width to all columns
Wall Street Prep Excel.pdfhttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
Wall Street Prep Excel.pdfhttps://www.stuvia.com/user/allatopnotch
Wall Street Prep Excel
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - ANS-Alt h i w
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360 day
count basis. - ANS-=YEARFRAC(D4,D5,2)
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range lookup'
argument if it is necessary. - ANS-=HLOOKUP(2016,A1:D4,3)
Identify the formula that outputs data from the table based on the user inputs in cells C6 and C7.
- ANS-=OFFSET(A1,MATCH(C6,A2:A4,0),MATCH(C7,B1:D1))
Identify the formula that outputs the sum of property values for properties in Boston that were
built after 1950. - ANS-=SUMIFS(B2:B5,C2:C5,"Boston",D2:D5,">1950")
Identify the formula that sums the property values of properties in Boston. -
ANS-=SUMIF(C2:C5,"Boston",B2:B5)
Identify the formula that will always output a date that is the end-of-month date 3 months after
the date inputted in D5. - ANS-=EOMONTH(D5,3)
Identify the formula that will output 2016 expenses (55). - ANS-=OFFSET(A1,2,2)
Identify the formula that will output 2016 expenses: - ANS-=CHOOSE(2,B3,C3,D3)
Identify the formula that, based in user inputs in cells B1 and B2, outputs the text "animal lover"
for users who have at least 1 dog and at least one cat, and outputs "lonely person" when those
conditions are not met. - ANS-=IF(AND(B1>0,B2>0),"animal lover","lonely person")
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - ANS-1. Group the
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In
the active sheet type in "Company Financials" in A1 and apply the desired width to all columns
3. Remember to hit Ctrl Pageup or Pagedown to make sure that future edits only apply to active
sheet.
If I want to add the title "Company Financials" in cell A1 ensure that all columns are the same
width across all the worksheets in my workbook, how would I do that? - ANS-1. Group the
wroksheets by hitting Ctrl Shift and use the PageUp/Down keys to select the worksheets. 2. In
the active sheet type in "Company Financials" in A1 and apply the desired width to all columns
Wall Street Prep Excel.pdfhttps://www.stuvia.com/user/allatopnotch
https://www.stuvia.com/user/allatopnotch https://www.stuvia.com/user/allatopnotch
