Lab 10 MS-Excel Data Format

1. Lab 10MS-ExcelData Format Qutaiba Albluwi

2. Special Data Formatting • Format Column E (Phone Number) as:(##)-###-(####) • Format the date on Column Q:March 14, 2001Note: the Location settings should be “English (United States)”

3. Number Formatting • Format Column H (Midterm) in 3 decimal places • Format Column R (Percentage) with percentage sign (%) and 4 decimal places

4. Conditional Formatting • Format Column I (Coursework) • If the grade is more than 40 color the cell in blue • If the grade is less than 30 color the cell in red • Otherwise, color the cell in yellow • Format Column K (Total) • If the grade is more than or equal to 60, color the Font in blue • Otherwise color the font in red

5. Sort • Sort the data according to the following criteria: • First Name (ascending), then • Total (descending)

6. Self Study Section

7. Currency • To format data as currency: • Highlight on the cells containing the data • Right-click  Format Cells  General • Choose “Currency” • Choose the proper currency symbol • Exercise: • Format Column S (Price) with the currency symbol of Bahrain.Note: currency symbol of Bahrain is BHD

8. Background • To add a background picture to the sheet: • Go to “Format”  “Sheet”  “Background” then choose a picture of your choice • Use the same steps to remove the background

9. Freeze Panes • If you want to freeze the panes of Rows 1 to 3: • Go to Cell A4 and then Choose: “Window”  “Freeze Panes” • If you want to freeze the panes of Columns A, B and C: • (Note: you have to remove the freeze from the previous step first) • Go to Cell D1  “Window”  “Freeze Panes” • If you want to freeze both Rows 1 to 3 and A to C: • Go to Cell D4  “windows”  “Freeze Panes”