DIGI SKILLS
how do you change the size of your slides in google slides?
page setup
what does linking buttons do in google slides?
they mkae your presentations interactive so when when you clickk a button, it will take you to a new slide or website.
which icon do you use to create lists?
the bullet point icon (looks like lines with dots) on the toolbar to create lists
what are the 3 main features in google sites? where do you find these?
previewing, copying links, sharing with others. You find these options on the top right corner of your screen.
what does previewing do?
allows you to see how your website will look before you use it
what does copying links do?
enables you to share your website with others by providing a web address.
what does sharing with others do?
gives you control over who can view or edit your site.
in google sheets what does freezing rows do?
keeps those rows visible even whe you scroll down the spreadsheet, this is useful for keeping headers in view
in google sheets what does conditional formatting do?
applies formatting (like colors or icons) to cells based on their values
in google sheets what does data transformation do?
allows you to create charts and graphs from your data to visualize it.
in google classroom how do you control your notifications?
in settings
in google classroom where would teachers post their announcements?
in the stream of a classroom
in google classroom where is your assignments found?
in the classwork section of a classroom
which button do you click to submit an assignment?
the hand in button
what can you do in archved classrooms?
view assignments
in google classroom, can you unsubmit the work before the ue date?
yes
what is a cell reference? (excel)
the unique address in each cell in a spreadsheet, this is made up of the column letter and the row number
what should formulasalways start with? (excel)
equals sign (=)
which symbol does multiplication use? (excel)
the asterisk (*)
which symbol does the plus use?
the plus (+)
which symbol does subtraction use?
the minus (-)
in functions, what does SUM do? (excel)
adds up a range of cells
what does spreadsheet formatting do?
changes the spreadsheet to make it easier to read and understand
in formating teachniques what does merge and center do?
combines multiple cells into one larger cell and enters the context
in formating teachniques what fill color do?
changes the background colour of a cell
in formating teachniques what does text color do?
changes the color of the text in a cell
in formating teachniques what does font do?
changes the typeface of the text (e.g, arial, times new roman)
in formating teachniques what does size do?
changes the height of the text
in formating teachniques what does Bold do?
makes the text thicker and darker
in formating teachniques what does Center do?
aligns the text to the center of the cell
in formating teachniques what does Borders do?
adds lines around cells
what does the function MIN do?
finds the smallest value in a range of cells
what does the function MAX do?
finds the maximum value in a range of cells
what does the function AVERAGE do?
calculates the average of the values in cells
what does the function COUNT do?
counts the number of cells in a range that contain only numbers
what does the function COUNTA do?
counts the number of cells in a range that aernt empty (it counts cells with any type of data, including numbers and text)
what does the conditional function IF do?
performs a logical test and retruns one value if the test is true and another value if the test is false
what does the conditional function SUMIF do?
adds the values in a range of cells that meet a specified condition
what does the conditional function COUNTIF do?
counts the number of cells within a range that meet a given condition
what does conditional formatting do? (more detail)
applies formatting to cells based on certain criteria (rules). this helps you to quickly visualize data patterns and trends