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.

This quiz covers essential Excel functions related to centering titles, text wrapping, orientation, and number formatting. Test your knowledge on how to effectively format cells in Excel and make your spreadsheets more user-friendly. Perfect for beginners looking to strengthen their Excel skills.