Test Your Knowledge on Spreadsheets Question Title * 1. Date OK Question Title * 2. First Name OK Question Title * 3. Last Name OK Question Title * 4. Age 15-25 25-35 35-50 50+ OK Question Title * 5. Educational Institution High School College Other (please specify) OK Question Title * 6. School Name OK Question Title * 7. School Location City State / Province Country OK Question Title * 8. What's the name of the Google Spreadsheets App? OK Question Title * 9. Is a Column vertical or horizontal? Vertical Horizontal OK Question Title * 10. Is a Row vertical or horizontal? Vertical Horizontal OK Question Title * 11. What tasks can you perform from the Function icon SUM NUMBERING SHADING AVERAGE BOLDING OK Question Title * 12. How would you select an entire column or row? Double click on a single cell Select a range of cells Click on the letter or number of the corresponding column or row OK Question Title * 13. List in correct order the steps for AVERAGING your data 1 2 3 4 5 6 Select the first cell to average 1 2 3 4 5 6 Hit enter and the Average result is displayed 1 2 3 4 5 6 Give the heading name Average to the column 1 2 3 4 5 6 Select the cells which have the data that will contribute to the AVERAGE amount 1 2 3 4 5 6 Go to tool bar menu, select the Function icon, and choose AVERAGE 1 2 3 4 5 6 AVERAGE is displayed at the first selected cell OK Question Title * 14. If you insert a column or row what do you need to check in your spreadsheet? The font size The data range of the function includes new column or row Page numbering OK DONE