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

Formulas and functions are very popular topics in Microsoft Excel assessment test. They’re also used very frequently in Excel interview. In this tutorial I am going to introduce you to Excel formulas and functions with some basic operations. Also learning about key functions that are used as part of Excel interview and Excel assessment test.

Excel is an electronic spreadsheet program created by Microsoft. An electronic spreadsheet is a computer software program that is used for storing, organizing and manipulating data. Excel is used by a lot of business for financial planning, forecasting, loan calculations and reporting.

Microsoft Excel is a program that provides worksheets comprised of rows and columns. Data can be stored in the worksheet, also called a spreadsheet, similarly to a Microsoft Word table, but the power of Excel is its ability to perform simple to complex mathematical calculations, and other functions.

Current version of Microsoft Excel allows users to manage multiple spreadsheet pages in a single file. The saved computer file is often referred to as a workbook and each page in the workbook is a separate worksheet.