Wall Street Prep Excel Questions and Answers | Latest Version | 2025/2026 | Correct & Verified

Wall Street Prep Excel Questions and Answers | Latest Version | 2025/2026 | Correct & Verified How do you quickly sum a column of numbers in Excel? Use the SUM function, e.g., =SUM(A1:A10). What formula would you use to find the average of numbers in cells B2 through B20? =AVERAGE(B2:B20) How can you lock a cell reference when copying a formula to other cells? Use the dollar sign to make it absolute, e.g., $A$1. Which function can you use to find the largest number in a range? =MAX(range) Which Excel feature allows you to create automatic charts from data? Insert → Recommended Charts 2 How do you create a dropdown list in a cell? Use Data Validation and select List. What formula would you use to combine the contents of two cells, A1 and B1, into one cell? =A1 & B1 or =CONCATENATE(A1,B1) How do you remove duplicate values from a column? Use the Remove Duplicates feature under the Data tab. Which function counts only numeric values in a range? =COUNT(range) How can you highlight all cells greater than 100 in a column? Use Conditional Formatting → Highlight Cell Rules → Greater Than 100. What formula would you use to find the minimum value in a range C1:C50? =MIN(C1:C50) 3 How do you freeze the top row in Excel so it stays visible while scrolling? View → Freeze Panes → Freeze Top Row. Which function can return the current date in a cell? =TODAY() How do you quickly transpose rows to columns? Use Copy → Paste Special → Transpose. What formula would you use to count all cells that contain the word “Revenue”? =COUNTIF(range,"Revenue") How can you remove all blank rows from a table? Use Go To Special → Blanks → Delete Rows. Which formula can you use to round a number in A1 to 2 decimal places? =ROUND(A1,2) 4 How do you lock the top left cell in a VLOOKUP formula? Use absolute references, e.g., $A$1. Which function would you use to find the position of a text string within another string? =FIND("text",cell) How do you create a pivot table from a dataset? Insert → Pivot Table → Select data range → Choose location. Which function returns the number of non-empty