SPREADSHEET BASICS
allows you to perform calculations based on the numbers and formulae that you enter into a worksheet.
what is a Spreadsheet software
When a formula contains a cell address
what is a cell reference?
use vertical bars to represent data. They can work with many different types of data, but they’re most frequently used for comparing information.
What is Column Chart?
program used to convert files so that it can be edited in google sheets.
What is Office Compatibility Mode (OCM)?
A global network of computers
What is the internet?
a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel.
what is Google Sheets?
Select the cell that will display the calculated value. Type the equals sign (=),hit enter to?
What is creating a formula?
Once you’re satisfied with your Chart, this option moves it
What is Move to Own Sheet?
Click this button to allow persons to view your document/content
What is Share?
Being able to share and access information on the go
What is the mobile internet?
quick access to the most common options for formatting text, including font, font size, bolt, underline, etc.
what is Text formatting options?
There may be times when you do not want a cell reference to change when copying or filling cells.
What is Absolute cell References?
to remove the Chart from the spreadsheet
What is Delete?
When a collaborator is modifying the file, a cursor will appear in a bright color at whatever point he or she is editing. Any changes the person makes will appear in real time.
What is Concurrent Edits?
The first page you see when you access a website
What is the Homepage?
When working with large spreadsheets, there will be times when you’ll want to keep certain rows or columns fixed on the screen (especially headers), while scrolling through the rest of the spreadsheet.
what is Freezing rows and columns?
What is the Order of Operations?
a tool that helps you to communicate data graphically and allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier.
What is a Chart?
Allow you to attach a brief note to any selected text in the document.
What is Comment?
What is a Context menu?
allows you to customize the look and feel of your spreadsheet, making it easier to view and understand.
What is formatting?
This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
What is Average?
This type of charts make it easy to compare proportions
What is a Pie Chart?
allows collaborators to communicate while collaborating on a document, however this is only available with the Google Docs web application and not the Mobile App.
What is Real Time Chat?
A software on your device that allows you to access the internet.
What is a Browser?