A spreadsheet appears as a grid - each row has its own number and each column its own letter. This labelling of rows and columns is used to give each cell a cell address or reference, for example, C5 means column C, row 5.
It is also possible to refer to a range of cells collectively, ie E4:E12 includes E4, E12 and all of the cells in-between. Spreadsheets offer a quick, easy way to display data and share it with others. You can type in data or copy it from another program and paste it into a spreadsheet, save your file and easily email it to someone else. Office workers can save a spreadsheet on their office computer network to allow other people to open the file and update various parts of it.
Spreadsheets offer the ability to store large amounts of data in one place because a spreadsheet file has more than one sheet in it. Each tab of the file is called a worksheet, and the file is called a workbook. You could store financial information, formatted into financial statements, for a small business, and use a different tab for each month of the year. You can then add another tab that uses links to summarize and add up all the data into an annual figure.
Excel is the name of the Microsoft Office spreadsheet product, but you can use it with Google, instead of using Google's spreadsheet application. One of the biggest advantages of using the Microsoft Excel spreadsheet program within Google's application Google Drive is that you can work on Excel spreadsheets online. With Microsoft Office, unless you have the online Office subscription, you will only be able to access your Excel spreadsheet files from your own computer's hard drive or network file folder.
If you want to work on Excel spreadsheets within Google drive, you can also convert your Excel spreadsheet to a Google Sheets file.
If you upload an Excel file to store in your Google Drive and try to open it, you will see a static document that will not allow you to make any changes. However, Microsoft and Google have improved their ability to work together on Microsoft Office files within Google.
Once you've installed the plug-in when you open your Microsoft Office applications, you will see a drop-down menu that says Google Drive, and it will give you various options to open, edit and save your Microsoft Office files, keeping them in the Microsoft Office format while storing them inside your Google Drive.
To get the plug-in, perform an online search in your browser for Google Drive plug-in for Microsoft Office. To create a spreadsheet within Google Sheets, make sure that you are logged into your Google account, open a browser tab, navigate to drive. Google Sheets allows you to easily collaborate with other people online once you send them a link to your spreadsheet. Before computers, a ledger was used for organizing data in order to perform calculations on it. In the rent example, you could easily add together all the figures on a column to give you the total rent paid in a given month, or you could add together all of the figures on a row to give the total rent paid by each renter.
Functions in a spreadsheet do the math for you. To perform functions you have to be able to identify specific cells. Cells in a spreadsheet can be identified by their column letter and row number. Thus the upper left corner of a sheet is cell A1. The cell directly below it is A2 and the one directly to its right is B1. To add the values recorded in these three cells you would use a function. Functions allow you not only to perform operations on individual cells but on a range of cells.
Columns, rows and cells Every cell in a spreadsheet or worksheet has a unique cell reference, which consists of a letter and a number. Entering data into a cell Data can be typed directly into a cell or into the formula bar. Data — values, usually numbers but can be letters or a combination of both. Labels — headings and descriptions to make the spreadsheet easier to understand. Formulas — calculations that update automatically if referenced data changes.
0コメント