Google Sheets - Fundamentals
Basic formulas, references, conditional formatting, sorting, filtering, data validation
1Which cell reference designates the cell located in column B, row 5?
Which cell reference designates the cell located in column B, row 5?
Answer
In Google Sheets, cell references always use the column letter followed by the row number. Column B with row 5 therefore gives B5. This notation allows for precise identification of each cell in a spreadsheet.
2What is the difference between a relative reference (A1) and an absolute reference ($A$1)?
What is the difference between a relative reference (A1) and an absolute reference ($A$1)?
Answer
A relative reference automatically changes when copied to other cells, adapting to the new position. An absolute reference remains fixed regardless of where the formula is copied. Dollar signs lock the column and row, which is essential for referencing constant values in calculations.
3Which formula calculates the sum of values from A1 to A10?
Which formula calculates the sum of values from A1 to A10?
Answer
The SUM function adds all numbers in a specified range. The correct syntax uses a colon to define a continuous range of cells. This function is one of the most commonly used to quickly aggregate numerical data without having to add them manually one by one.
Which function calculates the average of a range of cells?
What does the COUNT function do in Google Sheets?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
Power BI - Fundamentals
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free