Excel Formulas and Functions Quiz
15 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

On an Excel sheet, how is the active cell indicated?

  • A dotted border
  • A blinking border (correct)
  • A dark wide border
  • Italic text
  • In Excel, with which of the following do all formulas start?

  • *
  • = (correct)
  • $
  • /
  • What term describes explanatory text attached to a cell in Excel?

  • Dialog
  • Context
  • Callout
  • Comment (correct)
  • How can a cell comment be viewed in Excel?

    <p>Position the mouse pointer over the cell (D)</p> Signup and view all the answers

    Which action will not select all the cells in an Excel document?

    <p>Clicking three times with the right mouse button in the spreadsheet (A)</p> Signup and view all the answers

    What is the default style for new data keyed in a new workbook in Excel?

    <p>Normal (C)</p> Signup and view all the answers

    Which of the following keyboard shortcuts can be used for creating a chart from the selected cells in Excel?

    <p>F11 (C)</p> Signup and view all the answers

    What is the term used for the value used in a formula that does not change in Excel?

    <p>Constant (A)</p> Signup and view all the answers

    What action in Excel causes the cell to accept your typing as its contents?

    <p>Enter (C)</p> Signup and view all the answers

    In Excel, how is the active cell indicated?

    <p>A blinking border (B)</p> Signup and view all the answers

    What action in Excel causes the cell to accept your typing as its contents?

    <p>Enter (A)</p> Signup and view all the answers

    What term describes the explanatory text attached to a cell in Excel?

    <p>Comment (B)</p> Signup and view all the answers

    Which of the following keyboard shortcuts can be used for creating a chart from the selected cells in Excel?

    <p>F11 (A)</p> Signup and view all the answers

    On an Excel sheet, how is the active cell indicated?

    <p>A blinking border (B)</p> Signup and view all the answers

    How can a cell comment be viewed in Excel?

    <p>Position the mouse pointer over the cell (C)</p> Signup and view all the answers

    More Like This

    Mastering Formulas and Functions in Excel
    5 questions
    Excel Formulas and Functions
    10 questions
    MS Excel: Formulas and Functions
    5 questions
    Excel Formulas and Functions Quiz
    8 questions
    Use Quizgecko on...
    Browser
    Browser