MIS 112: Final Exam

a. a number is divided by zero!

What does it mean when Excel displays the following error? #DIV/0! a. a number is divided by zero! b. a number is divided by infinity! c. unrecognized text d. non of the options provided is correct

d. No margins

Which of the following is NOT one of the four quick margin settings for adjusting margins? a. Normal b. Wide c. Narrow d. No margins

a. slicers also work with pivot charts

Which of the following is TRUE about Pivot Charts? a. slicers also work with pivot charts b. by default, pivot charts are embedded in a new worksheet c. Pivot Charts work in Excel 2010 but not Excel 2016 d. the default pivot chart type is a pie chart

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

Which of the following is TRUE with respect to charts? A. After you create a chart, you have a 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

b. ---URL---?<Name>=<Val>

Which of the following is a VALID format for a URL query string in Excel? a. ---URL---?<Val>=<Name> b. ---URL---?<Name>=<Val> c. ---URL---<Name>=<Val>? d. ---URL---?name?value

A. Calibri, 11 point

Which of the following is the default font type and font size in Excel 2016 A. Calibri, 11 point B. Arial, 12 point C. Times New Roman, 10 point D. Cambria, 14 point

Ctrl + N

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+S

Which of the following procedures will not close your Excel workbook? A. Ctrl+S B. Ctrl+F4 C. Ctrl+W D. File -> Close

B.Yes

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

a. REPLACE()

______________ replaces part of text string that appears in a specific location within a string. Hint: This function can be used when you know the character location of the text to be replaced. a. REPLACE() b. SEARCH_AND_REPLACE() c. FINDREPLACE() d. SEARCHREPLACE()

A. Select cells for salary, click on "Conditional Formatting" under the Styles command group, under "Highlight Cells Rules" choose "Greater than", then enter 2000

check_formatting_steps.xlsx Please see the attached workbook. Which of the following is the correct sequence of steps to be followed to see employees with a salary over 2000? A. Select cells for salary, click on "Conditional Formatting" under the Styles command group, under "Highlight Cells Rules" choose "Greater than", then enter 2000 B. Select salary cells and click on "Cell Styles" under Styles C. Select Salary and click on "Wrap Text" under Alignment D. None of the options provided is valid

d. C

dataLookup_eg5.xlsx Please see the attached workbook. What will be the grade of Adams if the following formula is used in the cell C2? =LOOKUP(B2,{45,50,60,70,80,90},{"F","E","D","C","B","A"}) a. F b. B c. A d. C

a. 2

dataLookup_eg7.xlsx Please see the attached workbook. If the formula =MATCH(B2,I4:I7,0) was used in cell B3, what would be the result? a. 2 b. 3 c. 1 d. 0

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

A Loan amortization schedule in Excel is : 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 types 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

c. two-way

A _____ data table in Excel shows the result of a single calculation for different values of two input cells a. multiple b. one-way c. two-way d. None of the above

B. delete a record/row

A data form provides a convenient means to enter, display and search for data within table. It also permits you to do the following: A. over write calculated columns B. delete a record/row C. freeze panes D. create a new table

b. specify a time period for which you need the data

A date filter in Pivot Tables is used to _____ a. return the date of the transaction b. specify a time period for which you need the data c. change the date of a transactions (e.g., a sale) d. modify the date in your underlying table

B. The formula returns an error.

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 will return the value "N/A" or be automatically hidden depending on whether you sort data Smallest to Largest or Largest to Smallest.

B. range

A group of cells is referred to as which of the following? A. group B. range C. pack D. class

a. also changes

A pivot table and a pivot chart are joined in a two-way link, if you make structural or filtering changes to one, the other _______. a. also changes b. remains unchanged c. shows a sparkling graphic to highlight the change d. can be eliminated to avoid duplicates

d. 32000

A single cell in Excel can hold up to approximately ________________ characters. a. 5000 b. 10000 c. 50000 d. 32000

d. all options: 2 color scale, 3 color scale, and data bar are available

Choosing: conditional formatting> color scales > more rules > format styles: allows you to change formatting rules for a color scale. Which of the following formatting options are available? a. 2-color scale, but not 3-Scale Scale b. 3-color scale, but not data bar c. data bar, but not 2 color scale d. all options: 2 color scale, 3 color scale, and data bar are available

B. Three of the Histogram bins will have a different count

