DSS 100 FINAL SJU

In the formula =(1+2)/3<>10, Excel evaluates ____ first.

(1+2)

What is the result of the nested IF G9 is 3500 ? =IF(G9 <=3000,250,IF(G9 < 4000,"1","2"))?

1

When using the Data Table function, how many inputs are there

2

Which one is not a relational operator?

<>

All functions start with which of the following?

=

When you want Excel to execute a function, it must always start with

=

The syntax for the CONCATENATE function is as follows: ____.

=CONCATENATE(text1,text2,...)

The syntax of the COUNTIF function is ____.

=COUNTIF(range, criteria)

The FV function is structured as follows:

=FV(rate, nper, pmt, [pv], [type])

If cell B7 contains a value that is greater than 20 and ''ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax:

=IF(B7>20,"ORDER","OK")

To perform the task of displaying "credit approved" or "credit denied" based on the corresponding Boolean value in column H, you can write a formula in cell I3 containing an IF function, as follows:

=IF(H3,"credit approved","credit denied")

Which is the correct syntax for LARGE function?

=LARGE(array,k)

The PMT function is structured as follows:

=PMT(rate, nper, pv, [fv], [type])

The PV function is structured as follows

=PV(rate, nper, pmt, [fv], [type])

$10,000 compounded 1 time at 4% per period is different from $10,000 compounded 4 times at 1% per period; the latter results in a higher value.

True

An IF function can be used to evaluate a logical test, such as determining if the 90-days past due balance is greater than 0, with only two resulting values: a value_if_true and a value_if_false.

True

Depreciation must be added to the cash flow in each year to calculate taxes for that year, but then must be subtracted because it is not actually a cash flow in that year.

True

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

True

IPMT and PPMT have the same inputs.

True

If all of the constraints, which represent the availability of resources, have slack values, the solution isn't the optimal solution that maximizes the available resources.

True

If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.

True

Is =IF(logical_test, [value_if_true], [value_if_false]) is the correct structure for an IF statement?

True

Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

True

The COUNTIF function accommodates a(n) single contiguous range argument.

True

The INDEX function allows you to retrieve data from multidimensional tables.

True

The NOT function takes only one argument and essentially changes a single TRUE value to FALSE, or a single FALSE value to TRUE.

True

The Query Wizard lets you choose your data source and select the database table and fields you want to import into a workbook.

True

The Subtotal command creates summary reports that quickly organize data into categories with subtotal calculations.

True

The TRIM function removes all spaces in a text string except for the single spaces between words.

True

The cells in a worksheet usually display combinations of text or numbers; the math that generates the answers is hidden.

True

The easiest way to create a PivotChart report is to use an existing PivotTable report as the source data

True

The function inputs are referred to as arguments.

True

The fv argument is the value at the end of the financial transaction.

True

The result of the formula =B3>=C3 where cell B3 contains the date 1/1/2010 and cell C3 contains the date 12/31/2009 is ____.

True

The result of the formula =OR(I3:I21>90), where cell I5 is 92, is ____.

True

The syntax of the FV function is =FV(rate,nper,pmt,[pv],[type]).

True

The syntax of the RANK.EQ function is as follows: RANK(number,ref,[order]).

True

When solving problems with nonlinear objective functions, you must enter a variety of starting points to ensure that the answer that Solver reports is actually the optimal solution.

True

You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

True

You must make changes to the content of data labels using buttons in the Format Data Labels task pane

True

The default field setting in the ____ area is to calculate a sum of the items in this drop area by the categories in the Row Labels area or Column Labels area.

VALUES

You can change the calculation used in the VALUES area by right-clicking a value in the VALUES area to open the shortcut menu, and then clicking Field Settings to open the ____ dialog box.

Value Field Settings

A common way of storing data so that it is usable in other programs is to save it in a ____ file.

comma-delimited

Adding interest earned each period to the principal for purposes of computing interest for the next period is known as ____ interest.

compound

The ____ Wizard separates the values in a text string into columns or fields.

convert Text to Columns

Stacked charts do a good job of illustrating the ____ effects of data in categories.

cumulative

A(n) ____ results when Solver cannot determine the combination of decision variables that satisfies all of the constraints.

infeasible solution

The error message ###### means that there is ____.

insufficient width in the cell to display data, or negative date/time

To change the number of times Solver attempts to solve a problem, click Options in the Solver Parameters dialog box, change the value in the ____ box, and then click the OK button.

iterations

The syntax of the LOOKUP function is as follows: =LOOKUP(____,lookup_vector,result_vector).

lookup_value

The ____ option of splitting a pie data series into a second, smaller pie chart allows you to select a cutoff point by percentage, rather than value, and assign all the percentages below that point to the second plot.

percentage value

The ____ is the value of the loan or investment.

principal

A bank account would have an fv equal to the ____ plus any accrued interest, plus or minus any payments into or out of the account.

pv

