/
AI Flashcards
Save to my account
Sign up
AI Flashcards
Spreadsheet Basics and Functions
Study
1
Question
What is a spreadsheet as defined in the lesson?
Answer
An application software table/grid of rows and columns.
2
Question
What is the intersection of a row and column called?
Answer
A cell.
3
Question
How is a row identified in a spreadsheet?
Answer
By numbers.
4
Question
How is a column identified in a spreadsheet?
Answer
By letters.
5
Question
What is a workbook?
Answer
A group of related worksheets.
6
Question
What is a worksheet?
Answer
The current working sheet.
7
Question
What is a cell address?
Answer
Location of a cell identified by column letter and row number.
8
Question
What are the three data types a spreadsheet accepts?
Answer
Labels, Values, Formulas/Functions.
9
Question
What is a function in spreadsheets?
Answer
A predefined formula that calculates results or performs actions.
10
Question
What is a formula in spreadsheets?
Answer
An instruction to perform operations on values.
11
Question
How do formulas and functions start?
Answer
With an equal sign '='.
12
Question
What does BODMAS refer to in spreadsheets?
Answer
Order of operations for expressions.
13
Question
What is a range in a spreadsheet?
Answer
A cell or group of adjoining cells forming a rectangle.
14
Question
Name the three types of ranges with examples.
Answer
Row range (A4:D4), Column range (B3:B6), Cell range (A3:D6).
15
Question
What is relative cell addressing?
Answer
Cell references adjust when copied to another location.
16
Question
What is absolute cell addressing?
Answer
Cell references do not change when copied.
17
Question
What is the SUM function used for?
Answer
Adds all values in a range.
18
Question
What is the AVERAGE function used for?
Answer
Finds the mean of a set of values.
19
Question
What is the MAX function used for?
Answer
Finds the largest value in a range.
20
Question
What is the MIN function used for?
Answer
Finds the smallest value in a range.
21
Question
What is the COUNT function used for?
Answer
Returns the number of numeric entries in its argument.
22
Question
What does the COUNTA function count?
Answer
Counts both text and numbers.
23
Question
What does the COUNTIF function do?
Answer
Counts occurrences of a value/word in a range.
24
Question
What is the IF function used for?
Answer
Tests a condition and returns different values.
25
Question
What is the syntax of IF?
Answer
=IF(logical test, value_if_true, value_if_false)
26
Question
What does VLOOKUP do?
Answer
Searches leftmost column and returns value from specified column.
27
Question
What does the V in VLOOKUP stand for?
Answer
Vertical.
28
Question
What is a nested IF used for?
Answer
Testing multiple values within IF statements.
29
Question
What is the purpose of a VLOOKUP table array?
Answer
Provide the data to search and retrieve from.
30
Question
What is an absolute reference in VLOOKUP and why use it?
Answer
Locks the table range when copying the formula.