Excel Pre-Test Assessment

Match the following Excel functions with their descriptions: SUM - b) Adds all numbers in a range AVERAGE - a) Returns the highest value in a range MAX - c) Returns the average of the numbers in a range MIN - d) Returns the lowest value in a range

What is a PivotTable used for?

Write the formula to calculate the average of the numbers in cells A1 to A10.

Open a new Excel workbook and perform the following tasks: a) Enter the following data in cells A1 to A3: 10, 20, 30 b) Use a formula to calculate the sum of these numbers in cell A4 c) Format the numbers in cells A1 to A3 as currency d) Create a bar chart using this data

On a scale of 1 to 5, how would you rate your current proficiency in Excel? (1 = Beginner, 5 = Expert)

What specific Excel skills or topics would you like to improve or learn more about?

What is Microsoft Excel used for?

• Word processing

• Spreadsheets

• Database management

• Web browsing

What is the shortcut to save a workbook in Excel?

• Ctrl + C

• Ctrl + V

• Ctrl + S

• Ctrl + X

How do you start a formula in Excel?

• %

• =

• #

• @

What does the VLOOKUP function do?

• Finds a value in a row

• Finds a value in a column

• Sorts data in ascending order

• Filters data