0
0
Google Sheetsspreadsheet~20 mins

Chart customization (title, legend, colors) in Google Sheets - Practice Problems & Coding Challenges

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Challenge - 5 Problems
🎖️
Chart Customization Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
📊 Formula Result
intermediate
2:00remaining
What is the effect of this chart title formula?
You have a chart in Google Sheets with the title set by the formula =CONCATENATE("Sales Report - ", TEXT(TODAY(), "MMMM YYYY")). What will the chart title show if today is June 15, 2024?
Google Sheets
=CONCATENATE("Sales Report - ", TEXT(TODAY(), "MMMM YYYY"))
ASales Report - June 2024
BSales Report - 15 June 2024
CSales Report - 2024
DSales Report - 06/15/2024
Attempts:
2 left
💡 Hint
The TEXT function formats dates. "MMMM YYYY" means full month name and year.
❓ Function Choice
intermediate
2:00remaining
Which function changes the chart legend position in Google Sheets?
You want to move the legend of a chart to the bottom in Google Sheets using the chart editor. Which option correctly describes how to do this?
ARight-click the legend and drag it to the bottom manually.
BUse the formula =SETLEGENDPOSITION("Bottom") in a cell.
CIn the chart editor, go to 'Customize' > 'Legend' and select 'Bottom' from the position dropdown.
DChange the legend position by editing the chart's data range.
Attempts:
2 left
💡 Hint
Legend position is set in the chart editor under customization options.
🎯 Scenario
advanced
3:00remaining
You want to set custom colors for each data series in a Google Sheets chart. How do you do it?
You have a line chart with three data series. You want the first series to be red, the second green, and the third blue. What steps do you take in Google Sheets to apply these colors?
AUse the formula =COLOR_SERIES({"red", "green", "blue"}) in a cell to set colors.
BOpen the chart editor, go to 'Customize' > 'Series', select each series from the dropdown, and pick the desired color for each.
CChange the cell background colors of the data range to red, green, and blue respectively.
DRight-click each line in the chart and select 'Change color' from the context menu.
Attempts:
2 left
💡 Hint
Series colors are set in the chart editor under the Series section.
📊 Formula Result
advanced
2:00remaining
What happens if you set a chart title to a cell with a formula that returns an empty string?
You link a chart title to cell A1, and cell A1 contains the formula =IF(B1>100, "High Sales", ""). If B1 is 50, what will the chart title show?
Google Sheets
=IF(B1>100, "High Sales", "")
AThe chart title will show "" (two double quotes).
BThe chart title will show "0".
CThe chart title will show "FALSE".
DThe chart title will be blank (no text shown).
Attempts:
2 left
💡 Hint
An empty string means no visible text.
❓ data_analysis
expert
3:00remaining
Analyzing legend visibility with multiple series
You create a stacked bar chart with 4 data series. You want to hide the legend for the third series only, but keep legends for the others visible. Which statement is true about Google Sheets chart customization?
AGoogle Sheets does not allow hiding legend entries for individual series; the legend is shown or hidden for all series only.
BYou can hide the legend for the third series by unchecking it in the chart editor's Legend section.
CYou can hide the third series legend by setting its color to white in the Series section.
DYou can hide the third series legend by deleting the series from the data range.
Attempts:
2 left
💡 Hint
Legend visibility is controlled globally in Google Sheets charts.