Using Formulas in Microsoft Excel

John is trying to calculate the total sales of his store in Excel. What should he start with to do formulas in Excel?

• Start with the equal sign

• Start with the plus sign

• Start with the minus sign

• Start with the multiplication sign

John has two cells in his Excel sheet, one with the value 5 and the other with the value 7. How can he add these two numbers in Excel?

• Type the numbers in the formula bar

• Use the plus sign in the formula

• Use the minus sign in the formula

• Use the multiplication sign in the formula

John has 2 apples. He gave 1 apple to his friend. How many apples does he have now in his basket?

• 0

• 1

• 2

• 3

John is working on a financial report in Excel and needs to calculate the product of two numbers. How should he do this?

• He should use the asterisk sign in the formula

• He should use the plus sign in the formula

• He should use the minus sign in the formula

• He should use the division sign in the formula

John is dividing 4 apples equally among his 2 friends. How many apples will each friend get?

• 0

• 1

• 2

• 3

You are working as an accountant and you have a list of different expenses made throughout the month in an Excel sheet. Which formula would you use to calculate the total expenses?

• Sum

• Average

• Min

• Max

John is working on a spreadsheet in Excel and he needs to find the smallest number in a range of cells. Which formula should he use?

• Sum

• Average

• Min

• Max

John is working on a large dataset in Excel. He wants to count the number of cells that contain a value. Which formula should he use?

• Count

• Average

• Min

• Max

John is working on a spreadsheet in Excel and he needs to join two text strings into one text string. Which formula should he use?

• Concat

• Average

• Min

• Max

You are working on a spreadsheet in Excel and you need to perform a logical test. Which formula would you use?

• If

• Average

• Min

• Max