Excel Course Lesson 5 Working With Rows

 Excel Course Lesson 5 Working With Rows 

Excel Course Lesson 5 Working With Rows

 Module 5: Working with Rows, Columns, and Cells

In this module, you will learn about managing rows, columns, and cells in spreadsheet software (such as Microsoft Excel or Google Sheets). You’ll explore how to insert, delete, and resize rows and columns, merge cells, format cell ranges, freeze panes, and split worksheets. This knowledge is essential for organizing data, improving readability, and enhancing user navigation in large datasets.

1. Inserting, Deleting, and Resizing Rows and Columns

a. Inserting Rows and Columns

When working with spreadsheets, you often need to add new data. Inserting rows and columns allows you to make room for new entries without disturbing existing data.

Steps to Insert Rows/Columns:

Inserting a Row:

Select the row where you want the new row to appear. Right-click and choose “Insert Row.” A new row will appear above the selected row.

Inserting a Column:

Select the column where you want the new column. Right-click and choose “Insert Column.” A new column will appear to the left of the selected column.

Practical Exercise:

Open a spreadsheet and insert a row between rows 5 and 6, then insert a column between columns B and C. Input data into these newly created spaces to observe the change.

b. Deleting Rows and Columns

Deleting unwanted rows and columns helps maintain a clean dataset. This is especially useful when dealing with blank rows or unnecessary data.

Steps to Delete Rows/Columns:

Deleting a Row:

Select the row you want to delete. Right-click and choose “Delete Row.”

Deleting a Column:

Select the column you want to delete. Right-click and choose “Delete Column.”

Practical Exercise:

In the same spreadsheet from the previous exercise, delete row 3 and column D. Observe how the data shifts and ensure no important information is lost.

c. Resizing Rows and Columns

Sometimes data within cells doesn’t fit properly, requiring you to adjust row height or column width to improve readability.

Steps to Resize Rows/Columns:

Resizing a Row:

Hover over the boundary between two row numbers in the row header until a double-sided arrow appears. Click and drag to resize the row.

Resizing a Column:

Hover over the boundary between two column letters in the column header, then click and drag to adjust the column width.

Auto-Resize:

Double-click the boundary between rows/columns to automatically resize based on the largest entry in that row or column.

Practical Exercise:

Resize the height of row 7 and the width of column C to accommodate longer text. Try using both manual resizing and auto-resize techniques.

2. Merging Cells and Formatting Cell Ranges

a. Merging Cells

Merging cells is useful for creating headers or combining multiple cells into one. This is often done for presentation purposes, such as in titles or headings.

Steps to Merge Cells:

Select the cells you want to merge.

Right-click and choose “Merge Cells” or use the “Merge & Center” option from the toolbar.

The selected cells will combine into a single cell, centered horizontally and vertically if desired.

Types of Merging:

Merge & Center: Merges selected cells and centers the text.

Merge Across: Merges cells in the same row.

Merge Cells: Merges the selected cells without centering.

Practical Exercise:

Merge cells A1 through C1 to create a title for your dataset, then format the title text to be bold and centered.

b. Formatting Cell Ranges

Formatting cells is crucial for improving readability and presentation. You can apply various formatting options like background color, borders, number formatting, and text alignment.

Steps to Format Cell Ranges:

Select the range of cells you want to format.

Right-click and choose “Format Cells” or use the formatting options in the toolbar (such as font, color, alignment).

Apply formatting such as borders, shading, or text formatting.

Practical Exercise:

Format the range A2

with borders, apply a light fill color for better readability, and format the text to be bold. Adjust the number format in column C to display currency.

3. Freezing Panes and Splitting Worksheets

a. Freezing Panes

Freezing panes allows you to keep certain rows or columns visible while scrolling through large datasets. This is particularly useful for headers or labels.

Steps to Freeze Panes:

Select the cell just below the row and to the right of the column you want to freeze.

Go to the “View” menu and click “Freeze Panes.”

The rows and columns above and to the left of the selected cell will remain visible as you scroll.

Options for Freezing Panes:

Freeze Top Row: Keeps the top row visible.

Freeze First Column: Keeps the first column visible.

Freeze Custom: Allows you to freeze a specific row and column.

Practical Exercise:

Freeze the first row of a dataset so that the headers remain visible while scrolling. Experiment with freezing both rows and columns.

b. Splitting Worksheets

Splitting a worksheet allows you to view different sections of a worksheet simultaneously, making it easier to work on large datasets.

