Upgrade to remove ads
Only $2.99/month

MIS111L Midterm: Problem Sets 1-6

Terms in this set (50)

What excel tab is NOT visible in a worksheet by default?
developer
while comparing two sheets using the "view side by side" feature, there is an option which lets you scroll the two sheets in sync. what is that option called?
synchronous scrolling
what column name comes directly after column z?
AA
which of the following is the keyboard shortcut that creates a new blank workbook in excel?
ctrl + N
what characters are NOT allowed in sheet names?
[ ]
What is true about the relationship about workbooks and worksheets?
a workbook can have many worksheets
what shortcut allows you to enter the same data into multiple selected cells?
Ctrl + Enter
what is the primary purpose of the "protected view"?
protect you from malware
what scrolls the screen so that the active cell is visible?
Ctrl + Backspace
what is VALID for use in an Excel workbook file name?
_ (underscore)
what keyboard shortcut can be used to move the active cell one column to the left?
left arrow or Shift + Tab
a group of cells is referred to
range
when a range of cells is selected, which of the following occurs
all selected cells are bounded by a selection box, and all but the active cell in the range are highlighted/shaded
what does every chart type have a set of that you can choose from? (with settings for chart elements)
layouts
a chart in excel worksheet provides a visual representation of what
numeric values
what does NOT support the data table chart element?
treemap
you can add a title to the vertical axis of the chart by using Chart Layouts (Chart Tools "Design" tab) --> Add Chart Element --> ______
axis titles
what keyboard shortcut "cuts" the current selection of cells to both Windows and Office clipboards
Ctrl + X
the excel function: ISERR() returns TRUE if the cell contains any error value except
#N/A
what is the result of the following expressions (formulas), respectively?
=(10-6)*10
and
=10-6*10
40 and -50
what keyboard shortcut do you need in order to store the results of a formula entered in the formula bar [=(25*10)/2] as an actual number [125] in the active cell
F9
what (example) formula will calculate the total number of values in a selected column
=SUM(B2:B5)
in the function: =COUNTIF(A1:A200, ">200"), what is the information between the parenthesis called?
arguments
the SUM() function does which of the following in excel
allows you to total up numbers in a specified range of cells
(example) in order to answer the question: "how many days of stock data do I have?" what formula do you use
COUNT()
which of the following does the Formula Autocomplete feature in excel take into account
all options provided for this answer are valid:
1. excel built-in functions
2. user-defined functions
3. defined names
what is NOT a type of cell reference
dynamic
what button displays the Paste Name Dialog Box if names of cells or ranges are defined.
If cells are not named, this button has no effect
F3
what does the following formula do? =COUNTIF(data, TODAY())
returns the number of cells containing the current date in the range named Data
(example) what formula can be used to find: how many songs were sung by madonna and were 3-4 min long (inclusive formula)
=COUNTIFS(B2:B23,"Madonna",D2:D23,"<=4",D2:D23,">=3")
what will be the result of this formula =IF(A1<100000,A15%,A17.5%), if the cell A1 has a value if 90000
4500
what function can be used to count specific types of errors
COUNTIF
what does small red triangles on upper right corners of a cell denote?
a comment exists for that cell
what would you type in the Find and Replace dialog box (Home(tab) -> Editing (command group) -> Find & Select) to find all four-digit entries that begin with 5 and end with 2
5??2
in the formula: =SUMIFS(Inventory_Cost, Category, "=Beverages", Suppliers, "4"). what is true?
Two criteria are checked for this formula to include a value in the total:
1. the product category must be "Beverages",
2. the supplier must be "4"
in the analysis toolpak, which of the following parameters can you specify when creating a histogram?
input range and bin range
would you be able to apply the watch window option in multiple sheets at the same time
yes
after pressing alt+h while in an open excel worksheet, a number of key tips are displayed. which ribbon tab do these key tips relate to?
home
what formula will display both the current date and time when entered into a cell in an excel worksheet?
=NOW()
what moves the active cell right one screen?
alt + PgDn
what is the shortcut to open the find and replace dialogue box with the replace tab open?
ctrl+h
is it possible to convert a cell with text data into a .png format
yes
what formula selects a column
shift+spacebar
what is true about password protected workbooks?
passwords are case sensitive
functions that can be used to count error values in a range
iserror(), isna(), iserr()
shortcut key used to calculate the formulas in the active worksheet
shift+f9
if you copy a formula down a column and need a cell reference to stay the same, what type of cell reference do you need?
absolute
the COUNTIF() function used for single-criterion counting formula takes two arguments:
range and criteria
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
the analysis toolpak can be activated through which sequence of steps?
file - options - add ins - manage excel add ins - go
YOU MIGHT ALSO LIKE...