SPREADSHEET FINAL LATEST
EXAM
ANSWER ALL QUESTIONS IN THIS SECTION
QUESTION 1
IF function - ANSWER-A logical function that returns one
value if the statement is true and returns a different value if the statement is false.
Insert Function Button - ANSWER-Organizes all of the functions by category and
allows you to search for functions that perform particular calculations.
Landscape orientation - ANSWER-A type of page orientation in which the page is
wider than it is tall; so that the text spands the widest part of the page.
Location - ANSWER-also called a path. Example:
='C:\ticketsales\domestic sales\[new mexico.xlsx]summary'!B6 - ANSWER-
Logical operator - ANSWER-An operator that combines
expressions within a condition; used when writing conditions for control structures.
Lookup function - ANSWER-function returns a value from a range.
END OF
PAGE 1
, SPREADSHEET FINAL LATEST
EXAM
Lookup table - ANSWER-A table that organizes data you want to retrieve into
different categories.
Macro - ANSWER-A series of stored commands that can be run whenever you
need to perform the recorded tasks.
Method - ANSWER-A action that can be performed on an
object, such as closing a workbook or printing the contents of a worksheet.
Mixed expense - ANSWER-An expense that is part variable and part fixed
Module - ANSWER-In VBA, a collection of sub procedures.
Name - ANSWER-A word or string of characters associated with a single cell or
range.
Nonadjacent range - ANSWER-Cell range that is comprised of two or more
seperate adjacent ranges.
Not binding contsraint - ANSWER-A consraint that was not a limiting factor in
Solver arriving at the solution.
END OF
PAGE 2
EXAM
ANSWER ALL QUESTIONS IN THIS SECTION
QUESTION 1
IF function - ANSWER-A logical function that returns one
value if the statement is true and returns a different value if the statement is false.
Insert Function Button - ANSWER-Organizes all of the functions by category and
allows you to search for functions that perform particular calculations.
Landscape orientation - ANSWER-A type of page orientation in which the page is
wider than it is tall; so that the text spands the widest part of the page.
Location - ANSWER-also called a path. Example:
='C:\ticketsales\domestic sales\[new mexico.xlsx]summary'!B6 - ANSWER-
Logical operator - ANSWER-An operator that combines
expressions within a condition; used when writing conditions for control structures.
Lookup function - ANSWER-function returns a value from a range.
END OF
PAGE 1
, SPREADSHEET FINAL LATEST
EXAM
Lookup table - ANSWER-A table that organizes data you want to retrieve into
different categories.
Macro - ANSWER-A series of stored commands that can be run whenever you
need to perform the recorded tasks.
Method - ANSWER-A action that can be performed on an
object, such as closing a workbook or printing the contents of a worksheet.
Mixed expense - ANSWER-An expense that is part variable and part fixed
Module - ANSWER-In VBA, a collection of sub procedures.
Name - ANSWER-A word or string of characters associated with a single cell or
range.
Nonadjacent range - ANSWER-Cell range that is comprised of two or more
seperate adjacent ranges.
Not binding contsraint - ANSWER-A consraint that was not a limiting factor in
Solver arriving at the solution.
END OF
PAGE 2
