MIS112 Midterm 1
Which of the following functions can be used to count specific types of errors? COUNTA COUNTIF COUNTBLANK COUNT
COUNTIF
Adding comments to a cell is available through which tab of the Excel ribbon? Home Formulas Data Review
Review
Which of the following is NOT a method of creating frequency distributions? use the Review (Proofing) tool of Spelling Error Frequency per Worksheet Write your own formula or function Use the Pivot table feature Use the Analysis ToolPak add-in
use the Review (Proofing) tool of Spelling Error Frequency per Worksheet
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) ":" (colon) ";" (semi colon) " " (space)
"," (comma)
The Excel function: ISERR() returns TRUE if the cell contains any error value except which of the following? #N/A #REF! #VALUE! #NULL!
#N/A
What are the minimum and maximum zoom ranges that can be displayed in an open Excel worksheet (respectively)? 10%, 400% 10%, 500% 10%, 300% 25%, 200%
10%, 400%
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? Correct Answer 4500 500000 4750 Incorrect Response 6750
4500
If cell "A1" contains JOHN F. SMITH and you want this value to be changed into a proper case like John F. Smith, what Excel function would you use? =CASE(A1) =PROPER(A1) =PROPERCASE(A1) =LOWER(A1)
=PROPER(A1)
Which of the following does the search string ~?NULL~? match when entered in the find and replace dialog box? !NULL# ?NULL? ~?NULL~? ~NULL~
?NULL?
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) Absolute Relative Frozen Automated
Absolute
Please select the Excel function which allows us to answer the question: "How many days of stock data do I have?" MIN() MAX() COUNT() SUM()
COUNT()
Which keyboard shortcut is used to select all cells in an open Excel worksheet? Ctrl + A Ctrl + X Ctrl + V Ctrl + C
Ctrl+A
Which of the following shortcuts allows you to enter the same data into multiple selected cells?Example: In a new Excel worksheet select cells A1:B4 and type "MIS111". The text is initially entered into cell A1. What could you do to replicate the same text "MIS111" in all the selected cells? Ctrl+Enter Ctrl+Shift Ctrl+Backspace Ctrl+Insert
Ctrl+Enter
What is the shortcut to open the Find and Replace dialog box with the "Find" tab open? Ctrl+H Ctrl+F Ctrl+A Ctrl+Alt+F
Ctrl+F
Which of the following keyboard shortcuts can be used to activate a different sheet? Alt + PageUp Alt + PageDown Ctrl + PageUp Alt + F4
Ctrl+Page Up
Which of the following command sequences will allow you to save a copy of your workbook with a different name? Ctrl, A Ribbon, Save File, Save As Data, Create Copy
File, Save As
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 insert a function is to use the ______ on the _________ tab. Function Library group (on the) Formulas Formulas group (on the) Functions Functions group (on the) Insert Calculations group (on the) Formulas
Function Library group (on the ) Formulas
Which of the following is NOT one of the Excel functions to determine whether a cell contains an error value? ISERROR ISNA ISLOGICAL ISERR
ISLOGICAL
Which of the following statements is true? They all relate to the formula: =IF( OR(Category="Pasta",Category="Soups"), Inventory_Cost,0 ) This type of IF() functions with an embedded OR() is no longer supported in Excel 2013. Such IF() statements are too complicated for use in business. They are only used by NASA. 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 Using a nested IF() in a formula is not recommended because the formula result is different based on the IQ level of the user.
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? Filename (to import Data from Access) Ignore duplicates vs. Permit duplicates Simple vs. Compound Interest Input Range and Bin Range
Input Range and Bin Range
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 Review (tab) -> Comments (command group) -> Previous Home (tab) -> Navigate (command group) -> Next Comment Page Layout (tab) -> Search (command group) -> Jump To Comment
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 the entire array Selects all graphic objects on the worksheet Selects a rectangular range of cells around the active cell Selects all empty cells
Selects a rectangular range of cells around the active cell
To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: __________. Ctrl+Alt Shift+F2 F5 Ctrl+A
Shift+F2
Which of the following is a shortcut key used to calculate only the formulas in the active worksheet? Shift+F9 all of the choices provided are valid F9 Ctrl+Alt+ F9
Shift+F9
Which of the following procedures will NOT save (nor give you an option to save) your Excel workbook? Shift + S Ctrl + S (Excel ribbon tab) File -> Save clicking the Close (X) button in the workbook's title bar
Shift+S
Which of the following is NOT a type of ANOVA (Analysis of Variance) performed using tools in the Analysis ToolPak? Single-factor Single-factor without replication Two-factor With Replication Two-factor Without Replication
Single-factor without replication
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 ? Side View Toggle Synchronous Scrolling None of the (other) options provided is correct
Synchronous Scrolling
The formula =COUNTIF(range, "*budget*") 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" must appear in the cells surrounded by asterisks (i.e., the * character). The word "budget" can appear anywhere within the cell. It looks specifically for cells containing budget multiplied by some number. For example, a cell containing the formula: "=budget*0.25". Only cells with the text "budget" at the beginning or the end of the cell, are counted. Thus a cell with "budget constraint" is counted, but a cell with "Previous budget estimates" is not counted.
The word "budget" can appear anywhere within the cell.
Which of the following best describes what a Sparkline is? a mini-chart that is displayed in a single cell a blinking line to separate two cells a highlighted cell a dynamic line chart where the lines have metallic color effects
a min-chart that is displayed in a single cell
Examine the 6th argument in the formula below. What kind of argument is it? =SUM(B1, 5, 6, 7, SQRT(4), A1:A5, TRUE) a range reference an empty argument a literal value a logical value
a range reference
Which of the following is the keyboard shortcut that creates a new blank workbook in Excel? a.Ctrl + N b.Ctrl + E c.Ctrl + W d.Ctrl + B
a.Ctrl+N
What characters are NOT allowed in sheet names ? a.[] b., c.! d.All options are correct
a.[]
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 the 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 Delete the sales figure for Monday (seeing the the blank cell will make things clear to the assistant) Set a fill color of dark red for the sales figure cell Make a pie-chart to explain the ratio of sales of Monday to other days in the week so the assistant sees which day has the highest sale
add a comment to the sales figure cell, and explain to your assistant what you want him to do
Which of the following does the Formula Autocomplete feature in Excel take into account? all of the options provided for this answer are valid Excel built-in functions user-defined functions defined names
all of the options provided for this answer are valid
Which of the following statements is true? a.A workbook can have at most 3 worksheets. b.A worksheet can have many workbooks. c.A workbook can have many worksheets. d.A worksheet can have at most 3 workbooks.
c. a workbook can have many worksheets
A bar chart is essentially which of the following chart types rotated 90 degrees clockwise? column line area surface
column
In Excel, the ISNONTEXT() function returns TRUE if its argument refers to which of the following? content other than text (e.g., a date or a number) or a blank cell a cell containing data in a numeric or date format this function is used primarily for blank or empty cells a cell with alphanumeric characters
content other than text (e.g. a date or number) or a blank cell
Which of the following does the function =NOW() return? current date current time current date and time nothing, it is not a valid Excel function
current date and timee
For a range called Data, what does the function =COUNTIF(Data, "<>0") return? number of cells not equal to 0 number containing a positive value number of cells containing a negative value number of blank cells
number of cells not equal to 0
Which of the following types of data may NOT be contained in a cell in an Excel worksheet? objects formulas text numeric
objects
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 the contents and formatting of the cell are removed only the formatting of the cell is removed no changes occur
only the contents of the cell are removed
You can protect your Excel workbook with a password. Which of the following is TRUE about password protected workbooks? passwords are NOT case sensitive passwords are case sensitive if you forget your workbook password, you can email the TA to retrieve it for you workbook passwords automatically expire in 360 days
passwords are case sensitive
Which of the following is an object that contains the actual data in the chart? Correct Answer Plot area Incorrect Response Pie area Bar area Column area
plot area
A group of cells is referred to as which of the following? group range pack class
range
Fill in the blank: The COUNTIF() function used for single-criterion counting formula takes two arguments (or parameters) _______ and ______. range (and) constant expression (and) criteria constant (and) expression range (and) criteria
range (and) criteria
In Excel, Shift + Spacebar (keyboard shortcut) is used to _______. select a row select a column select a range select multiple rows or columns
salects a row
