1 / 9

Lab 10 MS-Excel Data Format

This guide outlines essential advanced formatting techniques in Microsoft Excel for managing data efficiently. Key formatting styles include specific formatting for phone numbers, dates, and currency symbols, as well as conditional formatting for grades to enhance data visualization. The document provides instructions for sorting data by multiple criteria, freezing panes for better data navigation, and customizing backgrounds for a personalized touch. These skills will aid users in creating organized, visually appealing spreadsheets that meet professional standards.

martena-burnett
Télécharger la présentation

Lab 10 MS-Excel Data Format

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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”

More Related