Mastering Spreadsheets: Essential Functions and Features
Learn how to navigate and utilize spreadsheets effectively with this comprehensive guide. Understand key terms like rows, columns, active cells, and functions to boost your productivity.
Mastering Spreadsheets: Essential Functions and Features
E N D
Presentation Transcript
Vocab • #1 Row- horizontal reference on the worksheet • #2 Worksheet- a page on the spreadsheet • #3 Sheet tab- Allows you to move from different worksheets easily • #4 Column- vertical reference on a spreadsheet • #5 Active Cell – the cell you are currently working on • #6 Cell –individual box on a spreadsheet • #7 Auto sum- formula that will add up a column of numbers • #8 Insert Function- Allows you to choose formulas for a certain cell
#9 Workbook- Made up of many worksheets and charts • #10 Sort- Allows you to arrange information easily • #11 Fill- allows you apply changes to one or more cells • #12 Create Chart- Allows you to make selected information into a variety of charts and graphs.
Additional Vocab • Fill handle- dot at bottom corner of active cell that will fill selected cells • Formula- usually begins with an “=“ sign • Selecting- to highlight one or more cells to apply changes to • Value- what a number is worth