Microsoft Excel Functions and Formulas Quiz

AdorableMaclaurin avatar
AdorableMaclaurin
·
·
Download

Start Quiz

Study Flashcards

16 Questions

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

Rounds a number down to the nearest integer

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

Display the current time

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

Copy values or formulas to adjacent cells

How can you hide a row in MS Excel?

Right-click on the row and select 'Hide'

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

'Merge and Center'

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

Calculates the power of a number

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

YEAR( )

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

NOW( )

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

Format Painter

In MS Excel, how do you hide a row?

Right-click on the row and select 'Hide.'

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

Copy values or formulas to adjacent cells.

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

SQRT( )

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

Combine multiple cells into one and center the content.

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

Copy values or formulas with specific operations.

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

MAX( )

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

Cell Range

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.

Test your knowledge of Microsoft Excel functions and formulas with this quiz. From calculating square roots to extracting years from dates, this quiz covers a range of Excel functionalities.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free
Use Quizgecko on...
Browser
Browser