Team OfficeBeginner 
When you’re working on Google Sheets, you might come across data that is distinguished by color. It can be useful to sort the data by color and make the sheet look neater. For instance, take the data of students highlighted in red and green below. Red means they’ve failed a test and green means they’ve passed it.
The same data when sorted by color looks much neater and cleaner.
You may come across merged cells while working on your Google Sheets. The cells can be vertically or horizontally merged. It can look something like this.
When you have merged cells in Google Sheets, it’s difficult to sort or filter the data present in those cells. Fortunately, unmerging cells is as easy as merging them.
When preparing a presentation for a mathematics class, you may want to use fractions. You may also need to use fractions when preparing a presentation for a company. PowerPoint offers many types of fractions that you can use.
We will show you all the above methods. We will also show the respective advantages of these methods.
Let us start.
Text boxes in an MS Word document are a very useful feature. Text within a box acts as a highlight for the reader. Here, we will show you how to:
While working on Google Sheets you’d need to underline texts. There are several ways to underline a Google cell, multiple cells, and text. We will cover the many methods and how we can do it with shortcuts.
Method 1: Underlining a text string within a cell
1.1 Underlining the entire string
1.2 Underlining multiple strings in different cells
1.3 Underlining part of the text string
2.1 Underlining one cell
2.2 Underlining multiple cells at once
Lets Start.
You often come across values that you need to round off in a data set. It could be rounding up a number to the nearest two decimal points. You might need to round down a number to the nearest whole number or integer. Google Sheets provides four functions for this. Let’s cover them today.
The four main functions to round numbers are ROUND, ROUNDUP, ROUNDDOWN and MROUND.
Rounding up on Google Sheets follows the general rules as explained below:
1.1 Rounding off to the nearest whole number
1.2 Rounding off number to set decimal points
1.3 Rounding off numbers beyond the decimal point
2.1 Rounding up numbers to the next whole number
2.2 Rounding up numbers while keeping set decimal points intact
2.3 Rounding up numbers beyond decimal places
3.1 Rounding down numbers to the next whole number
3.2 Rounding down numbers while keeping set decimal points intact
3.3 Rounding down numbers beyond decimal places
Let’s go over the functions in detail.
When you’re typing in your doc, it’s strenuous to check the spelling of each and every word. It can make your writing more difficult than it has to be. Google Docs allows you to use autocorrect to make your writing process much easier. It is especially useful if you misspell a particular word frequently.
You may have several pictures in your Word document. When editing the document, the pictures move independently. If you would like them to move together, you must group them.
We will explain both methods using simple step-by-step instructions.
Let us begin.