Create your Design - Project

Create your Design - Project

By Vasantha Ponnen

Poll

i can design my own spreadsheet

• YES

• NO

• I DONT KNOW

​

·       Creating spreadsheets

·       Adjusting cell sizes

·       Typing on multiple lines within a cell

·       Cell shading and borders

·       SUM, AVERAGE, MIN, and MAX formulas

·       Formulas using = + - * / ( )

·       Creating and formatting bar graphs

·       Creating Pai Chart

·       Copying and pasting charts to another document

·       Using Canva to present your information​

​If you want to research and create your own spreadsheet with information, here you go.

​

Reference: Department of Statistics, Malaysia

https://www.dosm.gov.my/v1/index.php?r=column/cthemeByCat&cat=333&bul_id=d1YxK0tsUWp4RGNHQXZTZTIzNUxWdz09&menu_id=U3VPMldoYUxzVzFaYmNkWXZteGduZz09​

​REINFORCEMENT Activity

Multiple Choice

Which of the following is a selected cell?

• current command
• default option
• active Cell
• default cell

Multiple Choice

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

Multiple Choice

What is the name of this cell?

• B10
• 5B
• B5
• A5

Multiple Choice

_____ are vertical. 

• Rows
• Columns

Multiple Choice

________ are horizontal

• Rows
• Columns

Multiple Choice

* is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing

Multiple Choice

/ is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing

Multiple Choice

- is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing

Multiple Choice

to merge cells, you need to :

• Hilight all cells the merge command

• Hilight one cells the merge command

• Hilight two cells the merge command

Multiple Choice

Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?

• =MAX(B2:B7)

• =HIGH(B2:B7)

• =LRG(B2:B7)

• =TOP(B2:B7)

Multiple Choice

Which formula will calculate the average?

• average

• countif

• averageif

• sumif

Multiple Choice

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Multiple Choice

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Poll

I can design my own spreadsheet

• YES

• NO

• I DON'T KNOW

Draw

Reflection