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 the domain extension for a non-profit organization, such as PBS or Red Cross?
.org
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
What does URL stand for?
Uniform Resource Locator
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 comes after a Gigabyte?
Terabyte (TB)
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