Google Sheets

Create a new spreadsheet called "Sales Tracker"

List all my Google Sheets spreadsheets

Search for spreadsheets containing "Sales"

Get information about the "Sales Tracker" spreadsheet

Add a new sheet called "Transactions" to "Sales Tracker"

Add a new sheet called "Summary" to "Sales Tracker"

Add a new sheet called "Products" to "Sales Tracker"

Add a new sheet called "Customers" to "Sales Tracker"

Rename the sheet "Sheet1" to "Archive" in "Sales Tracker" spreadsheet

Delete the "Archive" sheet from "Sales Tracker" spreadsheet

Write the headers "Date, Product, Quantity, Unit Price, Total, Customer" to row 1 of the "Transactions" sheet in "Sales Tracker"

Write these headers to row 1 of "Products" sheet in "Sales Tracker": Product ID, Product Name, Category, Price, Stock

Write headers "Customer ID, Name, Email, Phone, City" to row 1 of "Customers" sheet in "Sales Tracker"

Write headers "Metric, Value, Change" to row 1 of "Summary" sheet in "Sales Tracker"

Read the data from A1:F1 in "Transactions" sheet of "Sales Tracker"

Read all data from the "Products" sheet in "Sales Tracker"

Add these transactions to the "Transactions" sheet in "Sales Tracker":
2025-01-15, Laptop Pro, 2, 1299.99, 2599.98, John Smith
2025-01-15, Wireless Mouse, 5, 29.99, 149.95, Jane Doe
2025-01-16, USB-C Hub, 3, 49.99, 149.97, Bob Wilson
2025-01-16, Mechanical Keyboard, 2, 159.99, 319.98, Alice Brown
2025-01-17, Monitor 27", 1, 399.99, 399.99, Charlie Davis
2025-01-17, Webcam HD, 4, 79.99, 319.96, Diana Miller
2025-01-18, Laptop Pro, 1, 1299.99, 1299.99, Eve Johnson
2025-01-18, Wireless Mouse, 10, 29.99, 299.90, Frank Garcia
2025-01-19, Headphones BT, 3, 199.99, 599.97, Grace Lee
2025-01-19, USB-C Hub, 2, 49.99, 99.98, Henry Martinez

Add these products to the "Products" sheet in "Sales Tracker":
P001, Laptop Pro, Electronics, 1299.99, 50
P002, Wireless Mouse, Accessories, 29.99, 200
P003, USB-C Hub, Accessories, 49.99, 150
P004, Mechanical Keyboard, Accessories, 159.99, 75
P005, Monitor 27", Electronics, 399.99, 30
P006, Webcam HD, Electronics, 79.99, 100
P007, Headphones BT, Audio, 199.99, 60
P008, Desk Lamp LED, Office, 45.99, 120
P009, Mouse Pad XL, Accessories, 19.99, 300
P010, Cable Organizer, Office, 12.99, 500

Add these customers to the "Customers" sheet in "Sales Tracker":
C001, John Smith, [email protected], +1-555-0101, New York
C002, Jane Doe, [email protected], +1-555-0102, Los Angeles
C003, Bob Wilson, [email protected], +1-555-0103, Chicago
C004, Alice Brown, [email protected], +1-555-0104, Houston
C005, Charlie Davis, [email protected], +1-555-0105, Phoenix
C006, Diana Miller, [email protected], +1-555-0106, Philadelphia
C007, Eve Johnson, [email protected], +1-555-0107, San Antonio
C008, Frank Garcia, [email protected], +1-555-0108, San Diego
C009, Grace Lee, [email protected], +1-555-0109, Dallas
C010, Henry Martinez, [email protected], +1-555-0110, San Jose

Append these new transactions to "Transactions" sheet in "Sales Tracker":
2025-01-20, Desk Lamp LED, 5, 45.99, 229.95, John Smith
2025-01-20, Mouse Pad XL, 8, 19.99, 159.92, Jane Doe
2025-01-21, Cable Organizer, 15, 12.99, 194.85, Bob Wilson
2025-01-21, Laptop Pro, 3, 1299.99, 3899.97, Alice Brown
2025-01-22, Monitor 27", 2, 399.99, 799.98, Charlie Davis

Update cell E5 in "Transactions" sheet of "Sales Tracker" to 329.98

Find and replace "Laptop Pro" with "Laptop Pro 15" in the "Transactions" sheet of "Sales Tracker"

Clear the range G1:G20 in "Transactions" sheet of "Sales Tracker"

Make row 1 in "Transactions" sheet of "Sales Tracker" bold with a light blue background

