> For the complete documentation index, see [llms.txt](https://pinardag-1.gitbook.io/datajournalism/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://pinardag-1.gitbook.io/datajournalism/google-spreadsheet.md).
# 3.Data journalism basics with Google spreadsheets
Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. \
\
The service also includes Google Docs and Google Slides , a word processor and presentation program respectively. Google Sheets is available as a web application, mobile app for Android, iOS, Windows, BlackBerry, and as a desktop application on Google's ChromeOS. The app is compatible with Microsoft Excel file formats. \
\
The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by user with a revision history presenting changes. \
\
An editor's position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including "Explore", offering answers based on natural language questions in a spreadsheet.
\
Google Sheets is a Google Docs product.\
Also called Google Spreadsheet or Google sheet\
Has the same features as MS Excel\
Works online - web-based, except under certain circumstances\
Works with all internet browsers\
You can analyze and visualize your data.\
\
**Common Spreadsheet Statements**\
\
Cell: A single data point or item in a spreadsheet.\
Column: Vertical cell set.\
Row: A horizontal array of cells.\
Range: Select a cell that extends to a row, column, or both.\
Function: An internal process in a spreadsheet application that can be used to calculate cell, row, column, or range values, edit data, and more.\
Formula: Combination of functions, cells, rows, columns, and ranges used to achieve a given result.\
Worksheet: Named sets of rows and columns that make up your spreadsheet; a spreadsheet can contain multiple sheets\
Spreadsheet: the entire document containing your worksheets
**How to use it?**
You must first have a gmail account\
You can then access the New Menu> Google spreadsheets at google drive (drive.google.com)\
You will then be presented with an empty excel file, you can start by changing the name of the file.\
\
**Share you file**
**Few Features to Make Your Job Easier**\
\
1.Find and Replace\
2.Devrik Paste\
3.Text to Column\
4.Quick Graph Button\
5\. Basic Accounts\
\
**Useful functions**\
\
**Sum, Average, Count, Max, Min**
\
**Add a quick chart or graph to a spreadsheet**
**Line-Column-Pie Charts**
{% embed url="" %}
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://pinardag-1.gitbook.io/datajournalism/google-spreadsheet.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.