Steps to Split a Worksheet:

Select the cell where you want the split to occur.

Go to the “View” menu and click “Split.”

The worksheet will be divided into four quadrants, allowing you to scroll in different sections independently.

Practical Exercise:

Split the worksheet at cell B5 and observe how you can scroll through different sections while keeping multiple parts of the dataset visible.

4. Summary and Practical Application

In this module, you’ve learned how to manage rows, columns, and cells effectively by inserting, deleting, resizing, merging, and formatting them. You’ve also explored advanced navigation techniques, such as freezing panes and splitting worksheets. These tools are essential for working with larger datasets and improving the visual appeal of your spreadsheet.

Comprehensive Exercise:

Create a new spreadsheet with data in columns A through F and rows 1 through 20. Perform the following tasks:

Insert a new row at row 10 and a new column at column D.

Delete row 5 and column B.

Resize column C to fit longer text.

Merge cells A1 through F1 to create a title, and format the title to be bold and centered.

Format the range A2

with borders and a light fill color.

Freeze the top row and split the worksheet at cell D5.

By the end of this module, you will have mastered the core skills needed to efficiently manage data and enhance spreadsheet layouts.

Excel Course Lesson 4 Basic Formulas And Functions

 Excel Course Lesson 4 Basic Formulas And Functions 

Excel Course Lesson 4 Basic Formulas And Functions

Module 4: Basic Formulas and Functions

In this module, we will explore the foundational concepts of formulas and functions in spreadsheet software such as Microsoft Excel or Google Sheets. You will learn how to create and use basic formulas, understand cell references, and apply common functions like SUM, AVERAGE, MIN, and MAX. We will provide detailed explanations of each concept, step-by-step practical methods, and useful exercises to reinforce your learning.

4.1 Introduction to Formulas and Functions

A formula in a spreadsheet is an expression that calculates the value of a cell. A function is a predefined formula that simplifies the process of performing calculations. Functions can do anything from simple arithmetic (addition, subtraction) to more complex operations (averaging, finding the maximum or minimum values, etc.).

In Excel or Google Sheets, formulas always start with an equals sign (=) followed by the expression. Functions use the same pattern but include the function name, followed by parentheses containing the arguments (the data you want to calculate).

Example of a basic formula:

excel

=5 + 3

This formula will display 8 in the cell where it is entered.

Example of a basic function:

excel

=SUM(A1:A5)

This function will sum up the values in cells A1 to A5.

4.2 Understanding Cell References

In formulas and functions, we often use cell references rather than static values. There are three types of cell references: absolute, relative, and mixed.

Relative References:

These are the most common types of references.

When copied to another cell, the reference changes based on the relative position of the formula.

Example: If you have a formula =A1 + B1 in cell C1 and copy it to C2, the formula will change to =A2 + B2.

Absolute References:

An absolute reference remains constant, no matter where it is copied.

You create an absolute reference by adding a $ symbol before the column letter and/or row number.

Example: If you want to always refer to cell A1, use $A$1. Even if you copy the formula, it will always reference A1.

excel

=$A$1 + B1

Mixed References:

A mixed reference keeps either the column or the row constant while allowing the other to change.

Example: $A1 means the column will stay the same, but the row can change when copied.

4.3 Using Basic Functions: SUM, AVERAGE, MIN, MAX

Let's dive into four of the most commonly used functions in spreadsheets: SUM, AVERAGE, MIN, and MAX.

4.3.1 SUM Function

The SUM function adds all the numbers in a specified range of cells.

Syntax:

excel

=SUM(range)

Example:

excel

=SUM(B1:B5)

This function will add the values in cells B1 through B5.

Exercise:

Enter numbers in cells B1 to B5 (e.g., 10, 15, 20, 25, 30).

Use the SUM function to calculate the total of these values.

Solution:

excel

=SUM(B1:B5)

The result will be 100.

4.3.2 AVERAGE Function

The AVERAGE function calculates the mean of the numbers in a specified range.

Syntax:

excel

=AVERAGE(range)

Example:

excel

=AVERAGE(C1:C5)

This function will compute the average of the values in cells C1 through C5.

Exercise:

Enter numbers in cells C1 to C5 (e.g., 5, 10, 15, 20, 25).

Use the AVERAGE function to find the average of these values.

Solution:

excel

=AVERAGE(C1:C5)

The result will be 15.

4.3.3 MIN Function

The MIN function finds the smallest value in a specified range of cells.

Syntax:

excel

=MIN(range)

