Microsoft Excel Module 1 Review

When creating a new workbook in Excel, which of the following methods can be used?

• Clicking "New" on the File tab

• Pressing Ctrl + N on your keyboard

• Selecting "Blank Workbook" from the Start screen

• All of the above

What is the purpose of the Autofill feature in Excel?

• To automatically save a workbook

• To apply formatting to cells
  

• To copy data or formulas into adjacent cells based on a pattern

• To search for specific data in a workbook

How can you navigate to a named cell or named range in Excel?

• Use the "Find" function

• Enter the name in the "Name Box" above the worksheet grid

• Use the arrow keys on your keyboard

• Type the name in the formula bar

When saving a workbook in an alternate format, which of the following is an example of a valid alternate format?

• .pdf

• .csv

• .xlsx (default format)

• Both A and B

If you need to edit the contents of a cell, which action is the most efficient?

• Double-click the cell

• Right-click the cell and choose "Edit"

• Press F2 on your keyboard

• Both A and C

What is the purpose of the "Find" feature in Excel?

• To locate specific data within the workbook

• To rename a workbook

• To highlight duplicate values

• To navigate to the last cell in the worksheet

What happens when you press "Ctrl + S" in Excel?

• It opens a new workbook

• It saves the workbook

• It closes the workbook

• It opens the Save As dialog box

Which of the following methods allows you to delete data from a cell in Excel?

• Pressing the Delete key

• Selecting the cell and pressing Backspace

• Right-clicking the cell and selecting "Clear Contents"

• All of the above

What does the term "named range" refer to in Excel?

• A specific cell that has been renamed

• A group of cells assigned a unique name for easy reference

• The title of a workbook

• A column that is automatically filled

If you need to duplicate a formula into multiple adjacent cells, which tool would you use?

• Format Painter

• AutoFill handle

• Find and Replace

• Name Box