Examine the attached Excel data file (Histogram.xlsx) and image (Histogram.png). If you used the Excel data file to generate a histogram (you can use the Analysis Toolpak for that), and compared it with the histogram in the image, which of the following options best describes what would you see? A. The histograms would be identical B. Three of the Histogram bins will have a different count C. The histograms would be identical except for the Horizontal axis labels (taken from the "Ranges" column) D. Two of the Histogram bins will have a different count

D. The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar

Excel formatting tools are available at the following locations: A. The Format Cells dialog box and the Home Tab of the Ribbon B. On the Home Tab of the Ribbon only C. On the Mini toolbar that appears when you right-click a range or a cell, and the Home Tab of the Excel Ribbon D. The Format Cells dialog box, the Home Tab of the Ribbon, the Mini toolbar

b. visualize, trends

Fill in the blanks: conditional formatting effects help us ____ values in cells making it easier to locate data, find exceptions and spot _____ quickly. a. correct, trends b. visualize, trends c. exact, macros d. visualize, conditions

a. functions

HLOOKUP and VLOOKUP are both _________ in Excel a. functions b. formatting options c. interest payment calculation functions d. style and theme related options

C. 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 from within the Number tab

How can you add a dollar ($) symbol to values in a column as seen in the "Grand Total" column? A. The simplest way is to click on the "Wrap text" button in Home tab. From the dialog box that pops up, pick the default $-symbol formatting. B. This is automatically provided to you when you make an Excel Table C. 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 from within the Number tab D. The correct way to do this is by going through the "Format Table" menu, and selecting the option of "Number" (with 2 decimal places and a $ symbol)

d. all of the options provided are correct

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

d. None of the options provided is correct

How do you format a valid date serial number as a date ? a. Home (tab) ->Number (command group) ->Number Format -> $ b. Home (tab) -> Number (command group) ->Number Format -> Text c. Home (tab) -> Number (command group) -> Number Format -> Fraction d. None of the options provided is correct

a. After creating the pivot table, select the items to be grouped and then choose Analyze (tab) under PivotTable Tools and select Group (group) -> Group Selection

How do you group Pivot Table items manually? a. After creating the pivot table, select the items to be grouped and then choose Analyze (tab) under PivotTable Tools and select Group (group) -> Group Selection b. After creating the pivot table, select the items to be grouped and then choose Design (tab) under PivotTable Tools and select Group (group) -> Group Selection c. Select columns in the pivot table and right click on them and choose the option to "Cluster Group" d. None of the answers provided is valid

a. Data(tab) -> Data Tools (group) -> Data Validation -> Error Alert >-Style: Warning

How do you pick the data validation option that provides the user with a warning (instead of completely stopping data entry) when a validation check is violated? a. Data(tab) -> Data Tools (group) -> Data Validation -> Error Alert >-Style: Warning b. Formulas (tab) -> Insert function -> Data Validation -> Warning c. Insert (tab)--> Ink d. None of the options provided is valid

b. It searches for a date as displayed in the Formula bar, and then does a replace

How does the Excel search/replace function work for dates? a. It search a cell for any feasible date format including numbers and text dates, and then does a replace b. It searches for a date as displayed in the Formula bar, and then does a replace c. It can find dates, but not replace them d. It cannot find dates

b. ignored / do not work

If the user copies a cell that does not use data validation and pastes it to a cell that uses data validation, the data validation rules are ____ a. inserted b. ignored / do not work c. shifted to the next cell in the row d. changed from a "stop" to a "warning" type of rule (in error alert)

A. Absolute

If you copy 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? A. Absolute B. Relative C. Frozen D. Automated

d. none of the options provided

If you want to trace cell relationships for formulas, which of the following commands / options could you use? a. name manager b. spelling c. both options A and B d. none of the options provided

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

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

A. Select a row

In Excel, Shift + Spacebar (keyboard shortcut) is used to A. Select a row B. Select a column C. Select a range D. Select multiple rows or columns

a. CUMPRINC()

In Excel, in order to calculate the cumulative principal paid between any two payment periods, what function will you use? a. CUMPRINC() b. CUMIPMT() c. PPMT() d. PMT()

B. select a column

In Excel, the Ctrl + Spacebar (keyboard shortcut) is used to____ A. select a row B. select a column C. select a range D. select multiple rows or columns

a. find what, empty

