Exam (elaborations)
BUSA Final Exam: Questions & Complete Solutions (A+)
BUSA Final Exam: Questions & Complete Solutions (A+)
[Show more]
Content preview
BUSA Final Exam: Questions & Complete Solutions (A+)Which of the following is defined as a range of cells that shows calculated
results of one or more formulas? Right Ans - 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? Right Ans -
MATCH Function
Which of the following is a benefit of data validation? Right Ans - all of the
above E7-376
Which of the following tabs lets you edit or delete a comment? Right Ans -
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)? Right Ans - mixed reference
Which of the following simplifies the process of entering the months of the
year in a worksheet? Right Ans - Fill Handle Tool
Which of the following mathematical operations is always performed last?
Right Ans - Subtraction
Which of the following functions allows you to link or join text in a chain?
Right Ans - CONCATENATE Function
Which of the following conditions exists if you enter criteria on the same row?
Right Ans - AND Conditions
Which of the following terms refers to a piece of data in a single column?
Right Ans - Field
Which of the following is a new command in Excel 2013 for recognizing a
pattern and then duplicating the pattern for matching cells? Right Ans -
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? Right Ans - Hyperlink
Which of the following charts displays three series of data to show
fluctuations in stock prices from high to low to close? Right Ans - Stock
What should you keep in mind when it comes to using shadows, bevels, and
glows? Right Ans - Use them sparingly
Which of the following are examples of SmartArt objects? Right Ans - all of
the above E5-267
Which of the following enables you to identify a folder that contains secure,
safe worksheets? Right Ans - Trust Center
Which of the following types of workbooks open in Protected View? Right
Ans - all of the above E7-404
Which of the following functions rounds a value to a specified number of
decimal places? Right Ans - ROUND
Which of the following are structured references that Excel automatically
places in a table? Right Ans - 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? Right
Ans - SmartArt Graphic
Which of the following should you use to insert formulas and edit data?
Right Ans - Formula Bar
Which of the following is a picture of something that appeared on-screen, that
you insert as an object in a worksheet? Right Ans - Screenshot
Which of the following best describes the cell reference B5? Right Ans -
relative
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 Studycafe. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$14.05. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79064 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now