Cell-ebrity Sightings
What's the meeting point of a column and a row in a spreadsheet?
Cell
What does CSV stand for in Excel and Google Sheets?
Comma-Separated Values
What year was Coefficient founded?
2020
How do you create a drop-down list in both Google Sheets and Excel?
Data validation
This is an all-in-one workspace and collaboration platform that allows individuals and teams to organize, plan, and manage their work.
Notion
In Excel or Google Sheets, what keyboard shortcut is used to copy selected cells?
Ctrl+C
In spreadsheet terms, what does the acronym VLOOKUP stand for?
Vertical lookup
What milestone did we just hit?
2M ARR!
What keyboard shortcut allows you to quickly format a cell as currency in Excel?
Ctrl + Shift + $
This company provides a cloud-based platform for creating, organizing, and collaborating on relational databases. Their product combines the flexibility of a spreadsheet with the complexity of a database, allowing users to build custom applications, manage projects, and streamline workflows in a visually intuitive manner.
What is the function to count cells meeting a condition in both Excel and Google Sheets?
COUNTIF
What Excel feature allows you to quickly format a range of cells based on specified criteria?
Conditional Formatting
What is the mathematic definition of Coefficient?
a numerical or constant quantity placed before and multiplying the variable in an algebraic expression (e.g. 4 in 4x y).
This feature allows you to quickly repeat the last action you performed in Excel.
F4
This is an accounting software designed for small and medium-sized businesses to manage their financial operations.
Quickbooks
What function is used to find the highest value in a range in Excel or Google Sheets?
=MAX()
What is the colloquial term for an error in a spreadsheet formula that occurs when a cell reference is not valid?
#REF!
This Excel function helps you find the position of a value in a range.
Match
This is an all-in-one marketing platform that primarily focuses on email marketing services. It allows businesses and individuals to create, send, and automate email campaigns.
What symbol do you need to use to lock a specific cell in a formula to ensure it doesn't change when copied to others cells?
$
What is the term for a small, interactive visual representation of data in a cell in Excel or Google Sheets?
Sparkline
Where did Tommy & Navneet meet?
A small startup - Shopkick in 2010! Tommy interviewed and hired Navneet!!
In Google Sheets, how can you automatically fill down a formula in a column as new data is added?
ARRAYFORMULA
This is a platform designed to help sales teams manage their processes and deals more effectively. It provides a visual and user-friendly interface that allows users to track and organize leads, deals, and contacts through customizable pipelines, facilitating efficient sales pipeline management.
Pipedrive