100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
BUSA Final Exam Questions and Answers All Correct $11.99   Add to cart

Exam (elaborations)

BUSA Final Exam Questions and Answers All Correct

 5 views  0 purchase
  • Course
  • BUSA
  • Institution
  • BUSA

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...

[Show more]

Preview 2 out of 6  pages

  • November 7, 2024
  • 6
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • BUSA
  • BUSA
avatar-seller
Scholarsstudyguide
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 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

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

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

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 $11.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

62555 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.99
  • (0)
  Add to cart