Formulas and Functions
The symbol you type first to start a formula in Excel/Google Sheets
=
This term refers to each rectangle in an Excel sheet or Google Sheet
a cell
True or false: you must manually draw your chart in Excel and Google Sheets
False
This is how you make text bold
Highlight your desired cells and click the B in the toolbar, or press Ctrl+B as a keyboard shortcut
This is what KPI stands for
Key Performance Indicator
A function that adds up a range of numbers
=SUM()
The term for a group of cells in row/s and/or column/s that you select or put into a formula
a range
This type of chart shows parts of a whole
Pie chart
This is how you center align a cell's content
Highlight desired cell, then press Ctrl+Shift+E in Google Sheets
True or False: a KPI helps measure progress towards a goal
True
The formula to find the average of cells A1 to A5
=AVERAGE(A1:A5)
The tab you would click to create a chart
Insert
This type of chart is best for comparing values across categories
Bar chart
This is how you change the number to a currency format
Highlight desired cells, then click "$" in the toolbar, or use the Format Cells tab
Which could be a KPI?
a. Favorite color
b. Monthly sales
c. Type of font used
Monthly sales
The function that returns the highest number in a range of cells
=MAX()
This term refers to the bar that shows what is in a cell
Formula bar
This is what you click to insert a chart in Excel or Google Sheets
The Insert tab
This is how you color a cell's background
Highlight desired cells, then click the paint bucket icon and choose your color
Where might you see KPIs used?
a. Sports scores
b. Business dashboards
c. School report cards
d. All of the above
This formula adds the values of cells in A1 and B1
=A1+B1
This is the file extension that Excel usually uses. This is the same default file extension if you download a Google Sheet to your computer
.xlsx
This is how you select the data that will appear in your chart
Highlight the cells you want to include before clicking Insert for your chart
This is how you change the text in a cell's color
Highlight desired cells, then click the "A" in the toolbar and choose your color
This KPI would be useful in a goal of increasing website visits
Number of website visitors