MIS 112 MIDTERM EXAM

Ace your homework & exams now with Quizwiz!

What is the name of the company that created Excel? a) Microsoft b) Google c) Apple d) Dell

a) Microsoft

The Excel function: ISERR() returns TRUE if the cell contains any error value except which of the following? a) #N/A b) #REF! c) #VALUE! d) #NULL!

a) #N/A

What is the result of the following expressions (formulas), respectively? = (10-6)*10 and = 10-6*10 a) 40 and -50 b) -50 and 40 c) 40 and 50 d) 50 and 40

a) 40 and -50

20130315 represents a date March 15, 2013. To convert this string to an actual date, which of the following formulas can be used? (Assume the data 20130315 is in cell A1). a) =DATE(LEFT(A1,4), MID(A1, 5, 2), RIGHT(A1,2)) b) =DATE(RIGHT(A1,4), MID (A1, 5, 2), LEFT (A1,2)) c) =DATE(LEFT(A1,2), MID(A1, 3, 2), RIGHT(A1,2)) d) =DATE(RIGHT(A1,2), MID(A1, 3, 2), LEFT(A1,2))

a) =DATE(LEFT(A1,4), MID(A1, 5, 2), RIGHT(A1,2))

Suppose you deposit $100 at the beginning of each month (for 12 months) into an account that pays 3.5 percent annual interest compounded monthly. Which formula calculates the future value of your series of deposits? a) =FV(3.5%/12,12,-100,,1) b) =FV(3.5%/12,12,100,,1) c) =FV(3.5%,1,-100,,1) d) None of the above

a) =FV(3.5%/12,12,-100,,1)

Which of the following options, when used as a formula in the custom Data Validation criteria for cell A1, will ensure that the cell entry is a date, and that the date is a Sunday? Hint: Date format: MM/DD/YYYY a) =WEEKDAY(A1)=1 b) =WEEKDAY(A1)=SUNDAY c) =ISSUNDAU(A1)=1 d) =ISWEEKDAY(A1)=SUNDAY

a) =WEEKDAY(A1)=1

A Loan amortization schedule in Excel: a) A table of values that shows various types of information for each payment period of a loan b) A table of values that shows various type of information for any one payment period of a loan c) A table of values that shows only Present Value information for the entire payment period of a loan d) None of the above

a) A table of values that shows various types of information for each payment period of a loan

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? a) Add a comment to the sales figure cell, and explain to your assistant what you want him to do b) Delete the sales figure for Monday (seeing the blank cell will make things clear to the assistant) c) Set a fill color of dark red for the sales figure cell d) 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

a) Add a comment to the sales figure cell, and explain to your assistant what you want him to do

Which of the following is TRUE with respect to charts? a) After you create a chart, you have great deal of flexibility in customizing it b) Data is NOT needed to create a chart c) Plot area contains all the elements of the chart d) A Pie chart is another name for a Column chart

a) After you create a chart, you have great deal of flexibility in customizing it

Which of the following file formats can be opened using Excel 2016? a) All the other options are correct b) XLS c) XLT d) XLA

a) All the other options are correct

The =SUM() function does which of the following in Excel? a) Allows you to total up numbers in a specified range of cells b) Tells you the cumulative sum of interest paid between two time periods c) Shows you the current date and time d) Nothing, it is not a valid Excel function

a) Allows you to total up numbers in a specified range of cells

To view calculated fields and calculated items in a pivot table, which of the following can you do? a) Choose PivotTable Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas b) Choose PivotChart Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas c) Choose Pivot -> Analyze -> Calculations d) Choose Analyze -> Calculations -> Field, Items & Sets -> List Formulas -> PivotTable Tools

a) Choose PivotTable Tools -> Analyze -> Calculations -> Field, Items & Sets -> List Formulas

What does the following formula =A1=C12 do? a) Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE b) Copies the value in cell C12 to cell A1 c) Copies the value in cell A1 to cell C12 d) Subtracts the value in the cell C12 from the value in the cell A1

