Step 1 of 6
Excel Advanced Pre-Assessment
This assessment is designed to evaluate your current Excel skills to ensure you are placed at the right training level. Please answer all questions honestly based on what you know without external help or searching for answers.
- Read each question carefully before answering.
- Some questions require multiple-choice answers, while others require short responses.
- There is no pass or fail — this assessment simply helps us determine your starting point.
* Indicates required field
Your Details
Multiple Choice Questions (4 Questions, 1 Point Each)
Only one correct answer per question.
Q1.Which of the following best describes the purpose of freezing titles in Excel? 1 pt *
Q2.Which Excel feature allows you to create a worksheet with predesigned formatting and formulas? 1 pt *
Q3.What happens when you apply Conditional Formatting to a range of cells? 1 pt *
Q4.How do you rename a worksheet? 1 pt *
Checkbox Questions (4 Questions, 3 Points Each)
Multiple correct answers possible. Select all that apply.
Q5.Which of the following options are available when working with multiple worksheets? 3 pts *
Select all that apply.
Q6.Which of the following are built-in Excel functions? 3 pts *
Select all that apply.
Q7.Which features can be adjusted using Page Setup? 3 pts *
Select all that apply.
Q8.Which toolbar options can be customized in Excel? 3 pts *
Select all that apply.
Multiple Answer Questions (4 Questions, 1 Point Each)
Select the correct answer.
Q9.What is the main difference between relative and absolute cell references in Excel formulas? 1 pt *
Q10.What is the purpose of linking formulas between worksheets? 1 pt *
Q11.What are the basic steps to apply AutoFilter to a range of data in Excel? 1 pt *
Q12.How can you move an entire worksheet to another workbook? 1 pt *
True or False Questions (4 Questions, 1 Point Each)
Select True if the statement is correct, or False if it is incorrect.
Q13.You can apply multiple conditions in Conditional Formatting. 1 pt *
Q14.Error checking in Excel helps identify and correct formula mistakes. 1 pt *
Q15.A worksheet group allows you to edit multiple sheets at once. 1 pt *
Q16.Using the Draw tool in Excel allows you to insert formulas directly. 1 pt *
Scenario-Based Multiple Choice (4 Questions, 1 Point Each)
Read each scenario and select the best answer.
Q17.You need to ensure that a specific formula does not change when copied across multiple cells. What should you do? 1 pt *
Q18.You are working with a dataset and need to quickly find all entries where sales exceed R50,000. Which feature should you use? 1 pt *
Q19.You have inserted a chart but need to move it to a different sheet for better visibility. How can you do this? 1 pt *
Q20.When preparing a spreadsheet for printing, which of the following actions should you take? 1 pt *
Review Your Answers
Please review your answers below. You can edit any section before submitting.
We’re a team of expert trainers dedicated to empowering teams through live, interactive Microsoft Office and computer literacy workshops