LEFT_RIGHT_MID Excel Functions Quiz

Quiz
•
Computers
•
9th Grade
•
Medium
Joseph Andrada Advincula
Used 4+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the LEFT function do in Excel?
Extracts a specified number of characters from the right of a text string.
Extracts a specified number of characters from the middle of a text string.
Extracts a specified number of characters from the left of a text string.
Reverses the text string.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following formulas will return "Hel" from the text "Hello World"?
=LEFT("Hello World",3)
=RIGHT("Hello World",3)
=MID("Hello World",1,3)
=MID("Hello World",2,3)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the RIGHT function return when applied to the text "Excel" with the number 2?
"El"
"Ex"
"ce"
"el"
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the formula =MID("12345", 2, 3) return?
"12"
"234"
"345"
"23"
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best describes the MID function in Excel?
Extracts characters from the right of a string.
Extracts characters from the left of a string.
Extracts characters from the middle of a string, starting at a specified position.
Extracts the first character of a string.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the formula =LEFT("OpenAI", 4) return?
"Open"
"AI"
"pen"
"Ope"
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would you use to extract the last three characters of the text "Data Analysis"?
=LEFT("Data Analysis",3)
=MID("Data Analysis",3,3)
=RIGHT("Data Analysis",3)
=RIGHT("Data Analysis",4)
Create a free account and access millions of resources
Similar Resources on Wayground
14 questions
Quarter 1 PLTW CSE Exam Review

Quiz
•
10th Grade
10 questions
Unit 1 Jan 2017 Question 4 preparation

Quiz
•
11th Grade
13 questions
1.4 Variables, strings and integers

Quiz
•
9th Grade
10 questions
Programming - Data Types

Quiz
•
1st - 10th Grade
15 questions
Progamming - Java Syntax

Quiz
•
11th - 12th Grade
9 questions
Hashing and Hash Tables

Quiz
•
University
10 questions
Introducing Python Strings

Quiz
•
11th Grade
10 questions
Microbit Quiz

Quiz
•
9th Grade
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade