MIS 2201 Midterm II (UMD)
Questions and 100% Correct Verified
Solutions| Latest Update
How to create page breaks in Excel - Answer select 'page break', select the row below
where you want to insert the page break (vertical page break) or select the column to
the right of where you want to insert the page break (horizontal page break), and
click 'insert page break'
Creating data series in Excel - Answer data series: A row or column of numbers that are
plotted in a chart is called a data series. You can plot one or more data series in a chart.
1. select range
2. insert tab, column symbol
3. select clustered column
Different kinds of functions in Excel (Statistical, Math & Trig, Logical, etc) - Answer
- Aggregate: calculate a result, which is an aggregate of the range
- Financial: calculate financial information, such as net present value and payments
- Statistical: apply a mathematical process to a group of cells in a worksheet
- Scientific: trigonometry, logarithms and functions that manipulate numbers
, - Logical: test the value of a cell and perform different operations on it depending on
the outcome
- Text: lets you manipulate character data, such as the names of customers,
street addresses and product descriptions
Working with ranges in Excel, selecting non-adjacent ranges - Answer non-adjacent:
hold Ctrl and select additional nonadjacent cell(s)
Formatting text (e.g. wrapping) and numbers (decimal points) in Excel. - Answer
wrap text: in alignment tab, select 'wrap text'
specify decimal points: format menu, click 'format cells', number tab, choose
number item in category list. Decimal place is in right part of window
Absolute and relative addressing - Answer Relative references change when a formula is
copied to another cell.
Absolute references remain constant no matter where they are copied.
Mathematical and Financial formulas (e.g. SUM, MAX, MIN, PMT, etc) -
Answer Mathematical formulas:
- SUM: adds up all values in the range
- AVERAGE: adds up all values in range and divides by number of values
- COUNT: adds up number of values in range
-MAX: finds largest value in range
-MIN: finds smallest value in range
Financial formulas:
- PMT: denotes the periodical payment required to pay off for a particular period of time
with a constant interest rate
Questions and 100% Correct Verified
Solutions| Latest Update
How to create page breaks in Excel - Answer select 'page break', select the row below
where you want to insert the page break (vertical page break) or select the column to
the right of where you want to insert the page break (horizontal page break), and
click 'insert page break'
Creating data series in Excel - Answer data series: A row or column of numbers that are
plotted in a chart is called a data series. You can plot one or more data series in a chart.
1. select range
2. insert tab, column symbol
3. select clustered column
Different kinds of functions in Excel (Statistical, Math & Trig, Logical, etc) - Answer
- Aggregate: calculate a result, which is an aggregate of the range
- Financial: calculate financial information, such as net present value and payments
- Statistical: apply a mathematical process to a group of cells in a worksheet
- Scientific: trigonometry, logarithms and functions that manipulate numbers
, - Logical: test the value of a cell and perform different operations on it depending on
the outcome
- Text: lets you manipulate character data, such as the names of customers,
street addresses and product descriptions
Working with ranges in Excel, selecting non-adjacent ranges - Answer non-adjacent:
hold Ctrl and select additional nonadjacent cell(s)
Formatting text (e.g. wrapping) and numbers (decimal points) in Excel. - Answer
wrap text: in alignment tab, select 'wrap text'
specify decimal points: format menu, click 'format cells', number tab, choose
number item in category list. Decimal place is in right part of window
Absolute and relative addressing - Answer Relative references change when a formula is
copied to another cell.
Absolute references remain constant no matter where they are copied.
Mathematical and Financial formulas (e.g. SUM, MAX, MIN, PMT, etc) -
Answer Mathematical formulas:
- SUM: adds up all values in the range
- AVERAGE: adds up all values in range and divides by number of values
- COUNT: adds up number of values in range
-MAX: finds largest value in range
-MIN: finds smallest value in range
Financial formulas:
- PMT: denotes the periodical payment required to pay off for a particular period of time
with a constant interest rate