a) Compares cell A1 with cell C12. If the cells are identical, the formula returns TRUE; otherwise, it returns FALSE

To open an HTML file stored on a Web server using Excel, what needs to be done? a) Copy the URL and paste it into the Name Field in the Open dialog box b) Excel cannot open an HTML file stored on a Web server c) Type the name of the HTML file in the Name Field in the Open dialog box d) Choose File --> Open --> Get External Data --> From Web

a) Copy the URL and paste it into the Name Field in the Open dialog box

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? a) Ctrl + Enter b) Ctrl + Shift c) Ctrl + Backspace d) Ctrl + Insert

a) Ctrl + Enter

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

Which of the following keyboard shortcuts "cuts" the current selection of cells to both the Windows and Office clipboards? a) Ctrl + X b) Ctrl + V c) Ctrl + C d) Ctrl + Z

a) Ctrl + X

When you have imported data from an external data source, you can change properties of the 'external data range' by using the External Data Properties dialog box. How will you open this dialog box? a) Data(tab) -> Connections(group) -> Properties b) Data(tab) -> Connections c) Data(tab) -> Connections(group) -> Connections d) Data(tab) -> Connections(group) -> Refresh

a) Data(tab)-> Connections(group) -> Properties

What command (within Conditional Formatting, Manage Rules) is used to delete a specific rule from a worksheet? a) Delete Rule b) Clear Rule c) Alter Rule d) New Rule

a) Delete Rule

The Analysis Toolpak can be activated through which sequence of steps? a) File -> Options -> Add ins -> Manage Excel Add-ins -> Go b) Data -> Data Validation -> Manage Excel Add-ins -> OK c) Tools -> Options -> Data -> What-if Analysis d) Home -> Ribbon -> Analyze -> Analysis Toolpak

a) File -> Options -> Add ins -> Manage Excel Add-ins -> Go

The HYPERLINK function syntax has two arguments. Which argument has the jump text or numeric value that is displayed in the cell? a) Friendly_name b) Link_location c) Name d) File

a) Friendly_name

Which keyboard shortcuts can be used to move the active cell one column to the left? a) Left arrow or Shift + Tab b) Left arrow or Tab c) Left arrow or Ctrl + Tab d) Left arrow or Alt + Tab

a) Left arrow or Shift + Tab

Which of the following is an object that contains the actual data in the chart? a) Plot area b) Pie area c) Bar area d) Column area

a) Plot area

What does the following formula do? =COUNTIF(Data, TODAY()) a) Returns the number of cells containing the current date in the range named Data b) Returns the number of cells that were last changed on the current date in the range named Data c) "Returns the number of cells containing the text "TODAY()"" in the range named Data." d) Returns the value of the cells containing the current date in the range named Data.

a) Returns the number of cells containing the current date in the range named Data

To avoid printing more pages than necessary in Excel, you can use the following command: ____________. a) Set Print Area b) Reset Page Breaks c) Page Layout: Squashed d) Background Printing

a) Set Print Area

Which formula would you use if you want to accept only text that begins with a specific character 'a' for a given cell 'A1'? a) Use a formula: = LEFT(A1)="a" b) Use a formula: = RIGHT(A1)='a' c) Use a formula: =UPPER(A1)='A' d) None of the options provided is valid

a) Use a formula: =LEFT(A1)="a"

Which of the following options provides correct syntax for the VLOOKUP function? a) VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) b) VLOOKUP(lookup_value, table_array, row_index_num, range_lookup) c) Either of the two previous choices will work d) None of the options provided is valid

a) VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

You can use a data Form to add, find, and edit rows in a range or table. Is this correct? a) Yes, all these are valid form operations b) Incorrect, as adding rows is not supported c) False, Data forms work only with Tables, not with Ranges d) No, Data forms work only with Ranges, not with Tables

a) Yes, all these are valid form operations

