FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!
Quiz about A Little Left of Center
Quiz about A Little Left of Center

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.
  1. Home
  2. »
  3. Quizzes
  4. »
  5. Science Trivia
  6. »
  7. Software and Programming
  8. »
  9. Microsoft Excel

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
- -
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


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


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


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


Question 5 of 10
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


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


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


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


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


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



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

arrow Select a User ID:
arrow Choose a Password:
arrow 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.
11/21/2024, Copyright 2024 FunTrivia, Inc. - Report an Error / Contact Us