Creating Basic Formulas in Excel

This video tutorial covers the creation of basic formulas in Excel, focusing on the use of fundamental operators such as addition, subtraction, multiplication, division, percentage, and exponentiation. Each operator is demonstrated with examples, showing how to apply them in Excel to perform calculations. The tutorial emphasizes the importance of practicing these operations to enhance proficiency in Excel.

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

• Subtraction

• Addition

• Division

• Concatenation

What is the correct sequence to perform an addition operation in Excel?

• Select first cell, type '=', select second cell, type '+', press enter

• Type '+', select first cell, select second cell, press enter

• Select cell, type '+', select another cell, press enter

• Type '=', select first cell, type '+', select second cell, press enter

How do you perform a multiplication operation in Excel?

• Type '=', select first cell, type '-', select second cell, press enter

• Type '=', select first cell, type '/', select second cell, press enter

• Type '=', select first cell, type '*', select second cell, press enter

• Type '=', select first cell, type '+', select second cell, press enter

To calculate 5% of a number in Excel, which operators are used?

• Equal to, addition, percentage

• Equal to, multiplication, percentage

• Equal to, division, percentage

• Equal to, subtraction, percentage

What is the correct way to use the exponential operator in Excel?

• Type '=', select first cell, type '^', select second cell, press enter

• Type '=', select first cell, type '+', select second cell, press enter

• Type '=', select first cell, type '*', select second cell, press enter

• Type '=', select first cell, type '/', select second cell, press enter