|
#005 Sheets Explorer PublicDPS StaffYour skills in Sheets beg to be recognized and shared. |
| To get this badge, join it and submit the required evidence. | |
Create and ShareCreate a new Google Sheet. Fill in the first row of columns A-E with the names of five other teachers. Populate any kind of data in these columns (down at least 5 rows). Copy and paste the URL (shareable link) below. More Info |
Freeze and sortFreeze the first row of data in your sheet. Next Sort the teachers last name in alphabetical order. More Info |
Format your SheetChange the font size in your first row to 18 pt and select a nice color to fill in the first row. Apply borders to all cells that contain data. More Info |
Sheet within a SheetCreate a second sheet in that same file. Insert an image of your school mascot in any cell. Name the first sheet "Teachers" and second sheet "Mascot". Protect the "Mascot" sheet. As your evidence, upload an image of the Mascot on the second sheet with tab names visible. More Info |
Find the averageUse 1 column of data you have created and find the Average. Have the "Average" displayed in the color blue. More Info |
