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