Explanation
A cloud-based tool called Google Sheets offers sophisticated, quick, and online spreadsheets. With tools that were created with simplicity and collaboration in mind, you can work with your team from any online device to manage task lists, analyse data with charts and filters, and more. Every update is automatically saved in one location. Create, edit, and collaborate anywhere with Google Sheets.
What you’ll discover
You use Sheets to complete the following tasks in this lab:
- Make, modify, and personalise a spreadsheet
- data analysis
- Give a spreadsheet away
- access spreadsheet data from other apps
Note: You must instal Google Sheets in order to utilise it on an Android smartphone.
Install Google Sheets on your iOS device to start using it.
setup and prerequisites
Earlier than pressing the Start Lab button
Read the directions here. You cannot halt a lab since it has a time limit. The length of time that you will have access to Google Cloud resources is indicated by the timer, which starts when you click Start Lab.
You can complete the lab exercises in this hands-on lab on your own in a genuine cloud environment rather than a simulation or demo one. It does this by providing you with fresh, temporary login credentials that you use for the length of the lab to log in and access Google Cloud.
You require: to complete this lab.
access to a common web browser (Chrome browser recommended).
begin your lab
Click Start Lab in the upper left panel when you are ready.
Find the User Email and Password for your lab.
Find the User Email and Password on the left panel to access the lab’s resources and console. The login information for Google Drive is as follows.
These will also be visible on this panel if your lab needs any additional resource identifiers or connection-related information.
Register with Google Sheets
- Click the Google Sheets button.
Opening the tabs in separate windows side by side is a good idea. Opening the tabs in separate windows side by side is a good idea.
- Take note of the pre-filled User Email box. Choose Next.
- After entering your password, click Next.
- As asked, agree to all terms and conditions.
As soon as Google Sheets loads, your student Google Account is logged in.
Open an example spreadsheet for task one.
Task 1: Launch a model spreadsheet
To launch a test spreadsheet:
- A example spreadsheet can be opened by clicking Explore this data.
- Create a copy. Choose File > Make a copy.
- Click Make a copy after leaving the Name and Folder fields’ default values alone.
To check if you’re on track, click Check my progress.
Investigate the spreadsheet.
You can use Sheets to perform data analysis:
- To access the Explore panel, click Explore in the lower right corner of the spreadsheet.
- Enter the following queries in the Ask about this data area in the Answers section:
- “department that received the greatest actual sum”
- What number of distinct departments
3. Consider posing a few of your own inquiries to see what data Sheets can offer.
Data export
To utilise later in this lab, export the spreadsheet data to your local device.
- choose “File” > “Download” and then “Comma-separated values” (.csv).
- To close this spreadsheet, close the browser tab.
- If the original Explore this data worksheet (budget requests by department) is still open, close it as well.
The remaining browser tabs or windows are only open to these lab instructions and Sheets.
4. Find and rename the.csv file exported-data that you downloaded to your local computer.
2nd task: A spreadsheet import
Data from other spreadsheets can be readily imported and converted into Sheets.
In this phase, you import the exported-data.csv data file to your Drive and use Sheets to open it in order to create a new spreadsheet.
- Open a new browser tab and go to Google Drive.
- To upload a file, select New in the upper left corner.
- To add a file to Drive, select exported-data.csv from your computer.To add a file to Drive, select exported-data.csv from your computer.
You can also drag the csv file from your local computer to your Drive as an alternative. You can also drag the csv file from your local computer to your Drive as an alternative.
- Exporting data from a CSV file to a Google Sheet:
Right-click exported-data.csv in Drive.
Choose Google Sheets under Open with.
Sheets makes a copy of the original spreadsheet file in Sheets format when you import or convert it. The new file can then be edited in your browser just like any other Sheet.
Have spreadsheets of different types? Try importing it into Drive and then changing it to a Google Sheet if that’s the case.
Note: The following file types are supported:.xls,.xlsx,.xlt,.ods,.csv,.tsv,.txt, and.tab.
You can change spreadsheets that have been uploaded into Drive using Microsoft® Excel® without having to switch to Sheets.
To check if you’re on track, click Check my progress.
3. Produce your spreadsheet.
This section teaches you how to:
- Data entry and editing
- Make your spreadsheet unique.
- Utilise columns, rows, and cells.
- Use numerous sheets of paper
Make a spreadsheet.
Make a fresh spreadsheet.
- Visit the MyDrive browser tab once again.
- Google Sheets can be chosen by clicking the Google applications icon.
- To create a new template, click the + sign in the Start a new spreadsheet area.
Data entry and editing
- Click Untitled spreadsheet, then type important-data to rename your spreadsheet.
- Enter a header row and data by clicking inside a cell, entering any text, and then clicking outside the cell.
An illustration spreadsheet
The figures in column C of the spreadsheet sample above have a currency format applied, as you can see. This requires that you:
- Choosing the C column.
- In the menu bar, select Format > Number > Currency.
3. Add additional items by selecting Insert and experimenting with charts, pictures, sketches, functions, notes, and other elements.
4. (Optional) To examine your spreadsheet, utilise the Explore function.
- Try out different analysis ideas.
- Is it possible to add a pie chart to your spreadsheet?
Make your spreadsheet unique.
Use the spreadsheet you created in the last step to experiment. Your spreadsheet’s cells can be formatted after being selected using the choices on the toolbar.
Utilize columns, rows, and cells.
- Choose a cell or block of cells to add rows, columns, and cells to. Next, click Insert in the menu bar and select where to add the row, column, or cells.
- Right-click the row number or column letter and choose “Delete” or “Hide” to remove or hide rows and columns.
- Delete a cell or a group of cells by choosing the desired cells. Shift to the left or right while selecting Edit > Delete cells, respectively.
- Move columns and rows by clicking the row number or column letter. After that, move it somewhere else.
- Keep some data in the same location as you browse through the remainder of your spreadsheet by freezing the header rows and columns. Select an option by clicking View > Freeze in the menu bar.
Make use of several sheets.
Renaming a sheet:
- Double-click Sheet1 at the bottom of your spreadsheet.
- Change the name of the highlighted item to Overview.
Put in a sheet:
- Click Add Sheet (+) to add a new sheet in the bottom left of your spreadsheet.
- Give this sheet a detail name.
Copies of sheets:
- Click the down arrow next to Detail at the bottom of your spreadsheet.
- Choose Duplicate.
Removing a sheet:
- Click the down arrow next to Copy of Detail at the bottom of your worksheet. Choose Delete.
- To confirm, click OK.
To check if you’re on track, click Check my progress.
4. Share and work together
Give your staff or anyone outside of your company access to your spreadsheet. People can make changes simultaneously when working together, and you can watch those changes as they take place.
This section teaches you how to:
- Distribute spreadsheets
- Stop sharing spreadsheets
- Add responses and comments
- converse with others directly
Distribute spreadsheets
Send a file or folder to a specified person or group:
Only documents that you control or have permission to modify may be shared.
- Select Share in Sheets’ upper right corner while using the same important-data file.
- Under Share with persons and groups, enter the email address of the person or group you wish to share with.
- On the right, select Editor, then select the access level:
- Editor: Participants may contribute content, edit it, and provide comments.
- Collaborators can add comments but cannot alter the text (Only for selected files).
- Viewer: Users may browse the file but not change it or leave comments.
4. Select Send.
A link to the file or folder is sent through email to each person you share it with.
5. Enter your note here to add a note to the email (optional). The Notify people option can be unchecked to forego sending an email.
Share a file or folder link:
Send links to files or directories so that anyone with the link can access them. A link that you share lists you as the owner.
Only files that you own or have access to change can be shared.
- Select Share in Sheets’ upper right corner.
- Select Qwiklabs by clicking Restricted.
- Select the access level by clicking Viewer (to the right of Qwiklabs):
- Editor: Participants may contribute content, edit it, and provide comments. Editor: Participants may contribute content, edit it, and provide comments.
- Collaborators can add comments but cannot alter the text (Only for selected files).
- Viewer: Users may only view the file; they may not change it or leave comments.
4. The Copy link button.
5. Select “Done”
6. The URL can now be pasted in an email or anywhere else you choose to distribute it.
To check if you’re on track, click Check my progress.
Stop sharing spreadsheets
Don’t distribute a file or folder that you own:
- Select the shared file or folder in Drive.
- Share can be chosen with a right-click on the file.
- Click the access level (Editor, Viewer, or Commenter) next to the person you wish to stop sharing the file or folder with and click Remove if you had successfully shared the file with that person in the previous step.
- To save changes, click.
Delete a connection to a folder or file you control:
The only individuals who can still access a link to a file or folder that you own after you remove it are you and anyone you shared it with.
- Share can be selected by right-clicking a file or folder in Drive.
- Restricted can be chosen by clicking Qwiklabs.
- Select “Done”
Add responses and comments
1: Choose the cell or cells in an open spreadsheet that you want to remark on.
2: Choose one of these:
- Click the comment icon in the formatting bar at the top.
- Click Comment by doing a right-click on the cell or cells.
3: Fill up the field with your comment.
4: If you want to send a task or comment to a specific person, insert their email address after the At Sign (@). You can include whatever many persons you wish. Your comment and a link to the file will be, included in an email sent to each recipient.
5: Check the Assign to box to designate a specific person as the recipient of the comment (optional).
6: Click Assign or Comment.
Use Google Chat to communicate with people directly (information only)
Google Chat also allows for real-time collaboration. To start a group chat if more than one person has your spreadsheet open, simply click Show chat.
Directly from Google Meet, present your spreadsheet (information only)
Open Google Meet directly from Sheets to present and discuss your spreadsheet with team members. Click Bring this tab to a call to start or join a meeting or join a call here.
Good luck!