Font size
WorksheetsExcel Pre-Test Assessment
Total questions: 15
Worksheet time: 23mins
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
What is the purpose of the fill handle in Excel?
To save the workbook
To copy cell contents
To adjust column width
To sort data
How do you create a chart in Excel?
Insert > Chart
File > Chart
View > Chart
Data > Chart
How do you apply conditional formatting to highlight cells with values greater than 100?
Data > Conditional Formatting
Home > Conditional Formatting
Insert > Conditional Formatting
Review > Conditional Formatting
Which function would you use to find the total sales from a list of transactions?
COUNT
SUM
AVERAGE
MAX
Which of the following is a common file extension for Excel workbooks?
.docx
.xlsx
.pptx