Example:

excel

=MIN(D1:D5)

This function will return the smallest number from the range D1 to D5.

Exercise:

Enter numbers in cells D1 to D5 (e.g., 7, 3, 9, 2, 5).

Use the MIN function to find the minimum value.

Solution:

excel

=MIN(D1:D5)

The result will be 2.

4.3.4 MAX Function

The MAX function finds the largest value in a specified range of cells.

Syntax:

excel

=MAX(range)

Example:

excel

=MAX(E1:E5)

This function will return the largest number from the range E1 to E5.

Exercise:

Enter numbers in cells E1 to E5 (e.g., 12, 45, 7, 19, 30).

Use the MAX function to find the maximum value.

Solution:

excel

=MAX(E1:E5)

The result will be 45.

4.4 Practical Methods and Exercises

Now that we’ve covered the basics, let’s apply them with practical exercises.

Exercise 1: Budget Calculator

Create a simple budget tracker with expenses and income. Use the SUM, AVERAGE, MIN, and MAX functions to analyze the data.

Steps:

Create a table for income and expenses in column A and B, respectively.

Enter random income values in cells B2 to B6 (e.g., 500, 600, 750, 900, 850).

Enter random expense values in cells B7 to B11 (e.g., 400, 300, 350, 500, 450).

Use the SUM function to calculate the total income and total expenses.

Use the AVERAGE function to calculate the average income and expenses.

Use the MIN and MAX functions to find the smallest and largest expense.

Solution:

excel

=SUM(B2:B6) // Total Income =SUM(B7:B11) // Total Expenses =AVERAGE(B2:B6) // Average Income =AVERAGE(B7:B11) // Average Expenses =MIN(B7:B11) // Smallest Expense =MAX(B7:B11) // Largest Expense

Exercise 2: Student Grades Analysis

Create a table to analyze student grades using the functions learned.

Steps:

Enter 5 student names in column A (e.g., Alice, Bob, Carol, Dave, Eve).

Enter their grades in column B (e.g., 85, 90, 78, 88, 92).

Use the SUM function to calculate the total score of all students.

Use the AVERAGE function to find the class average.

Use the MIN and MAX functions to find the lowest and highest grades.

Solution:

excel

=SUM(B2:B6) // Total Grades =AVERAGE(B2:B6) // Class Average =MIN(B2:B6) // Lowest Grade =MAX(B2:B6) // Highest Grade

Conclusion

By mastering basic formulas and functions, you will be able to perform powerful calculations and data analysis in spreadsheets. Understanding cell references allows you to create flexible and efficient formulas. Practice using the SUM, AVERAGE, MIN, and MAX functions with different datasets to strengthen your skills.

Excel Course Lesson 3 Basic Formatting In Spreadsheet Software

 Excel Course Lesson 3 Basic Formatting In Spreadsheet Software 

Excel Course Lesson 3 Basic Formatting In Spreadsheet Software

 Module 3: Basic Formatting in Spreadsheet Software

In this module, we will focus on essential formatting techniques in spreadsheet software, including formatting text and numbers, using cell styles and themes, and applying conditional formatting. These skills are crucial for making your data more readable, aesthetically pleasing, and functional. This module also includes practical methods and exercises to reinforce your learning.

1. Formatting Text and Numbers

Formatting text and numbers is a fundamental aspect of working with spreadsheets. By formatting, you ensure that your data is presented clearly, which can help improve readability and comprehension.

Key Concepts:

Text Formatting: Changing the font, size, style (bold, italic, underline), and color of text to emphasize key points.

Number Formatting: Displaying numbers in a more readable or meaningful way, such as showing currency symbols, percentages, or adjusting the number of decimal places.

Date Formatting: Customizing the display of dates (e.g., MM/DD/YYYY, DD/MM/YYYY).

Methods and Examples:

Text Formatting:

Select the cell(s) containing the text you want to format.

Use the toolbar to change the font style, size, or apply bold/italic.

Example: Select cell A1 and apply bold and font size 14 for the title "Sales Report."

Number Formatting:

Select the cell(s) containing numbers.

Choose the number format from the toolbar (currency, percentage, or custom format).

Example: Select cell B2 containing "1500" and format it as currency ($1,500.00).

Date Formatting:

Select the cell(s) containing date values.

Right-click and choose "Format Cells," then select the desired date format.

Example: Format the date "10/19/2024" as "19 October 2024" by using custom formatting.

Practical Exercise:

Open a new spreadsheet.

