Nat's MIS 111 Lab Final Study Guide

Which if the following statements is true? 1) A workbook can have at most 3 worksheets. 2) A worksheet can have many workbooks. 3) A workbook can have many worksheets. 4) A worksheet can have at most 3 workbooks.

3) A workbook can have many worksheets.

Please select the Excel function which allows us to answer the question: "How many days of stock data do I have?" You many refer to the image in the question. 1) MIN( ) 2) MAX( ) 3) COUNT( ) 4)SUM( )

3) COUNT( )

A group of cells is referred to as which of the following? 1) group 2) range 3) pack 4) class

2) range

The Excel function: ISERR ( ) returns TRUE if the cell contains any error value except which of the following? 1) #N/A 2) #REF! 3) #VALUE! 4) #NULL!

1) #N/A

Please see the attached Excel workbook image in answering this question. In order to sort the 'Salesperson' column in a descending order, which of the following steps is correct? 1) Click on any cell containing Salespersons data, from the Ribbon pick the Data tab, and then click on the "Sort Z to A" command button 2) Select the entire Salesperson Column, then Click on the Review tab (in the Excel ribbon), followed by clicking on Group and "Sort" 3) The Salesperson column cannot be sorted 4) Convert the data into a Table, right click on the Table header and select the A-to-Z sort option

1) Click on any cell containing Salespersons data, from the Ribbon pick the Data tab, and then click on the "Sort Z to A" command button

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

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

Which keyboard shortcut is used to select all cells in an open Excel worksheet? 1) Ctrl + A 2) Ctrl + X 3) Ctrl + V 4) Ctrl + C

1) 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? 1) Ctrl+Enter 2) Ctrl+Shift 3) Ctrl+Backspace 4) Ctrl+Insert

1) Ctrl+Enter

If you want to print a copy of a worksheet, which of the following would you choose? 1) File (tab) -> Print and then choose the PRINT command. 2)Home (tab) -> Print and then press the PRINT button. 3)Page (tab) -> Print and then press the PRINTOUT button. 4)Press Alt+N, and then press the PRINTOUT command

1) File (tab) -> Print and then choose the PRINT command.

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? 1) Home 2) Review 3) Insert 4) Formulas

1) Home

Which type of chart does not allow format changes to the Plot area? 1) None of the (other) options provided is correct 2) Thermometer chart 3) Bar chart 4) Treemap

1) None of the (other) options provided is correct

Which of the following is an object that contains the actual data in the chart? 1) Plot area 2) Pie area 3) Bar area 4) Column area

1) Plot area

Which of the following types (chart types) is a VALID option in the charts ribbon group on the Insert ribbon tab? 1) all of the options provided are valid 2) area 3) scatter 4) column

1) all of the options provided are valid

Which of the following does the Formula Autocomplete feature in Excel take into account? 1) all of the options provided for this answer are valid 2) Excel built-in functions 3) user-defined functions 4) defined names

1) all of the options provided for this answer are valid

In Excel, a parameter query is a query that prompts for ________ every time it is run. 1) an input 2) a password 3) an image 4) a fingerprint

1) an input

Which of the following option is NOT available after right clicking on an Excel worksheet tab? 1) changing the font color in the worksheet 2) changing the color of the worksheet tab 3) hiding the tab 4) changing the name of the worksheet

1) changing the font color in the worksheet

Please refer to the figure. The address of the active cell consists of which of the following? 1) column letter, row number 2) column height, row width 3) column letter 4) row number

1) column letter, row number

In Excel, the ISNONTEXT ( ) function returns TRUE if its argument refers to which of the following? 1) content other than text (e.g., a date or a number) or a blank cell 2) a cell containing data in a numeric or date format 3) this function is used primarily for blank or empty cells 4) a cell with alphanumeric characters

1) content other than text (e.g., a date or a number) or a blank cell

Fill in the blanks: A cell in an Excel worksheet is identified by its address, which consists of a column ____ and row _______. 1) letter, number 2) number, letter 3) value, range 4) range, value

1) letter, number