In order to delete information using Find and Replace in Excel, enter the text to be deleted in the ____ field and leave the Replace With field _____. a. find what, empty b. replace with, empty c. find what, with a comma d. find what, with the keyword "delete"

D. Input Range and Bin Range

In the Analysis ToolPak for Excel which of the following parameter can you specify when creating a Histogram? A. Filename (to import data from access) B. Ignore duplicates vs. permit duplicates C. Simple vs Compound Interest D. Input Range and Bin Range

b. Ctrl+P

Issuing the Print command (in Excel) with a mouse takes three clicks. A slightly more efficient method is to press _____________ and then click the Print button a. Ctrl+PrintScreen b. Ctrl+P c. Ctrl+X d. Ctrl+T

D. no, a chart can be embedded or placed in a sheet separate from that of its data source

Must a chart be embedded in the same worksheet as its data source? A. yes, this is a limitation of Microsoft Excel but lead to easier linking between charts and data B. yes, and this holds true for graphs as well C. no, unless the chart is a histogram D. no, a chart can be embedded or placed in a sheet separate from that of its data source

C. Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose

Please examine the attached workbook. Given the data in sheet1, which of the following steps should be followed to obtain the data in sheet2. (PS1_Sheets) A. It is only possible if done manually B. Select cells A1 through C4 in Sheet1 -> Copy -> Transpose -> Go to Sheet2 -z. Paste C. Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Transpose D. Select cells A1 through C4 in Sheet1 -> Copy -> Go to Sheet2 -> Paste -> Formulas

D. Ribbon

Please refer to the figure. What excel element is shown in the red box? (top of excel spans across entire distance) A. File Button B. Quick Access Toolbar C. Scrollbar D. Ribbon

B. Quick Access Toolbar

Refer to the figure. What excel element is shown in the red box? (top left hand corner) A. File Button B. Quick Access Toolbar C. Scrollbar D. Ribbon

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

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

c. A combination of: FIND(), LEN(), MID()

Suppose you have a column of file names such as: 001-Chapter1.txt, ..., 015-Chapter15.txt, ..., 104-Chapter104.txt, etc. You want to use a formula to consistently remove the prefix numbers, e.g., make the file names into: Chapter1.txt or Chapter12.txt. Which of the following text functions can you use to make this change? a. A combination of: TRIM(), SUBSTITUTE(), REPT() b. A combination of: FIND(), INDEX(), CHAPTER() c. A combination of: FIND(), LEN(), MID() d. A combination of: REPT(), PREFIX(), REMOVE()

A. column letter, row number

The Addresses of the active cell consists of which of the following A. column letter, row number B. column height, row width C. column letter D. row number

D. range and criteria

The COUNTIF() function used for single criterion counting formula takes two arguments (or parameters) ______ and _____ A. range and constant B. expression and criteria C. constant and expression D. range and criteria

a. Friendly_name

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

c. row labels

The first field you add to a PivotTable report that does not contain numbers will automatically be added in the _______ part of the report. a. column labels b. report filter c. row labels d. slicer group

A. 3

The formula =COUNTIF(range,"???") returns the number of cells in the range containing exactly ____ characters of text A. 3 B. 5 C. 4 D. 2

d. tools

There are four boxes/areas below the PivotTable Field List. Which of the following is NOT one of these four boxes? a. filters b. rows c. columns d. tools

a. An HTML file and a single-file web page

There are two options if you want to save an Excel workbook, so that it can be viewed on the World Wide Web. What are the two options? a. An HTML file and a single-file web page b. An HTML file and a JPEG file c. A Text file and a JPEG file d. A .ZIP archive file and a Text file

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

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")

A. Returns the number of cells containing the current date in the range names Data

What does the following formula do? = COUNTIF(Data, TODAY()) A. Returns the number of cells containing the current date in the range names 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. a comment exists for that cell

What does the small red triangle on the upper right corner of a cell denote? A. a comment for the cell exists B. the cell has an error C. wrong value/formula in the cell D. the cell references a missing value

A. TRIM

What function removes leading and trailing spaces from a cell? A. TRIM B. CUT C. COMPACT D. CLEAN

A. 31

What is the maximum number of character a worksheet name can contain? A. 31 B. 34 C. 28 D. 32

A. Chart Elements

What is the name of the icon highlighted using the red oval? (plus sign on right hand corner of chart) A. Chart Elements B. Add Charts C. Chart Styles D. Chart Filter

