Expertise in Excel: Sample

What's an efficient way to rearrange columns in a large dataset?

• Sorting based on column headers
• Using the =TRANSPOSE() function
• Manually retyping the data in the desired order
• Cut and paste columns individually
• Other - Write In Please enter an 'other' value for this selection.

You have employee names in column A (e.g., "John Smith") and need to extract their first names into column B. Which formula is appropriate?

• =LEFT(A1, FIND(" ",A1)-1)
• =SUBSTITUTE(A1," ","")
• =MID(A1,1,5)
• =RIGHT(A1, LEN(A1)-FIND(" ",A1))
• Other - Write In Please enter an 'other' value for this selection.

Which chart type best visualizes how different categories contribute to a total over time?

• Scatter plot
• Pie chart
• 100% stacked area chart
• Line chart
• Other - Write In Please enter an 'other' value for this selection.

How do you apply a calculation to an entire column of data quickly, without dragging the formula down?

• Use the =TRANSPOSE() function
• Convert the range to a table
• Double-click the cell's fill handle
• Ctrl + Enter after entering the formula in the first cell
• Other - Write In Please enter an 'other' value for this selection.

You're tracking project expenses, and want to alert yourself if spending exceeds 75% of the budget. Instead of manual checks, how do you get a visual alert?

• Create a data bar with Conditional Formatting
• Format the expense cell to turn red when the condition is met.
• Insert a chart that updates dynamically with the expenses
• Use an IF formula to return the text "ALERT" when the condition is met.
• Other - Write In Please enter an 'other' value for this selection.

Would you like us to email your score to you? *This question is required.

• Yes
• No