MIS Quiz 1, UNH Incham Kim |Questions
Solved 100% Correct| Verified Solutions
Relative cell reference - ANSWER default method of referencing
The VLOOKUP function - ANSWER accepts a value and looks for the value in the left
column of a specified table array and returns another value located in the same
row from a specified column.
The PMT function - ANSWER calculates payments for a loan, with three
required arguments and two optional arguments.
chart - ANSWER a visual representation of numerical data that compares data and
reveals trends or patterns to help people make informed decisions.
data point - ANSWER a cell containing a value.
data series - ANSWER a group of related data points that display in row(s) or
column(s) in a worksheet.
bar chart - ANSWER compares values across categories using horizontal bars.
The horizontal axis displays values, and the vertical axis displays categories.
Good info:
Bar charts and column charts both compare categories of data. A bar chart is
preferable when category names are long. Note how easily the long category names
are accommodated.
Solved 100% Correct| Verified Solutions
Relative cell reference - ANSWER default method of referencing
The VLOOKUP function - ANSWER accepts a value and looks for the value in the left
column of a specified table array and returns another value located in the same
row from a specified column.
The PMT function - ANSWER calculates payments for a loan, with three
required arguments and two optional arguments.
chart - ANSWER a visual representation of numerical data that compares data and
reveals trends or patterns to help people make informed decisions.
data point - ANSWER a cell containing a value.
data series - ANSWER a group of related data points that display in row(s) or
column(s) in a worksheet.
bar chart - ANSWER compares values across categories using horizontal bars.
The horizontal axis displays values, and the vertical axis displays categories.
Good info:
Bar charts and column charts both compare categories of data. A bar chart is
preferable when category names are long. Note how easily the long category names
are accommodated.