c. it parses strings into their component parts

What is the purpose of the text to columns command? a. it combines several columns of text into a single column b. it creates several columns within a single text cell c. it parses strings into their component parts d. it adds common to text to separate values

B. Ctrl+F

What is the shortcut to open the find and replace dialog box with the "Find" tab open? A. Ctrl+H B. Ctrl+F C. Ctrl+A D. Ctrl+Alt+F

a. forces the cell A1 to accept only text

What is the use of the following data validation formula: =ISTEXT(A1) a. forces the cell A1 to accept only text b. forces the cell A1 to accept only numbers c. forces the cell A1 to accept only '*' d. forces the cell A1 to accept only '+'

B. Select the data, then click "Table" under the "Insert" tab of the Excel Ribbon

What sequence of steps will allow you to format the data into a table? A. Select data, then click "Ctrl + 1" and choose the "Table Creation"option B. Select the data, then click "Table" under the "Insert" tab of the Excel Ribbon C. Select data, then click on conditional formatting command in Excel D. Select data, then click the "Convert to Table" option under the Table Tools / Design tab

b. Link_location is required, Friendly_name is optional

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

A. wide

When a row of data is very ____ and required repeated horizontal scrolling, consider using data form to add, edit, find, and delete rows A. wide B. narrow C. transformed D. empty

a. External Data Properties Dialog Box

When working with data returned from a Query Wizard, you can adjust a variety of properties of an external data range. This can be done using the ______________. a. External Data Properties Dialog Box b. Internal Data Properties Dialog Box c. General Properties Dialog Box d. You cannot adjust properties of the external data range

B. Excel applies currency formatting to the new value in that column cell.

When you apply currency formatting to a Table column and then add a new row to the table, what happens to data entered in the new cell? A. Currency formatting is not applied to the new cell. B. Excel applies currency formatting to the new value in that column cell. C. A special type of formatting other than currency formatting is applied to the new value. D. Currency formatting is temporarily applied to the new value (but only persists until the Workbook is closed).

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

When you have imported data from an external data source, you can change the 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. stop

Which icon (in data validation error alerts) is used to prevent users from entering invalid data into a cell? a. stop b. warning c. information d. prevent

A. Ctrl+A

Which keyboard shortcut is used to select all cells in an open Excel worksheet? A. Ctrl+A B. Ctrl+X C. Ctrl+V D. Ctrl+C

A. Developer

Which of the following Excel tabs is NOT visible in a worksheet by default? A. Developer B. Review C. Home D. Insert

d. data in a table

Which of the following can be retrieved from a web page using web queries? a. .gif image b. contents of scripts c. .jpeg images d. data in a table

C. File, Save As

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. current date and time

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 vlid excel function

a. #NUM!

Which of the following error codes indicates that a problem with a value exists? For example, a negative number was specified by the user where a positive number was expected. a. #NUM! b. #REF! c. #N/A d. #NAME?

b. =TODAY()-MOD(TODAY()-1,7)

Which of the following formulas is used to determine the date of the Sunday that was most recent? a. =WEEKDAY(DATE(2011,1,1)) b. =TODAY()-MOD(TODAY()-1,7) c. =TODAY()-MOD(TODAY()-3,7) d. =DATE(YEAR(TODAY()),12,31)-TODAY()

A. =NOW()

Which of the following formulas will display both the current date and time when entered into a cell in an Excel worksheet? A. =NOW() B. =DATE() C. =TIME() D. =TODAY()

d. None of the answers provided is false

Which of the following is FALSE about Pivot Table Slicers? a. Slicers can be moved and resized. b. The effects of filtering by a particular slicer can be removed. c. To use a Slicer to filter data in a Pivot Table, you can click one of the slicer value buttons. d. None of the answers provided is false

d. row_index_num

Which of the following is NOT one of the VLOOKUP function arguments? a. lookup_value b. table_array c. col_index_num d. row_index_num

C. ISLOGICAL

Which of the following is NOT one of the excel functions to determine whether a cell contains an error value? A. ISERROR B. ISNA C. ISLOGICAL D. ISERR

C. A table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS)