Format the header row (row 1) in "Products" sheet of "Sales Tracker" with bold text, dark blue background (#1a73e8), and white text color

Center align the headers in row 1 of "Customers" sheet in "Sales Tracker"

Add solid borders to the range A1:F11 in "Transactions" sheet of "Sales Tracker"

Add thick outer borders and thin inner borders to A1:E11 in "Products" sheet of "Sales Tracker"

Set column widths in "Transactions" sheet of "Sales Tracker": A=100px, B=150px, C=80px, D=100px, E=100px, F=150px

Set row 1 height to 35 pixels in "Transactions" sheet of "Sales Tracker"

Auto-resize columns A through F in "Customers" sheet of "Sales Tracker" to fit content

Freeze the first row in "Transactions" sheet of "Sales Tracker"

Freeze the first row and first column in "Products" sheet of "Sales Tracker"

Add alternating row colors (white and light gray) to the data range A2:F11 in "Transactions" sheet of "Sales Tracker"

Add conditional formatting to the range E2:E100 in "Transactions" sheet of "Sales Tracker": highlight cells with values greater than 500 with a green background

Add two conditional formatting rules to the range E2:E100 in "Products" sheet of "Sales Tracker": 
1. Red background for cells with values less than 50
2. Yellow background for cells with values less than 100

Format the range D2:E100 in "Transactions" sheet of "Sales Tracker" as USD currency ($#,##0.00)

Format the range D2:D100 in "Products" sheet of "Sales Tracker" as USD currency

Format the range C2:C50 in "Summary" sheet of "Sales Tracker" as percentage with 2 decimals

Add a SUM formula in cell E12 to total all values in E2:E11 in "Transactions" sheet of "Sales Tracker"

Add an AVERAGE formula in cell E13 to calculate average of E2:E11 in "Transactions" sheet of "Sales Tracker"

Add COUNT formula in cell C12 to count all transactions in "Transactions" sheet of "Sales Tracker"

Sort the data in "Transactions" sheet of "Sales Tracker" by Total (column E) in descending order

Sort "Products" sheet in "Sales Tracker" by Category (column C) ascending, then by Price (column D) descending

Add a dropdown list to column C in "Transactions" sheet of "Sales Tracker" with values: Laptop Pro 15, Wireless Mouse, USB-C Hub, Mechanical Keyboard, Monitor 27", Webcam HD, Headphones BT, Desk Lamp LED, Mouse Pad XL, Cable Organizer

Add number validation to column C (Quantity) in "Transactions" sheet of "Sales Tracker": only allow numbers between 1 and 100

Add checkbox data validation to column F (In Stock) in "Products" sheet of "Sales Tracker"

Create a named range called "TransactionTotals" for column E (E2:E100) in "Transactions" sheet of "Sales Tracker"

Create a named range called "ProductPrices" for D2:D11 in "Products" sheet of "Sales Tracker"

Create a filter view for the "Transactions" sheet in "Sales Tracker" covering columns A through F

Create a column chart showing Products (column B) vs Total Sales (column E) from the "Transactions" sheet in "Sales Tracker". Place it starting at cell H2.

Create a pie chart showing the distribution of sales by Product from "Transactions" sheet in "Sales Tracker"

Create a line chart showing daily sales trends using Date (column A) and Total (column E) from "Transactions" sheet in "Sales Tracker"

List all charts in the "Sales Tracker" spreadsheet

Protect the header row (A1:F1) in "Transactions" sheet of "Sales Tracker" with warning only

Protect the formulas in cells E12:E13 in "Transactions" sheet of "Sales Tracker"

Share the "Sales Tracker" spreadsheet with [email protected] as an editor

Share "Sales Tracker" with [email protected] as a viewer

Add these new transactions to the "Returns" sheet in "Sales Tracker". If the Returns sheet doesn't exist, create it first:
2025-01-22, Wireless Mouse, 1, 29.99, Defective, Jane Doe
2025-01-23, USB-C Hub, 1, 49.99, Wrong Item, Bob Wilson
2025-01-24, Headphones BT, 1, 199.99, Changed Mind, Grace Lee

Create a new sheet called "Monthly Report" in "Sales Tracker", add headers "Month, Revenue, Expenses, Profit, Margin", and format the header row with bold text, navy background, white text, and center alignment

In the "Summary" sheet of "Sales Tracker":
1. Write these labels in column A starting at A1: Metric, Total Revenue, Transaction Count, Average Sale, Top Product, Total Customers
2. Add appropriate formulas in column B to calculate these metrics from the Transactions and Customers sheets
3. Format the header row with bold and light gray background
4. Add borders around all cells with data
5. Set column A width to 150px and column B to 120px

Set up a dashboard in the "Summary" sheet of "Sales Tracker":
1. Clear any existing data
2. Add title "Sales Dashboard" in A1, merge cells A1:C1, make it bold with font size 18
3. Add these KPI sections starting at A3:
   - Total Revenue (with SUM formula from Transactions)
   - Number of Transactions (COUNT)
   - Average Order Value (AVERAGE)
   - Total Products (COUNT from Products sheet)
   - Total Customers (COUNT from Customers sheet)
4. Format KPI labels with bold text
5. Format KPI values as currency where applicable
6. Add a column chart showing Top 5 Products by Revenue
7. Freeze the first row

Copy all data from "Transactions" sheet to a new sheet called "Transactions Backup" in "Sales Tracker". Then add data validation to the original Transactions sheet: 
- Column B: dropdown with product names from Products sheet
- Column C: numbers only, 1-1000
- Column F: dropdown with customer names from Customers sheet

Read data from the "NonExistent" sheet in "Sales Tracker"

Format cells in a spreadsheet called "Does Not Exist"

Add 100 rows of sample transaction data to "Transactions" sheet in "Sales Tracker"

Add a product called "USB-C to HDMI™ Adapter (2-pack)" with price $24.99 to the "Products" sheet in "Sales Tracker"

Add a customer named "José García-López" with email "[email protected]" to "Customers" sheet in "Sales Tracker"

Add an ARRAYFORMULA to automatically calculate Total (Quantity × Unit Price) for all rows in column E of "Transactions" sheet in "Sales Tracker"

Add a VLOOKUP formula in "Transactions" sheet to automatically pull the product price from "Products" sheet based on the product name