Microsoft Excel 2021365 - Beginner to Advanced - Formulas and Functions Explained

This video tutorial introduces Excel's formulas and functions, emphasizing their importance in performing calculations. It covers basic formula construction using cell references, the use of the SUM function, and the role of operators in Excel. The tutorial also explains the order of operations, using the BODMAS rule to clarify how Excel processes calculations. Key tips include using cell references for dynamic updates and understanding function arguments.

What is the primary purpose of formulas in Excel?

• To create charts

• To sort data

• To format text

• To perform calculations

Why is it recommended to use cell references in Excel formulas?

• To make the worksheet look cleaner

• To ensure formulas update automatically when data changes

• To prevent errors in calculations

• To save the file in a different format

What is the benefit of using the SUM function in Excel?

• It formats the cells

• It adds a large range of numbers quickly

• It creates a chart

• It sorts the data

What does Intellisense in Excel help you with?

• Finding functions as you type

• Formatting text

• Creating charts

• Sorting data

Which of the following is NOT a basic operator in Excel?

• Addition

• Subtraction

• Multiplication

• Exponentiation

What symbol is used for multiplication in Excel formulas?

• x

• *

• -

• /

In the expression 10 + 2 / 2, which operation is performed first according to the order of operations?

• Multiplication

• Division

• Subtraction

• Addition

What does the BODMAS rule help you determine in Excel?

• The order of operations in calculations

• The sorting order of data

• The format of the worksheet

• The type of chart to use

If you want Excel to calculate 10 + 2 first in the expression 10 + 2 / 2, what should you do?

• Use a different function

• Put 10 + 2 in brackets

• Change the order of numbers

• Use a different operator

Which of the following is calculated last according to the BODMAS rule?

• Brackets

• Division

• Addition

• Orders