Excel Workbook and Worksheet Quiz

What is a workbook in Microsoft Excel?

• A) A type of paper notebook

• B) An individual Excel file

• C) A part of Microsoft Word

• D) A cell format option

What is a worksheet in Excel?

• A) A separate Excel file

• B) A single page in a workbook

• C) A way to format text

• D) A tool for printing data

Why would you divide information into different worksheets?

• A) To make your data colorful

• B) To keep your information neat and organized

• C) To make your workbook bigger

• D) To use more paper when printing

What should you do before entering a large amount of data into Excel?

• A) Save the file

• B) Make sure your information is organized

• C) Print the worksheet

• D) Close the workbook

Why would you protect a worksheet in Excel?

• A) To stop someone from deleting the entire file

• B) To make the data look better

• C) To prevent changes to certain cells

• D) To stop the worksheet from printing

What is one thing you can do when printing an Excel worksheet?

• Change cell borders

• Adjust how the spreadsheet looks on the page

• Insert a new formula

• Format your data as currency

What does 'formatting cells' mean in Excel?

• Printing a worksheet

• Changing how the cell looks (borders, colors, etc.)

• Writing a report

• Creating a new workbook

What can advanced functions in Excel do?

• Format your text

• Print your worksheets

• Perform logical tests and analyze data

• Open new workbooks

What does the 'MIN' function do in Excel?

• Finds the smallest number in a list

• Finds the largest number in a list

• Adds all the numbers together

• Formats the text in a cell

What does the "SUM" function do in Excel?

• Finds the largest number in a list

• Adds numbers together

• Formats the cell

• Fills cells automatically