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

What does the function 'INT( )' do in Excel?

  • Extracts the year from a given date
  • Returns the square root of a given number
  • Returns the current time
  • Rounds a number down to the nearest integer (correct)

In Excel, what is the purpose of the 'NOW( )' function?

  • Copy formatting from one cell to another
  • Display the current time (correct)
  • Find the highest value in a range of cells
  • Merge and center selected cells

What does the 'Paste Special' tool in Excel allow you to do?

  • Apply conditional formatting to selected cells
  • Copy values or formulas to adjacent cells (correct)
  • Sort and filter data in a spreadsheet
  • Insert trendlines in charts

How can you hide a row in MS Excel?

<p>Right-click on the row and select 'Hide' (A)</p> Signup and view all the answers

Which feature in MS Excel allows you to combine multiple cells into one and center the content?

<p>'Merge and Center' (A)</p> Signup and view all the answers

What is the purpose of the 'POWER( )' function in Excel?

<p>Calculates the power of a number (B)</p> Signup and view all the answers

Which Excel function is used to extract the year from a given date?

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

What is the name of the function in Excel that displays the current time?

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

Which Excel feature allows you to copy formatting from one cell to another?

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

In MS Excel, how do you hide a row?

<p>Right-click on the row and select 'Hide.' (B)</p> Signup and view all the answers

What is the primary function of the 'Fill Handle' in MS Excel?

<p>Copy values or formulas to adjacent cells. (A)</p> Signup and view all the answers

Which Excel function returns the square root of a given number?

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

What do you accomplish with the 'Merge and Center' feature in MS Excel?

<p>Combine multiple cells into one and center the content. (D)</p> Signup and view all the answers

What does the 'Paste Special' tool in Excel allow you to do?

<p>Copy values or formulas with specific operations. (C)</p> Signup and view all the answers

How can you find the highest value in a range of cells in Excel?

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

What do you call a group of selected cells in Excel?

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

Flashcards are hidden until you start studying

Study Notes

Excel Functions

  • The SQRT function returns the square root of the given number.
  • The NOW function is used to display the current time.
  • The YEAR function is used to extract the year from a given date, e.g., =YEAR(“25-01-2024”).

Excel Terms

  • A group of selected cells is called a cell range.
  • The "Merge and Center" feature in MS Excel allows you to combine multiple cells into one and center the content.

Excel Tools

  • The Format Painter tool allows you to copy formatting from one cell and apply it to another cell.
  • The "Fill Handle" in MS Excel allows you to copy values or formulas to adjacent cells.

Excel Operations

  • To hide a row in MS Excel, right-click on the row and select "Hide".
  • The MAX function is used to find the highest value in a range of cells.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser