Lecture+18+-+Excel+1

Lecture+18+-+Excel+1 - CS170Lecture13 Spreadsheets1...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 170 Lecture 13 Spreadsheets 1 Kristian Stout stouty@rci.rutgers.edu Office IN: Livingston Student Center, A lounge near “the rock” and the commuter lounge. Office Hours: TTH 5:30 – 6:30
Background image of page 1

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

View Full DocumentRight Arrow Icon
A note I use the latest version of Office the functions and features will be the same ---  the layout on screenshots might be different.  for exact  locations of the specific menus in  your version of excel see the recommended  texts or ask your TA in recitation
Background image of page 2
Getting Started Microsoft Office Excel is a powerful tool you can use to  create and format spreadsheets, and analyze and share  information to make more informed decisions.  One can use Excel to create budgets, work with taxes,  record student grades, or even track daily exercise or the  cost of a remodel.  Professional or personal, the possibilities are nearly  endless. 
Background image of page 3

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

View Full DocumentRight Arrow Icon
Getting Started When you start Excel you're faced with a big  empty grid.  There are letters across the top, numbers down  the left side, tabs at the bottom named Sheet1  and so forth.
Background image of page 4
Example Workbook
Background image of page 5

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

View Full DocumentRight Arrow Icon
Workbook and worksheets You open a file called a  workbook .   The first workbook you open is called  Book1  (or  workbook1) by default you can change this when you save the document Each new workbook comes with three worksheets, like  pages in a document.  On a mac it opens with 1 You enter data into the worksheets.  On the  File  menu, click  New . In the  New Workbook   task pane, click  Blank workbook
Background image of page 6
Workbook and worksheets Each worksheet has a name on its  sheet  tab  at the bottom left of the workbook  window: Sheet1, Sheet2, and Sheet3.  You view a worksheet by clicking its  sheet tab.  
Background image of page 7

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

View Full DocumentRight Arrow Icon
default title default three sheets; change sheets by clicking different tabs You enter data in this area
Background image of page 8
Workbook and worksheets It is a good idea to rename the sheet tabs to make the  information on each sheet easier to identify.   You can add additional worksheets if you need more  than three.  Or if you don’t need as many as three, you can delete  one or two (but you don’t have to). You can also move the worksheets around by clicking  the tab and dragging it You can also duplicate worksheets by right-clicking the  sheet’s tab and choosing “Move or copy”
Background image of page 9

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

View Full DocumentRight Arrow Icon
Columns, rows and cells Columns and rows have headings: Each column has an alphabetical heading at the top. The first 26 columns have the letters from A through Z. Each 
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/17/2011 for the course BUSINESS 198:170 taught by Professor Staff during the Spring '09 term at Rutgers.

Page1 / 34

Lecture+18+-+Excel+1 - CS170Lecture13 Spreadsheets1...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online