MIS Midterm

Question 1

How many cells in Excel are included in the range A2:A6?

Answer 1

5

Question 2

A pivot table in Excel allows the user to place columns of the original worksheet into all of the following categories except?

Answer 2

Formulas

Question 3

In math, the absolute value of a number is the non-negative value of the number. For example, the absolute value of -3 is 3 and the absolute value of 4 is still 4. Which of the following Excel formulas finds the absolute value of the number in cell A1?

Answer 3

=IF(A1 > 0, A1, -A1)

Question 4

Which of the following statements is correct?

Answer 4

An Excel workbook may contain multiple spreadsheets.

Question 5

The arithmetic mean of a range of cells is found by using which function?

Answer 5

AVERAGE

Question 6

What is the first step that should be taken when creating a chart?

Answer 6

selecting the range of cells that contain the data the chart will use

Question 7

What is the value of the formula: =IF(A3<B3, IF(A3<C3, “Small”, “Medium”), “Large”)

Answer 7

Small

Question 8

What is the value of the formula: =SUMIF(B1:B3, “>” & 3, C1:C3)

Answer 8

8

Question 9

Suppose the formula = MAX(A1:A4, A$1:D1, D:D) is entered into cell E1. What value will be calculated by Excel in the cell E1?

Answer 9

5

Question 10

Suppose the formula from the previous question was copied from E1 and pasted into F3. What value will be calculated by Excel in the cell F3?

Answer 10

7

Question 11

Revenue Calculation

Answer 11

= Price*units sold

Question 12

COGS

Answer 12

=Cost per Unit * Units sold

Question 13

Gross Profit

Answer 13

=Revenue - COGS

Question 14

Current total profit

Answer 14

=sum of all gross profit

Question 15

Best Case profit

Answer 15

= Best case revenue - best case COGS

Question 16

Best case Total Profit

Answer 16

= sum of best-case profits

Question 17

Worst Case Profit

Answer 17

=Worst case revenue - worst case cogs

Question 18

worst case total profit

Answer 18

= sum of worst-case profits

Question 19

Find the grade

Answer 19

IF(Average >= 90, “A+”,
IF(Average >= 80, “A”,
IF(Average >= 70, “B”,
IF(Average >= 60, “C”, “F”))))

Question 20

calculate gpa

Answer 20

=VLOOKUP(Grade, $G$16:$H$20, 2, FALSE)

Question 21

Pass or fail

Answer 21

=IF(MIN(B2:D2) < 60, “Fail”, “Pass”)

Question 22

Number of students with average >=80

Answer 22

=COUNTIF(E2:E5, “>=80”)

Question 23

Total average marks for students with science >=80

Answer 23

=AVERAGEIF(C2:C5, “>=80”, E2:E5)

Question 24

Current class average

Answer 24

Average of All Student Averages