The Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2
()
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.
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
Excel Tips and Tricks Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsAccess 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsExcel 365 Essentials Rating: 0 out of 5 stars0 ratingsHow To Gather And Use Data For Business Analysis Rating: 0 out of 5 stars0 ratingsWord Essentials 2019 Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsMicrosoft Office 2019 Beginner Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsMicrosoft Office for Beginners Rating: 0 out of 5 stars0 ratingsWord Essentials Rating: 0 out of 5 stars0 ratingsWord 365 Essentials Rating: 0 out of 5 stars0 ratingsPowerPoint 365 Essentials: PowerPoint 365 Essentials Rating: 0 out of 5 stars0 ratingsMy Grandfather's Spaceship Rating: 0 out of 5 stars0 ratingsA Light in the Window Rating: 0 out of 5 stars0 ratingsToll Booth Rating: 0 out of 5 stars0 ratingsTails of the North Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials 2019 Rating: 0 out of 5 stars0 ratings
Related to The Intermediate Excel Quiz Book
Titles in the series (4)
The Excel for Beginners Quiz Book: Excel Essentials Quiz Books, #1 Rating: 0 out of 5 stars0 ratingsThe Intermediate Excel Quiz Book: Excel Essentials Quiz Books, #2 Rating: 0 out of 5 stars0 ratingsThe 50 Useful Excel Functions Quiz Book: Excel Essentials Quiz Books, #3 Rating: 0 out of 5 stars0 ratingsThe 50 More Excel Functions Quiz Book: Excel Essentials Quiz Books, #4 Rating: 0 out of 5 stars0 ratings
Related ebooks
Excel Essentials Rating: 0 out of 5 stars0 ratingsIntermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 365 Pivot Tables: Easy Excel 365 Essentials, #4 Rating: 0 out of 5 stars0 ratingsThe Excel for Beginners Quiz Book: Excel Essentials Quiz Books, #1 Rating: 0 out of 5 stars0 ratingsPivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsIntermediate Excel: Excel Essentials, #2 Rating: 5 out of 5 stars5/520 Most Powerful Conditional Formatting Techniques Rating: 0 out of 5 stars0 ratings50 More Excel Functions: Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsAdvance Excel 2016: Training guide Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel 365 Formatting: Easy Excel 365 Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel Essentials 2019 Rating: 0 out of 5 stars0 ratingsIntermediate Excel 365: Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 2016 Hands-On Lab Rating: 0 out of 5 stars0 ratingsMastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Excel for Beginners: Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsMore Excel Outside the Box: Unbelievable Excel Techniques from Excel MVP Bob Umlas Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's Guide for Mastering the Quintessence of Excel 2010-2019 in no time! Rating: 0 out of 5 stars0 ratingsExcel: A Step-by-Step Guide with Practical Examples to Master Excel's Basics, Functions, Formulas, Tables, and Charts Rating: 0 out of 5 stars0 ratingsData Analysis with Excel: Tips and tricks to kick start your excel skills Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsHidden Gems of Microsoft Excel Rating: 0 out of 5 stars0 ratingsLearn to Use Microsoft Excel 2016 eBook Rating: 0 out of 5 stars0 ratingsPivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel 365 Conditional Formatting: Easy Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 2019 Conditional Formatting: Easy Excel Essentials 2019, #3 Rating: 0 out of 5 stars0 ratingsLearn Excel in 24 Hours Rating: 4 out of 5 stars4/5
Enterprise Applications For You
Some Future Day: How AI Is Going to Change Everything Rating: 0 out of 5 stars0 ratingsQuickBooks 2024 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsLearning Microsoft Endpoint Manager: Unified Endpoint Management with Intune and the Enterprise Mobility + Security Suite Rating: 0 out of 5 stars0 ratingsSharePoint For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsEnterprise AI For Dummies Rating: 3 out of 5 stars3/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Excel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsCreating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsExcel Data Analysis For Dummies Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Excel 2019 Bible Rating: 5 out of 5 stars5/5Mastering Microsoft Teams: Creating a Hub for Successful Teamwork in Office 365 Rating: 0 out of 5 stars0 ratingsNotion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/550 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5SharePoint 2016 For Dummies Rating: 5 out of 5 stars5/5Excel Workbook For Dummies Rating: 4 out of 5 stars4/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5CompTIA Project+ Study Guide: Exam PK0-005 Rating: 0 out of 5 stars0 ratings
Reviews for The Intermediate Excel Quiz Book
0 ratings0 reviews
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