Excel Formulas Overview Quiz
5 Questions
3 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

In Excel, which reference style uses letters for columns and numbers for rows?

  • D4 reference style
  • B2 reference style
  • C3 reference style
  • A1 reference style (correct)

    • What does the AVERAGE function calculate in Excel?

  • The total sum of a range of cells
  • The minimum value in a range of cells
  • The average value for a range of cells (correct)
  • The maximum value in a range of cells

    • Which cell does the reference 'B2' point to in Excel?

  • Intersection of column D and row 4
  • Intersection of column B and row 2 (correct)
  • Intersection of column C and row 3
  • Intersection of column A and row 1

    • What does the exclamation point ( ! ) do in an Excel reference?

    <p>Separates the worksheet reference from the cell range reference (A)</p> Signup and view all the answers

    How many columns are there in the A1 reference style in Excel?

    <p>16384 (D)</p> Signup and view all the answers

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser