Test How Much Do You Know About Excel Sheets! Trivia

20 Questions | Total Attempts: 169

SettingsSettingsSettings
Please wait...
Excel Quizzes & Trivia

How well do you know excel?


Questions and Answers
  • 1. 
    You need to sort a column of names alphabetically. What do you do?
    • A. 

      Select the column you need to sort. Click the Data tab and click the Sort button

    • B. 

      Select the column you need to sort. Click the Insert tab and click the Group button

    • C. 

      Manually arrange the data properly

  • 2. 
    How you can lock columns to remain visibly when I scroll down my worksheet?
    • A. 

      I click the page layout option and the click breaks, insert break in top row

    • B. 

      I click the view tab and in the window group I click "Freeze Pane" and then click freeze top row

    • C. 

      Insert a pivot table with including the top row

  • 3. 
    Tables can organize data for easier reading and analysis. How do you create a table?
    • A. 

      After highlighting the data you need, select the insert tab and click on the Table button.

    • B. 

      From the window tab, click the insert button and select table

    • C. 

      Select your data and click the Page Layout tab. Click on the Table button

  • 4. 
    How can you highlight important numbers stand out from your excel table?
    • A. 

      Right Click on the mouse and change the font of the cell

    • B. 

      I click the Home Tab and then change the colors in the Font Options

    • C. 

      I select the group of cells that I want to work with, then on the Home Tab,I click conditional fomating on the menu

  • 5. 
    To adjust the column width or a row’s height, you need to:
    • A. 

      Click the format button under the cells tab.

    • B. 

      Click the conditional formatting button under the styles tab

    • C. 

      Click the Margings button under the Page Settup tab

  • 6. 
    You have a large spreadsheet that is full of names. What do you need to do to search for a single person’s name?
    • A. 

      Under the Data tab, click the Filter button and select the search option.

    • B. 

      Under the View tab, click the Zoom button and select the Find option

    • C. 

      Under the Home tab, click the find & select button and select the find option

  • 7. 
    Is Ctrl +  C the shortcut for copy selected text.
    • A. 

      True

    • B. 

      False

  • 8. 
    Is Ctrl + Z the shortcut for format the Cells dialogue box?
    • A. 

      True

    • B. 

      False

  • 9. 
    What is the common excel math fuction for finding the average value of the selected range
    • A. 

      =Median(A2:B3)

    • B. 

      =Average(A2:C14)

    • C. 

      =Max(B2:B88)

  • 10. 
    What is the common excel math function to find the largest value in the selected range. 
    • A. 

      =Sum(B4,B5)

    • B. 

      =Max(B2:B88)

    • C. 

      =Min(B2:B88)

  • 11. 
    To count the numer of cells that contain numbers, which formula you use?
    • A. 

      =If(A2>2,"Yes")

    • B. 

      =sumcells(A1:A5)

    • C. 

      =count(A1:A5)

  • 12. 
    Vlookup will look for a piece of information in a large table of data and pull in any field from that table into your new table?
    • A. 

      True

    • B. 

      False

  • 13. 
    Is Quick Analysis a way to easily display and summarize my data for meaningful conclusion?
    • A. 

      True

    • B. 

      False

  • 14. 
    The Pivot Table helps me to cross data and analyze it depending of what I am looking?
    • A. 

      True

    • B. 

      False

  • 15. 
    The $ symbol in the formula will block the column A =$A4
    • A. 

      True

    • B. 

      False

  • 16. 
    Is the next formula well type, =SumA5:A8
    • A. 

      True

    • B. 

      False

  • 17. 
    The formula "IF SUM" is use when I want to return one value if a condition is true and another value if it's false
    • A. 

      True

    • B. 

      False

  • 18. 
    The If error returns a value you specify if a formula evaluates to an error, otherwise, returns the result of the formula. =Iferror(value, value_if_error)
    • A. 

      True

    • B. 

      False

  • 19. 
    In a Vlookup formula. the __________- is the value to be found in the first column of the table, and can be a value, a reference, or text string
    • A. 

      Table Array

    • B. 

      Lookup Value

    • C. 

      Col Index Num

  • 20. 
    Is the next formula correct, =Vlookup(A5,$A$5:A10,0)
    • A. 

      True

    • B. 

      False

Back to Top Back to top