In cell A1, type "Sales Report" and format it as bold, font size 16, and center it.

In column B, input a list of sales numbers (e.g., 500, 1500, 2500). Format these numbers as currency.

In column C, input a series of dates and apply a custom date format of your choice.

2. Using Cell Styles and Themes

Cell styles and themes allow you to quickly apply consistent formatting across multiple cells, making your spreadsheet look professional and cohesive.

Key Concepts:

Cell Styles: Predefined combinations of formatting options (fonts, colors, borders) that you can apply to selected cells.

Themes: A set of predefined colors, fonts, and effects that give your entire spreadsheet a consistent look.

Methods and Examples:

Applying Cell Styles:

Select the cell(s) you want to format.

In the toolbar, click on "Cell Styles" and choose from options like "Heading," "Title," "Total," etc.

Example: Apply the "Heading" style to the first row of your spreadsheet to highlight the column headers.

Applying Themes:

Go to the "Page Layout" tab and choose "Themes."

Select from the available themes or customize one by choosing specific fonts, colors, and effects.

Example: Choose a "Business" theme to give your report a professional look with complementary colors and fonts.

Practical Exercise:

In the "Sales Report" spreadsheet, apply the "Heading" style to row 1 to highlight the column headers.

Choose a theme from the "Page Layout" tab that suits your project. Apply this theme across the entire worksheet.

3. Applying Conditional Formatting

Conditional formatting allows you to automatically apply formatting to cells based on their values. This is a powerful tool for highlighting important data trends or outliers.

Key Concepts:

Conditional Formatting Rules: Set conditions (e.g., values greater than a specific number, text containing a certain word) that trigger specific formatting (colors, icons, etc.).

Highlighting Trends: You can highlight cells with certain data, such as the highest or lowest values, or use color scales to visualize data distribution.

Methods and Examples:

Creating a Conditional Formatting Rule:

Select the cell range you want to apply conditional formatting to.

Go to "Conditional Formatting" in the toolbar and choose a rule (e.g., "Highlight Cells Rules" > "Greater Than").

Example: Highlight cells in column B that have a value greater than 2000 by applying a green background.

Using Color Scales:

Select the range of cells with numeric values.

Go to "Conditional Formatting" > "Color Scales" and choose a scale (e.g., green for high values, red for low values).

Example: Apply a color scale to sales data to visually identify the best and worst months at a glance.

Using Data Bars:

Select the cell range.

Go to "Conditional Formatting" > "Data Bars" and choose a style (e.g., gradient fill).

Example: Use data bars to visualize the relative size of sales figures in a column.

Practical Exercise:

In the "Sales Report" spreadsheet, apply conditional formatting to column B. Set a rule that highlights any sales greater than $2,000 in green.

Apply a color scale to the sales figures in column B to visualize performance across different months.

Summary of Practical Methods and Exercises:

Formatting Text and Numbers: Apply bold, italic, currency, and date formatting to make your data clearer.

Using Cell Styles and Themes: Apply pre-designed styles and themes to maintain consistency in your spreadsheet’s appearance.

Conditional Formatting: Use rules, color scales, and data bars to highlight important data and visualize trends.

By the end of this module, you should be able to efficiently format text and numbers, apply consistent styles and themes across your spreadsheet, and use conditional formatting to visually emphasize key data points.

Excel Course Module 2 Working With Data

 Excel Course Module 2 working With Data 

Excel Course Module 2 Working with Data

 Module 2: Working with Data

In this module, we'll dive deep into the essential skills needed for working with data in spreadsheet software such as Microsoft Excel, Google Sheets, or similar tools. This module will cover three key topics: entering and editing data, using the Autofill feature, and understanding and modifying cell references. Each section will provide detailed explanations, practical methods, exercises, and examples to ensure a comprehensive understanding.

1. Entering and Editing Data

Explanation:

Data entry is the fundamental task of inputting data into a spreadsheet. This can include numbers, text, dates, formulas, or even special symbols. Editing data refers to making changes to the already entered information.

Key concepts include:

Cell: A single unit in a spreadsheet (e.g., A1, B5) where data can be entered.

Data types: Numbers, text, dates, or formulas that are used in the cells.

Editing: Altering the data already present in a cell. This can be done by selecting the cell, making changes directly, or by editing data within the formula bar.

Methods:

Entering Data: Click on a cell and type the desired information. Press Enter or Tab to move to the next cell.

Editing Data: Double-click a cell to edit it directly, or click once and use the formula bar above the worksheet to make changes.

