Excel Crash Course
, All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1 Alt
hiw
Incorrect - ANS-Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a
workbook.
Alt h i w is not a valid shortcut.
Below is a Data Table designed to display the effect on 2015 Net Profit based of changes in 2015 Revenue Growth
and 2015 COGS %. Please provide:
The cell reference required in D22.
The row input cell required by the Data Table. The
column input cell required by the Data Table.
Provide all three cell references, in order above, separated by commas with no space (i.e. A1,A2,A3) Note: Do not
include spaces within answer - ANS-The correct answer is: E8,E10,E11 E8 is the cell reference for 2018 Net
Income, the output variable, which must be in the top left corner of the table. E10, the 2015 revenue growth rate, is
the row input cell, the variable that is being sensitized in the top row of the table. E11, the COGS %, is the column
input variable that is being sensitized.
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360 day count basis.
=STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)
=YEARFRAC(D4,D5) - ANS-The correct answer is: =YEARFRAC(D4,D5,2). STUB is not an Excel formula.
DAYS360 will return the number of days in a 360 day year. YEARFRAC(D4,D5) will calculate the fraction using a
365-day year.
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range lookup' argument if it is
necessary.
=HLOOKUP(2016,B2:D4,2,0)
=HLOOKUP(2016,A1:D4,3)
=HLOOKUP("Expenses",A1:D4,2)
=HLOOKUP(2016,B2:D4,2) - ANS-The correct answer is: =HLOOKUP(2016,A1:D4,3)
, All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1 Alt
hiw
Incorrect - ANS-Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a
workbook.
Alt h i w is not a valid shortcut.
Below is a Data Table designed to display the effect on 2015 Net Profit based of changes in 2015 Revenue Growth
and 2015 COGS %. Please provide:
The cell reference required in D22.
The row input cell required by the Data Table. The
column input cell required by the Data Table.
Provide all three cell references, in order above, separated by commas with no space (i.e. A1,A2,A3) Note: Do not
include spaces within answer - ANS-The correct answer is: E8,E10,E11 E8 is the cell reference for 2018 Net
Income, the output variable, which must be in the top left corner of the table. E10, the 2015 revenue growth rate, is
the row input cell, the variable that is being sensitized in the top row of the table. E11, the COGS %, is the column
input variable that is being sensitized.
Identify a function in cell D6 that will return the fraction of the year elapsed assuming a 360 day count basis.
=STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)
=YEARFRAC(D4,D5) - ANS-The correct answer is: =YEARFRAC(D4,D5,2). STUB is not an Excel formula.
DAYS360 will return the number of days in a 360 day year. YEARFRAC(D4,D5) will calculate the fraction using a
365-day year.
Identify the best formula that will output 2016 expenses. Hint: Only select the 'range lookup' argument if it is
necessary.
=HLOOKUP(2016,B2:D4,2,0)
=HLOOKUP(2016,A1:D4,3)
=HLOOKUP("Expenses",A1:D4,2)
=HLOOKUP(2016,B2:D4,2) - ANS-The correct answer is: =HLOOKUP(2016,A1:D4,3)
