Rounding and Decimals:

Format Cells in Excel

The purpose of this activity is to provide you with some basic instructions on how to use Excel. In this activity, you will walk through a few simple steps that will familiarize you with this program. This is a supplemental activity; therefore, you are not required to complete it. However, if you are unfamiliar with Excel, it is recommended that you complete this activity.

Additional help on certain steps is available by clicking on the question mark button () to the right of that step.

1. Open the Excel file that you created last week. If you no longer have this file, open a blank workbook.
2. Type today's date in cell D5.
3. Change the format of the date to something different than what you entered in step 2.
4. Change the color of the date you entered.
5. Next, enter a three or more digit number into any cell you choose.
6. Format the number to the currency format.
7. Save and close the file.
• Note: You will not need this file later in the course.

View the following Excel image to see an example of what your Excel sheet should look like. If you are having trouble with any of these steps, including downloading Excel, please contact your Instructor.

Additional Resources

1. Where is the toolbar in Excel?
2. Where is the ribbon in Excel?
3. How do I print a sheet in Excel?
4. What is a cell reference?

If you feel that you need additional training on Excel, refer to these helpful resources on the Microsoft Office Support site:

• Basic tasks in Excel: Quick tips to help you open Excel and get started with basic tasks.
• Microsoft Excel Training (Windows): More detailed step-by-step lessons on Excel for Windows.
• Microsoft Excel Training (Mac): More detailed step-by-step lessons on Excel for Mac.