Sunday, April 12, 2020

Google Spreadsheet Introduction - Understanding the spreadsheet

Google spreadsheet has many features which can be used for day to day QA tasks, before moving to how to insert data and formulas to the sheet, let us first understand terminologies which are used in google spreadsheet. If you have not gone through my post on how to create a new google spreadsheet then visit the link below first.


Let's start with the most import terminologies used in the spreadsheet. 

Worksheet( Sheet)

Every page in the spreadsheet is called Sheet.

Cell:

Every box in the google spreadsheet is called a Cell.

Rows:

Horizontally displayed cells are called as Row. Rows are represented by numbers on the Y-axis.

Columns: 

Vertically displayed cells are called as Column. Columns are represented by Alphabets on the X-axis