BUSA FINAL EXAM QUESTIONS WITH CORRECT
ANSWERS
Which of the following is defined as a range of cells that shows calculated results of one
or more formulas? - ✔✔ 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? - ✔✔ MATCH Function
Which of the following is a benefit of data validation? - ✔✔all of the above E7-376
Which of the following tabs lets you edit or delete a comment? - ✔✔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)? -
✔✔mixed reference
Which of the following simplifies the process of entering the months of the year in a
worksheet? - ✔✔Fill Handle Tool
Which of the following mathematical operations is always performed last? -
✔✔Subtraction
Which of the following functions allows you to link or join text in a chain? -
✔✔CONCATENATE Function
Which of the following conditions exists if you enter criteria on the same row? - ✔✔AND
Conditions
Which of the following terms refers to a piece of data in a single column? - ✔✔Field
, Which of the following is a new command in Excel 2013 for recognizing a pattern and
then duplicating the pattern for matching cells? - ✔✔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? - ✔✔Hyperlink
Which of the following charts displays three series of data to show fluctuations in stock
prices from high to low to close? - ✔✔Stock
What should you keep in mind when it comes to using shadows, bevels, and glows? -
✔✔Use them sparingly
Which of the following are examples of SmartArt objects? - ✔✔all of the above E5-267
Which of the following enables you to identify a folder that contains secure, safe
worksheets? - ✔✔Trust Center
Which of the following types of workbooks open in Protected View? - ✔✔ all of the above
E7-404
Which of the following functions rounds a value to a specified number of decimal places?
- ✔✔ROUND
Which of the following are structured references that Excel automatically places in a
table? - ✔✔all of the above E4-201
Which of the following is a high-quality illustration, which often includes text that you
can place in Office documents, including Excel worksheets? - ✔✔SmartArt Graphic
ANSWERS
Which of the following is defined as a range of cells that shows calculated results of one
or more formulas? - ✔✔ 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? - ✔✔ MATCH Function
Which of the following is a benefit of data validation? - ✔✔all of the above E7-376
Which of the following tabs lets you edit or delete a comment? - ✔✔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)? -
✔✔mixed reference
Which of the following simplifies the process of entering the months of the year in a
worksheet? - ✔✔Fill Handle Tool
Which of the following mathematical operations is always performed last? -
✔✔Subtraction
Which of the following functions allows you to link or join text in a chain? -
✔✔CONCATENATE Function
Which of the following conditions exists if you enter criteria on the same row? - ✔✔AND
Conditions
Which of the following terms refers to a piece of data in a single column? - ✔✔Field
, Which of the following is a new command in Excel 2013 for recognizing a pattern and
then duplicating the pattern for matching cells? - ✔✔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? - ✔✔Hyperlink
Which of the following charts displays three series of data to show fluctuations in stock
prices from high to low to close? - ✔✔Stock
What should you keep in mind when it comes to using shadows, bevels, and glows? -
✔✔Use them sparingly
Which of the following are examples of SmartArt objects? - ✔✔all of the above E5-267
Which of the following enables you to identify a folder that contains secure, safe
worksheets? - ✔✔Trust Center
Which of the following types of workbooks open in Protected View? - ✔✔ all of the above
E7-404
Which of the following functions rounds a value to a specified number of decimal places?
- ✔✔ROUND
Which of the following are structured references that Excel automatically places in a
table? - ✔✔all of the above E4-201
Which of the following is a high-quality illustration, which often includes text that you
can place in Office documents, including Excel worksheets? - ✔✔SmartArt Graphic
