Basic Arithmetic Operations in Excel

This tutorial covers the four basic arithmetic operations in Microsoft Excel: addition, subtraction, multiplication, and division. It explains how to perform these operations manually and using Excel functions like SUM and PRODUCT. The video provides step-by-step instructions for each operation, demonstrating how to use Excel's formula capabilities effectively. It concludes with a summary of the operations and encourages viewers to engage with the content by liking, commenting, and subscribing.

What is the main focus of this Excel tutorial?

• Advanced Excel functions

• Basic arithmetic operations in Excel

• Data visualization in Excel

• Excel macros and automation

How do you manually add two cells in Excel?

• Use the SUM function

• Enter '=' followed by clicking the cells and adding a minus symbol

• Use the AVERAGE function

• Enter '=' followed by clicking the cells and adding a plus symbol

What is the result of adding cells with values 5 and 15 manually?

• 15

• 10

• 25

• 20

Which function in Excel is used to add multiple cells together?

• AVERAGE

• SUM

• COUNT

• PRODUCT

What is the advantage of using the SUM function?

• It can only add two cells

• It can add a large range of cells

• It can subtract cells

• It can divide cells

How do you manually subtract one cell from another in Excel?

• Use the PRODUCT function

• Enter '=' followed by clicking the cells and adding a plus symbol

• Enter '=' followed by clicking the cells and adding a minus symbol

• Use the SUM function

What is the result of subtracting 5 from 12?

• 17

• 10

• 7

• 5

How do you manually multiply two cells in Excel?

• Enter '=' followed by clicking the cells and adding an asterisk symbol

• Enter '=' followed by clicking the cells and adding a plus symbol

• Use the SUM function

• Use the AVERAGE function

What is the result of multiplying 5 by 20?

• 200

• 100

• 50

• 25

Which function in Excel is used to multiply a range of cells?

• SUM

• COUNT

• AVERAGE

• PRODUCT