Product Description:

Designed with the busy professional in mind, this 4-page quick reference guide provides step-by-step instructions in Google Sheets. When you need an answer fast, you will find it right at your fingertips with this Google Sheets Quick Reference Guide. Clear and easy-to-use, quick reference guides are perfect for individuals, schools, businesses, and as supplemental training materials.

Topics Covered:

The Worksheet Environment The Worksheet Environment

The Google Sheets Home Screen Accessing Settings and Other Apps Viewing and Hiding Templates Using Search Viewing, Filtering, and Sorting

File Management Basics Creating New Spreadsheets Naming Spreadsheets Opening Spreadsheets Importing Files Into Google Sheets Saving, Copying, Exporting, Closing Deleting Spreadsheets

Data Entry Selecting Cells Entering New Data Using Auto Fill for Data Entry Using Smart Fill

Formulas Understanding Formulas Ranged Formula Syntax Simple Formula Syntax Entering a Formula Understanding 3D Formulas Ranged 3D Formula Syntax Simple 3D Formula Syntax Entering a 3D Formula Inserting Functions Editing a Range in a Formula Viewing and Hiding Formulas Using Auto Calculate

Copying and Pasting Formulas Relative vs. Absolute Cell References Cutting, Copying, and Pasting Using "Drag and Drop" to Cut and Paste Auto Filling Formula Cells Using Undo and Redo

Adjusting Columns and Rows Selecting Columns, Rows, and Worksheets Resizing Column Width/Row Height Inserting and Deleting Columns and Rows Hiding Columns and Rows Freezing Columns and Rows

Formatting Worksheets Formatting Text, Shading, and Borders Formatting Number Cells Aligning and Merging Cells Rotating Text Copying Cell Formatting Clearing Cells and Cell Formatting

Inserting Worksheets Objects Inserting a Link Inserting Comments Inserting a Chart

Worksheet Tools Inserting and Deleting Worksheets Navigating Worksheets Renaming Worksheets Coloring Worksheet Tabs Moving and Copying Worksheets Protecting Worksheets and Ranges Hiding Worksheets

Sorting and Filtering Data Sorting Data Filtering Data Creating Filter Views

Printing Printing Worksheets Adjusting Page Breaks

Keyboard Shortcuts Navigating Worksheets Selecting Cells, Columns, and Rows Entering Data Other Common Functions