What does Excel display when you enter the formula =DATE(2014,13,1)? 1)"1/1/2015" 2)"1/1/2014" 3)"1/31/2014" 4)"1/31/2015"

1)"1/1/2015"

There is a type of investment in which you make a stream of fixed payments (e.g., as a series of investment deposits into an account). What is this type of investment called? 1)Annuity 2)Loan 3)Payment 4)Interest

1)Annuity

What is the purpose of the function TIME()? 1)Converts the input hours, minutes & seconds to a serial number 2)Returns the current time 3)Returns the serial number of the current date and time 4)Converts a time in the form of text string (e.g., "18:45") to a serial number

1)Converts the input hours, minutes & seconds to a serial number

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 section. What is the purpose of the following code: &[Date] ? 1)Displays the current date 2)Displays the date when the workbook was created 3)Displays the date when the workbook was last modified 4) None of the above

1)Displays the current date

The HYPERLINK function syntax has two arguments. Which argument has the jump text or numeric value that is displayed in the cell? 1)Friendly_name 2)Link_location 3)Name 4)File

1)Friendly_name

Which of the following is one of the ways to create a Pivot Chart? 1)Insert (tab) -> Charts (group) -> PivotChart 2)Insert (tab) -> Sparklines (group) -> PivotChart 3)Insert (tab) -> Tables (group) -> PivotChart 4)Insert (tab) -> Illustrations (group) -> Shapes -> PivotChart

1)Insert (tab) -> Charts (group) -> PivotChart

The HYPERLINK function syntax has two arguments. Which argument has the path and file name to the document to be opened? 1)Link_location 2)Friendly_name 3)Name 4)File

1)Link_location

What is Not the purpose of using Slicers? 1)Make table more beautiful 2)Easy to filer data in a pivot table 3)Help those who don't understand using field labels to filer data 4)create an easy-to-use interactive ""dashboard"

1)Make table more beautiful

How can you define a Print Area after selecting the required cells on the worksheet? 1)On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area. 2)On the Page Layout tab, in the Page Setup group, click Print Area, and then click Custom Print Area. 3)On the Page Layout tab, in the Page Setup group, click Print Area, and then click Clear Print Area. 4)Press the keyboard shortcut of: Ctrl+!

1)On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

When importing a text file into Excel, the _____________ helps specify how the data will be imported. 1)Text Import Wizard 2)External Data Wizard 3)CSV Wizard 4)Text Preview Panel

1)Text Import Wizard

What is the output of the following command sequence: click the Analyze tab under PivotTable tools -> Actions (group) -> Clear -> Clear Filters? 1)This removes all the filters at once 2)This removes only filters on the selected column (or row) 3)This does not remove any filters 4)This is not a valid command sequence for any pivot table

1)This removes all the filters at once

When you try to import data from MS-Access into Excel, which of the following is TRUE? 1)You can import a table or a query 2)Excel no longer supports this type of import 3)Excel imports reports, forms and query SQL 4)You must convert the database into XML output before the import

1)You can import a table or a query

The Linked Picture paste option in Excel ________. 1)allows you to link to a clip-art, instead of saving it within your workbook 2)is a dynamic / live picture of the range you copy 3)Both options (A) and (B) 4)is primarily used with WordArt

1)allows you to link to a clip-art, instead of saving it within your workbook

When you create one or more Sparklines in Excel, by default they all use _________ axis scaling. 1)automatic 2)manual 3)batch 4)linear

1)automatic

When do you use the following sequence of commands: PivotTable Tools -> Analyze -> PivotTable -> Options -> Generate GetPivot Data? 1)prevent Excel from using GETPIVOTDATA function 2)make use of GETPIVOTDATA function 3)add GETPIVOTDATA function to the pivot table 4)enable GETPIVOTDATA function for the pivot table

1)prevent Excel from using GETPIVOTDATA function

Please choose the formula that will calculate the future value of a $6,500 investment at 4.55 percent compounded continuously for 4 years. 1)=6500+EXP(4.55%*4) 2) =6500*EXP(4.55%*4) 3)=6500/EXP(4.55%*4) 4)=6500+EXP(4.55%+4)

