About This Book "Google Sheets in 8 Hours" is a textbook for high school and college students; it covers all essential Google Sheets language knowledge . You can learn complete primary skills of Google Sheets programming fast and easily . The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam . "Google Sheets in 8 Hours" is a useful textbook for beginners . The straightforward definitions, the plain examples, the elaborate explanations and the neat layout feature this helpful and educative book . You will be impressed by its distinctive and tidy writing style . Reading this book is a great enjoyment ! Note This book is only suitable for Google Sheets programming beginners, high school students and college students; it is not for the experienced Google Sheets programmers. Table of Content Hour 1 What are Google Sheets? Start Google Sheets Description of Spreadsheet Cell Coordinate Multiple Sheets Calculation Calculate by Coordinates (1) Calculate by Coordinates (2) Name Box Selection Hour 2 Select a Range (1) Select a Range (2) Select a Range (3) Enlarge Selection Fill Values Fill the Sequence Fill Characters & Numbers Fill Calculating Results Quick Menu Move Data Copy & Paste Data Cut & Paste Data Delete Data Hour 3 Add a Row Add a Column Undo & Redo Formulas Show/Hide Formulas Addition & Substraction Multiplication & Division Relative Reference Absolute Reference Hour 4 Format Format Color Format Border Format Number Format Painter Format Alternating Colors Remove Formatting Hour 5 Single Color Formatting Color Scale Formatting Remove Gridlines Sort Sheet in Ascending Order Sort Sheet in Descending Order Sort Range in Ascending Order Sort Range in Descending Order Hour 6 AND AVERAGE AVERAGEIF COUNT COUNTA COUNTBLANK Review Functions Hour 7 COUNTIF IF IFS MAX MEDIAN MIN Review Functions Hour 8 MODE OR SUM SUMIF SUMIFS XOR Review Functions Google Sheets Questions & Answers Questions Answers