Excel Formulas and Functions for Excel Skills Test (SUM, MIN, MAX, COUNT, AVERAGE) – VIDEO Tutorial with XLSX Workfiles Download


Why knowledge of Excel Formulas and Functions is important for Assessment Test?

Excel Formula is an expression that calculates the value of a cell. For example, =B2+B2+C3+C4 is a formula that adds up the values in cells listed. Function is a predefined formula already available in Excel. Samples of Predefined functions are SUM, MIN, MAX, AVERAGE, COUNT and more

Because spreadsheets are so popular and useful, many companies conduct Excel interview before hiring for job. An Excel Interview Test is a screening process employers use as part of the candidate employment interview to test a potential candidate on their knowledge and proficiency of Microsoft Excel.

The basic Microsoft Excel skills test assesses candidate’s ability to use Microsoft Excel's user interface quickly and efficiently to access the right features and perform simple tasks in the application. It validates fundamental knowledge from determining the best way to open a recently closed Workbook to using the correct formula to perform automatic calculations. Candidates are required to answer true/false,  multiple-choice questions and multiple answer questions based on Excel spreadsheets, charts and tables filled with sample data.

Because Formulas and Functions are used so frequently in Microsoft Excel there are a lot of relevant questions about most frequently used formulas and functions on Excel Assessment Test.


Excel Assessment Test: Excel Formulas and Functions (SUM, MIN, MAX, COUNT, AVERAGE)

Download Files Used in the Video

There are multiple Excel Assessment work files included in this free download. Please complete below form and you will be redirected to the page, which contains below listed downloadable files for you to follow along and complete the exercises:

  • Work file to follow along. Use this file to follow along with the video and solve challenges yourself: Basic Formulas And Functions Practice File.XLSX
  • Completed File with all problems solved. Same file as above with all problems solved: Basic Formulas And Functions Complete.XLSX
  • Both Files in Zip Archive - Zip archive containing both excel work files referenced above: Excel Formulas and Functions Video Download XLSX Work Files.2 Files.Zip