# Microsoft Excel Functions and Formulas Quiz

·
·

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

YEAR( )

NOW( )

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.

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.

MAX( )

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.

## More Quizzes Like This

10 questions
12 questions
10 questions
Use Quizgecko on...
Browser
Information:
Success:
Error: