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?

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

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

'Merge and Center' (A) Signup and view all the answers

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

Calculates the power of a number (B) Signup and view all the answers

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

YEAR( ) (D) Signup and view all the answers

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

NOW( ) (C) Signup and view all the answers

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

Format Painter (B) Signup and view all the answers

In MS Excel, how do you hide a row?

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

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

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

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

SQRT( ) (B) Signup and view all the answers

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

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

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

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

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

MAX( ) (A) Signup and view all the answers

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

Cell Range (C) Signup and view all the answers

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.

Description

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.