Step 1 of 4
Excel Intermediate Pre-Assessment
This assessment evaluates your current Excel skills to place you at the correct training level. Answer honestly without external help.
- 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 (10 Questions, 1 Point Each)
Select the single best answer.
Q1.How do you align text to the centre of a cell? 1 pt *
Q2.What is the keyboard shortcut for "Save As" in Excel? 1 pt *
Q3.Which of the following best describes a spreadsheet? 1 pt *
Q4.Which command is used to remove an entire row from a worksheet? 1 pt *
Q5.What is the difference between Relative and Absolute References in Excel? 1 pt *
Q6.What is the difference between a Workbook and a Worksheet? 1 pt *
Q7.Which shortcut key is used to open a new spreadsheet? 1 pt *
Q8.You have January sales data in Column C (C3:C6). How would you calculate the average sales for the month? 1 pt *
Q9.Which shortcut key is used to save an Excel workbook? 1 pt *
Q10.What is the quickest way to fill a series of numbers in a column? 1 pt *
Checkbox Questions
Multiple correct answers possible. Select all that apply.
Q11.What are the differences between Relative, Absolute, and Mixed References in Excel? 3 pts *
Select all that apply.
Q12.Which of the following are valid ways to open an existing Excel workbook? 3 pts *
Select all that apply.
Q13.What is the difference between a Workbook and a Spreadsheet in Excel? 2 pts *
Select all that apply.
Q14.Which formatting options can be applied to numbers in Excel? 4 pts *
Select all that apply.
Q15.How does the BODMAS Rule apply in Excel formulas? 3 pts *
Select all that apply.
Q16.Suppose you have the Total per product listed in Column D (D3:D7). In Column E (E3:E7), you need to calculate the 15% tax using an absolute reference for cell E4, which contains the tax rate. What will the formula look like? 2 pts *
Select all that apply.
Q17.Why is it important to use cell references in Excel when performing calculations? 2 pts *
Select all that apply.
Q18.In Excel, what is the purpose of the "Find and Replace" feature? 1 pt *
Q19.Which option should you use in Excel if you want to save your current workbook with a different name or in a different folder? 1 pt *
True or False Questions (5 Questions, 1 Point Each)
Select True if the statement is correct, or False if it is incorrect.
Q20.Pressing "Ctrl + P" will print the current Excel worksheet. 1 pt *
Q21.The "SUM" function is used to count the number of words in a cell. 1 pt *
Q22.Pressing "Ctrl + Z" will redo an action in Excel. 1 pt *
Q23.A cell reference "A1" refers to the first column and first row of a worksheet. 1 pt *
Q24.An Excel worksheet has only one column. 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