In an Excel Form, when finding a row by entering search criteria: Will the question mark symbol "?" find or match any single character? a) Yes, the "?" symbol is used to find/match a single character b) No, the asterisk or "*" symbol is used to match/find a single character c) The symbol for a single character is the tilde: ~ d) One of the limitations of form-based searching is the inability to find/match single characters

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

Which of the following types (chart types) is a VALID option in the Charts ribbon group on the Insert ribbon tab? a) all of the options provided are valid b) area c) scatter d) column

a) all of the options provided are valid

Which of the following function(s) can be used to count error values in a range? a) all of the provided choices are valid b) ISERROR() c) ISERR() d) ISNA()

a) all of the provided choices are valid

In Excel, a parameter query is a query that prompts for _________ every time it is run. a) an input b) a password c) an image d) a fingerprint

a) an input

When you create one or more Sparklines in Excel, by default they all use ________ axis scaling a) automatic b) manual c) batch d) linear

a) automatic

A bar chart is essentially which of the following chart types rotated 90 degrees clockwise? a) column b) line c) area d) surface

a) column

In Step 1 of the Query Wizard, you select database _________ that you want to appear in your query. a) columns b) records c) rows d) sort order

a) columns

In Excel, what does the MODE function in a range return? a) most frequently occurring value in a range b) mean of the values in the range c) most frequently occurring text entry in a range d) middle value of the range

a) most frequently occurring value in a range

For a range called DATA, what does the function =COUNTIF(Data, TODAY()) return? a) number of cells containing the current date b) current date c) cells containing the current date d) cells not containing the current date

a) number of cells containing the current date

A ___________ is a graphical data representation of data displayed in a pivot table. a) pivot chart b) reverse pivot pie chart c) slicer d) sparkline

a) pivot chart

Which of the following is NOT a method of creating frequency distributions? a) use the Review (Proofing) tool of Spelling Error Frequency per Worksheet b) Write your own formula or function c) Use the Pivot table feature d) Use the Analysis ToolPak add-in

a) use the Review (Proofing) tool

What is the file format (file extension) used when you save an Excel workbook as a single file webpage? a) .html b) .mht or .mhtml c) .xlsx d) .txt

b) .mht or .mhtml

To create a hyperlink to a specific location in a Microsoft Word document, you must use a bookmark to define the location you want to jump to in the document. Which of the following is the right option to create a hyperlink to the bookmark 'QrtlyProfits' in the document 'Annual Report.doc' located at http://example.microsoft.com. The link text to be displayed is "Quarterly Profit Report". a) =HYPERLINK("[Example.xlsx]E2", "Quarterly Profit Report") b) =HYPERLINK("[http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report") c) =HYPERLINK("[Annual Report.docx]QrtlyProfits", "Quarterly Profit Report") d) =HYPERLINK("QrtlyProfits", "Quarterly Profit Report")

b) =HYPERLINK("[http://example.microsoft.com/AnnualReport.docx]QrtlyProfits"',"Quarterly Profit Report")

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? a) =CASE(A1) b) =PROPER(A1) c) =PROPERCASE(A1) d) =LOWER(A1)

b) =PROPER(A1)

Which of the following does the search string ~?NULL~? match when entered in the find and replace dialog box? a) !NULL# b) ?NULL? c) ~?NULL~? d) ~NULL~

b) ?NULL?

There are a few commands that could be used to customize spark lines to highlight parts of data. One of them is Negative Points. What is its purpose? a) Apply a different color to the highest data point in the Sparkline b) Apply a different color to the negative values in the Sparkline c) Apply a different color to the lowest data point in the Sparkline d) Apply a different color to the first data point in the Sparkline

b) Apply a different color to the negative values in the Sparkline

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? a) At the beginning b) At the end c) Excel cannot sort ranges with blank values d) Excel leaves the blank values in their original location

b) At the end

Which of the following functions can be used to count specific types of errors? a) COUNTA b) COUNTIF c) COUNTBLANK d) COUNT

b) COUNTIF

