Assignment- Self-Paced Option
For this assignment, you will create a new workbook and add data about travel expenses.
NOTE: To complete this class, you must have a copy of Excel 2013. If you're not sure which version you have, please check to make sure that the icon in the top-left corner of the Excel interface matches this one:
Instructions
Open Excel 2013 and select Blank workbook. A blank workbook will appear.
Type the following cell content in the specified cells:
A1: Travel Expenses
A2: Estimated Expenses
Select row 1 and insert a new row above it.
Select cell A2, and then move the text to cell A1.
HINT: When you're done, cell A1 should say "Travel Expenses" and cell A2 should be empty.
Resize the width of column A so that all the text is visible and fits within column A.
Type the following cell content in the specified cells:
B2: 1 July 2014
B3: 45
C3: 60
D3: 70
E3: 100
F3: 50
HINT: When you enter the date in cell B2, it may autocorrect to an abbreviated date format. This is OK and will not be counted against you.
Select cell B2. Next, drag the fill handle in the bottom right of cell B2 all the way to cell F2. When you're done, you should see a different date in each cell for cell range B2:F2.
Select all of the cells in the entire worksheet and then increase the row height to a height greater than 15. When you're done, the row height should be the same for every cell in the worksheet.
Select cell range A1:F1 and then use the Merge & Center command. When you're done, the selected cells will be merged together into one cell.
Select cell A1 and apply the Accent6 cell style.
Select cell range B2:F2 and apply the following formatting changes:
Make the cells bold.
Change the horizontal text alignment to Center Align.
Change the vertical text alignment to Middle Align.
Add a bottom border to the cells.
Select cell range B3:F3 and apply Currency number formatting. When you're done, the values should look like this: "$45.00".
Select cell range A1:F3. Next, change the font to Gadugi and the font size to 12. If this causes any text to get cut off or disappear,adjust the column width as necessary.
Select column F. Next, insert a new column. When you're done, a blank column should appear between column E and column G.
Type the following cell content into the specified cells:
F2: Fireworks
F3: 55
Select column A and then hide it.
Right-click Sheet1 at the bottom of the workbook and rename it to July 2014.
Insert a new worksheet and then rename it to December 2014.
Select the July 2014 worksheet.
Before submitting, double-check your assignment to make sure that data has been entered correctly.
Row 1 should be merged as one cell.
The data in B2 should read 1 July 2014. (It may also read 7/1/2014, 1/7/2014, or another date format. These are all OK.)
The data in B3 should read $45.00.