Excel Crash Course Exam (Wall Street Prep):
Practice Questions & Answers Guide
________________________________________________
**Question 1**
What is the keyboard shortcut to insert a new row in Excel?
o Ctrl + Shift + +
☑ Ctrl + Shift + =
o Alt + I + R
o Ctrl + R
________________________________________________
**Question 2**
Which function is used to round a number to the nearest multiple of significance?
o ROUND
o TRUNC
☑ MROUND
o FLOOR
________________________________________________
**Question 3**
In a PivotTable, how do you add a field to the Values area?
o Right-click the field and select "Filter"
,☑ Drag the field to the Values area
o Double-click the field name
o Select "Insert Slicer"
________________________________________________
**Question 4**
What does the INDEX-MATCH combination replace as a more flexible lookup tool?
o SUMIF
☑ VLOOKUP
o OFFSET
o CHOOSE
________________________________________________
**Question 5**
Which financial function calculates the net present value of an investment based on a
series of periodic cash flows?
o IRR
o PMT
☑ NPV
o XIRR
________________________________________________
**Question 6**
How do you freeze the top row and first column simultaneously in Excel?
o View > Freeze Panes > Freeze Top Row
☑ View > Freeze Panes > Freeze Panes
o Home > Format > Freeze Panes
, o Data > Freeze Panes
________________________________________________
**Question 7**
What is the correct syntax for a SUMIFS formula with multiple criteria?
o =SUMIFS(sum_range, criteria_range1, criteria1)
☑ =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)
o =SUMIF(sum_range, criteria_range1, criteria1 + criteria2)
o =SUMIFS(criteria_range1, sum_range, criteria1)
________________________________________________
**Question 8**
In conditional formatting, which rule highlights cells greater than a value?
o Equal to
o Contains text
☑ Greater Than
o Duplicate Values
________________________________________________
**Question 9**
What does Ctrl + ; insert in a cell?
o Current time
☑ Current date
o Current date and time
o Day of the week
________________________________________________
Practice Questions & Answers Guide
________________________________________________
**Question 1**
What is the keyboard shortcut to insert a new row in Excel?
o Ctrl + Shift + +
☑ Ctrl + Shift + =
o Alt + I + R
o Ctrl + R
________________________________________________
**Question 2**
Which function is used to round a number to the nearest multiple of significance?
o ROUND
o TRUNC
☑ MROUND
o FLOOR
________________________________________________
**Question 3**
In a PivotTable, how do you add a field to the Values area?
o Right-click the field and select "Filter"
,☑ Drag the field to the Values area
o Double-click the field name
o Select "Insert Slicer"
________________________________________________
**Question 4**
What does the INDEX-MATCH combination replace as a more flexible lookup tool?
o SUMIF
☑ VLOOKUP
o OFFSET
o CHOOSE
________________________________________________
**Question 5**
Which financial function calculates the net present value of an investment based on a
series of periodic cash flows?
o IRR
o PMT
☑ NPV
o XIRR
________________________________________________
**Question 6**
How do you freeze the top row and first column simultaneously in Excel?
o View > Freeze Panes > Freeze Top Row
☑ View > Freeze Panes > Freeze Panes
o Home > Format > Freeze Panes
, o Data > Freeze Panes
________________________________________________
**Question 7**
What is the correct syntax for a SUMIFS formula with multiple criteria?
o =SUMIFS(sum_range, criteria_range1, criteria1)
☑ =SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)
o =SUMIF(sum_range, criteria_range1, criteria1 + criteria2)
o =SUMIFS(criteria_range1, sum_range, criteria1)
________________________________________________
**Question 8**
In conditional formatting, which rule highlights cells greater than a value?
o Equal to
o Contains text
☑ Greater Than
o Duplicate Values
________________________________________________
**Question 9**
What does Ctrl + ; insert in a cell?
o Current time
☑ Current date
o Current date and time
o Day of the week
________________________________________________
