100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
BITM 215 Exam Multiple Choice Questions Solved 100% with Certified Correct Answers $12.99   Add to cart
Quickly navigate to
Preview
  2.  
  3. BITM 215
  4.  
  5. BITM 215

Exam (elaborations)

BITM 215 Exam Multiple Choice Questions Solved 100% with Certified Correct Answers
 1 view  0 purchase
  • Course
  • BITM 215
  • Institution
  • BITM 215

Which of the following is an Excel add-in? (a) Goal Seek (b) Solver (c) One- or two-variable data table (d) Scenario Manager - (b) Solver

Preview 2 out of 12  pages

Document information

  • August 29, 2024
  • 12
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • bitm 215 exam multiple choice questions solved 100

Written for

  • BITM 215
  • BITM 215

Seller

avatar-seller
KenAli

Content preview

BITM 215 Exam Multiple Choice Questions
Solved 100% with Certified Correct Answers

Which of the following is an Excel add-in?



(a) Goal Seek

(b) Solver

(c) One- or two-variable data table

(d) Scenario Manager - ✔✔(b) Solver



Which of the following is not an acceptable range name?



(a) Apr

(b) Rate_2021

(c) 2021_Rate

(d) Payment - ✔✔(c) 2021_Rate



What is the keyboard shortcut to open the Paste Name dialogue box?



(a) F2

(b) F3

(c) F4

(d) F5 - ✔✔(b) F3



Which of the following tools can incorporate constraints?



(a) Goal Seek

(b) Solver

, (c) Data Tables

(d) Scenario Manager - ✔✔(b) Solver



The Solver add-in displays on this tab in the ribbon.



(a) Home tab

(b) Formulas tab

(c) Data tab

(d) Analyze tab - ✔✔(c) Data tab



The date 8/3/2021 is stored in cell C1. What function is used to extract just 3?



(a)=YEAR(C1)

(b)=MONTH(C1)

(c)=DAYS(B1,C1)

(d)=DAY(C1) - ✔✔(d)=DAY(C1)



The date February 16, 2021 is stored in cell B1. The last day of the semester (May 7, 2021) is stored in
cell B2. Which function calculates the number days until the end of the semester?



(a)=DAYS(B1,B2)

(b)=DAYS(B2,B1)

(c)=YEARFRAC(B1,B2)

(d)=DAY(C1) - ✔✔(b)=DAYS(B2,B1)



For which situation would you use the SWITCH function?



(a) You want to display a bonus if an employee earned a 5 on a performance evaluation and was
hired before 1/1/2021

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 KenAli. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

82191 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
$12.99
  • (0)
  Add to cart