Class Notes (839,328)
Canada (511,271)
Human Rights (128)
HUMR 2202 (13)
Lecture

2-excel.doc

3 Pages
120 Views

Department
Human Rights
Course Code
HUMR 2202
Professor
Marc Tedder

This preview shows page 1. Sign up to view the full 3 pages of the document.
Description
2-Introduction to MS Excel Editing a Cell • Double-click a cell to edit the data in it. • Click the cell, and then edit the data in the formula bar. • The worksheet now says Edit in the status bar). • To save the changes in the cell, press ENTER or TAB • If you are editing and made a mistake, you can press ESC. The changes will not take place. ##### • Sometimes a cells displays ##### even when you know entered data in it. • This means that the cell is not wide enough to display the number (or date). • Double-click the right column boundary at the top to make more room. Also you can drag the right column boundary as in the example. Format Cells • Every cell can have several formats in Excel. • The most common type for a cell are: – General (no format) – Numbers (1, 394, 22.3) – Currency ($2.43) – Text – Percentage (33.4%) Format Cells dialog • Right click on a cell then select the Format Cell option. • This dialog box allows you to change the formatting of any selected cell. Cell Borders • You might want to eventually print your worksheet. • If you don’t put any cell borders, all you will see is the content of the cells (numbers, text, etc). Adding Cell Borders • You can add many different types of cell borders by clicking the Borders button in the Home tab. • Simply click on the cell or cells that you wish to add a border to, then apply any border type. • If you want more option, use Format Cell dialog, Border tab (as we showed before) Printed Example With Borders • If we print the same example as before after adding borders we would get the following. Changing the Cell Format • You can also change the format by using the Numbers panel of the Home tab (it will show a preview of what the cell will look like in that format. Removing Cell Format • If you want to remove all cell formatting that you added (cell format, text size, text font, text color, etc) on a cell, select it and use the Clear Formatting button in the Editing panel of the Home tab. Changing the Font • You can change the font type, size, color, etc, using the same method as with Word or PowerPoint. - 1 - • You should first select the cells Inserting Rows • Sometimes you need another row to hold additional information. • Click any cell in the row immediately below where you want the new row to appear. • Then in the Home tab, click the Insert button of the Cells panel. • Then click Insert Sheet Rows. Inserting Rows • Before inserting the row: • After inserting the row: Inserting Columns • Click any cell in the column immediately to the right of where you want the new column to appear. • Then in the Home tab, click the Insert Button of the Cells panel. • Then click Insert Sheet Columns Sorting Values • A very useful feature in Excel is the Sort & Filter button of the Home tab. • This button allows you to sort different types of data in ascending (increasing) or descending (decreasing) order. Sorting
More Less
Unlock Document

Only page 1 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit