BUS 1350 Exam (Risinger) | UPDATED Questions with
100% Verified Answers
Q1: When would you paste a copied cell using the Paste Link
option?
A: When you want to paste the reference to the cell and not the cell's value or format
Q2: How do you check the status of a link within the current
workbook to determine whether the link's source file is
accessible and up-to-date?
A: On the Data tab, in the Queries & Connections group, click the Edit Link button to open
the Edit Links dialog box, and then view the link's status in the Status column
Q3: What is a field?
A: A single value that describes a person, place, or thing
Q4: What is a record?
A: A group of related fields
Q5: Before you can add subtotals to a data range, what must you
first do with the data?
A: Sort the data range by order the field for which you want the subtotals calculated.
Q6: When multiple filter buttons are used with a data range, how
are criteria in different fields combined?
A: With an AND logical operator
Q7: When would you use an advanced filter in place of the filter
buttons?
A: To join several fields with an OR logical operator
Q8: What is the structural reference to the table header row?
A: [#Headers]
Q9: What are two reasons for using slicers rather than filter buttons
to filter data?
A: Use slicers when you want to filter the data into a few distinct categories that can be
easily listed within the slicer and when you want to perform the filter on a separate
worksheet from the data
, Q10: What are two reasons for using filter buttons rather than slicers
to filter data?
A: Use filter buttons when you want to apply text filter, date filters, and numeric filters, and
when you want to view all of the record in place as you filter the data
Q11: Write a formula to calculate the sum of the filtered values from
the Sales Price field in the Sales_Result table
A: =SUBTOTAL(9, Sales_Result[Sales Price])
Q12: Write a formula to calculate the average of the filtered values
from the Sales Price field in the Sales_Resulttable
A: =SUBTOTAL(1, Sales_Result[Sales Price])
Q13: Write a formula to retrieve the value from the third field in the
Sales_Result table that exactly matches the lookup value in
cell B10
A: =VLOOKUP(B10, Sales_Result, 3, FALSE)
Q14: What is the VLOOKUP function to retrieve the letter grade
stored in the second column of the GradeScale table using a
lookup value of 83 in an approximate match lookup?
A: =VLOOKUP(83, GradeScale, 2)
Q15: What is the XLOOKUP function to perform an approximate
match lookup for a test score of 83? Assume the column
containing the lower end of the range of test scores is named
TestScores and the range containing the grades is named
Grades.
A: =XLOOKUP(83, TestScores, Grades,,-1)
Q16: What is a PivotTable?
A: A PivotTable is an interactive table that groups and summarizes data in a concise tabular
format.
Q17: What are the four primary areas of a PivotTable?
A: The Rows area, the Columns area, the Values area, and the Filters area
Q18: What is default statistic is used for non-numeric data in the
Values area of the PivotTable
A: Count
100% Verified Answers
Q1: When would you paste a copied cell using the Paste Link
option?
A: When you want to paste the reference to the cell and not the cell's value or format
Q2: How do you check the status of a link within the current
workbook to determine whether the link's source file is
accessible and up-to-date?
A: On the Data tab, in the Queries & Connections group, click the Edit Link button to open
the Edit Links dialog box, and then view the link's status in the Status column
Q3: What is a field?
A: A single value that describes a person, place, or thing
Q4: What is a record?
A: A group of related fields
Q5: Before you can add subtotals to a data range, what must you
first do with the data?
A: Sort the data range by order the field for which you want the subtotals calculated.
Q6: When multiple filter buttons are used with a data range, how
are criteria in different fields combined?
A: With an AND logical operator
Q7: When would you use an advanced filter in place of the filter
buttons?
A: To join several fields with an OR logical operator
Q8: What is the structural reference to the table header row?
A: [#Headers]
Q9: What are two reasons for using slicers rather than filter buttons
to filter data?
A: Use slicers when you want to filter the data into a few distinct categories that can be
easily listed within the slicer and when you want to perform the filter on a separate
worksheet from the data
, Q10: What are two reasons for using filter buttons rather than slicers
to filter data?
A: Use filter buttons when you want to apply text filter, date filters, and numeric filters, and
when you want to view all of the record in place as you filter the data
Q11: Write a formula to calculate the sum of the filtered values from
the Sales Price field in the Sales_Result table
A: =SUBTOTAL(9, Sales_Result[Sales Price])
Q12: Write a formula to calculate the average of the filtered values
from the Sales Price field in the Sales_Resulttable
A: =SUBTOTAL(1, Sales_Result[Sales Price])
Q13: Write a formula to retrieve the value from the third field in the
Sales_Result table that exactly matches the lookup value in
cell B10
A: =VLOOKUP(B10, Sales_Result, 3, FALSE)
Q14: What is the VLOOKUP function to retrieve the letter grade
stored in the second column of the GradeScale table using a
lookup value of 83 in an approximate match lookup?
A: =VLOOKUP(83, GradeScale, 2)
Q15: What is the XLOOKUP function to perform an approximate
match lookup for a test score of 83? Assume the column
containing the lower end of the range of test scores is named
TestScores and the range containing the grades is named
Grades.
A: =XLOOKUP(83, TestScores, Grades,,-1)
Q16: What is a PivotTable?
A: A PivotTable is an interactive table that groups and summarizes data in a concise tabular
format.
Q17: What are the four primary areas of a PivotTable?
A: The Rows area, the Columns area, the Values area, and the Filters area
Q18: What is default statistic is used for non-numeric data in the
Values area of the PivotTable
A: Count
