Assignments 02:
Basic Formatting and Cell Styles
Assignment 1:
Formatting a Student Score Sheet
Objective: Apply cell formatting to enhance readability.
Instructions:
- Create a new workbook and name it Student_Scores.xlsx.
- In Sheet1, enter the following data:
- A1: Student Name, B1: Subject, C1: Score
- A2 to A6: Enter five student names.
- B2 to B6: Enter subjects (e.g., Math,
Science, English).
- C2 to C6: Enter corresponding scores.
- Apply the following formatting:
- Bold the headers (A1 to C1).
- Change the font color of the headers to
blue.
- Apply a border around the entire table.
- Change the font size of the data rows to
12.
- Save the workbook.
Assignment 2:
Aligning Text and Applying Cell Styles
Objective: Practice text alignment and using cell
styles.
Instructions:
- Open a new workbook and name it Employee_List.xlsx.
- In Sheet1, create the following columns:
- A1: Employee Name, B1: Department, C1:
Salary
- A2 to A6: Enter names of five employees.
- B2 to B6: Enter their respective
departments.
- C2 to C6: Enter their corresponding
salaries.
- Apply the following formatting:
- Center-align the headers and bold them.
- Right-align the salary column (C).
- Use a fill color for the headers (A1 to
C1) to distinguish them.
- Apply a pre-defined cell style to all the
data rows (A2 to C6).
- Save the workbook.
Assignment 3:
Number Formatting and Custom Styles
Objective: Practice applying number formatting and using
custom styles.
Instructions:
- Create a workbook named Sales_Report.xlsx.
- In Sheet1, enter the following data:
- A1: Product, B1: Quantity Sold, C1: Unit
Price, D1: Sale Date
- A2 to A6: Enter five product names.
- B2 to B6: Enter the quantities sold.
- C2 to C6: Enter the unit prices for each
product.
- D2 to D6: Enter sale dates in different
formats (e.g., 09/20/2024, September 20, 2024).
- Apply the following formatting:
- Apply currency formatting to the Unit
Price column.
- Format the Sale Date column to
display dates in Long Date format.
- Bold and apply a background color to the
headers.
- Use a custom style for the data rows.
- Save the workbook.
Assignment 4:
Formatting Financial Data
Objective: Format financial data with currency and
percentage formatting.
Instructions:
- Open a new workbook and name it Financial_Summary.xlsx.
- In Sheet1, create the following columns:
- A1: Category, B1: Amount, C1: Percentage
Change
- A2 to A6: Enter different financial
categories (e.g., Sales, Profit, Expenses).
- B2 to B6: Enter the amounts for each
category.
- C2 to C6: Enter the percentage change in
financial values.
- Apply the following formatting:
- Use currency formatting for the Amount
column.
- Apply percentage formatting for the Percentage
Change column.
- Bold the headers and apply a fill color
to make them stand out.
- Use borders around the entire dataset.
- Save the workbook.
Assignment 5:
Combining Styles, Alignment, and Formatting
Objective: Use multiple formatting features to present a
well-structured dataset.
Instructions:
- Open a new workbook and name it Inventory_List.xlsx.
- In Sheet1, enter the following data:
- A1: Item, B1: Quantity, C1: Price, D1:
Restock Date
- A2 to A6: Enter five different inventory
items.
- B2 to B6: Enter the quantities in stock.
- C2 to C6: Enter the prices of each item.
- D2 to D6: Enter restock dates in various
formats.
- Apply the following formatting:
- Format the Price column with
currency formatting.
- Change the Restock Date column to
display dates in Short Date format.
- Apply bold and center alignment to all
headers.
- Use borders and shading for the entire
table to improve readability.
- Save the workbook.
******************************
