BUSA Final Exam Questions and Answers All Correct
What is selected when you click the button located above the row 1 heading and to the left of the column A heading? - Answer- the entire worksheet
Which of the following can you do with open workbooks? - Answer- all of the above E5-264
Which...
What is selected when you click the button located above the row 1 heading and to the
left of the column A heading? - Answer- the entire worksheet
Which of the following can you do with open workbooks? - Answer- all of the above E5-
264
Which of the following is true of Solver? - Answer- It finds soutions to many, but not all,
problems.
Which of the following must you use when using database functions? - Answer- criteria
range
Which of the following is the default Value Field Setting in a PivotTable? - Answer- SUM
In the function =SUM(B2:B6), which part of the function is the argument? - Answer-
B2:B6
Which of the following conditions exists if you enter criteria on different rows? - Answer-
OR Conditions
Which of the following includes data that is referenced in a dependent workbook? -
Answer- Source Workbook
What do trendlines demonstrate? - Answer- Averages
Which kinds of source data can you import into Excel? - Answer- all of the above E4-
187
Which of the following functions can be inserted by the Subtotal command? - Answer-
all of the above
E4-212
Which of the following helps you make sure that your worksheet will work well with
others who have earlier versions of Excel? - Answer- Check Compatibility Command
Which of the following functions counts the number of cells in a range that contain
numbers? - Answer- COUNT
, Which of the following are miniature charts displayed in a cell or cell range with your
data? - Answer- sparklines
In a pie chart, what is a data series represented by? - Answer- the whole pie
Which of the following actions can you perform with a hyperlink in Excel? - Answer- all
the above E5-269
Which of the following is the name used to describe a group of cells? - Answer- Range
Which of the following applies specified formats to cells only when the cells meet some
criteria? - Answer- Conditional Formatting
Which of the following tasks can you perform using a data input form? - Answer- All of
the above E7-384
Which of the following would let you limit the length of a text entry as with an
abbreviation of a state? - Answer- Validation Settings
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data? - Answer- REPLACE Function
Which of the following is defined as a range of cells that shows calculated results of one
or more formulas? - 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? - Answer- MATCH Function
Which of the following is a benefit of data validation? - Answer- all of the above E7-376
Which of the following tabs lets you edit or delete a comment? - 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)? -
Answer- mixed reference
Which of the following simplifies the process of entering the months of the year in a
worksheet? - Answer- Fill Handle Tool
Which of the following mathematical operations is always performed last? - Answer-
Subtraction
Which of the following functions allows you to link or join text in a chain? - Answer-
CONCATENATE Function
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 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 Scholarsstudyguide. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.79. You're not tied to anything after your purchase.