2) =6500*EXP(4.55%*4)

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? 1) =CASE(A1) 2) =PROPER(A1) 3) =PROPERCASE(A1) 4) =LOWER(A1)

2) =PROPER(A1)

Please see the attached workbook image. What sequence of steps will allow you to format the data into a table? 1) Select data, then click "Ctrl + 1" and choose the "Table Creation" option 2) Select the data, then click "Table under the "Insert" tab of the Excel Ribbon 3) Select data, then click on conditional formatting command in Excel 4) Select data, then click the "Convert to Table" option under the Table Tools / Design tab

2) Select the data, then click "Table under the "Insert" tab of the Excel Ribbon

What characters are NOT allowed in sheet names? 1) All options are correct 2) [ ] 3) , 4) !

2) [ ]

A data form provides a convenient means to enter, display and search for data within a table. It also permits you to do the following: _______ 1) over-write calculated columns 2) delete a record/row 3) freeze panes 4) create a new table

2) delete a record/row

What is the file format (file extension) used when you save an Excel workbook as a single file webpage? 1).html 2).mht or .mhtml 3).xlsx 4).txt

2).mht or .mhtml

Which of the following formulas is used to determine whether the date in cell D4 is part of a leap year? 1)=DAY(DATE(YEAR(D4), MONTH(D4)+1,LEAP)) 2)=IF(MONTH(DATE(YEAR(D4),2,29))=2,TRUE,FALSE) 3)=LEAPYEAR(A1) 4)None of the answers provided is correct

2)=IF(MONTH(DATE(YEAR(D4),2,29))=2,TRUE,FALSE)

Converting a string (e.g., an email address) to purely lowercase, can be done using which of the following functions? 1) =CONVERTCASE() 2)=LOWER() 3)=CASECHANGE() 4)=EMAIL()

2)=LOWER()

A pivot chart is which of the following? 1)A bar chart that can pivot to a pie chart form with a single click 2)A graphical representation of a data summarized in a pivot table 3)A chart that is joined to a pivot table in a 4-way link 4)A chart that cannot be used with a slicer

2)A graphical representation of a data summarized in a pivot table

There are a few commands that could be used to customize sparklines to highlight parts of data. One of them is Negative Points. What is its purpose? 1)Apply a different color to the highest data point in the Sparkline 2)Apply a different color to negative values in the Sparkline 3)Apply a different color to the lowest data point in the Sparkline 4)Apply a different color to the first data point in the Sparkline

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

Which is one of the ways to refresh a query used to import data from external data source using the query wizard? 1)Data (tab) -> Connections (group) -> Properties 2)Data (tab) -> Connections (group) -> Refresh All 3)Refresh 4)Data (tab) -> Connections (group) -> All

2)Data (tab) -> Connections (group) -> Refresh All

________ can be used to check whether all of the columns fit on one page before printing an Excel worksheet. 1)Quick Print 2)Print Preview 3)Page Layout 4)A Pivot Table

2)Print Preview

What is the syntax for the RATE() function? 1)RATE(nper,[fv],[type],[guess]) 2)RATE(nper,pmt,pv,[fv],[type],[guess]) 3)RATE(rate,nper,pmt,pv,[fv],[type]) 4)RATE(nper,pmt,pv,[guess])

2)RATE(nper,pmt,pv,[fv],[type],[guess])

The __________ function will be used as part of a formula to calculate how many days old you are today. 1)YESTERDAY() 2)TODAY() 3)BIRTHDAY() 4)HOWOLDAMI()

2)TODAY()

A calculated field must reside in the ________ area of the pivot table. 1)Column 2)Values 3)Rows 4)Report Filter

2)Values

The formula: =CHAR(CODE("A")+32) returns which of the following? 1)97 2)a 3)C 4)B

2)a

Consider a Column Sparkline with three columns. A wide area of blank space between two columns in a sparkline corresponds to which of the following? 1)boolean data 2)missing data 3)a right aligned cell 4)a value formatted as currency (not supported by sparklines)

