Microsoft Excel Lessons

Microsoft Excel Lessons

Lesson 1

Lesson 2

Lesson 3

Microsoft Excel sample questions

1. What is the basic structure of a spreadsheet?

• a workbook containing multiple worksheets

• data organized as a budget or report

• cells arranged in columns and rows

2. Which information about a cell do you need to determine its cell address in a spreadsheet?

• the workbook and spreadsheet name

• the data entered into the cell

• the column letter and row number

3. Where can you enter information into a spreadsheet?

• in individual cells but not the formula bar

• in the formula bar but not in individual cells

• in both the formula bar and individual cells

4. Why should you use the cell address to create formulas in Excel?

• because at least one cell address must be included in a formula for it to work

• because cell addresses are a more accurate way to do math

• because you can update the data in a cell without having to adjust the formula

5. What is a ribbon?

• a collection of tools and features

• a landing page used to access files

• a type of spreadsheet used in Excel

6. Which icon in Microsoft Excel allows you to correct your last action if you’ve made a mistake?

• the Redo arrow

• the Undo arrow

• the disk symbol

7. Which of the following is an indication that a note has been added to your spreadsheet?

• a cell with red or blue highlighting

• a green outline around the contents of a cell

• a red triangle in the upper-right corner of a cell

8. How can you navigate to individual cells on a spreadsheet?

• by using the search bar located at the top of the Excel spreadsheet

• by typing the cell address anywhere on the Home or Insert ribbon

• by clicking on them or using the directional keys on your keyboard

9. Which two pieces of information determine the cell address?

• column number and row letter

• cell reference and cell letter

• column letter and row number

10. How can you open an existing Excel file located on your computer?

• by selecting Open and using the Browse option in Excel

• by using an Internet-based browsing tool

• by opening a new workbook template using Excel

11. Which of these symbols would you use if you wanted to create a formula for division to calculate a percentage in Microsoft Excel?

• an asterisk (*)

• a carrot symbol (^)

• a forward slash (/)

12. Which of these Excel functions could be used to add a column of numbers correctly?

• =SUM(B3:B18)

• =C10/C29

• =D2+D11