Clearing Data: Select a cell or range of cells and press Delete to remove the contents.

Practical Exercises:

Entering Data:

Open a new spreadsheet and enter the following data in separate cells:

A1: "Item"

B1: "Quantity"

A2: "Apples"

B2: "50"

A3: "Oranges"

B3: "30"

Editing Data:

Change the value of "Apples" in A2 to "Bananas."

Modify the quantity of "Oranges" in B3 to "25."

Clearing Data:

Clear the data in cells A3 and B3.

2. Using the Autofill Feature

Explanation:

The Autofill feature allows you to automatically fill cells with a series of data, whether it’s numbers, dates, or text. This saves time by generating data patterns based on the initial input.

Key concepts include:

Autofill Handle: A small square at the bottom-right corner of the selected cell. Dragging this handle helps replicate data across cells.

Series Generation: Autofill can generate number sequences (e.g., 1, 2, 3…) or date sequences (e.g., January, February, March…).

Methods:

Using Autofill for Numbers: Type a starting number (e.g., 1) in a cell. Click and drag the Autofill handle down or across to create a series (e.g., 1, 2, 3…).

Using Autofill for Dates: Enter a starting date (e.g., 01/01/2024), click the Autofill handle, and drag to fill consecutive dates.

Copying Values: If you only want to copy the value of a cell without creating a series, hold Ctrl (Windows) or Command (Mac) while dragging the Autofill handle.

Practical Exercises:

Autofilling Numbers:

Enter "1" in cell A1.

Click on the cell and drag the Autofill handle down to A10 to create a sequence of numbers from 1 to 10.

Autofilling Dates:

In cell B1, enter "01/01/2024."

Use the Autofill handle to fill cells down to B10 with consecutive dates.

Copying Values:

Enter "Test" in cell C1.

Hold Ctrl and drag the Autofill handle down to copy the word "Test" in cells C2 to C10.

3. Understanding and Modifying Cell References

Explanation:

Cell references are the identifiers of cells (e.g., A1, B5) and are crucial for creating formulas and linking data. There are three types of cell references:

Relative References: Automatically change when a formula is copied to another cell. Example: =A1 + B1 will adjust to =A2 + B2 if copied to the next row.

Absolute References: Remain fixed when a formula is copied. They are denoted with a dollar sign ($). Example: =$A$1 + B1 will always refer to A1, even if copied.

Mixed References: Part of the reference is fixed, and part is relative. Example: =$A1 + B$1.

Methods:

Creating Formulas with Relative References: Type a formula in one cell and drag it down or across to copy it to other cells. The references will automatically adjust.

Using Absolute References: In a formula, use $ signs before the row or column that should stay constant. Example: =$A$1 will always refer to cell A1, no matter where the formula is copied.

Switching Between Reference Types: Select a cell reference in the formula and press F4 to toggle between relative, absolute, and mixed references.

Practical Exercises:

Using Relative References:

Enter "10" in cell A1 and "20" in cell B1.

In C1, type the formula =A1+B1. Copy this formula down to row 5. Notice how the references adjust automatically (e.g., A2+B2, A3+B3).

Using Absolute References:

Enter "5" in cell D1.

In cell E1, type the formula =A1*$D$1. Copy this formula down to row 5. Observe how $D$1 remains constant while A1, A2, etc., change.

Mixed References:

Enter values in A1 to A5 and B1 to B5.

In cell C1, type the formula =A1+$B$1. Copy the formula down to C5. Notice that column B remains fixed while A1 changes to A2, A3, etc.

Summary of Key Takeaways:

Data entry and editing: Basic skills for entering, modifying, and clearing data in a spreadsheet.

Autofill: A powerful tool for automatically generating sequences and copying data.

Cell references: Essential for formulas, with three types—relative, absolute, and mixed—each serving different purposes in data manipulation.

Final Challenge:

Using what you’ve learned, create a spreadsheet that tracks the following:

In column A, enter a list of items (e.g., "Item 1" to "Item 10") using Autofill.

In column B, enter random quantities for each item.

In column C, create a formula to multiply the quantities by a fixed value (e.g., 10), ensuring that the fixed value stays constant using absolute references.

Autofill the formula down column C to calculate for each item.

Starting Excel Course Module 1

 Starting Excel Course Module 1

Starting Excel Course Module 1

 Module 1: Introduction to Excel

