Preview

05 - Formulas in Excel

 1. One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide.

  TRUE

  FALSE

 2. Excel uses standard _______ for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.

  numbers

  booleans

  functions

  operators

 3. All formulas in Excel must begin with an ______________.

  equivalent SUM phrase

  equals sign (=).

  alphebetical letter

  apostrophe

 4. While you can create simple formulas in Excel using numbers (for example, =2+2 or =5*5), most of the time you will use ___________ to create a formula.

  cell addresses

  functions

  numerical values

  alphabetical values

 5. Alexa wishes to add up the values in cells A46 to A50 and put the result in cell: C46. What would the formula be?
formulas_excel_question1.png

  Answer: =SUM(A46:A50)

  Answer: SUM(=56-50)ADD

  Answer: 46+47+48+49 (SUM)

  Answer: SUM+ADD(A46 to A50)

 6. What formula is likely to have gone in cell C7?
Note: This question, and the next, refers to this image.
formulas_excel_question2.png

  Answer: There is no formula in this cell

  Answer: =SUM(E3:E4)

  Answer: =SUM(4+5)ADD

  Answer: ==SUM(C3:C4)

 7. What formula is likely to have gone in cell E4?

  Answer: =SUM(C3+D3)

  None of these answers are correct

  Answer: =SUM(C3*C3)

  Answer: = C4 * D4

 8. Formulas can also be copied to adjacent cells with the fill handle, which can save a lot of time and effort if you need to perform ____________________.
formulas_excel_question3.png

   the same calculation multiple times in a worksheet

  several calculations in the same cell, at the same time

  different calculations that are each unique

  no calculations at all

 9. Oliver is having a party and has ordered from the Mac imitation company. Tax applied to all sales is 7.5%. What formula is likely to be in cell D6?
Note: PEDMAS / BODMAS (the order of operations carried out)
formulas_excel_question4.png

  Answer: =SUM(D3:D5)*0.075

  None of these options are correct as you cannot have numbers outside the brackets

  Answer: =0.075 * D3 + D5

  Answer: =SUM(D3:D5 * 0.075)

 10. There are two types of cell references: relative and absolute. By default all cell references are ___________________.

  absolute, which means they do not change at all

  relative, which means they change when a formula is coped to another cell.

  relative, which means they are constant no matter where they are copied

  absolute, which means they change when a formula is copied to another cell