Notes workbook is a file which contains one or more spreadsheets Spreadsheet



Download 22.4 Kb.
Date02.01.2017
Size22.4 Kb.


ANATOMY OF A SPREADSHEET

NOTES

  • Workbook is a file which contains one or more spreadsheets

  • Spreadsheet (or worksheet) is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form

  • Column vertical part of the spreadsheet, letters are used to refer to the column

  • Rows horizontal part of the spreadsheet, numbers are used to refer to the rows

  • Cells intersection of the columns and rows, are individual locations on a spreadsheet, the smallest part of the spreadsheet

  • Cell Address (cell reference) column letter and the row number, cell A4 refers to one specific location

  • Range (cell range) selected group of cells that form a rectangle, refers to a group of adjacent cells (side by side)

Examples:

  • Range A4:A16 refers to a group of adjacent cells

  • Column A refers to all of the contents in a vertical range of cells in the first column of the spreadsheet

  • Row 3 refers to all of the contents in a horizontal range of cells on Row 3

  • 'All Years'!A6:E16 refers to a range of cells in a specific spreadsheet

  • Label text, symbol, date or number not used in calculations, default alignment is left

  • Value a number entered into a spreadsheet that will be used in calculations, default alignment is right

  • Formula equations with symbols for math functions, formulas begin with an equal sign =A1+A2

Complete birthday gifts as an example.





Share with your friends:


The database is protected by copyright ©dentisty.org 2019
send message

    Main page