Excel Formulas and Functions Quiz

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

Flashcards are hidden until you start studying

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