Textbook Notes (362,734)
Canada (158,032)
UOIT (533)
Business (277)
Chapter 1

Chapter 1 Introdution to Excel.docx

8 Pages
Unlock Document

BUSI 1520U
Amin Ibrahim

Chapter 1 Introduction to ExcelIntroduction to SpreadsheetsSpreadsheetan electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations enabling interpretation of quantitative data and to display results for decision makingSpreadsheet Programa computer application such as Microsoft Excel that you use to create and modify electronic spreadsheets Planning for Effective Workbook and Worksheet DesignWorksheetsingle spreadsheet that typically contains descriptive labels numeric values formulas functions and graphical representation of dataWorkbooka collection of one or more related worksheets contained within a fileSteps to designing a workbook and a worksheet1State the purpose of the worksheet2Decide what input values are needed3Decide what outputs are needed to achieve the purpose of the worksheet4Assign the worksheet inputs and results into columns and rows and consider labelling5Enter the labels values and formulas in Excel6Format the numerical values in the worksheet7Format the descriptive titles and labels attractively but so as not to distract your audience from the purpose of the worksheet8Document the worksheet as thoroughly as possible9Save the completed workbookAddIns Tab Might see an AddIns tab on the ribbon This tab indicates that additional functionality such as an updated office feature or an officecompatible program has been added to your system Are used to increase your productivityIdentify Columns Rows and Cells
More Less

Related notes for BUSI 1520U

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.