Download
excel 2003 fundamentals brainbench 2 notes n.
Skip this Video
Loading SlideShow in 5 Seconds..
Excel 2003 Fundamentals Brainbench 2 Notes PowerPoint Presentation
Download Presentation
Excel 2003 Fundamentals Brainbench 2 Notes

Excel 2003 Fundamentals Brainbench 2 Notes

99 Vues Download Presentation
Télécharger la présentation

Excel 2003 Fundamentals Brainbench 2 Notes

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Excel 2003 Fundamentals Brainbench2 Notes Mr. Martin Fundamentals of Admin Tech

  2. Info • MAX returns the largest value in a set of values; ignores logical values and text • A Bar chart has horizontal bars • XY (Scatter) chart has many points, but no connecting lines • =COUNTIF(range, criteria) shows the correct syntax for the COUNTIF() function • You can change the data from a column to a row by using Transpose • #10 shows an Organizational Diagram

  3. Info • You can change the background of a chart area to a picture by using Fill Effects • SUM adds all numbers in a range of cells • Double-clicking in a cell allows you to edit the contents directly in the cell • You can rename a worksheet by doing the following: Select Format>Sheet>Rename • You can import data into Excel from an external source by doing the following: Click Data>Import External Data>Import Data. Choose the data you want to import in the Select Data Source dialog box

  4. Info • You can adjust the worksheet to always display Column A, Row 2 by Placing the cell pointer in A2 and selecting Window>Freeze Panes • Wrap Text allows you to control the behavior of text • LOWER converts all uppercase letters in a text string to lowercase • You can filter data and place the results in another location by doing the following: Select Data>Filter>Advanced Filter>Copy to another location

  5. Info • For # 21, 5 appears in A5 after pressing the ENTER key • If you get #### for an answer after entering a formula that calculates numbers, the column width is too narrow to display the formula results • A Pie chart displays a circle cut into multiple pieces • The following toolbar button allows you to indent the contents of a cell:

  6. Info • The red arrow in the following image is pointing to Insert Hyperlink: • 18 will be displayed in cell D1 in the following image after you press enter: