Wall Street Prep: Excel Crash Course
Questions and Answers | Latest Version
| 2025/2026 | Correct & Verified
What is the keyboard shortcut to insert a new worksheet in Excel?
✔✔ Press Shift + F11.
How do you calculate the sum of a range of cells from A1 to A10?
✔✔ Use the formula =SUM(A1:A10).
What function returns the current date in Excel?
✔✔ =TODAY().
How can you quickly remove duplicates from a column?
✔✔ Use the “Remove Duplicates” option under the Data tab.
What Excel function calculates the average of a range of cells?
✔✔ =AVERAGE(range).
1
,How do you reference a cell in another worksheet named “Sheet2”?
✔✔ Use =Sheet2!A1.
What function can you use to find the maximum value in a range?
✔✔ =MAX(range).
How can you make a cell reference absolute?
✔✔ Add dollar signs, e.g., $A$1.
What Excel function counts only numeric entries in a range?
✔✔ =COUNT(range).
How do you combine text from two cells into one?
✔✔ Use =CONCATENATE(A1,B1) or =A1&B1.
What is the formula to calculate compound interest for principal P, rate r, and n periods?
✔✔ =P*(1+r)^n.
2
,How can you quickly fill a series of numbers down a column?
✔✔ Use the fill handle (drag the small square at the corner).
Which function returns the number of characters in a text string?
✔✔ =LEN(text).
What formula finds the smallest value in a range?
✔✔ =MIN(range).
How do you calculate future value of an investment using Excel?
✔✔ =FV(rate, nper, pmt, [pv], [type]).
What is the keyboard shortcut to switch between worksheets?
✔✔ Ctrl + Page Up / Page Down.
Which function would you use to look up a value in a table by row?
✔✔ =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
3
, How do you round a number up to the nearest integer?
✔✔ =ROUNDUP(number, 0).
Which function counts all non-empty cells in a range?
✔✔ =COUNTA(range).
How do you extract the first three characters from a text string in A1?
✔✔ =LEFT(A1,3).
How do you calculate net present value (NPV) in Excel?
✔✔ =NPV(discount_rate, value1, [value2], …).
How can you lock a cell to prevent accidental editing?
✔✔ Use “Protect Sheet” and lock the specific cell.
What formula calculates the internal rate of return (IRR) for a series of cash flows?
✔✔ =IRR(values).
4
Questions and Answers | Latest Version
| 2025/2026 | Correct & Verified
What is the keyboard shortcut to insert a new worksheet in Excel?
✔✔ Press Shift + F11.
How do you calculate the sum of a range of cells from A1 to A10?
✔✔ Use the formula =SUM(A1:A10).
What function returns the current date in Excel?
✔✔ =TODAY().
How can you quickly remove duplicates from a column?
✔✔ Use the “Remove Duplicates” option under the Data tab.
What Excel function calculates the average of a range of cells?
✔✔ =AVERAGE(range).
1
,How do you reference a cell in another worksheet named “Sheet2”?
✔✔ Use =Sheet2!A1.
What function can you use to find the maximum value in a range?
✔✔ =MAX(range).
How can you make a cell reference absolute?
✔✔ Add dollar signs, e.g., $A$1.
What Excel function counts only numeric entries in a range?
✔✔ =COUNT(range).
How do you combine text from two cells into one?
✔✔ Use =CONCATENATE(A1,B1) or =A1&B1.
What is the formula to calculate compound interest for principal P, rate r, and n periods?
✔✔ =P*(1+r)^n.
2
,How can you quickly fill a series of numbers down a column?
✔✔ Use the fill handle (drag the small square at the corner).
Which function returns the number of characters in a text string?
✔✔ =LEN(text).
What formula finds the smallest value in a range?
✔✔ =MIN(range).
How do you calculate future value of an investment using Excel?
✔✔ =FV(rate, nper, pmt, [pv], [type]).
What is the keyboard shortcut to switch between worksheets?
✔✔ Ctrl + Page Up / Page Down.
Which function would you use to look up a value in a table by row?
✔✔ =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
3
, How do you round a number up to the nearest integer?
✔✔ =ROUNDUP(number, 0).
Which function counts all non-empty cells in a range?
✔✔ =COUNTA(range).
How do you extract the first three characters from a text string in A1?
✔✔ =LEFT(A1,3).
How do you calculate net present value (NPV) in Excel?
✔✔ =NPV(discount_rate, value1, [value2], …).
How can you lock a cell to prevent accidental editing?
✔✔ Use “Protect Sheet” and lock the specific cell.
What formula calculates the internal rate of return (IRR) for a series of cash flows?
✔✔ =IRR(values).
4
