BUSA Final PASSED Actual Exam Questions and CORRECT Answers
4 views 0 purchase
Course
BUSA
Institution
BUSA
BUSA Final PASSED Actual Exam
Questions and CORRECT 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
loc...
BUSA Final PASSED Actual Exam
Questions and CORRECT 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
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
What should you keep in mind when it comes to using shadows, bevels, and glows? -
CORRECT ANSWER- ✔✔Use them sparingly
Which of the following are examples of SmartArt objects? - CORRECT ANSWER- ✔✔all of
the above E5-267
Which of the following enables you to identify a folder that contains secure, safe worksheets?
- CORRECT ANSWER- ✔✔Trust Center
Which of the following types of workbooks open in Protected View? - CORRECT
ANSWER- ✔✔all of the above E7-404
Which of the following functions rounds a value to a specified number of decimal places? -
CORRECT ANSWER- ✔✔ROUND
Which of the following are structured references that Excel automatically places in a table? -
CORRECT ANSWER- ✔✔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? - CORRECT ANSWER-
✔✔SmartArt Graphic
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller MGRADES. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
