WorksheetsUsing Functions and Formulas in an Electronic Spreadsheet
Total questions: 10
Worksheet time: 11mins
What pertains to a union operator, which combines multiple ranges into one reference?
Example: B5:B15 , C11:C13
colon
space
comma
plus
it is an intersection operator which produces one reference to cells common to the two references.
Example:
B5:B15 B5:C5
colon
comma
equal
space
Values for Evaluation:
A=10
B=5
C=15
D=10
Type TRUE if the result is correct and FALSE if not based on the given values for evaluation above.
A=B __________?
Values for Evaluation:
A=10
B=5
C=15
D=10
Type TRUE if the result is correct and FALSE if not based on the given values for evaluation above.
A=D __________?
Values for Evaluation:
A=10
B=5
C=15
D=10
Type TRUE if the result is correct and FALSE if not based on the given values for evaluation above.
A > B __________?
Values for Evaluation:
A=10
B=5
C=15
D=10
Type TRUE if the result is correct and FALSE if not based on the given values for evaluation above.
A > C __________?
a worksheet is a ledger sheet that lets users enter, edit, and manipulate numerical data.
correct
incorrect
there are two types of spreadsheet: manual spreadsheet and electronic spreadsheet.
correct
incorrect
an electronic spreadsheet is a computer program that looks like the manual ledger sheet with its many rows and columns.
correct
incorrect
What is a range operator which produces one reference to all the cells between two references. Including two references?
Example: B5:B15
comma
colon
space
equals
