{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Accounting- Spreadsheets definitions

Accounting- Spreadsheets definitions - 11 Edit box each...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Accounting Spreadsheets List three parts/keys to your measurable plan to achieve your course goal grade! 1 st I must FOCUS 2 nd I must PRACTICE 3 rd I must WORK HARD & then I will ACHIEVE my Anticipated Goal! 1. Row- horizontal group of cells identified by a number in a worksheet. 2. Column- vertical group of cells in a worksheet identified by alphabetic letter. 3. Formulas- equation that performs a calculation on values in a worksheet. 4. Range- a group of cells that forms a rectangle. 5. Relative addressing- a cell address that adjusts to the row or column where a copied formula is located. 6. Absolute addressing- a cell address that does not change when copied in a formula. 7. Macro- a sequence of commands and keystrokes that performs a task, saved as a Visual Basic routine in a workbook. 8. Spreadsheet- a worksheet matrix in which columns and row numbers are summed for budgets and statements. 9. Cell- intersection of a column and row in a worksheet with an address or reference. 10. Cell address- column letter and row number that identifies a location in the worksheet.
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 11. Edit box- each small rectangle or box is known as a cell. It can be used also to enter or edit a formula, a function or data in a cell. 12. Named ranges- name range in Excel allows you to assign a name to a single cell or range of cells. 13. Formatting- is used to change the look of the numbers in the cell. Excel formatting is a way to make your spreadsheet easier to read and understand the important data. 14. Menu bar- is directly below the title bar. The bar is a horizontal assembly of icons you click on to open a menu or perform functions. 15. Formula bar- located above the worksheet, displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function or data in a cell. 16. Software applications (5) - Microsoft Office, Excel, Access, PowerPoint, Outlook. 17. Operating systems (5) – Windows 7, Window Vista, Lenox, PeopleSoft, Pac Man, Angel....
View Full 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