Sheet Basics
What is Google Sheets mainly used for?
To organize, store, and analyze data in a spreadsheet
What symbol starts every formula?
=
Name a type of charts.
Pie, Bar, Line
What do we call a box where a row and column meet?
A cell.
What is a formula?
A formula in Google Sheets is an equation you type into a cell to perform a calculation or action.
why use charts?
to Visualize the data/analyze the data.
What is the purpose of a header row in a table?
To label and organize the data
Where do you see the formula?
You see the formula in the formula bar at the top of the Google Sheets window when you select a cell.
where can you find the chart editor?
in the existing chart click on three dots
What happens if you copy a formula that uses relative references across multiple rows?
The references change based on the new position
what is the formula to add values A1 to A10.
=sum(A1:A10)
which chart is best to show part of a whole
A pie chart.
How can you hide a column without deleting it.
Right click on a column and click on Hide column
If you want to find the Average of the call A1 through A10 what formula you will use?
=Average(A1:A10)
which chart is used to show trends over time.
Line chart