New Information systems
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/19
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
20 Terms
What does PEMDAS stand for in order of operations?
Parentheses, Exponents, Multiplication and Division (from left to right), Addition and Subtraction (from left to right)
What must every formula or function begin with?
An equal sign.
What does the name box indicate in a spreadsheet?
The address of the active cell.
What is the term for a cell that is highlighted in green?
Active cell.
How does a cell solve formulas?
By using the order of operations, or PEMDAS.
What is the function of the file handle in spreadsheet software?
It allows you to drag and increment values.
What is a relative reference?
Referencing a cell that updates when copied to other cells or columns.
What is a function in spreadsheet terminology?
A predefined formula.
What is the proper syntax for a function in spreadsheets?
It starts with an equal sign, followed by the function name, an open parenthesis, required arguments, optional arguments, and a closed parenthesis.
How are the arguments in a function separated?
By commas.
What does a cell range use to separate values?
A colon.
What is the keyboard shortcut CTRL ~ used for?
It shows formulas in the spreadsheet.
What does 'False' mean in a lookup function?
It looks for an exact match.
For what type of tables are V-lookup functions used?
For horizontal tables.
What is a relative reference in context of cell B5?
The column and row will change relative to where you copy or paste the formula.
What is an absolute reference in context of cell $B$5?
The column and row will not change regardless of where you copy or move the function.
What are logical operators in relation to formulas?
They include
What happens to a relative reference when copied?
Both the column and row will update relative to the new location.
What is a mixed reference in context of cell $BF?
The column will not change, but the row will change relative to where the formula is copied.
What is a mixed reference in context of cell B$F?
The row will not change, but the column will change relative to where the formula is copied.
Explore top notes
