Register New Player - Log In
Welcome to our world of fun trivia quizzes and quiz games:     New Player quiz register Play Now! trivia game

A Little Left of Center

Created by ASA

Fun Trivia : Quizzes : Microsoft Excel
A Little Left of Center game quiz
"This quiz is going to explore the right, left and other functions of Excel"

15 Points Per Correct Answer - No time limit  



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)" ?


    this is a
    ons
    this
    thi


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

What will this formula yield?

=Right(c1,4)
    two.
    text
    This
    two


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)
    ll us
    Quest
    three
    text.


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)
    ques
    s fo
    info
    rmat


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)?
    =mid(g1,round(len(G1)/2,0),5)
    =right(left(G1,40),5)
    =mid(G1,find("I",G1),5)
    all answers are correct


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?
    =MID(H1,ROUND(LEN(H1)/2,0)-5,5)
    all answers are correct
    =RIGHT(LEFT(H1,ROUND(LEN(H1)/2,0)-1),5)
    =LEFT(RIGHT(H1,ROUND(LEN(H1)/2,0)+6),5)


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?
    TEXT
    S TH
    text
    tHIS


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

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


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?
    Lastname, Firstname
    Firstname, L
    lastname, f
    Lastname,F


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


Copyright, FunTrivia.com. All Rights Reserved.
Legal / Conditions of Use
Compiled Feb 03 13