The syntax of the VLOOKUP function is as follows: =VLOOKUP(lookup_value,table_array,col_index_num,____)

range_lookup

B1 is an example of a(n) ____ reference

relative

In an INDEX function, the argument ____ refers to the number of the row in the range referenced in the first argument.

row_num

Each function has its own ____, which specifies the function name and order of the arguments.

syntax

Taxes are calculated based on _____ income, which excludes certain elements that are cash flows and includes other non-cash flow items.

taxable

You use VLOOKUP when ____ of the lookup table contains the data you are looking up.

the first column

A PivotChart report represents source data as a(n) graphic.

true

Dividing text into columns is also referred to as parsing text into columns.

true

If Solver attempts the maximum number of iterations without the objective cell converging to an answer, the assumption is that the solution is ____.

unbounded

The ____ is the vertical axis where data values are plotted.

y axis

With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.

High-Low-Close

You must answer four questions before using optimization to solve a problem. They do NOT include ____.

How much does each decision variable cost?

Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value

IF

Choose a(n) ____ function if the problem requires you to make a decision and then generate different values depending on whether the logical test results in a TRUE or FALSE value.

IF

A$1 is an example of a(n) _____ reference?

MIXED

When you want to see which number(s) occurs most in a range of numbers, which function should you use:

MODE

What is the result of =IF(NOT(B2="London"),"Yes","No") if B2= london ?

NO

The ____ function returns the last character or characters in a text string, based on the number of characters specified.

RIGHT

When using the Data Table function, the 2 inputs are:

Row input cell, Column input cell

The ____ function adds a list of values and/or cell ranges.

Sum

The formula for IPMT and PPMT has th same input

TRUE

When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.

False

With Solver, you can change the values of up to 500 cells at one time to reach a goal in the objective cell.

False

The CONCATENATE function combines the values in a range of cells into one numeric item in a new cell.

False

The LAST function returns the last character or characters in a text string, based on the number of characters specified.

False

The MAX function will display the smallest number in a selected array of numbers.

False

The RANDOM function randomly assigns a number between two specified values.

False

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

False

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing.

False

Which functions are not a part of the formulas tab?

CHART

Which of the following is not an option for conidtional formatting:

Chart Sets

In which tab is the conditional fromatting option?

Data

It is mandatory to start the line chart with a zero starting-point.

Data label

What are the 3 function options in the What-If-Anlysis dropdown:

Data table, Goal seeking, Scenario Manager

A doughnut chart serves a similar purpose to a pie chart, execpt that it is able to show more than one set of data.

FALSE

It is mandatory to start the line chart with a zero starting-point.

FALSE

The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.

FALSE

If the value in B4 =40,what is the result of =IF(B4>65,"PASS","FAIL")

Fail

=NPER(rate,pmt,pv,fv,type) solves for the interest rate per period.

False

A function is always structured beginning with the function address and an opening parenthesis mark.

False

A(n) PivotSheet report is an interactive report that lets you summarize and analyze a data set.

False

An IF function is a Boolean logical function that returns one value if a specified condition evaluates to TRUE, and the same value if the specified condition evaluates to FALSE.

False

Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart.

False

Excel provides unconditional formatting tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.

False

Function inputs are not referred to as arguments.

False

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP opens up the Lookup Wizard.

False

In a line chart, values are indicated by the filled areas below the lines.

False

In a one-dimensional table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column

False

Placing a field in the Row Labels area of a PivotTable displays data from that field in columns and rows.

False

Relational operators can be used to evaluate dates.

False

Solver can produce four different reports: summary, answer, sensitivity, and limits.

False

The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.

False

The Accounting Number Style displays values with commas and two decimal places, but no dollar signs.

False

The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

False

The IPMT function calculates which part of the payment for an ammortization schedule?

Interest

In the formula =B2=C2, the second equal sign is interpreted as ____.

a relational operator

$B$1 is an example of a(n) ____ reference.

absolute

After you have identified the criteria that prevent a solution from being feasible, you have two choices: You can do nothing and declare that there is no solution to the problem, or you can ____ to create a feasible solution.

adjust the constraints

The >, >=, <, and <= operators also work with text, where a greater value is one that appears later in the ____.

alphabet

The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.

ascending

The formula =PMT(0.03/12,12*3,15000,-2000) includes a ____.

balloon payment

The purpose of formatting is to make a chart ____.

easier for the viewer to understand

The PivotTable ____ task pane contains a list of fields in the data source you selected for the PivotTable report.

fields

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.

format

The first goal when working with unstructured data is to determine the ____ you need so you can find the best way to change the unstructured data into structured data.e?

format

The technique used to fix certain rows while you scroll to other rows in a worksheet is called ____ panes.

freezing

Microsoft Excel allows you to use ____, such as LARGE, SMALL, and RANK.EQ, that help you to structure and analyze data in meaningful ways.

functions

A PivotChart report represents source data as a ____

graphic