In this module, you'll gain a foundational understanding of Excel, covering the basics of its interface, key terms, and fundamental elements like workbooks, worksheets, and cells. This module is designed to help you feel comfortable navigating Excel, performing simple tasks, and preparing for more advanced skills in future modules.

1. Overview of Excel and Its Interface

Description: Excel is a spreadsheet program used for organizing, analyzing, and storing data. It's part of Microsoft Office and is widely used for tasks like budgeting, data analysis, and project management.

Excel Interface Components:

Ribbon: The toolbar at the top of Excel, containing tabs like Home, Insert, and Page Layout, which house various commands.

Workbook: The entire Excel file, which contains one or more worksheets.

Worksheet (Sheet): A single tab in the workbook where data is entered and organized.

Cell: The basic unit in a worksheet, where rows and columns intersect. Cells hold data such as text, numbers, or formulas.

Practical Exercise: Exploring the Interface

Open Excel and examine the main interface. Identify the Ribbon and explore the Home, Insert, and Page Layout tabs to see the commands available.

Locate the Workbook Tabs at the bottom of the window, and click on Sheet1 to see the first worksheet.

Click any cell (e.g., A1) to see how the column and row intersect to form a cell.

Method:

Open Excel and explore the components by clicking on different elements. Familiarize yourself with the layout and functionality of each section.

2. Understanding Workbooks, Worksheets, and Cells

Workbooks: A workbook is a single Excel file that can contain multiple worksheets. Think of it as a binder containing multiple pages.

Worksheets: Each worksheet consists of a grid of cells, where data is entered. You can have multiple worksheets within a workbook, allowing you to organize data separately.

Cells: Cells are individual boxes where data is stored. They are identified by their column letter and row number (e.g., A1, B2).

Practical Exercise: Creating a Workbook and Adding Worksheets

Open a new workbook by selecting File > New.

Rename the workbook by selecting File > Save As and entering a new name.

Click on the + icon next to Sheet1 to add a new worksheet. Rename it by double-clicking on the tab and typing in a new name (e.g., "Budget 2024").

Enter data into the cells. In cell A1, type “Income,” and in B1, type “Expenses.” Practice navigating between cells by using the arrow keys or clicking on different cells.

Method:

Create a new workbook, add and rename worksheets, and enter data into specific cells. Navigate between cells and experiment with different worksheet tabs.

3. Basic Navigation and Common Terms

Basic Navigation:

Selecting Cells: Click on any cell to select it, or drag your mouse to select multiple cells.

Navigating Between Worksheets: Click the tabs at the bottom to switch between worksheets.

Scrollbars: Use the vertical and horizontal scrollbars to move through large sheets of data.

Common Terms:

Cell Reference: The unique address of a cell (e.g., A1, C3).

Range: A group of selected cells, such as A1

, which includes all cells from A1 to A5.

Formula Bar: Located above the worksheet, it shows the contents or formula of the selected cell.

Active Cell: The currently selected cell, highlighted with a border.

Practical Exercise: Navigating and Using Terms

Select Cell A1 and then use the arrow keys to navigate to B1, B2, etc. Observe how the cell reference changes in the Name Box (next to the Formula Bar).

Select a Range: Click on cell A1, hold down the mouse button, and drag to cell B5. This selects the range A1

.

Enter Data and Use Formula Bar: Type a value in cell A1 and check how it appears in the Formula Bar.

Click on different worksheet tabs and notice how the data changes with each worksheet.

Method:

Practice selecting individual cells and ranges, navigating between worksheets, and using the Formula Bar to view cell contents.

Summary Exercise: Creating a Simple Table

In this exercise, you will create a basic table using the skills you've learned.

Create a New Workbook and name it “Monthly Expenses.”

In Sheet1, create the following table structure:

A1: "Category"

B1: "Amount"

A2 to A6: Enter categories (e.g., Rent, Utilities, Groceries, Transportation, Entertainment).

B2 to B6: Enter sample amounts (e.g., 1200, 200, 300, 150, 100).

Format the Table:

Select A1 to B1, then use the Bold option in the Ribbon.

Format B2 to B6 as currency by selecting the cells, right-clicking, choosing Format Cells, and selecting Currency.

Save your workbook and review the structure to ensure everything is correct.

Method:

Use navigation and basic cell entry skills to create and format a table. Practice formatting options and saving the workbook for future reference.

By the end of this module, you should have a basic understanding of Excel's interface, how to navigate workbooks and worksheets, and how to enter and format data in cells. Practice these exercises to reinforce your skills and prepare for more advanced tasks in Excel.