Excel Formulas Creation
12 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What character always starts a formula in Excel?

  • Minus sign (-)
  • Ampersand (&)
  • Plus sign (+)
  • Equal sign (=) (correct)

    • What is the correct step to create a formula in Excel after selecting a cell?

  • Type the asterisk sign (*)
  • Type the equal sign (=) (correct)
  • Type the plus sign (+)
  • Type the minus sign (-)

    • What is the formula to calculate the sum of 1 and 1 in Excel?

  • $=1-1$
  • $=1*1$
  • $=1+1$ (correct)
  • $1=+1$

    • What is communicated by reference(value) in Excel?

    <p>$A1(2)$</p> Signup and view all the answers

    Which arithmetic operator is used to subtract in Excel?

    <p>$-$</p> Signup and view all the answers

    What is the result of the formula $=A1-B2$ in Excel, based on the given values?

    <p>$274$</p> Signup and view all the answers

    What is the purpose of typing values into cells in Excel before using them in formulas?

    <p>To provide input for calculations</p> Signup and view all the answers

    What is the role of pressing enter after entering an arithmetic operation and selecting another cell or typing value in Excel?

    <p>To confirm and execute the formula</p> Signup and view all the answers

    What does the formula $=SUM(A1:A5)$ represent in Excel?

    <p>Adds values from cell A1 to A5 together</p> Signup and view all the answers

    What does it mean to 'claim' a cell by entering the equal sign (=) followed by a value in Excel?

    <p>To specify that it will be used in a formula</p> Signup and view all the answers

    What happens if you type a formula directly without clicking on cells in Excel?

    <p>The formula will be executed using default cell references</p> Signup and view all the answers

    What is communicated by reference(value) example A2(320) in Excel?

    <p>The value of cell A2 as 320</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser