1 / 6

Excel 2003 Fundamentals Brainbench Notes 1

Excel 2003 Fundamentals Brainbench Notes 1. Mr. Martin Fundamentals of Admin Tech. Info. AutoFilter allows you to filter through a list of names and addresses For #19, the number was entered in cell A6 by using a formula to total the above cell number values

bryony
Download Presentation

Excel 2003 Fundamentals Brainbench Notes 1

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. Excel 2003 Fundamentals Brainbench Notes 1 Mr. Martin Fundamentals of Admin Tech

  2. Info • AutoFilter allows you to filter through a list of names and addresses • For #19, the number was entered in cell A6 by using a formula to total the above cell number values • You select the Legend to change the order of the data series on the chart • 4^3 would give you 64 • The following button is used to merge and center cells:

  3. Info • You disconnect from a shared workbook by clicking: Select Tools>Share Workbook, select the user, and click Remove User • The followinf function will return the value 11: =SEARCH("brown","The quick brown fox jumps over the lazy dog.") • A Venn Diagram contains overlapping circles • A Line chart has a line • SHIFT+F3 launches the Insert Function Wizard

  4. Info • Go To can take you to another location in a spreadsheet when you click on an object • Select Print Selection in the Print dialog box to print only the cells you have selected • You can remove a formula from a cell by pressing the Delete key on the keyboard • Data Validation restricts the entry of a cell to a certain data range • The maximum number of criteria available for conditional formatting is 3

  5. Info • The following drawing toolbar button allows you to create flowchart shapes: • The following drawing toolbar button allows you to draw lines: • You protect a shared workbook by doing the following: Select Tools>Protection>Protect and Share Workbook

  6. Info • If you want to sort a range of dates chronologically, you: Click Options in the Sort dialog box and choose the list of days in the Sort Order box • The red arrow is pointing to Error Checking: • The red arrow is pointing to Research:

More Related