Search
Browse
Create
Log in
Sign up
Log in
Sign up
Upgrade to remove ads
Only $2.99/month
Com Sci. Exam 2
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (44)
A subtotal row must contain at least one .... function
aggregate
What does a + button indicate to the left of a row heading in an outline
You can expand the details of that category
If you create a Recommended PivotTable on a group of data about book sales with these columns: Discipline (i.e., Business), Area (i.e., Finance and Marketing), Units Sold, Wholesale Price, what column might Excel use as values?
Units Sold
Given a list of candy bars in a field called Item and their prices in a field called Price on an empty PivotTable, how would you find out how many of each type of candy bar you have?
Drag item to both the VALUES and the ROWS area
Which of the following is true about creating a blank PivotTable?
A PivotTable may be created on the same worksheet as the source data
Moving one of two fields from the ROWS area to the COLUMNS area of a PivotTable would ..............
consolidate data and remove redundant labels
You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories. How do you hide the entire second level without removing it from the ROWS area?
Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab
You would like to see both average sales and total sales for a category in a pivot table. Which of these would best accomplish both a Total and an Average column on the field Sales?
Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.
What dictates the order of hierarchy of fields in the rows of a PivotTable?
the order of the fields in the ROWS area
You created a PivotTable and later made changes to values in the underlying data. What happens to the PivotTable?
Changes in the dataset do no affect to the PivotTable until you refresh the PivotTable
If you need to find the day of the month on which events occurred from a list of dates in the named range StartDate, which formula would provide the correct result?
=DAY(StartDate)
The YEARFRAC calculates ..................
the fraction of a year in days between two dates
If you need to find out how many days between two dates, which function would you use?
DAYS
In an IF function there are 3 possible outcomes, how many logical tests are required?
2
If a cell B5 contains the value 6 and is named Quantity and cell C6 contains the value 3 and is named UnitPrice, what would the formula =Quantity*UnitPrice display in cell D6?
18
What is the benefit of using a range name in Excel?
Range names are easier for people to remember than cell references.
A one-variable data table can be built .......
either horizontally or vertically
If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?
3.0%, 3.25%, 3.5%, 3.75%
What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?
two-variable data table
What is an Excel Add-in?
A program that you can add to Excel to enhance functionality
Where does Excel create a Scenario Summary report?
on a new worksheet
If "February 28, 2017" (without quotation marks and format is Date as shown) is the contents of B3, what would be the result of =MONTH(b3)?
2
What is a nested function?
A function embedded within an argument of another function
If you use the function, =MATCH(66, A1:A4, 0), on the table below, what would be the result?
4
What is the purpose of the row_num argument in the =INDEX(A2:B5, MATCH(MAX(B2:B5), B2:B5, 0), 1) function?
To return the position of the highest value in the range B2:B5
What is the first argument of an IF function?
logical\_tes
A(n) .................. is a matrix that provides the results (TRUE or FALSE) for every possibility of an AND, OR, or NOT criteria combinations.
truth table
Which function returns a value at the intersection of a specified row and column?
INDEX
Which function returns the relative position of a value?
MATCH
Which is not an argument in an INDEX function?
table
Why would you nest MATCH in an INDEX function?
To use the position returned in the MATCH function as an argument in the INDEX function
What best describes a criteria range?
The group of adjacent cells that specifies the conditions used to control the results of a filter
What is < > equivalent to in Advanced Filters?
Not Equal to
Which database function returns the lowest value from the dataset based on your criteria?
DMIN
Which of the following is not an argument in a Database function?
Filter
Which of the following is not an argument in a Database function?
A2:B5
What is the purpose of an Excel What-if scenario?
Detailed set of values that represent different possible situations
Why would you put a negative sign in many financial functions?
Excel interprets these calculations as a negative cash flow (money leaving your account)
An INDEX function returns the position of a value
FALSE
The arguments of an INDEX function are array, row_num, and column_num.
TRUE
Advanced filtering will not copy results to a new location.
FALSE
The RATE function returns periodic rate for an investment or loan.
TRUE
The MONTH function would return 25 when used on a cell containing August 25, 2018.
FALSE
You need the same number of logical tests as outcomes in a nested IF function.
FALSE
YOU MIGHT ALSO LIKE...
Chapters 5 -7 Vocab Cum see 113 exam 2
101 terms
itm 175
65 terms
Advanced Excel Chapter 5,6,7
83 terms
CIS
48 terms
OTHER SETS BY THIS CREATOR
350 Midterm
28 terms
NREM Exam 2
113 terms
NREM Exam 1
79 terms
416 Final Historical Terms
18 terms