Unit 1: Webmail/Internet
Give me an example of a browser
Safari, Chrome, Firefox, etc.
Where is the header located?
Top of the Page
A group of cells is called what?
Cell Range
What is the keyboard shortcut for copy?
Command+C
What formula would I use to find the highest number in a column?
MAX
What is a cybercrime where criminals trick individuals into revealing sensitive information like passwords or bank details by pretending to be legitimate organizations or people.
Phishing
The space between columns is called?
Gutter
What spreadsheet feature is used to combine multiple cells into a single cell?
Merge
What is the keyboard shortcut for Underline?
Command+U
What formula is used to add a group of cells together?
SUM
What section of an email would you need to use if you wanted to keep a teacher in the loop on a group project's communication?
CC
What is the blank space on the left, right, top, and bottom of the page which can be easily adjusted?
Margins
What symbol would you use for absolute cell reference?
$
What is the keyboard shortcut for Print?
Command+P
What formula is used to display a value based upon a True or False scenario?
IF
Games, Sports, News, Shopping, Education, etc. are all what in our schools firewall system?
Categories
If I wanted to move my image within my document, what feature would I turn on?
Text Wrapping
What is the part of the spreadsheet that runs vertically and is labeled with letters?
Columns
What is the keyboard shortcut for undo?
Command+Z
What feature is used to display colors or icons to help analyze data that meets various criteria?
Conditional Formatting
What is a fiber optic cable laid on the ocean floor to transmit data, enabling international communication and the internet.
Transatlantic Cable
In this URL, what is the domain?
https://www.amazon.com/tech/phones/accessories/GooglePixel4screenprotectors.html
Amazon
If I wanted to make all cells that have any number over 10 blue, I would use what symbol in conditional formatting.
Greater Than >
What is the keyboard shortcut for cut?
Command+X
What formula is used to display a value based upon more than two possible criteria by comparing a value to a cell range and returning a value from that range?
VLOOKUP