Excel Functions and Formulas Overview

In this video, Kevin, a Microsoft employee, demonstrates how to use various formulas in Microsoft Excel. He covers basic arithmetic operations, the SUM formula, and functions like MIN, MAX, COUNT, COUNTA, AVERAGE, and MEDIAN. Kevin also explains advanced functions such as VLOOKUP and SUMIF, and how to use the NOW function to get the current time. The video concludes with a call to action for viewers to subscribe for more tutorials.

What is the main topic of the video presented by Kevin?

• Creating pivot tables

• Formatting cells in Excel

• Using formulas in Microsoft Excel

• Using charts in Excel

Which versions of Excel are compatible with the formulas discussed in the video?

• Only Excel 2016 and later

• Only Office 365

• Only Excel 2019 and later

• Excel 2007 and later

What symbol is used to start a formula in Excel?

• Plus sign (+)

• Asterisk (*)

• Equal sign (=)

• Forward slash (/)

How can you add two numbers located in different cells in Excel?

• Type the numbers directly in the formula bar

• Use the SUM function

• Use cell references with the plus sign

• Use the CONCATENATE function

What function is used to add multiple values in Excel?

• ADD

• TOTAL

• PLUS

• SUM

Which function helps find the smallest value in a range?

• SMALL

• MAX

• MIN

• LOW

What does the COUNTA function do?

• Counts all cells with any value

• Counts only numeric cells

• Counts empty cells

• Counts cells with text only

How do you calculate the average of a set of numbers in Excel?

• Use the SUM function

• Use the AVERAGE function

• Use the COUNT function

• Use the MEDIAN function

What does the CONCATENATE function do?

• Counts the number of cells

• Adds numbers together

• Joins text strings

• Finds the average of numbers

What is the purpose of an IF statement in Excel?

• To perform logical tests

• To join text strings

• To find the maximum value

• To perform arithmetic operations