Excel - Centering and Formatting Basics

Centering and Formatting Cells

• Center a title over a cell range by navigating to Home → Alignment → Merge and Center.
• Enable text wrapping within cells via Home → Alignment → Wrap Text.
• Adjust text orientation through Home → Alignment → Orientation.
• Clear cell formatting using Home → Editing → Clear Format.

Number Formatting Options

• Set number formatting to percentage by selecting Home → Number → Percentage.
• Apply or remove comma style using Home → Number → Comma Style.
• Add currency symbols by going to Home → Number → Currency icon and selecting the appropriate symbol.
• Reset number formatting to general by accessing Home → Number → Number Format icon → General.

Freezing and Unfreezing Panes

• Freeze both row and column titles through View → Window → Freeze Pane.
• Unfreeze panes using View → Window → Unfreeze Pane.
• Freeze just the top row with View → Window → Freeze Top Row.
• Freeze the first column by selecting View → Window → Freeze First Column.

Workbook Navigation

• Switch between workbooks via View → Windows → Switch Window, the taskbar, or by pressing Alt + Tab.

Moving and Copying Cell Contents

• Copy selected cells with Ctrl + C and move them with Ctrl + X.

Inserting and Deleting Rows/Columns

• Insert rows using Home → Cells → click the arrow next to Insert → Insert Sheet Rows.
• Insert columns by going to Home → Cells → click the arrow next to Insert → Insert Sheet Columns.
• Delete a row or column through Home → Cells → click the arrow below Delete → select Delete Sheet Row or Delete Sheet Column.

Copying and Moving Cell Contents

• Copy contents through Home → Clipboard → Copy and paste with Home → Clipboard → Paste.
• Move contents via Home → Clipboard → Cut and then paste with Home → Clipboard → Paste.

Auto Fill Feature

• For auto fill, select the cell to copy, drag the fill handle (bottom corner) to adjacent cells while holding down the left mouse button.

File Management in Excel

• Save a worksheet by going to File → Save, choosing the location, typing the file name, and clicking Save.
• Open a workbook by selecting File → Open, locating the document, and clicking Open.
• Create a new workbook by clicking File → New and double-clicking the blank workbook.
• Save a workbook under a new name with File → Save As, selecting the location, entering a new name, and saving.

Adding Borders

• Add borders by going to Home → Font, clicking the border arrow, selecting a style, changing the color if needed, and adjusting the border style.

Filtering and Searching Data

• Filter data in cells through Home → Editing → Sort & Filter.
• Search for specific data using Home → Editing → Find and Select → Find, and writing the desired text.

Replacing Data

• Open Find & Replace with Ctrl + F, enter the text to find and replace, and click Replace.

Format Painter Tool

• Use the Format Painter by accessing Home → Clipboard → Format Painter to copy formatting from one cell to another.

Excel Functions Overview

• Use the Sum function with =SUM(range) for totals, Average function with =AVERAGE(range) for averages, Max function with =MAX(range) for maximum values, Min function with =MIN(range) for minimum values, Count function with =COUNT(range), and CountA function with =COUNTA(range) for counted values.
• Access functions from Home → Editing → AutoSum menu for easy use.
• Implement the IF function through Home → Editing → AutoSum menu → More Functions → IF.

Calculating Annual Grades and Student Results

• Calculate total scores by summing columns with formulas like =E2+F2 for annual and final scores.
• Determine results (pass or fail) using IF functions linked to score inputs.