{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lec15 - Lecture 15 Excel Part I navigation of MS Excel...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Lecture 15 Excel – Part I Lecture 15 Excel Part I Basic navigation of MS Excel spreadsheet Calculations Basic operations, tables, functions Graphing Importing data from text files created by C++
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 Lecture 15 Excel – Part I Starting Microsoft Excel Start Programs Microsoft Office Excel (the green X)
Image of page 2
3 Lecture 15 Excel – Part I Navigating Excel You can add or delete tool bars by right clicking in the tool bar area. Standard tool bar Chart tool bar Formatting tool bar Main menu Drawing tool bar Sheets: can be added, deleted and renamed (right click them)
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 Lecture 15 Excel – Part I Columns are labeled with letters; rows with numbers. Current cell. The Formula Bar shows the formula in the current cell. Formulas start with a + and can be typed in or “pointed – in” B5 is a relative cell reference (relative to B6). In this case meaning the cell directly above the current cell. $B$1 is a fixed cell reference.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern