Chapter 1 Spreadsheet Basics

Chapter 1 Spreadsheet Basics - CHAPTER 1 SPREADSHEET BASICS...

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

View Full Document Right Arrow Icon
CHAPTER 1 - SPREADSHEET BASICS This chapter contains general information about spreadsheets and the spreadsheet software package Microsoft Excel 2010. Spreadsheet applications are used extensively in industry to analyze data, create balance sheets, prepare budgets, and keep track of other information such as project costs, inventory, etc. This chapter will explore the basic concepts of using a spreadsheet and briefly introduce some of the features found in an Excel workbook. Subsequent chapters will cover additional tools and develop an understanding of how Excel can be used as a problem solving tool. BASIC FEATURES OF AN EXCEL 2010 WORKBOOK THE WORKSHEET: Page 1
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
As seen in Figure 1 spreadsheet is a work area composed of columns and rows . The intersection of a column and row is referred to as a cell . Each cell is identified by an address which indicates the column and row in which it resides. Columns are named by letters (A,B..Z, AA,AB..AZ, BA,BB..BZ etc), and the rows are named by numbers (1,2 ….1048576). The cell address first lists the column name and then the row name. So the cell in the first column and first row has the cell address A1 and the cell in the third column second row has the cell address C2. To enter a value or formula, click on the cell where you wish to place your entry and type. This selected cell is referred to as the active cell . The contents of the active cell will also be displayed on the formula bar which is located directly above the column headings. A single Excel file may contain many spreadsheets, which are referred to as worksheets . Together, these worksheets comprise an Excel workbook file. The tabs at the bottom of the Excel window list the worksheets in the workbook. The worksheet you are currently using is referred to as the active worksheet. The active worksheet tab appears highlighted. To reference cells on different worksheets in a workbook place the worksheet name in front of the cell address. So a cell that is on sheet 3, in the second column third row would be referred to as Sheet3!B3. Note the use of ! to indicate a sheet name. When referring to a cell on the active worksheet the sheet name is not required. A worksheet can be renamed by right-clicking on the tab and selecting Rename . A worksheet’s name can be Page 2 Figure 1 The Parts of a Worksheet
Image of page 2
almost any text string ( e.g. data, Financial Summary, January, etc.). In addition, worksheet tabs can be colored or reordered, and worksheets may be copied or deleted. NAVIGATING THE WORKSHEET: The easiest way to move from one cell to the next is to use the mouse pointer and click on the desired cell. The up, down, left, right arrow keys on the keyboard can also be used to move around the worksheet one cell at a time. However not all worksheets are as simple as the one seen in Figure 1. The window displays columns A through N and rows 1 through 19. What if your worksheet required more than 15 columns or 19 rows? To view rows 19 and above on the screen use the Vertical Scroll bar on the right side of the worksheet window or the down arrows on your keyboard.
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
Image of page 4
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