Which of the following is true about table renaming? A. Table renaming is not recommended in Excel as it will cause formulas to stop functioning properly B. Renaming a table is done automatically when a Table is extended (e.g., when you add a new row of data) C. A table can be renamed to better reflect its contents (e.g., PARTS or PRODUCTS) D. Excel tables are named based on the worksheet it is located in, e.g., a table in "Sheet1" will be named "Sheet1Table1" or "Sheet1Table2"

B. Ctrl+X

Which of the following keyboard shortcuts "cuts" the current selection of cells to both the windows and office clipboards? A. Ctrl+A B. Ctrl+X C. Ctrl+V D. Ctrl+C

a. The PROPER() function doesn't handle names with an embedded capital letter, such as McDonald.

Which of the following options is TRUE with respect to the function PROPER() in Excel? a. The PROPER() function doesn't handle names with an embedded capital letter, such as McDonald. b. The letter following an apostrophe is not capitalized. c. First letter of words such as 'and' and 'the' are not capitalized d. Converts the text to ALL UPPERCASE.

C.MATCH(lookup_value,lookup_array,match_type)

Which of the following provides correct syntax for the MATCH function? A. MATCH(column-name) B.MATCH(lookup_value,lookup_vector,result_vector) C.MATCH(lookup_value,lookup_array,match_type) D.MATCH(lookup_value,match_type)

b. the formula contains an invalid cell reference

Which of the following returns a #REF! error value? a. MS Excel cannot recognizer the text in the formula (it may be written in a foreign language) b. the formula contains an invalid cell reference c. calculation doesn't include all data d. non of the options provided is correct

A. Ctrl + Enter

Which of the following shortcuts allows you to enter the same data into multiple selected 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

C. A workbook can have many worksheets

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. 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

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 OR() 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.

B. Format

Which ribbon tab provides the best option to resize charts? A. Layout B. Format C. Design D. Insert

a. The contents of cell A1 do not comprise four digits

While converting from military time, when would the formula TIMEVALUE(LEFT(A1,2)&":"&RIGHT(A1,2)) return an incorrect result? a. The contents of cell A1 do not comprise four digits b. An error is returned in all cases c. Presence of a symbol such as . Instead of a : in the time, e.g., 16.24 (instead of 16:24) d. The presence of the character ':' (colon) in the time, e.g., 15:25

B. 2 (i.e., an action if the criteria is true, or an action if the criteria is false)

With a single IF() function, how many actions can you ask Excel to carry out? A. 1 (i.e., an action if the criteria is true) B. 2 (i.e., an action if the criteria is true, or an action if the criteria is false) C. 3 (i.e., an action if the criteria is any one of true, false, unknown) D. As many as you want, this is why IF() functions are so difficult to understand

a. Refers to the Variable-declining balance function. Computes the depreciation of an asset for any period (including partial periods) using the double-declining balance method or some other method you specify.

With regards to Depreciation Calculation functions in Excel, which of the following are true about the function VDB()? a. Refers to the Variable-declining balance function. Computes the depreciation of an asset for any period (including partial periods) using the double-declining balance method or some other method you specify. b. It refers to the Visual Depreciation Barchart method, and uses a bar chart to display the falling amounts of asset values c. This method of calculating depreciation uses random numbers to fairly distribute depreciation over the lifetime of an asset d. None of the above

12

Within the "Number" tab, how many categories are available for displaying numbers?

B. =HLOOKUP(B2, E1:J3, 3)

dataLOOKUP_Ex2.xlsx Please see the attached workbook. What formula (in cell B3) would return the tax rate for the income in cell B2? A. =VLOOKUP(B2, E1:J3, 3) B. =HLOOKUP(B2, E1:J3, 3) C. =VLOOKUP(B3, D2:F7, 3) D. None of the other options are correct

C. forces a complete recalculation of all formulas in all open workbooks.

what does the excel keyboard shortcut Ctrl+Alt+F9 do? 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

A. Home

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? A. Home B. Review C. Insert D. Formulas

C. #N/A

Assume the "range_lookup" parameter in an HLOOKUP function is FALSE. If an exact match is not found, what value is returned? A. #REF! B. Excel returns a "No value was found" error message C. #N/A D. An approximate match is returned

A. Yes, the statement is accurate

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? A. Yes, the statement is accurate B. No, this is a false statement C. The statement is accurate only for the first 7 styles previewed. After that, to conserve memory, Excel will apply a style and you can start the preview process over again. D. Yes, previews are possible as long as the Total Row option is not checked