Google Sheets Flashcards
How to make cells auto resize to content?
Drag curser to the cell border and double click
How do you see edit history for a specific cell
right tab on a cell and click, “view edit history”
How do you change the color of a checkbox?
Change the font color
How to swap out rows and columns?
Copy section you want to transpose. Right click and find, “paste transposed”
What are the three different types of counts that google sheets does?
=count will count all numerical values in cells
=counta will count all cells with anything in them, they don’t need to be numerical.
=countunique - will only count unique things so if you had Karah Jones twice it would only count it as 1
is it possible to show your formula on the cell and not be hidden?
yes, click = then type “formulatext” and click the cell that you want to show
You can also click View > Show formulas
Absolute reference vs relative reference
click f4 once to get absolute referencing with a dollar sign in from of like this $1$3.
copy and paste if you don’t need it duplicated?
use cut Ctrl + X and then ctrl + v
What does f4 do?
It auto adds the $ to keep absolute vs relative referencing
AND
it copies the last action you did
How to remove duplicates?
Data > Data Cleanup > remove duplicates
3 types of functions
- Functions that return ONE value like SUM, COUNT
- Functions that return multiple values like UNIQUE, SORT
- Volatile functions like TODAY, NOW, RAND, RANDBETWEEN
How do you find a very specific number using the sumifs feature?
=SUMIFS($D$5:$D$46,$B$5:$B$46,P4,C5:C46,P5)
How do you use the & feature in google sheets to make a formula show >60,000 but you want it reference a cell and not have to type out 60,000 so that it is dynamic?
Use the “>”&t4
How do you combine the data from 2 cells into 1 cell?
=”a1”&”a2”
or =”+1 “&”a2”
What are logical functions used for?
Can tell you true of false for a given data set.
Examples: You want to see if all of the numbers in a column are >100
=(A1:A99>100)
The function will pop out TRUE
What logical text are there for info?
Function
When would you use the IF function on google sheets?
If you want a certain text in a cell if it matches what you want.
When would you use the IF and AND function together?
If you have 2 things you want to see if it is true and you want specific text in the cell.
What is the formula for percent change?
=current number divided by previous number -1
=B5/C5-1
