MGSC 290 Exam 2 Questions with Correct Answers Latest Version 2025
import - Answers ______________ is the process of obtaining data from another source, such as the
Internet, another software program, or another file format and bringing it into Excel.
text files - Answers are documents that include basic data without formatting and typically include
commas or other characters to separate data into columns and rows.
data base - Answers Most companies, service organizations, schools, and other enterprises keep great
amounts of data in ______________, so it is quite common to import that data for use in Excel.
table - Answers ______________ is list of related information formatted with a title row followed with
rows of data.
pivot table - Answers ______________ summarize list-type data in a worksheet.
export - Answers When working with Excel, you may find that you need to ______________ your data to
use in other programs.
sorting - Answers _____________ is the process of arranging rows of data in a specified order.
auto filter - Answers _____________ allows you to select which types of data are visible based on the
values in a specific column.
advanced filter - Answers _______ are very powerful and complex as they allow you to set multiple
criteria and extract information based on the criteria.
subtotal - Answers The ___________ command automatically inserts summary rows for data that are
arranged in related groups.
outline - Answers An ____________ is a summary that groups records so that they can be displayed or
hidden from view.
conditional formatting - Answers ______________ applies specified formatting to cells that meet
selected criteria.
back solving - Answers ______________ means knowing the desired outcome and determining values
needed to achieve those results.
protect sheet - Answers ___________ prevents further edits on a worksheet.
font color
fill color
cell icon - Answers What are three additional ways Excel allows you to sort data, besides text and
number sorting?
, delimiter - Answers In certain import files, the ______________ is a special character used to separate
the data.
field - Answers A ______________ represents an individual column in a text file.
field - Answers Each row in a database includes related information and is known as a record. The piece
of data in a single column is a _____________?
criteria - Answers When you use database functions, you must build a __________________.
and - Answers When you use database functions and you enter criteria on the same row, they are
treated as ______________ conditions.
3 - Answers How many arguments do all data database functions have?
and - Answers The ______________ function is used to define more than one condition that must be
met for a TRUE result.
or - Answers An _______________ function is much less restrictive than an AND function.
nest - Answers A ________________ is a function within a function.
#N/A - Answers A ________________ error values indicates a value or an argument is missing.
#Values - Answers A ________________ error values indicates an incorrect data type is used (for
example, a label is used instead of a value).
#REF! - Answers A ________________ error values indicates a cell reference is empty, usually because
cells were deleted.
#DIV/10 - Answers A ________________ error values indicates the formula divides by zero (0) or an
empty cell.
index - Answers The _______________ function displays the contents of the cell at the intersection of an
identified column and row.
Match - Answers The _______________ function looks for data that you specify and returns the relative
location of the data that matches the search.
-1 - Answers When using the MATCH function, which Match_type Argument finds the smallest value
that is greater than or equal to the lookup_value?
1 or omitted - Answers When using the MATCH function, which Match_type Argument finds the largest
value that is less than or equal to the lookup_value?
0 - Answers When using the MATCH function, which Match_type Argument finds the first value that
exactly matches the lookup_value?
import - Answers ______________ is the process of obtaining data from another source, such as the
Internet, another software program, or another file format and bringing it into Excel.
text files - Answers are documents that include basic data without formatting and typically include
commas or other characters to separate data into columns and rows.
data base - Answers Most companies, service organizations, schools, and other enterprises keep great
amounts of data in ______________, so it is quite common to import that data for use in Excel.
table - Answers ______________ is list of related information formatted with a title row followed with
rows of data.
pivot table - Answers ______________ summarize list-type data in a worksheet.
export - Answers When working with Excel, you may find that you need to ______________ your data to
use in other programs.
sorting - Answers _____________ is the process of arranging rows of data in a specified order.
auto filter - Answers _____________ allows you to select which types of data are visible based on the
values in a specific column.
advanced filter - Answers _______ are very powerful and complex as they allow you to set multiple
criteria and extract information based on the criteria.
subtotal - Answers The ___________ command automatically inserts summary rows for data that are
arranged in related groups.
outline - Answers An ____________ is a summary that groups records so that they can be displayed or
hidden from view.
conditional formatting - Answers ______________ applies specified formatting to cells that meet
selected criteria.
back solving - Answers ______________ means knowing the desired outcome and determining values
needed to achieve those results.
protect sheet - Answers ___________ prevents further edits on a worksheet.
font color
fill color
cell icon - Answers What are three additional ways Excel allows you to sort data, besides text and
number sorting?
, delimiter - Answers In certain import files, the ______________ is a special character used to separate
the data.
field - Answers A ______________ represents an individual column in a text file.
field - Answers Each row in a database includes related information and is known as a record. The piece
of data in a single column is a _____________?
criteria - Answers When you use database functions, you must build a __________________.
and - Answers When you use database functions and you enter criteria on the same row, they are
treated as ______________ conditions.
3 - Answers How many arguments do all data database functions have?
and - Answers The ______________ function is used to define more than one condition that must be
met for a TRUE result.
or - Answers An _______________ function is much less restrictive than an AND function.
nest - Answers A ________________ is a function within a function.
#N/A - Answers A ________________ error values indicates a value or an argument is missing.
#Values - Answers A ________________ error values indicates an incorrect data type is used (for
example, a label is used instead of a value).
#REF! - Answers A ________________ error values indicates a cell reference is empty, usually because
cells were deleted.
#DIV/10 - Answers A ________________ error values indicates the formula divides by zero (0) or an
empty cell.
index - Answers The _______________ function displays the contents of the cell at the intersection of an
identified column and row.
Match - Answers The _______________ function looks for data that you specify and returns the relative
location of the data that matches the search.
-1 - Answers When using the MATCH function, which Match_type Argument finds the smallest value
that is greater than or equal to the lookup_value?
1 or omitted - Answers When using the MATCH function, which Match_type Argument finds the largest
value that is less than or equal to the lookup_value?
0 - Answers When using the MATCH function, which Match_type Argument finds the first value that
exactly matches the lookup_value?