How do you set up a data validations (using the data validation dialog box) that restricts data entry to a text of a specified length? a) Click the Settings tab (in the Data Validation box). In the Allow box, select 'date'. In the Data box, select 'greater than' b) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Text Length', 'equal to', and specify the length c) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Decimal'. In the Data box, select 'between' d) Home (tab) -> Editing (group) -> Find&Select -> Data Validation

b) Click the Settings tab (in the Data Validation box). In the Allow box, select 'Text Length', 'equal to', and specify the length

Which of the following keyboard shortcuts can be used in Excel 2016 to create a table? a) Ctrl + F2 b) Ctrl + L c) Alt + T d) Ctrl + Alt + L

b) Ctrl + L

When a header or footer section is activated, you can insert any of several element codes from the Header & Footer Elements group. Each button inserts a code into the selected sections. What is the purpose of the following code: &[Path]&[File]? a) Displays the workbooks complete path b) Displays the workbooks complete path and filename c) Displays the workbooks filename d) None of the above

b) Displays the workbooks complete path and filename

The _______ function is used to return a specific number of letters or characters from the start of a text string. a) FROMRIGHT() b) LEFT() c) MID() d) SUM()

b) LEFT()

What statement about the two Hyperlink arguments Hyperlink(link_location,[friendly_name]) is TRUE? a) Link_location is required, Friendly_name is required b) Link_location is required, Friendly_name is optional c) Link_location is optional, Friendly_name is required d) Link_location is optional, Friendly_name is optional

b) Link_location is required, Friendly_name is optional

To view or edit a comment, you can select the cell where a comment has been attached and press the following keyboard shortcut: ___________ a) Ctrl + Alt b) Shift + F2 c) F5 d) Ctrl + A

b) Shift + F2

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 / Design tab) is unchecked? a) The formula will now result in an answer of 0 b) The formula returns an error c) The formula will continue to work whether the "Total Row" option is checked or unchecked d) The formula will return the value "N/A" or be automatically hidden depending on whether you sort data Smallest to Largest or Largest to Smallest

b) The formula returns an error

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? a) The word "budget" must appear in the cells surrounded by asterisks (i.e., the * character). b) The word "budget" can appear anywhere within the cell. c) It looks specifically for cells containing budget multiplied by some number. For example, a cell containing the formula: "=budget*0.25". d) 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.

b) The word "budget" can appear anywhere within the cell

To find an asterisk (*) within a cell, you enter which of the following in an Excel form search criteria? a) a tilde followed by a question mark b) a tilde followed by an asterisk c) a tilde by itself d) this is a type of search you cannot do with Excel Forms

b) a tilde followed by an asterisk

To remove a single individual field from a report, _______ the check box beside the field name in the PivotTable Field List. a) check b) clear c) fill d) drag

b) clear

The __________ command is used to display text on multiple lines in a cell. a) shrink to fit b) wrap text c) merge cells d) icon formatting

b) wrap text

How many sort options/commands do we have in Excel under the 'Data' tab? a) 1 b) 2 c) 3 d) 4

c) 3

To extract a student's first name (e.g., "Herbert" from their full name (e.g., "Herbert Smith"), which of the following functions will you typically use? a) A combination of DATE(), FIND() and FIRST() b) A combination of REPT() and CONCATENATE() c) A combination of FIND() and MID() d) The function FIRST()

c) A combination of FIND() and MID()

Which of the following statements is true? a) A workbook can have at most 3 worksheets b) A workbook 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

Which of the following is true for printing a worksheet that contains objects/shapes? a) Objects are printed along in the worksheet by default b) You can avoid printing the object by making changes to the properties of the shape c) Both of the above d) None of the above

c) Both of the above

What option in the Table Tools / Design tab removes a table without losing the data in it? a) Remove Duplicates b) Summarize with PivotTable c) Convert to Range d) Delete Table

c) Convert to Range

What is the shortcut to open the Find and Replace dialog box with the "Replace" tab open? a) Ctrl + F b) Ctrl + A c) Ctrl + H d) Ctrl + FIND

