Google Data Analytics Professional Certificate • STUDY MODE
Test your knowledge on working with spreadsheets
QUESTION 1 OF 12
When giving a spreadsheet a title, what are some best practices to follow? Select all that apply.
A
Titles should state what the data in the spreadsheet is aboutCorrect Answer
B
Titles should be shortCorrect Answer
C
Titles should be in ALL CAPS
D
Titles should be clearCorrect Answer
QUESTION 2 OF 12
Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.
A
filters
B
italics
C
pivot tables
D
bordersCorrect Answer
QUESTION 3 OF 12
Within a spreadsheet, data analysts use which tools to save time and effort by automating commands? Select all that apply.
A
FunctionsCorrect Answer
B
Tables
C
FormulasCorrect Answer
D
Filters
QUESTION 4 OF 12
Which of the following are examples of operators used in formulas? Select all that apply.
A
Forward slash (/)Correct Answer
B
Asterisk (*)Correct Answer
C
Hyphen (-)Correct Answer
D
Hash (#)
QUESTION 5 OF 12
In a spreadsheet, a formula should always start with which of the following operators?
A
Dash (—)
B
Colon (:)
C
Equal sign (=)Correct Answer
D
Plus-minus (±)
QUESTION 6 OF 12
What is the term for the set of cells that a data analyst selects to include in a formula?
A
Data boundary
B
Data rangeCorrect Answer
C
Cell set
D
Cell domain
QUESTION 7 OF 12
In a formula, the plus sign (+) is the operator for addition, and the hyphen (-) is the operator for subtraction.
A
TrueCorrect Answer
B
False
QUESTION 8 OF 12
Which of the following functions quickly counts how many items in a range of cells meet a given criterion?
A
The COUNTIF functionCorrect Answer
B
The TEXT function
C
The MAX function
D
The SUM function
QUESTION 9 OF 12
Data analysts use which of the following functions to quickly perform calculations in a spreadsheet? Select all that apply.
A
MINCorrect Answer
B
SUMCorrect Answer
C
MASS
D
AVERAGECorrect Answer
QUESTION 10 OF 12
What is the term for a preset command in a spreadsheet?
A
FunctionCorrect Answer
B
Quotient
C
Cell
D
Range
QUESTION 11 OF 12
You are working with spreadsheet data about a cross-country relay race. Each runner’s times are located in cells H2 through H28. To find the runner with the slowest time, what is the correct function?
A
=MIN(H2-H28)
B
=HIGH(H2-H28)
C
=MAX(H2:H28)Correct Answer
D
=LOW(H2:H28)
QUESTION 12 OF 12
When you created a complete and thorough mock SOW, which foundational pieces of content did you include? Select all that apply.
A
DeliverablesCorrect Answer
B
MilestonesCorrect Answer
C
TimelineCorrect Answer
D
ReportsCorrect Answer
E
Budget
Ready to test your recall?
When giving a spreadsheet a title, what are some best practices to follow? Select all that apply.
💡Select all 3 correct answers before submitting (0 of 3 selected).
A
Titles should state what the data in the spreadsheet is about