Upgrade to remove ads
MIS 112 Midterm
Terms in this set (80)
Which of the following statements about workbooks and worksheets is true
a workbook can have many worksheets
which characters are not allowed in sheet names
which of the following is the keyboard shortcut that creates a new blank workbook in Excel
Ctrl + N
Which of the following shortcuts allows you to enter the same data into multiple selected cells
Ctrl + Enter
Which of the following is NOT one of the Excel functions to determine whether a cell contains an error value?
Please select the Excel function which allows us to answer the question "How many days of stock data do I have"
If cell A1 contains JONE F SMITH and you want this value to be changed into a proper case like John F Smith, what Excel function would use?
Which operator in Excel combines multiple range references into a single reference (e.g if I want to sum up the values in non contagious cell- ranges across the worksheet
which of the following is a key shortcut key used to calculate only 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 (for example, you don't want B2 to change to B3), what type of cell references do you need?
The Excel function: ISERR() returns TRUE if the cell contains any error value except which of the following
Which of the following does the function =NOW() return
current date and time
the easiest way to enter a function into a formula is to use Formula AutoComplete (the drop-down list that Excel displays while you type a formula). Another way to insure a function is to use the _____ on the _____ tab
function library group, Formulas
In Excel, the ISNONTEXT() function returns TRUE if its argument refers to which of the following
context other than text or a blank cell
For a range called Data, what does the function =COUNTIF(Data,"<>0") return
number of cells not equal to 0
What will be the result of this formula =IF(A1<100000,A1
7.5%), if the cell A1 has a value of 90000?
Which of the following functions can be used to count specific types of errors
You are reviewing a spreadsheet that records daily sales for Burgers, Hotdogs, and Chili. Monday of last week shows exceptionally high sales for Burgers. You want to email this spreadsheet back to your assistant so he can look into whether the data was correctly entered. Which of the following methods should you use to explain your request to your assistant
add a comment to the sales figure cell and explain to your assistant what you want him to do
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 and Select) do
selects a rectangular range of cells around the active cell
Which of the following does the search string -?NULL-? match when entered in the find and replace dialog box?
In the Analysis ToolPak for Excel, which of the following parameters can you specify when creating a Histogram?
Input Range and Bin Range
Which of the following is NOT a method of creating frequency distributions?
use the Review (Proofing) tool of Spelling Error Frequency per Worksheet
The COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) _____ and _____
range (and) criteria
The formula =COUNTIF(range, "budget") will count the number of cells in specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted?
the word "budget" can appear anywhere within the cell
Adding comments to a cell is available through which tab of the Excel ribbon?
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 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") values to FALSE
Which of the following is NOT a type of ANOBA (Analysis of Variance) performed using tools in the Analysis ToolPak
single-factor without replication
Which of the following types of data may NOT be contained in a cell in an Excel worksheet?
you select a cell with data "120" in an Excel worksheet and press the "Delete" key on your keyboard. Which of the following holds TRUE?
only the contents of the cell are removed
In Excel, Shift + Spacebar (keyboard shortcut) is used to _____
select a row
What is the shortcut to open the Find and Replace dialog box with the "Find" tab open?
Ctrl + F
you can protect your excel workbook with a password. Which of the following is TRUE about password protected workbooks?
passwords are case sensitive
Which of the following command sequences will allow you to save a copy of your workbook with a different name?
File, Save as
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook?
shift + S
a group of cells is referred to as which of the following?
Which of the following best describes what a Sparkling is?
a min-chart is displayed in a single cell
A bar chart is essentially which of the following chart types rotated 90 degrees clockwise?
Which of the following is an object that contains the actual data in the chart?
Which of the following keyboard shortcuts can be used to activate a different sheet?
what are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet (respectively)?
Which keyboard shortcut is used to select all cells in an open Excel worksheet?
Different table formatting styles can be previewed by mousing over different options within "Table Styles" (i.e., you can see what the appearance will be like without actually applying a new style). Is this statement accurate?
yes, the statement is accurate
when a column is sorted within a table, which of the following is true about the drop-down list in the header row
it displays a different graphic to remind you that the table is sorted by that column
please see the attached workbook image. What sequence of steps will allow you to format the data into a table?
select the data, then click "table" under the "insert" tab of the excel ribbon
to gain access to the table tools / design tab in the excel ribbon when working with tables, you should do the following
click anywhere in the table
please refer to the attached excel workbook. How can you add a dollar ($) symbol to values in a column as seen in the "grand total" column
one way to do this is by going through the "Format Cells" dialog, and selecting 'Accounting" (with a $ symbol and 2 decimal places) as your formatting option form within the number tab
a formula refers to a value in the Total Row of a table. What will happen to the formula result if the option for "'Total Row" (from the Excel ribbon: Table Tools / Designs tab) is unchecked
the formula returns an error
what part(s) of a table can be selected
the entire table, an entire row, or an entire column from a table can be selected
Based on the class lecture, which of the following is true about table renaming?
a table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS)
which of the following actions should be taken while creating a table to display table headers
check "my table has headers"
which of the following types of Cell Formatting can be achieved using the Format Cell feature of Excel
all of the other options are correct
After pressing Alt+H while in an open excel worksheet, a number of key tips are displayed. Which ribbon do these key tips relate to?
would you be able to apply the "watch window" option in multiple sheets at the same time
Please examine the attached workbook. Given the data in Sheet1, which of the following steps should be followed to obtain the data in Sheet2?
select cells A1 through C4 in Sheet1 > copy > go to sheet2 > paste > transpose
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?
What is the shortcut to open the Find and Replace dialog box with the "Replace" tab open
What is the Skip blanks option (under Excel Paste Special option) used for while copying a range to another area?
to prevent blank cells in the copied range from overwriting existing data
In excel, shift + spacebar (keyboard shortcut) is used to
select a row
Which of the following options moves the active cell right one screen
Examine the attached file, if you copy the whole cell "B8" (not only its formula) and paste it into cell "D8" (shaded in green), will it produce the correct total sales value for Quarter 3?
which of the following procedures will NOT close your Excel workbook?
Ctrl + S
You can protect your Excel workbook with a password. Which of the following is TRUE about password protected workbooks?
passwords are case sensitive
which of the following is the file format of the Excel 97-2003 workbook
You enter "(500)" into an unformatted cell in an Excel worksheet (without quotation marks). Which of the following will be generated by your entry?
a negative number
Which keyboard shortcuts can be used to move the active cell one column to the left
left arrow or shift + tab
The excel functions: ISERR() returns TRUE if the cell contains any error value except which of the following
Examine the imagine in question. You can store the results of a formula entered in the formula bar (e.g., =(25*10)/2) as an actual number (e.g., 125) in the active cell. What keyboard shortcut do you need to press while editing the cell to do this?
Which operator in Excel combines multiple range references into a single reference (e.g., if I want to sum up the values in noncontiguous cell-ranges across the worksheet)?
Please select the Excel function which allows us to answer the question: "How many days of stock data do I have?"
What does the Excel keyboard shortcut Ctrl+Alt+F9 do?
forces a complete recalculation of all formulas in all open workbooks
If you copy a formula down a column, and need a cell reference to stay the same (for example, you don't want B2 to change to B3), what type of cell reference do you need? (Example: Use of F4 key)
Please use the attached spreadsheet to test your answer (it has a range "salary" defined).
If your formula uses named cells or ranges, you can either type the name in place of the address, or choose the name from a list and have Excel insert the name for you automatically.
You can also press the ____ button which displays the Paste Name Dialog box. If no names are defined, pressing this button has no effect.
Use the attached spreadsheet to answer the following question. Which formula can be used to find: How many songs were sung by either Eminem or Spears
Used the attached spreadsheet to answer the following question. Which formula can be used to find: How many songs were sung by singers whose last names contain exactly six letters?
The formula =COUNTIF(range, "
") will count the number of cells in the specified range containing the word "budget" in certain positions within the text. Which of the following best describes the cells counted?
the word "budget" can appear anywhere within the cell
To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: __________.
What would you type in the Find and Replace dialog box (Home (tab) -> Editing (command group) -> Find and Select) to find all four-digit entires that begin with 5 and end with 2
Consider the following formula: =SUMIFS(Inventory_Cost, Category, "Beverages", Suppliers, "
") Which of the following statements is TRUE?
Two criteria are checked for this formula to include a value in the total: a) the product category must be "Beverages", and b) the supplier must be "4"
YOU MIGHT ALSO LIKE...
MIS 111 LAB exam 1
MIS112 Midterm 1
MIS LAB Midterm
MIS 111L Midterm
OTHER SETS BY THIS CREATOR
Marketing - quiz 1
Econ final hard stuff