The Excel for Beginners Quiz Book: Excel Essentials Quiz Books, #1

By M.L. Humphrey

Familiar with the basics of Excel but looking to test your knowledge? Or just learned Excel and wanting to make sure you grasp the concepts? Then this is the book for you.

 

It contains questions and answers on the basics of Excel, including how to navigate Excel, input your data, format it, manipulate it, and print your results.

 

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

• Language: English
• Publisher: M.L. Humphrey
• Release date: Nov 18, 2018
• ISBN: 9781386227038

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.

Book preview

Part I

Quizzes

Terminology Quiz

1. In an Excel worksheet what are generally identified by letters that run across the top of the worksheet?

a. Columns

b. Rows

c. Cells

d. Other

---

2. In an Excel worksheet what are generally identified by numbers that run along the left-hand side of the worksheet?

a. Columns

b. Rows

c. Cells

d. Other

---

3. What is a cell?

---

4. How do you know what cell or cell(s) you have selected?

---

5. In general, what does left-clicking do?

---

6. In general, what does right-clicking do?

---

7. What is the difference between a worksheet and a workbook in Excel?

---

8. What is the formula bar?

---

9. What is a scroll bar?

---

10. How can you use a scroll bar?

a. Click on the bar and drag.

b. Click on the space to either side of the bar.

c. Click on the arrows at the top and bottom or on each end of the scroll bar space.

d. All of the above.

---

11. With a scroll bar if you want to move outside of the area where you’ve already entered information, which method should you use?

---

12. Name two ways that you can select cells in a worksheet.

---

13. What is a dropdown menu?

---

14. What is a dialogue box?

---

15. How can you access a dialogue box?

Absolute Basics Quiz

1. What is the Ctrl shortcut you can use to save a file?

---

2. Which of the following methods works to open an existing Excel file:

a. Double-click on the file name where it’s stored on your computer

b. Open Excel and choose the file name from the list under Recent on the left-hand side or navigate to the file location by clicking on Open Other Workbooks at the bottom of the page.

c. If you’re already in Excel, go to File and then choose Open from the left-hand side menu and then choose a file name from under Recent Workbooks or navigate to the file you want using the Computer option.

d. All of the above.

---

3. What is the difference between Save and Save As?

---

4. Discuss why you might save a file as an .xls file type instead of an .xlsx file type.

---

5. Name three ways to save a file.

---

6. How can you delete an existing Excel file?

---

7. How can you rename an existing Excel file?

---

8. What issue should you be aware of if you move or rename an Excel file that you recently used?

Navigating Excel Quiz

1. When you open a new Excel file, what cell and worksheet does it open to?

---

2. When you open an existing Excel file, what cell and worksheet does it open to?

---

3. Name two ways you could use to get to Cell B6 if you were in Cell A1?

---

4. What does the Shift key do? What does Shift + Tab do?

---

5. In a worksheet that has a lot of data in it, what is a quick way to scroll down a large number of rows or to scroll over a large number of columns?

---

6. What is one very important thing you need to remember when using scrollbars to navigate an Excel worksheet?

---

7. Name two ways to move to a different worksheet than the one you’re currently in.

---

8. What does using the F2 key do?

---

9. Name two ways to insert a cell into a worksheet.

---

10. What do the different insert cell options (shift cells right, shift cells down, entire row, and entire column) do?

---

11. Name three ways you can insert a row or column into a worksheet.

---

12. How do you select an entire row or column?

---

13. How do you insert a new worksheet into an Excel workbook?

---

14. How do you delete a cell in a worksheet?

---

15. What is the problem you might run into when you either insert a cell or cells or delete a cell or cells from a worksheet that has existing data?

---

16. How do you delete a column or row?

---

17. How do you delete a worksheet?

---

18. How do you rename a worksheet?

Inputting Your