BUSA Final Exam 2026 Questions and
Answers
Which of the following is defined as a range of cells that shows calculated results
of one or more formulas? - Correct answer-Data Table
Which of the following functions looks for data that you specify and returns the
relative location of the data that matches the search? - Correct answer-MATCH
Function
Which of the following is a benefit of data validation? - Correct answer-all of the
above E7-376
Which of the following tabs lets you edit or delete a comment? - Correct answer-
Reveiw Tab
Which of the following contains one relative reference (either the row number or
column letter) and one absolute reference (the remaining row number or column
letter)? - Correct answer-mixed reference
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, Which of the following simplifies the process of entering the months of the year in
a worksheet? - Correct answer-Fill Handle Tool
Which of the following mathematical operations is always performed last? -
Correct answer-Subtraction
Which of the following functions allows you to link or join text in a chain? -
Correct answer-CONCATENATE Function
Which of the following conditions exists if you enter criteria on the same row? -
Correct answer-AND Conditions
Which of the following terms refers to a piece of data in a single column? - Correct
answer-Field
Which of the following is a new command in Excel 2013 for recognizing a pattern
and then duplicating the pattern for matching cells? - Correct answer-Flash Fill
Which of the following is a clickable string of text or objects that, when you click
on it, displays another worksheet, opens another workbook, opens another
program, or displays a web page? - Correct answer-Hyperlink
Which of the following charts displays three series of data to show fluctuations in
stock prices from high to low to close? - Correct answer-Stock
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
Answers
Which of the following is defined as a range of cells that shows calculated results
of one or more formulas? - Correct answer-Data Table
Which of the following functions looks for data that you specify and returns the
relative location of the data that matches the search? - Correct answer-MATCH
Function
Which of the following is a benefit of data validation? - Correct answer-all of the
above E7-376
Which of the following tabs lets you edit or delete a comment? - Correct answer-
Reveiw Tab
Which of the following contains one relative reference (either the row number or
column letter) and one absolute reference (the remaining row number or column
letter)? - Correct answer-mixed reference
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, Which of the following simplifies the process of entering the months of the year in
a worksheet? - Correct answer-Fill Handle Tool
Which of the following mathematical operations is always performed last? -
Correct answer-Subtraction
Which of the following functions allows you to link or join text in a chain? -
Correct answer-CONCATENATE Function
Which of the following conditions exists if you enter criteria on the same row? -
Correct answer-AND Conditions
Which of the following terms refers to a piece of data in a single column? - Correct
answer-Field
Which of the following is a new command in Excel 2013 for recognizing a pattern
and then duplicating the pattern for matching cells? - Correct answer-Flash Fill
Which of the following is a clickable string of text or objects that, when you click
on it, displays another worksheet, opens another workbook, opens another
program, or displays a web page? - Correct answer-Hyperlink
Which of the following charts displays three series of data to show fluctuations in
stock prices from high to low to close? - Correct answer-Stock
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
