Sorting & Charts
Sorting is different from filtering. When you are sorting, you are [BLANK] the data. All of the data is still visible and there.
What is reordering?
Filtering is different from sorting. Filtering is [BLANK] the data that doesn't meet the criteria that is set or being able to see only certain data.
What is hiding?
Define a Sparkline.
What is a Sparkline is an in-cell chart that shows trends on columns or rows of data?
Paint Brush/Roller Icon
What is Paint Format?
Italicized Letter "T" with a Right Slash Icon
What is Clear Formatting?
TRUE OR FALSE: You can remove the Legend from your chart by selecting it and pressing on delete or backspace?
What is TRUE?
How to turn off filters that are applied onto my data?
What is clicking on any cell within your data > click on the Funnel icon on the editing bar?
How to create a line Sparkline?
What is click on the cell next to the data > type "=sparkline( > select the cells to create a sparkline for > type ")"
Magnifying glass icon
What is Search icon?
Magnifying glass with a plus/cross icon
Two things that are important and you would need for a list format and sorting.
What is column headers and no blank rows?
How to turn off filter views on your data?
What is click on the Filter Views icon (Calculator) > click on the option "None"
Benefits of Formatting Data with Alternating Row Colors.
What is help you in reading your data with ease and not mixed information from one row to another?
Two brackets facing each other with two arrows facing each other as well icon
What is Merge Cells?
Funnel Icon
What is Filter(s)?
How to remove data from a chart?
What is opening the Chart Editor > Setup > Series > Click on the 3-Dot Ellipsis on that certain data that will be removed > Click on "Remove"
What is Text, Dates, and Values?
Why are Named Ranges a good idea?
What is when you’re working with groups of people who may not be so familiar with formulas, this can help simplify and help them understand what the formula is doing.
Capital Letter A with an arrow facing to the right icon
What is Text Rotation?
123 icon
What is More Formats?
Steps to doing a multi-column sort in Google Sheets.
What is select Data including column headers > Data > Sort Range > Advanced Range Sorting Options > Select Data has header row > Indicate the first column to sort > Choose if ascending or descending order > Click on "Add another sort column" to do a multilevel sort. Once you are done, click on "Sort."
How to save a filter view?
What is click on the Create a Filter icon (Funnel) to turn it on > create a condition/any filter on the sheet to your likings > click on the Filter Views icon (Calculator) > click on "Save as filter view" > Rename the Filter view name
What is a Pivot Table?
What is data that is narrowed down or summarized from a long list of data within your spreadsheet. It automatically sorts, filters, analyzes, and calculates the data into a new table?
Two parallel lines that has an arrow going from the top to the bottom/underneath icon
What is Wrapping?
∑ icon
What is functions?