2)missing data

In Excel, dates are stored as _________. 1)alphanumeric characters 2)numbers 3)alphabets 4)special characters

2)numbers

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. 1) F1 2) F2 3) F3 4) F4

3) F3

Microsoft Office Excel can automatically generate a data form (which allows for convenient data entry, among other things) for your range or ________. 1) Chart 2) Field 3) Table 4) Record

3) Table

The Pivot Table Field List shows which of the following? 1)Columns from the source data only 2)Columns and Rows from the source data 3)Columns from the source data and Groups defined in the Pivot Table 4)Names of available charts

3)Columns from the source data and Groups defined in the Pivot Table

What is the purpose of the Text to Columns command? 1)It combines several columns of text into a single column. 2)It creates several columns within a single text cell. 3)It parses strings into their component parts. 4)It adds commas to text to separate values.

3)It parses strings into their component parts.

The _________ function can return a specified number of characters beginning at any position within a string. 1)INSIDE() 2)LEFT() 3)MID() 4)EXTRACT()

3)MID()

Which command helps you to override the automatic behavior and control max and min value for Sparklines? 1)Sparkline tools-> Design-> Group -> Line 2)Sparkline tools-> Design-> Group ->Tables 3)Sparkline tools-> Design-> Group -> Axis 4)Sparkline tools-> Design-> Group -> Chart

3)Sparkline tools-> Design-> Group -> Axis

Which of the following is TRUE about the DATEDIF() function? 1)It can be found under the dropdown function for the Date & Time category 2)It appears in the Insert function dialog box 3)You must enter it manually 4)The function has four arguments

3)You must enter it manually

Which function is used to calculate depreciation in Excel using the straight line method? 1)DB() 2)DDB() 3)SYD() 4) None of the above

4) None of the above

Which financial function returns the loan payment (principal plus interest) per period, assuming constant payment amounts and a fixed interest rate? 1)CUMPRINC() 2)IPMT() 3)PPMT() 4) PMT()

4) PMT()

Please examine the attached workbook. Given the data in Sheet1, which of the following steps should be followed to obtain the data in Sheet2? 1) Select cells A1 through C4 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -> Paste 2) It is only possible if done manually 3) Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas 4) Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose

4) Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose

Which of the following is NOT one of the types of Sparkline graphics? 1) Line 2) Column 3) Win/Loss 4) Slicer

4) Slicer

Would you be able to apply the "watch window" option in multiple sheets at the same time? 1) Yes, but only if there are no more than 3 sheets in the workbook 2) No 3) This option was available in Excel 2013 but not in Excel 2016 4) Yes

4) Yes

Which of the following is TRUE about a Watermark in Excel? 1)A watermark is an image (or text) that appears on each printed page. 2)A watermark can be a faint company logo, or a word such as DRAFT. 3)Excel doesn t have an official command to print a watermark, but you can add a watermark by inserting a picture in the page header or footer. 4)All of the above statements are TRUE.

4)All of the above statements are TRUE.

Excel has many Shapes to choose from, but sometimes the Shape you need isn't in the gallery. In such a case, you may modify one of the existing shapes using which of these techniques? 1)Rotate shape 2)Edit the shape's points 3)Create a Freeform shape 4)All of the options provided are correct

4)All of the options provided are correct

When customizing a sparkline, which of the following is NOT one of the options? 1) Change the width or height of a cell. 2)Insert a Sparkline into merged cells. 3)Change the Sparkline type. 4)Convert the Sparkline into a table.

4)Convert the Sparkline into a table.

If you need to display lots of text in a worksheet, you can consider using a text box. How will you insert a textbox? 1)Insert (tab) -> Links (command group) -> Text Box 2)Insert (tab) -> Symbols (command group) -> Text Box 3)Home (tab) -> Text(command group) -> Text Box 4)Insert (tab) -> Text (command group) -> Text Box

4)Insert (tab) -> Text (command group) -> Text Box