Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Stack #1076166
Google Spreadsheets
| Question | Answer |
|---|---|
| What does a spreadsheet do? | A spreadsheet, like a table, organizes data in rows and columns. |
| What is google spreadsheet? | Google Spreadsheets is the spreadsheet application in the Google Docs suite. |
| What is a row? | A row is spreadsheet data arranged horizontally. In Google Spreadsheets, rows are numbered sequentially. |
| What is a column? | A column is spreadsheet data arranged vertically. In Google Spreadsheets, columns are lettered alphabetically. |
| What is a cell? | A cell is the intersection of a row and column. |
| What is a cell address? | A cell address is the column letter followed by the row number, used to reference a cell in calculations. |
| Where do you access the menu bar? | 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 or the toolbar. |
| Where do you enter formulas? | Below the toolbar is a Formula bar that you use to enter and edit formulas in your spreadsheet. |
| What is a template | A template is a combination of cell, number, and text formatting (and in some cases graphics) to which you can add your own numbers and text. |
| can you work on spreadsheets created in microsoft excel in google spreadsheets? | You can use Google Spreadsheets to work on spreadsheet files you've previously created in Microsoft Excel and other spreadsheet programs. |
| Where are google doc spreadsheets stored? | By default, all the spreadsheets you work with in Google Docs are stored on Google's servers. |
| What special formats will export spreadsheet files in? | -Microsoft Excel (.xls or .xlsx) -Comma Separated Values (.csv) -Plain text (.txt) -Open Document Spreadsheet (.ods) |
| What is a Sheet | A sheet is within a Spreadsheet file. It is a single page or tab that contains its own spreadsheet data. |
| What do excel and google spreadsheets have in common? | Like Excel, Spreadsheets enable you to work with multiple sheets within a single spreadsheet file. 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 |
| What is a range? | A range is a group of contiguous cells in a spreadsheet. |
| Why would you need to 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. |
| What is a reference | A reference is a way of noting individual cells or cell ranges elsewhere in a spreadsheet. |
| How would you write a range? | For example, the range that starts with cell A1 and ends with B9 is written like this: A1:B9 |
| how IS DATA FORMATTED WHEN IT’S ENTERED? | BY DEFAULT, THE DATA YOU ENTER IS FORMATTED BASED ON THE TYPE OF DATA ENTERED |
| How are numbers formatted? | -If you type only numbers, the data will be formatted as a number (with no commas or dollar signs) |
| What happens when you type a dollar sign in front of a number? | -If you type a number with a dollar sign ($) in front of it, the data will be formatted as currency |
| How are alphabetical numbers formatted? | -If you type any alphabetical characters, the data will be formatted as text |
| What happens when You type numbers separated by “_” or “/? | -If you type numbers separated by the "-" or "/" characters (such as 12-31 or 1/2/12, the data will be formatted as a date |
| What happens when u type numbers separated by a “:”? | -If you type numbers separated by the ":" character (such as 2:13), the data will be formatted as time |
| how can a number be expressed? | A number can be expressed as a whole number, percent, fraction, currency, date, or exponential (scientific notation). |
| What does text formatting in google spreadsheets include? | Text formatting in Google Spreadsheets includes changing font, font size, bold, italic, underline, strikethrough and font color. |
| How can you align text? | You can align text horizontally in an individual cell left (default), right or center. |
| How can You align text vertically? | You can align text vertically (to the top, bottom, or center of the cell) or allow long text to wrap to multiple lines in a cell. |
| Can you change the cell background and add borders? | You can change the background color and add borders to any cell or range of cells within a spreadsheet. |
| How can you sort cells? | You can sort a selected range of cells. or sort all cells within selected columns. |
| How can you sort 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 by column? | When you sort by column, you sort all the cells in the spreadsheet by the selected columns. |
| Can you include multiple sub sorts when you sort by range? | When you opt to sort by range, you can include multiple sub sorts. |
| Can you include multiple sub sorts when you sort by range? | That is you sort by Column A first, by Column B next, and then by Column C. |
| What file does Google spreadsheets convert to before you print? | Google Spreadsheets converts the spreadsheet into a PDF file, which you can then print from within Adobe Reader. |
Created by:
00014780
Popular Computers sets