c) Ctrl + H

Which of the following command sequences will allow you to save a copy of your workbook with a different name? a) Ctrl, A b) Ribbon, Save c) File, Save As d) Data, Create Copy

c) File, Save As

Which of the following statements is true? They all relate to the formula: =IF ( OR(Category="Pasta",Category="Soups"), Inventory_Cost,0 ) a) This type of IF() functions with an embedded OF() is no longer supported in Excel 2013 b) Such IF() statements are too complicated for use in business. They are only used by NASA c) 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 d) Using a nested IF() in a formula is not recommended because the formula result is different based on the IQ level of the user

c) 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 for the category ="Pasta") evaluates to FALSE

Which of the following is NOT a formatting option offered through the Mini Toolbar? (Hint: for more information on the mini-toolbar you can right click on an Excel cell) a) Comma Style b) Format Painter c) Left Align d) Center Align

c) Left Align

Does deleting a cell by pressing the Delete key also delete the conditional formatting on the cell? a) Yes, but only if the data is text b) Yes c) No d) No, it only deletes the cell's style

c) No

Which of the following is TRUE about sorting a table? a) Sorting a table is not possible b) Words cannot be sorted, while numbers can be sorted c) Sorting a table re-arranges the rows based on the contents of a particular column d) Sorting the rows based on the background or text color of the data is not possible

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

Which of the following does the function =NOW() return? a) current date b) current time c) current date and time d) nothing, it is not a valid Excel function

c) current date and time

While creating a parameterized web query the ampersand character (&) is used to _________. a) delimit the parameter from the prompt b) delimit the name from the value c) delimit each name/ value pair d) begin the URL query string

c) delimit each name/ value pair

What does the Excel keyboard shortcut Ctrl+Alt+F9? a) highlights error codes in the current workbook b) calculates only the formulas in the active worksheet. Other worksheets in the same workbook aren't calculated c) forces a complete recalculation of all formulas in all open workbooks d) Ctrl+Alt+F9 will not do anything in Excel

c) forces a complete recalculation of all formulas in all open workbooks

What best describes the connection between a Pivot Table and a Pivot Chart? a) one-way link (updates from the Pivot Table are reflected in the chart, but not vice versa) b) one-way link (updates from the Pivot Chart are reflected in the Pivot Table, but not vice versa) c) two-way link (updates made in the Pivot Chart are reflected in the PivotTable) d) broken link

c) two-way link (updates made in the Pivot Chart are reflected in the PivotTable)

What result does the following formula display? =DOLLAR(5742.999,2) a) $5,742.99 b) $5742.99 c) $2,999,2475 d) $5,743.00

d) $5,743.00

To display today's date in the format like "Today is Friday April 4, 2014", which formula should you use? a) ="Today is "&TEXT(TODAY(),"dddd, mmmm, yy") b) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yy") c) ="Today is "&TEXT(TODAY(),"dddd, mmmm, yyyy") d) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")

d) ="Today is "&TEXT(TODAY(),"dddd, mmmm d, yyyy")

Which of the following formulas round a time in cell B2 to the closest minutes? (You can assume relevant cells have Excel's Time formatting). a) =ROUND(B2*24,0)/24 b) =ROUND(B2*60,0)/60 c) =ROUND(B2*30,0)/30 d) =ROUND(B2*1440,0)/1440

d) =ROUND(B2*1440.0)/1440

If you write a lookup formula to look up the text 'education', the formula considers which of the following a match? a) EDUCATION b) Education c) education d) All answers provided are correct

d) All answers provided are correct

Which of the following file types can Excel import? a) XML Files (.xml) b) Comma separated values (.csv) c) Microsoft Access (.accdb) d) All of the file types

d) All of the file types

How can you avoid the "#NAME?" error value? a) If the formula uses a label in a formula, make sure labels are allowed b) Enclose any text in double quotation marks c) Make sure all range references in the formula use a colon d) All of the options provided are correct