Ron Mikhael Surara

Ron Mikhael Surara

Friday, January 9, 2015

What I Learned in CompSci #21: Software - Excel

SPREADSHEET
Excel


       There are many good software out there for spreadsheet and data analysis, but what I'm going to blog about is Excel... because it's what I learned from Sir Tom.

Excel - Introduction

  • A file of Excel is called a workbook
  • A workbook is made up of worksheets
  • A worksheet is made up of grid cells
  • A cell is where you input data into. Cells are arranged into rows and columns.
Parts of Excel
  • Cell - It is where you input data into
  • Row / Column Heading - It is found at the topmost or leftmost part. Clicking these will select the entire row or column
  • Name Box - Holds a cell's reference number. You can rename a cell by typing a new name here
  • Formula Bar - You can type data or formulas here
  • Active Cell - The highlighted cell




Reference: http://upload.wikimedia.org/wikipedia/de/thumb/c/c1/Microsoft_Excel_Icon.svg/1065px-Microsoft_Excel_Icon.svg.png
http://moodle.pshs-brc.edu.ph/pluginfile.php/4705/mod_resource/content/0/Spreadsheet%20for%20Data%20Analysis.pdf