Notas de lectura
Lecture 1-16 Notes
- Grado
- Institución
These notes are really detailed and hold a lot of information. That will be useful for school and helping you study for the class.
[Mostrar más]Vista previa 1 fuera de 3 páginas
Vista previa 1 fuera de 3 páginas
Añadir al carrito
Añadir al carrito
Vendedor
Seguir
madelynhed2002
Vista previa del contenido
Google Workspace: SheetsCTE 1210
This lesson is designed for students to learn how to create & format spreadsheets using Google Sheets. In this
lesson, students will:
● Build, organize, and format spreadsheets
● Evaluate and interpret data
● Use filters, functions, and charts to organize data
What to do: Using this file, follow the steps below to complete the work. Add your responses directly to this doc
and submit this doc back to Blackboard when finished. Please make sure you are using your UCM Google
Account, not a personal account!
Step 1: Watch the following video and complete the tasks below: Introduction to Google Workspace: Sheets
1. Log into your UCM Google account
2. Make a copy of this starter file.
3. Rename your project using your last name and course section. Example: Gremaud_CTE 1210 online
Step 2: Watch the following video and complete the tasks below: Duplicating Sheets & Adding Data (4 points)
1. Duplicate the sheet in a new tab.
2. Rename the new tab and change the color.
3. Insert a row and add data to it. Highlight the row you inserted.
4. Why is it important to duplicate your original data?
a. Its important to duplicate the original data because you maybe accidentally delete it or
something happens and that way you wouldn’t lose all of the work you have done.
Step 3: Watch the following video and answer the questions below: Formatting & Organization (10 points)
1. Insert two rows above row 1 to create category headers.
2. Label and format the headers as the video shows. Be sure you:
a. Update cells and make them bold
b. Merge cells
3. Change the date format in Column A.
Step 4: Watch the following video and complete the tasks below: Formatting and Organizing ( 22 points)
1. Insert a new column to the left of Column A
2. Freeze the new column A
3. Title the new column. Make sure the formatting matches your other columns.
4. Number the rows.
5. Add borders between the columns and fill your title rows with color.
6. Make the borders in row 1 clear.
7. Add another title in Row 1 and format as you did your other title rows.
8. Resize your columns to fit your data.
9. Delete the columns that have no data.
10. Why would you want to freeze a row or column?
a. Well you would click on the column you want to freeze then go to view tab and click on the
freese button and click on 1 row or 1 column and it would freeze it
Los beneficios de comprar resúmenes en Stuvia estan en línea:
Garantiza la calidad de los comentarios
Compradores de Stuvia evaluaron más de 700.000 resúmenes. Así estas seguro que compras los mejores documentos!
Compra fácil y rápido
Puedes pagar rápidamente y en una vez con iDeal, tarjeta de crédito o con tu crédito de Stuvia. Sin tener que hacerte miembro.
Enfócate en lo más importante
Tus compañeros escriben los resúmenes. Por eso tienes la seguridad que tienes un resumen actual y confiable. Así llegas a la conclusión rapidamente!
Preguntas frecuentes
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
100% de satisfacción garantizada: ¿Cómo funciona?
Nuestra garantía de satisfacción le asegura que siempre encontrará un documento de estudio a tu medida. Tu rellenas un formulario y nuestro equipo de atención al cliente se encarga del resto.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller madelynhed2002. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for 9,03 €. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
45,681 summaries were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 15 years now