Microsoft Excel Functions Quiz
Quiz
•
Computers
•
9th Grade
•
Practice Problem
•
Easy
Bahaa A
Used 2+ times
FREE Resource
Enhance your content in a minute
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
11 questions
HEALTH AND SAFETY 9
Quiz
•
7th - 9th Grade
20 questions
Network topologies
Quiz
•
8th Grade - University
15 questions
Quiz 1
Quiz
•
1st - 12th Grade
15 questions
visual basic 6.0 LDA
Quiz
•
9th Grade
20 questions
QUIZ BAB 4: SISTEM OPERASI
Quiz
•
8th Grade - University
13 questions
Guess the Retro Computer 1
Quiz
•
KG - Professional Dev...
15 questions
L3...JavaScript - Introducción
Quiz
•
9th Grade
11 questions
Threats to Data
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
