Excel: Basic Math Operations

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

Questions and Answers

Match each Excel operation with its correct symbol:

Addition = + Subtraction = - Multiplication = * Division = /

Match each action with the initial step required in Excel:

Entering a formula = Type '=' Selecting cells = Click the cell Displaying a result = Press 'Enter' Performing operations = Type symbol

Match the operation to the description of its function:

Addition = Combines values Subtraction = Finds the difference Multiplication = Calculates the product Division = Calculates the quotient

Match the task with the series of steps that best describes how to execute it:

<p>Calculate sum of cells B1 and B2 = Type '=', click B1, type '+', click B2, press Enter Calculate difference between cells B1 and B2 = Type '=', click B1, type '-', click B2, press Enter Calculate product of cells B1 and B2 = Type '=', click B1, type '*', click B2, press Enter Calculate quotient of cells B1 and B2 = Type '=', click B1, type '/', click B2, press Enter</p> Signup and view all the answers

Match the term with the process it belongs to:

<p>Result = All '=' = All '+' = Addition '-' = Subtraction</p> Signup and view all the answers

Match the operator location to the action:

<p>Click Cell = Before and After Type '=' = Beginning Press 'Enter' = End Type Operator = Middle</p> Signup and view all the answers

Match the description of the result with the formula:

<p>Sum = $=A1+B1$ Difference = $=A1-B1$ Product = $=A1*B1$ Quotient = $=A1/B1$</p> Signup and view all the answers

Match the steps with performing multiple additions:

<p>Select starting cell = First Type '+' = Middle Click final 'Enter' = End Double Click = Continue</p> Signup and view all the answers

Match the purpose with its most appropriate Excel symbol:

<p>Combining two numerical values = + Finding the remaining total = - Enlarging a numerical value = * Shrinking a numerical value = /</p> Signup and view all the answers

Match the correct order of the formula to the description:

<p>A1 = First operand '+' = Operator '=' = Start Enter = End</p> Signup and view all the answers

Match the type with the way it is used:

<p>Cell = Clicked Symbol = Typed Equal = Typed Formula = Displayed</p> Signup and view all the answers

Match the cell name with its location:

<p>B1 = First cell B2 = Second cell = = Before the first cell Enter = After the second cell</p> Signup and view all the answers

Match the order of events to the part of the formula:

<p>Type '=' = Setting up the Formula Click cells and + = Calculate Display Answer = Result Multiple '+': = Increase Complexity</p> Signup and view all the answers

Match the type of calculation with the type of operand:

<p>Addition &amp; Subtraction = Mixed Values Multiplication = Expand Division = Reduce Single Operation = Basic</p> Signup and view all the answers

Match the operation with its symbol being typed:

<p>Total = + Difference = - Product = * Quotient = /</p> Signup and view all the answers

Match the operation with the proper excel action:

<p>Open Excel = Start Select cells = Operands Type = Operators Press Enter = End</p> Signup and view all the answers

Match where the calculation takes place with the location:

<p>Type '=' = Cell Selected Type operator = Between cells Results = New cell Press Enter = Calculates from formula</p> Signup and view all the answers

Match when the actions take place in the operation.

<p>Select cell = First Type operator = Middle Calculate = Formulas New value = End</p> Signup and view all the answers

Match the type of operation with its location:

<p>New formula = New Cell Continue adding = Double Click Display result = Any cell Perform math = Cell Formula</p> Signup and view all the answers

Match the math action with the symbol:

<p>Values Combined = + Remaining = - Expanded Value = * Shrunken Value = /</p> Signup and view all the answers

Flashcards

How to add in Excel?

To add numbers in Excel, start with '=' then click cells and use '+' between them.

How to subtract in Excel?

Enter '=' then click the first cell, type '-', click the second cell, and press Enter.

How to multiply in Excel?

Enter '=' then click the first cell, type '*', click the second cell, and press Enter to multiply.

How to divide in Excel?

Enter '=' then click the first cell, type '/', click the second cell, and press Enter to divide.

Signup and view all the flashcards

How to start a formula?

Begin by typing an equals sign (=) in the cell.

Signup and view all the flashcards

How to show the result?

After typing the formula, press the Enter key to display the result.

Signup and view all the flashcards

Add more cells to formula?

Double-click to edit, then add '+' and select the next cell.

Signup and view all the flashcards

Study Notes

  • The tutorial explains how to perform basic mathematical operations (addition, subtraction, multiplication, division) in Microsoft Excel.

Addition

  • Click on the cell where you want the answer to appear.
  • Type "=" to start the formula.
  • Click on the first cell you want to add (e.g., B1).
  • Type "+" to indicate addition.
  • Click on the second cell you want to add (e.g., B2).
  • Press "Enter" to display the sum.
  • To add more cells, double-click the cell with the existing formula
  • Continue adding "+" and selecting the next cell (e.g., C2) before hitting Enter.

Subtraction

  • Select the cell for the result.
  • Type "=" to begin the formula.
  • Click the first cell (e.g., B1).
  • Type "-" for subtraction.
  • Click the second cell (e.g., B2).
  • Press "Enter" to see the difference.

Multiplication

  • Choose the cell for the answer.
  • Type "=" to start the formula.
  • Click the first cell (e.g., B1).
  • Type "*" (asterisk) for multiplication.
  • Click the second cell (e.g., B2).
  • Press "Enter" to display the product.

Division

  • Select the cell where you want the result.
  • Type "=" to start the formula.
  • Click the first cell (e.g., B1).
  • Type "/" (forward slash) for division.
  • Click the second cell (e.g., B2).
  • Press "Enter" to display the quotient.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser