Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2
    The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2
    The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2
    Ebook119 pages4 hours

    The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2

    By M.L. Humphrey

    ()

    Read preview

    About this ebook

    Think you know the basics of pivot tables? What about charts? Or conditional formatting?

     

    If you're looking for a way to test your knowledge on these intermediate-level Excel topics as well as others, then this is the book for you.

     

    The quizzes in this book are based on the material covered in Intermediate Excel. There are also five bonus exercises that test your ability to implement what you've learned with real-world scenarios.

    LanguageEnglish
    PublisherM.L. Humphrey
    Release dateNov 18, 2018
    ISBN9781386285496
    The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2
    Author

    M.L. Humphrey

    Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.

    Read more from M.L. Humphrey

    Related to The Intermediate Excel Quiz Book

    Titles in the series (4)

    View More
    View More

    Related ebooks

    Enterprise Applications For You

    View More
    View More

    Related podcast episodes

    Related categories

    Reviews for The Intermediate Excel Quiz Book

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      The Intermediate Excel Quiz Book - M.L. Humphrey

      Introduction

      This is a companion book written to complement Intermediate Excel by M.L. Humphrey and is geared towards those who are already familiar with the content covered in that book who now want to test their knowledge through quizzes or to those who learn better from a question and answer format.

      For each chapter in Intermediate Excel there is a set of questions meant to test your knowledge of the information that was covered in the chapter.

      The first section of the book just has the questions, the next section of the book has the questions as well as the answers. There is also a bonus section that contains five exercises where you can test your knowledge of the various functions by applying them to specific real-life scenarios.

      I encourage you to try to do each exercise first without looking at the solutions, since in the real world you’ll be faced with a problem that needs solved and no one will be there to tell you how to solve it. However, I would also encourage you to have Excel open as you work each exercise so you can use the help functions within Excel to find what you need. Don't feel like you need to memorize every task in Excel in order to use it effectively. You just need to know what's possible and then what keywords or phrasing to use to help you find the information that will let you perform the right task.

      Alright, then. Let’s start with the first quiz.

      Part I

      Quizzes

      Conditional Formatting Quiz

      1. What does conditional formatting allow you to do?

      2. Where can you find the Conditional Formatting option?

      3. What conditional formatting options are available in Excel 2007?

      4. If you want to mark all cells that have a value greater than $3,500, what conditional formatting option should you use?

      5. If you want to mark all cells that have a value less than $1,500, what conditional formatting option should you use?

      6. If you want to mark all cells that contain a certain text phrase, what conditional formatting option should you use?

      7. If you want to flag when a value occurs more than once, what conditional formatting option can you use?

      8. What is the issue with using the Duplicate Values conditional formatting option?

      9. How can you customize the format that’s applied to a range of cells when using conditional formatting for the greater than and less than rules?

      10. If you want to flag the top 10 values in your range of data, which conditional formatting option can you use to do that?

      11. Is it possible to flag just the top 5 values? If so, how?

      12. What if you want to flag the top 10% of your results using conditional formatting, how can you do that?

      13. Can you flag any % of your results?

      14. How would you flag results that are above the average value for the range using conditional formatting?

      15. How would you flag results that are below the average value for the range using conditional formatting?

      16. What do Data Bars do?

      17. What do Color Scales do?

      18. What do Icon Sets do?

      19. Can you customize the limits Excel uses when applying data bars, color scales, and icon sets? How?

      20. How can you remove conditional formatting from a range of cells?

      21. What if you only want to remove one conditional formatting rule from a range of cells, how can you do that?

      22. How do you change the order in which conditional formatting rules are applied to a cell or range of cells?

      23. What other option do you have for adding a new conditional formatting rule to your data other than using one of the pre-defined options (Highlight Cells Rules, Top/Bottom Rules, etc.)?

      Inserting Symbols Quiz

      1. How do you insert a symbol into a cell in Excel?

      2. Can you insert a symbol into a cell that already has text in it?

      3. Which font has a lot of images like scissors, mailboxes, smiley faces, etc?

      4. If you need the copyright symbol or trademark symbol, where can you find those?

      5. Can you change the size or color of a symbol you’ve inserted? If so, how?

      6. Once you’ve inserted a symbol into a cell can you change the font without impacting the symbol?

      Pivot Tables Quiz

      1. What does a pivot table allow you to do?

      2. How do you need to format your data in order to use a pivot table?

      3. What are some best practices when formatting your data for analysis?

      4. How do you start a pivot table?

      5. Should you add your pivot table to your existing sheet or to a new one? Why?

      6. What are the two ways you can add a field to your blank pivot table?

      7. If you drag a field to the Filters section, what can you do with that field?

      8. If you drag a field to the Rows section, how will that field appear in the table?

      9. If you drag a field to the Columns section, how will that field appear in the table?

      10. If you drag a field to the Values section, how will that field appear in the table?

      11. How can you change the function that is performed on a field that you’ve placed in the Values section?

      12. What functions can you apply to a field in the Values section?

      13. If you want to format the values in your table, what are two ways to do so?

      14. Can you perform two or more calculations on the same field in a pivot table? If so, how?

      15. Can you have multiple fields for your rows or columns?

      16. What would be the drawback in doing so?

      17. Can you filter which results show for your rows or columns

      Enjoying the preview?
      Page 1 of 1