Search Header Logo

(Do Now) Excel Functions Quiz

Authored by Wakisha Turrentine

Computers

12th Grade

Used 11+ times

(Do Now) Excel Functions Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the RIGHT function in Excel do?

Returns the middle characters from a text string

Returns the characters from a text string in reverse order

Returns the rightmost characters from a text string

Returns the leftmost characters from a text string

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the LEFT function in Excel do?

Returns a specified number of characters from the beginning of a text string.

Returns a specified number of characters from a random position in a text string.

Returns the middle characters from a text string.

Returns a specified number of characters from the end of a text string.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the MID function in Excel do?

The MID function converts a text string to lowercase.

The MID function calculates the average of a range of cells.

The MID function counts the number of characters in a text string.

The MID function extracts a substring from a text string.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the CONVERT function in Excel do?

The CONVERT function is used to convert measurements in Excel.

The CONVERT function is used to convert dates in Excel.

The CONVERT function is used to convert formulas in Excel.

The CONVERT function is used to convert text to numbers in Excel.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the RAND function in Excel do?

Generates random whole numbers between 0 and 1.

Generates a random date and time.

Generates a random text string.

Generates random decimal number between 0 and 1.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function is used to extract a specified number of characters from the right side of a text string?

LEFT

MID

SUBSTRING

RIGHT

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function is used to extract a specified number of characters from the left side of a text string?

RIGHT

LEFT

MID

SUBSTRING

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?