MIS 112 Midterm

Which operator in Excel combines multiple range references into a single reference (e.g., if I want to sum up the values in non-contiguous cell-ranges across the worksheet)?

"," (comma)

To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: __________.

Shift+F2

Which of the following is a shortcut key used to calculate only the formulas in the active worksheet?

Shift+F9

Which of the following is TRUE about sorting a table?

Sorting a table re-arranges the rows based on the contents of a particular column.

Microsoft Office Excel can automatically generate a data form (which allows for convenient data entry, among other things) for your range or _______________.

Table

Suppose you have a range of cells with numbers and a few blank entries. If you sort the range in ascending order (smallest to largest), where will the blank cells be located after sorting?

At the end

Which of the following is the default font type and font size in Excel 2016?

Calibri, 11 point

The Analysis Toolpak can be activated through which sequence of steps?

File-->Options-->Add ins -->Manage Excel Add-Ins --> Go

Which of the following statements is true? They all relate to the formula: =IF( OR(Category="Pasta",Category="Soups"), Inventory_Cost,0 )

In this formula, the second statement in the OR (i.e., checking for the category ="Soups") is only checked/evaluated if the first part (i.e., checking if category ="Pasta") evaluates to FALSE

In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram?

Input Range and Bin Range

To display the Total Row in a Table: choose Table Tools / Design -> Table Style Options (command group) and put a check mark next to Total Row. Selecting a cell in the Total Row and clicking on the drop-down arrow that appears in that cell will NOT allow you to select which of the following summary formulas?

Mode

Which of the following is NOT an advantage of using defined range names to work with ranges in Excel?

Moving to areas of the worksheet is controlled

Adding comments to a cell is available through which tab of the Excel ribbon?

Review

Suppose your worksheet has a comment in cell A1 and a comment in cell B5. Your active cell is B1. Which command can you use to navigate to the comment in cell B5?

Review (tab) -> Comments (command group) -> Next

What does selecting the option "Current region" within the: Go To Special Dialog Box (Home (tab) -> Editing (command group) -> Find & Select) do?

Selects a rectangular range of cells around the active cell

Which of the following types of Cell Formating can be achieved using the Format Cells feature of Excel?

Alignment, Fill, Protection

What will be the result of this formula =IF(A1<100000,A1*5%,A1*7.5%) , if the cell A1 has a value of 90000?

4500

Which of the following shows the correct syntax for referencing cell "A2" in another worksheet?

=A1*Sheet2!A2

Which of the following does the search string ~?NULL~? match when entered in the find and replace dialog box?

?NULL?

What of the following is FALSE about filtering a table?

When you copy data from a filtered table, both visible data and rows hidden by filtering are copied.

In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character?

Yes, the "?" symbol is used to find/match a single character

A data form provides a convenient means to enter, display and search for data within a table. It also permits you to do the following: ____________

delete a record/row

Which of the following is NOT a type of cell reference?

dynamic