FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!

A Little Left of Center Trivia Quiz

This quiz is going to explore the right, left and other functions of Excel

A multiple-choice quiz by ASA. Estimated time: 5 mins.

Author
ASA

Time
5 mins

Type
Multiple Choice

Quiz #
355,965

Updated
Nov 10 22

# Qns
10

Difficulty
Tough

Avg Score
5 / 10

Plays
266

One at a Time - Single Page - Timed Game

Question 1 of 10

1. Cell a1 has this text message "this is a test sentence for this questions"

What will show in cell b1 containing the formula "=left(a1,3)" ?

Hint

ons

this is a

thi

this

NEXT>

Question 2 of 10

2. Cell C1 contains the text "This is the text for question two."

What will this formula yield?

=Right(c1,4) Hint

This

two

text

two.

NEXT>

Question 3 of 10

3. Cell E1 contains the following text, "Question three will use this text."

What will the following formula result in?

=right(left(e1,14),5) Hint

Quest

ll us

text.

three

NEXT>

Question 4 of 10

4. Cell F1 has this message, "this information is for question four only"

What result will the below formula give?

=Left(mid(f1,10,12),4) Hint

rmat

info

ques

s fo

5. Cell G1 has the following message "texts can be of varying length and I want to get the middle five letters"

Which of the following formulas would return the desired result: the middle five letters of G1 (for any value of G1)? Hint

=mid(G1,find("I",G1),5)

=mid(g1,round(len(G1)/2,0),5)

=right(left(G1,40),5)

all answers are correct

NEXT>

Question 6 of 10

6. Cell H1 says:

"The title of this quiz is a little left of center, so which formula would get the five characters that are before the centre of this sentence."

Which formula could be applied to cell H1 to give the result described? Hint

=LEFT(RIGHT(H1,ROUND(LEN(H1)/2,0)+6),5)

=MID(H1,ROUND(LEN(H1)/2,0)-5,5)

all answers are correct

=RIGHT(LEFT(H1,ROUND(LEN(H1)/2,0)-1),5)

NEXT>

Question 7 of 10

7. The text in cell a3 is "This is the text for question seven"

What will the formula =upper(right(left(A3,10),4)) give? Hint

S TH

text

TEXT

tHIS

NEXT>

Question 8 of 10

8. Cell a10 contains the text message "firstname, lastname"

What result will the formula =proper(right(a10,find(", ",a10))) give? Hint

Firstname

, Lastname

Lastname

namelast

NEXT>

Question 9 of 10

9. Cell a10 still contains the text message "firstname, lastname"

What will the formula =proper(right(a10,len(a10)-1-find(",",a10))&","&left(a10)) give? Hint

Lastname,F

lastname, f

Lastname, Firstname

Firstname, L

NEXT>

Question 10 of 10

10. Cell a15 says "The title of this quiz is a little left of center, but I spell center as centre."

What will the following formula display?

=proper(substitute(A15,"center","centre",1))
Hint

Thetitleofthisquizisalittleleftofcentre,butIspellcentreascentre

The Title Of This Quiz Is A Little Left Of Centre, But I Spell Center As Centre

The Title Of This Quiz Is A Little Left Of Centre,

THETITLEOFTHISQUIZISALITTLELEFTOFCENTRE,BUTISPELLCENTREASCENTRE

(Optional) Create a Free FunTrivia ID to save the points you are about to earn:

Select a User ID:

Choose a Password:

Your Email:

Quiz Answer Key and Fun Facts

1. Cell a1 has this text message "this is a test sentence for this questions" What will show in cell b1 containing the formula "=left(a1,3)" ?

Answer: thi

The left command takes the left part of the desired cell for the number of positions indicated. If the formula = Upper(left(a1,3)) had been used then THI would have been correct.

2. Cell C1 contains the text "This is the text for question two." What will this formula yield? =Right(c1,4)

Answer: two.

The right command gets the extreme right of the desired cell for the indicated number of characters which in this case includes the full stop.

3. Cell E1 contains the following text, "Question three will use this text." What will the following formula result in? =right(left(e1,14),5)

Answer: three

The formula first asks to get the fourteen leftmost characters and then get the 5 rightmost of those.

4. Cell F1 has this message, "this information is for question four only" What result will the below formula give? =Left(mid(f1,10,12),4)

Answer: rmat

The mid command advises to go in so many spaces and then give the desired amount. In this particular case the same result could also have been obtained by the simpler formula of =mid(f1,10,4)

5. Cell G1 has the following message "texts can be of varying length and I want to get the middle five letters" Which of the following formulas would return the desired result: the middle five letters of G1 (for any value of G1)?

Answer: =mid(g1,round(len(G1)/2,0),5)

The number of characters in the cell can be calculated by using the LEN command, and dividing it in two will give the middle character, but if it is an odd amount,it is likely to only take the integer part of the answer, so a round, or roundup command is used. Specifying the letter that is in the mid position may not work as the letter may occur elsewhere in the sentence and the right/left formula uses a constant which only returns correct results for string lengths of 71 and 72.

6. Cell H1 says: "The title of this quiz is a little left of center, so which formula would get the five characters that are before the centre of this sentence." Which formula could be applied to cell H1 to give the result described?

Answer: all answers are correct

There are often many ways of expressing the same thing.

7. The text in cell a3 is "This is the text for question seven" What will the formula =upper(right(left(A3,10),4)) give?

Answer: S TH

The upper command puts everything into capital letters, and spaces are counted as characters.

8. Cell a10 contains the text message "firstname, lastname" What result will the formula =proper(right(a10,find(", ",a10))) give?

Answer: , Lastname

This is actually not the desired result if one wishes to return the last name only as the formula is only finding where the comma is and would only work as intended if the same number of letters were in the first name and the last name. The function "proper" puts the string in proper name case, meaning only the first letter of each word gets capitalized.

9. Cell a10 still contains the text message "firstname, lastname" What will the formula =proper(right(a10,len(a10)-1-find(",",a10))&","&left(a10)) give?

Answer: Lastname,F

The "&" is the shortform for the concatenate function and is a lot easier to spell. It joins together strings of text to make one new string.

10. Cell a15 says "The title of this quiz is a little left of center, but I spell center as centre." What will the following formula display? =proper(substitute(A15,"center","centre",1))

Answer: The Title Of This Quiz Is A Little Left Of Centre, But I Spell Center As Centre

The substitute command lets you specify which word should be replaced and the number of times you wish to replace it.

Source: Author ASA

This quiz was reviewed by FunTrivia editor WesleyCrusher before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.