Microsoft Excel Functions Quiz

Microsoft Excel Functions Quiz

9th Grade

16 Qs

quiz-placeholder

Similar activities

Python List

Python List

4th Grade - University

15 Qs

QUIZ BAB 4: SISTEM OPERASI

QUIZ BAB 4: SISTEM OPERASI

8th Grade - University

20 Qs

Python

Python

8th - 9th Grade

15 Qs

Threats to Data

Threats to Data

9th - 12th Grade

11 Qs

HEALTH AND SAFETY 9

HEALTH AND SAFETY 9

7th - 9th Grade

11 Qs

Network topologies

Network topologies

8th Grade - University

20 Qs

CMU quiz

CMU quiz

7th - 9th Grade

20 Qs

Arduino Loop

Arduino Loop

2nd Grade - University

20 Qs

Microsoft Excel Functions Quiz

Microsoft Excel Functions Quiz

Assessment

Quiz

Computers

9th Grade

Practice Problem

Easy

Created by

Bahaa A

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the UPPER function in Excel do?

Counts the number of uppercase letters in a text string

Converts all letters in a text string to lowercase

Deletes all uppercase letters in a text string

Converts all letters in a text string to uppercase

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How is the UPPER function used in Excel?

Convert all letters in a text string to lowercase

Count the number of characters in a text string

Convert all letters in a text string to uppercase

Change the font size of a text string

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Explain the purpose of the LOWER function in Excel.

To convert all letters in a specified text to lowercase.

To insert a new row in the spreadsheet

To change the font size of a specified text

To calculate the sum of a range of cells

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Provide an example of using the LOWER function in Excel.

UPPER(A1)

PROPER(A1)

LOWER(A1)

TRIM(A1)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the MID function used for in Excel?

To calculate the average of a range of cells

To create a pivot table

To extract a specific number of characters from a text string

To convert a value from radians to degrees

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you extract a specific number of characters using the MID function in Excel?

=SUM("apple",2,3)

=MID("apple",2,3)

=PROPER("apple",2,3)

=LOWER("apple",2,3)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Describe the functionality of the PROPER function in Excel.

It removes all punctuation from the text

It converts all letters to uppercase

It converts all letters to lowercase

It converts the first letter of each word in a text to uppercase and the rest to lowercase.

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?