Google Spreadsheets

Course Content

Google Spreadsheets

Google Spreadsheets

1. Introduction to Google Sheets

Why do you need Google Sheets?Creating Google Sheets Opening Google Sheets Renaming Google Sheets Copying Google Sheets Deleting Google Sheets Moving Google Sheets Downloading Google Sheets

2. Formatting of Cells and Ranges

Basic Editing Operations Formatting Data Working with Fonts Formatting Text and Filling with Color Formatting Borders Merging Cells and Text Alignment Clear Formatting and Paint Format Tools Selecting Cells and Ranges Adjusting Column and Row Size and Position Copying and Deleting Columns and Rows Freezing and Grouping Rows and Columns

3. Advanced Formatting of Cells

Splitting Text to Columns Trimming Whitespaces Inserting Internal and External Hyperlinks Autocompleting Cells Creating Checkboxes Creating Forms Adding Notes Adding Images Creating Drawings Challenge: Mastering Event Planning Challenge Challenge: Your Event, Your Plan

4. Sorting, Filtering and Cleaning Data

Find and Replace Sorting Range Searching Filter and Filter by Condition Custom Filter Views Conditional Formatting and Color Scale Using Slicers Named Range Removing Duplicates Challenge: Library Book List Management

5. Creating Charts

Line Chart Basic Chart Settings Chart Style and Chart and Axis Titles Legend, Gridlines and Ticks Horizontal and Vertical Axis Customization Area Chart Columns and Stacked Columns Pie Chart Challenge: Data Visualization Sprint Sales Insights

6. Basic Functions

Basic Calculations Arithmetic Functions Statistical Functions Rounding Functions Working with Numbers and Integers Working with Roots and Powers Random Number Generation Text Functions Working with Dates and Time Sort Function Challenge: Sales Visualization Trends and Analytics

7. Logical Functions

AND and OR Functions IF and Nested IF Functions IFS Function SUMIFS, COUNTIFS and AVERAGEIFS Challenge: Employee Performance and Payroll Analysis with Excel Functions

8. Collaboration and Security

Access Control and Real-Time Document Collaboration Notification Rules Chatting with Other Users Protecting Sheets and Ranges Comments and Google Meet Integration Version History and Data Recovery

Working with Roots and Powers

The SQRT function calculates the square root of a number. It returns a positive value that, when squared, equals the original number. This function is useful for geometric calculations, speed or acceleration measurements, and other mathematical operations involving squares and roots.

Syntax and Examples

SQRT(value)

value - The number for which the positive square root is to be calculated;
- value must be non-negative; if it is negative, SQRT will return a #NUM! error.

Formula	Result	Comment
SQRT(16)	4	The square root of 16 is 4, as 4×4=16.
SQRT(10)	3.162	The square root of 10 is approximately 3.162, as 3.162×3.162 = 10.
SQRT(0)	0	The square root of 0 is 0, as 0×0=0.
SQRT(-16)	#NUM!	The square root of a negative number −16-16 is undefined in real numbers, returning #NUM!.
SQRT(100/60)	1.290994449	Used for speed calculations, where 100 is the distance and 60 is the time in hours.
SQRT(3^2 + 4^2)	5	Finds the hypotenuse of a triangle with sides of 3 and 4. The sum of squares (9+16=25), √25=5.

Calculating Powers

The POWER function raises a number to a specified exponent. This is useful for calculations involving progressions, scaling, compound interest, and any operations requiring exponentiation.

Syntax and Examples

POWER(base, exponent)

base - The number to be raised to the power of the exponent;
exponent - The power to which the base is raised.

Formula	Result	Comment
POWER(3, 2)	9	3 squared is 9, as 3×3=9.
POWER(3, 1.5)	5.196	3 raised to the power of 1.5 is approximately 5.196.
POWER(3, 0)	1	Any number raised to the power of 0 equals 1.
POWER(0, 3)	0	0 raised to any positive power equals 0.
POWER(3, -2)	0.1111111111	3 to the power of -2 equals 1/3² ≈ 0.111.
POWER(-8, 1/3)	-2	The cube root of -8 is -2, as (-2)×(-2)×(-2) = -8.

Everything was clear?

Thanks for your feedback!

Section 6. Chapter 6

some-alt