Excel101

First Name

Last Name

Department ID

Select a choice

A. Columns, rows, and charts
B. Columns, rows, and formulas
C. Columns, rows, and cells
D. None of the above

Select a choice

A. A set of commands organized in small related groups
B. The band at the top of the Excel window
C. All of the above
D. None of the above

3. When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

6. You can use Excel to create budgets, to work with taxes, or to record student grades

7 To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text

Select a choice

A. Numbers and text
B. Numbers and figures
C. Text and charts
D. None of the above

Select a choice

A. You have entered a number wrong
B. You have misspelled something
C. The cell is not wide enough
D. Any of the above

11. A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

Select a choice

A. Click in cell C6, and then press CTRL+SHIFT.
B. Click in cell C6, and then press CTRL
C. Click in cell C6.
D. None of the Above

13. ____________ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

Select a choice

A. Cell references
B. Conditional formatting
C. Excel tables
D. Pivot tables

Select a choice

A. The cell in column A and row 10
B. Cell A10 and cell A20
C. The range of cells in column A and rows 10 through 20
D. The range of cells in row 15 and columns B through E

15. What is the primary way that data within a CSV file is separated between different columns?

Select a choice

A. on the right side of the Home tab on the Ribbon
B. in Backstage view
C. Cell Cluster
D. in the bottom-right corner of the selected cell

21. ________ is a feature in Excel that helps users find a desired result by adjusting an input value.

Select a choice

A. Hold down the Ctrl key while clicking the cells you want to select.
B. Click and drag over the cells you want to select.
C. Hold down the Shift key while clicking the cells you want to select.
D. All of the Above

Select a choice

A. Use the Format Cells dialog box.
B. Select the cells you want to merge, then click the "Merge & Center" button on the Home tab.
C. Right-click the cells you want to merge, then select "Merge Cells" from the context menu.
D. None of the Above

Select a choice

A. to move or copy data between multiple worksheets at once
B. to perform calculations across multiple worksheets at once
C. to apply formatting changes to multiple worksheets at once
D. All of the Above

Select a choice

A. to explore how changing input values affects calculated values
B. to calculate the maximum and minimum values in a range
C. to compare different versions of a workbook
D. to create charts and graphs

Microsoft Excel for Beginners

Section header goes here...

1. _ , and _ are what you see when you open Excel

2. Microsoft Excel Ribbon is

3. When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

4. ___________ are where you start working and enter data in a worksheet.

5. In a new worksheet, you must start by typing in cell A1.

6. You can use Excel to create budgets, to work with taxes, or to record student grades

7 To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text

8. You can enter two basic kinds of data into worksheet cells:

9. You learned in the practice that ###### means:

10. What do you type into an empty cell to start a formula?

11. A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

12. To divide 853 by 16 in a formula in Excel, you would use what math operator?

13. ____________ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

14. A10:A20 Refer to values in

15. What is the primary way that data within a CSV file is separated between different columns?

16. The intersection of a row and a column is called a ________.?

17. A group of cells is called a ________.

18. Where is the fill handle located?

19. Which of the following is an absolute cell reference?

**20. What value would Excel return for this formula? = (82 -32)/5+8*2?**

21. ________ is a feature in Excel that helps users find a desired result by adjusting an input value.

22. How can you select multiple cells at once in Excel?

23. How do you merge two or more cells in Excel?

24. What number format(s) can you use in Excel?

25. What is the purpose of grouping worksheets in Excel?

26 Bonus Question. What is the goal of "What-if" analysis?

Microsoft Excel for Beginners

Section header goes here...

1. _______ , ________ and _______ are what you see when you open Excel

2. Microsoft Excel Ribbon is

3. When you start Excel, you open a file that's called a workbook. Each new workbook comes with_____________ worksheet(s), like pages in a document. You enter data into the worksheets. (Worksheets are sometimes called spreadsheets.)

4. ___________ are where you start working and enter data in a worksheet.

5. In a new worksheet, you must start by typing in cell A1.

6. You can use Excel to create budgets, to work with taxes, or to record student grades

7 To enter a date in a cell, you should use a slash or a hyphen to separate the parts: 7/16/2009 or 16-July-2009. Excel will recognize this as a text

8. You can enter two basic kinds of data into worksheet cells:

9. You learned in the practice that ###### means:

10. What do you type into an empty cell to start a formula?

11. A formula result is in cell C6. You wonder how you got the result. To see the formula, you:

12. To divide 853 by 16 in a formula in Excel, you would use what math operator?

13. ____________ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

14. A10:A20 Refer to values in

15. What is the primary way that data within a CSV file is separated between different columns?

16. The intersection of a row and a column is called a ________.?

17. A group of cells is called a ________.

18. Where is the fill handle located?

19. Which of the following is an absolute cell reference?

20. What value would Excel return for this formula? = (82 -32)/5+8*2?

21. ________ is a feature in Excel that helps users find a desired result by adjusting an input value.

22. How can you select multiple cells at once in Excel?

23. How do you merge two or more cells in Excel?

24. What number format(s) can you use in Excel?

25. What is the purpose of grouping worksheets in Excel?

26 Bonus Question. What is the goal of "What-if" analysis?

1. _ , and _ are what you see when you open Excel

**20. What value would Excel return for this formula? = (82 -32)/5+8*2?**