click below
click below
Normal Size Small Size show me how
Spreadsheet
Question | Answer |
---|---|
What is a spreadsheet? | A spreadsheet, like a table, organizes data in rows and columns. |
What is a benefit of google spreadsheet? | The big difference is that Google Spreadsheets is a web-based application, so that web files can be accessed from any computer at any location. The web-based nature of Google Spreadsheets also facilitates collaboration. W |
What’s a row? | A row is spreadsheet data arranged horizontally. In Google Spreadsheets, rows are numbered sequentially. |
What’s a column? | A column is spreadsheet data arranged vertically. In Google Spreadsheets, columns are lettered alphabetically. |
What’s a cell? | A cell is the intersection of a row and column. |
What’s a cell address? | A cell address is the column letter followed by the row number, used to reference a cell in calculations. |
where is the menu bar? What is its purpose? | There is a menu bar at the top of the workspace, with a toolbar just below that; most commands and functionality are accessed from either the menu bar of the toolbar. |
Where is the formula bar? | Below the toolbar is a Formula bar that you use to enter and edit formulas in your spreadsheet |
how to change the title? | ou can change the title of a saved file (which is typically named something like "untitled document") by entering a new title into the title box above the menu bar. |
Can you work on a spreadsheet and use it in google? | You can use Google Spreadsheets to work on spreadsheet files you've previously created in Microsoft Excel and other spreadsheet programs. |
What formats will google spreadsheets import and export? | oogle Spreadsheets will import and export spreadsheet files in the following formats: -Microsoft Excel (.xls or .xlsx) -Comma Separated Values (.csv) -Plain text (.txt) -Open Document Spreadsheet (.ods) |
What is the difference between excel and spreadsheets? | Unlike Excel, which also starts with 3 sheets per file, Google Spreadsheets contain a single sheet by default. You can then add additional sheets to the first sheet. |
why should you select multiple cells | You often need to select multiple cells at the same time. This is useful if you are applying formatting to more than one cell, or if you are selecting a group of cells for a particular equation |
whats a reference? | A reference is a way of noting individual cells or cell ranges elsewhere in a spreadsheet. |
how is he cell range that starts with A1 and ends with b9 written? | For example, the range that starts with cell A1 and ends with B9 is written like this: A1:B9 |
what can the range be named? | A range can also be named-that is you assign a name to the range. This enables you to use ranges names in formulas rather than entering the exact cell reference. |
how can you sort cells | You can sort a selected range of cells. or sort all cells within selected columns. |
How can you sort cell data? | You can sort cell data in ascending order (A to Z or 1-9) or descending order (Z to A of 9-1). |
What happens when you sort by range | When you sort by range, you sort only those selected cells in the range. |
what happens when you sort | When you sort by column, you sort all the cells in the spreadsheet by the selected columns. |
How can you include multiple subsorts? | When you opt to sort by range, you can include multiple subsorts. |
How do you print a google spreadsheet? | Google Spreadsheets converts the spreadsheet into a PDF file, which you can then print from within Adobe Reader. |