Functions & Formulas
The symbol one puts at the front of a function in a cell to indicate they are writing a function
What is Equal Sign (=)
The area in which you enter data in google sheets
What is a Cell?
An object on a computer that stores data, information, settings, or commands used with a computer program.
What is a file?
Created via the "insert" tab, this is a visual recreation of data that can be formatted further into different types. Variants include "map," "scatter," and "line."
What is "chart"
Google sheets, google docs, google slides, gmail, and Google calendar and more programs are part of what?
What is the google suite
A single cell or a group of adjacent cells in your spreadsheet, often listed in an X:Y format, with X being "start" cell and Y being "end" cell.
What is a range?
=Sum and =Average are examples of what in google sheets?
What is a function?
A text based user-interface a person uses to interact with their computer & operating system through "commands" and code.
What is Command Prompt?
A type of formatting that automatically changes every other color of a row or column.
What is alternating colors?
The first computer mouse was made of this material
What is Wood?
The function that adds together all values in a given range
What is =Sum(Range)/What is Sum
This is the main place that formulas, equations, and strings are typed or found within Google Sheets.
What is the Formula Bar?
An example of an image file extension, indicating the type of image file. (Numerous correct answers)
What is .jpg/.png/.pdf/.psd/.jpeg/.gif
A way to prevent text from overflowing into other cells
What is resizing a cell OR What is Text Wrapping?
Computer software that interferes with normal computer functions or sends personal data about the user to unauthorized parties over the Internet.
What is malware?
the formula that lists the number of different values in a set of data
what is
=countunique
If you click and drag this box in the bottom right corner of the cell, it will fill in missing information.
What is the fill handle? (Blue square in the bottom right of selected cell)
The command we used to navigate folders and directories in the command prompt.
What is /cd
This Google Sheets function lets you format cells so that their appearance changes dynamically according to the value they contain, or to values in other cells
What is conditional formatting
Data in a computer is stored here.
What is the CPU? (Central Processing Unit)
This function references & shows data from another spreadsheet.
What is =Importrange(sheet,range)
A sequence of computer characters (typically letters), including spaces. Separate from numbers.
What is a "string"?
This system is how files are named, stored, and retrieved from a computer (or any other storage devices)
What is a file system?
A Google Sheets function that will take your data and show you only the rows of data that meet the criteria specified (e.g. Sorting based on wishlist item price).
What is a filter/What is Filter?
'Firefox', 'Chrome', and 'Safari' are all examples of this type of computer software
What is a web browser?