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 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that future edits only
apply to active sheet.
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 3.
Remember to hit Ctrl Pageup or Pagedown to make sure that future edits only
apply to active sheet.
