Excel Crash Course Exam from Wall Street Prep-wall Street Prep | Practice Questions with Verified Answers| Latest 2025/2026 Update.

Excel Crash Course Exam from Wall i,- i,- i,- i,- i,- i,-




Street Prep-wall Street Prep | i,- i,- i,- i,- i,-




Practice Questions with Verified i,- i,- i,- i,-




Answers| Latest 2025/2026 Update. i,- i,- i,-




Identify the utility used to create a dropdown menu in Excel.
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,- i,-



Alt d l i,- i,-




Which of the following is NOT a shortcut for changing the format
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



of a cell
i,- Ctrl Tab
i,- i,-i,- i,- i,-




Identify the shortcut to remove arrows from Trace Precedents or
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Trace Dependents. i,-Alt m a i,-i,- i,- i,- i,-




What is the keyboard shortcut to open the formatting cells dialog
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



box? Ctrl 1 i,-i,- i,- i,-




What are the keyboard shortcuts for auto-fitting a range of
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



columns? 1) Select the columns by hitting Ctrl Spacebar. 2)
i,-i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Hold down the shift key and use left and right arrow keys to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-

,highlight the range of columns. 3) Hit Alt H O I to auto fit the
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



columns.


When you are in the Format Cells dialog (Ctrl 1):
i,- i,- i,- i,- i,- i,- i,- i,- i,-




What is the keyboard shortcut for moving across tabs (Number,
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Alignment, Font Border, Fill, Protection)? i,- i,- i,- i,-




How do you move counter clockwise across form elements?
i,- i,- i,- i,- i,- i,- i,- i,-




How do you select a checkbox (put a checkbox next to it)
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,- i,- 1) i,-



Ctrl Tab 2) Shift Tab 3) Spacebar
i,- i,- i,- i,- i,- i,-




Instructions: See question 7. i,- i,- i,-




In the previous question, you determined which sales rep gave
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



the most discounts by dollar amount. What was that amount?
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,-



17,439.6
i,-




Instructions: See question 7. i,- i,- i,-




Over the entire analysis period, which item code did postal code
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



93930 spend the greatest dollars on (using Sales Price Per Unit)?
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-i,-



16 i,-




Instructions: See question 7. i,- i,- i,-

, Which item number had the highest average sales price per unit
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



(use a simple average for calculation)?
i,- i,- 3 i,- i,- i,- i,-i,- i,-




Instructions: See question 7. i,- i,- i,-




For that item number, what was the average unit sales price?
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



Please enter your answer with numbers only, to one decimal
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



place. Use a simple average for calculation.
i,- i,- 74.6
i,- i,- i,- i,- i,-i,- i,-




Instructions: See question 7. i,- i,- i,-




Which sales rep had the lowest average sales price / unit? Use a
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



simple average for calculation.
i,- Amy Adams i,- i,- i,-i,- i,- i,-




Instructions: See question 7. i,- i,- i,-




What was that average sales price? Please enter your answer to
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



one decimal place. Do not include any symbols. Use a simple
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



average for calculation. 30.7 i,- i,- i,-i,- i,-




Instructions: See question 7. Your answer for this question should
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-



be rounded to the nearest 1 decimal, comma separating 000s,
i,- i,- i,- i,- i,- i,- i,- i,- i,- i,-