UNIT NO.4
Google Sheets
(Solved Exercise)
C. Answer the following short questions:
1. What is Google Sheets?
Google Sheets is a widely used spreadsheet program. It is free online web-based spreadsheet application that is linked with Google Account. It is developed by Google Corporation to run in web browser.
2. Why do we use Google Sheets?
Google Sheets is a popular online spreadsheet platform that offers a range of benefits and uses. We use Google Sheets for its real-time collaboration, cloud-based accessibility, automatic saving, and sharing features, making it ideal for data management, analysis, and teamwork.
3. What are the applications of Google Sheets?
Google Sheets is typically used for:
- Data storage
- Data analytics
- Project management
- Finance and accounting
- Visuals and graphs
- Programming
- Print and download
- Financial modelling
4. How to create new sheets in Google Sheets?
To create a new sheet in Google Sheets:
1. Open your Google Sheets document.
2. At the bottom right, click the “+” button next to existing sheet tabs.
3. A new sheet will be added to your document.
5. How to select multiple cells in Google Sheets?
By left-clicking the cells while holding down Ctrl or Command, you can select multiple cells at once. Once
completed with selecting, you can let go of Ctrl or Command.
6. What are the formulas in Google Sheets? Write any three examples.
A formula in Google Sheets is used to do mathematical calculations. Formulas always start with an equal sign (=) typed in the cell, followed by your calculation.
Formulas can be used for calculation such as:
- =1+1
- =2*2
- =4/2
7. What are the differences between Google Sheets and Excel?
| Google sheets | Excel |
| 1. Google LLC developed Google sheets. | 1. Microsoft Corporation developed MS Excel. |
| 2. The launched Google Sheets as a pack of G Suite in 2006. | 2. They launched MS Excel as a pack of MS Office in 1987. |
| 3. We can use Google Sheets both online as well as offline modes. | 3. We can use Excel in offline mode only. |
| 4. Google Sheets is available in 83 languages. | 4. Excel is available in 91 languages. |
| 5. It uses Google Drive. | 5. It uses One Drive. |
| 6. It is better for small volumes of data. | 6. It is better for large volumes of data. |
8. What makes Google Sheets better then Excel?
- It is easy to acquire and to get started.
- Multiple users can work on the same sheet at once.
- Links can also be shared with anyone.
9. How can you use a formula to fill out a whole row?
You can use a formula to fill out a whole row. Just select cell A1, position the cursor in the bottom right corner, hold and drag the Fill handle.
D. Answer the following long question:
1. Write a detailed note on Google Sheets range.
The range is an important part of Google Sheets because it makes you work with selections of cells.
There are four different operations for selection;
- Selecting a Cell
- Selecting Multiple cells
- Selecting a Column
- Selecting a Row
Selecting a Cell
Cells are pointed by clicking them with the left mouse button or by navigating to them with the keyboard arrows. When you click on a cell or point it from the keyboard arrow, it is selected. A bold blue rectangle around the cell shows that this cell is selected.
Selecting Multiple Cells
By left-clicking the cells while holding down Ctrl or Command, you can select multiple cells at once. Once completed with selecting, you can let go of Ctrl or Command.
Selecting a Column
Columns are selected by left-clicking on Column Headers. This will select every sheet cell that is connected to the column.
To select column A, click on the letter A in the column bar.
Selecting a Row
Rows are selected by left-clicking on Row Headers. This will select all the cells in the sheet linked to that row.
To select row 1, click on number 1 in the row bar.
Selecting the Entire Sheet
The all-inclusive spreadsheet can be carefully chosen by clicking on the rectangle in the top-left corner of the spreadsheet. Now, the whole spreadsheet is selected.
2. Explain the Ribbon in the Google Sheets.
In Google Sheets, the “Ribbon” is not the official term, but it refers to the interface at the top of the screen that provides access to the main features and tools. This interface includes several key components:
Menu Bar
The Menu bar contains different menus like File, Edit, View, etc. The menus are groups of commands grouped based on their functionality.
For example, the File menu will show the commands related to File actions like creating a new file, opening a file, saving a file, etc.
Toolbar
The most common actions from the menu are on the Toolbar. You can activate any command from the toolbar with a single click.
Groups of Commands in Toolbar
The Toolbar’s Groups are collections of related commands. The slim break in the perpendicular line divides the groups.
Commands
The buttons you press of perform actions are known as Commands.