100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
GL19 U5 (Excel) CH02 Concepts Exam Practice Questions and Answers 100% Pass $10.49   Add to cart

Exam (elaborations)

GL19 U5 (Excel) CH02 Concepts Exam Practice Questions and Answers 100% Pass

 0 view  0 purchase
  • Course
  • Prep Tests
  • Institution
  • Prep Tests

GL19 U5 (Excel) CH02 Concepts Exam Practice Questions and Answers 100% Pass Assume that you own a store and need to calculate the number of sales transactions that took place in one day. Which of the following functions should you use? - ANSWER-COUNT Because Excel follows the standard mathemati...

[Show more]

Preview 1 out of 4  pages

  • November 11, 2024
  • 4
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Prep Tests
  • Prep Tests
avatar-seller
OliviaWest
Copyright © OLIVIAWEST2024/2025 ACADEMIC YEAR. ALL RIGHTS RESERVED




GL19 U5 (Excel) CH02 Concepts Exam Practice

Questions and Answers 100% Pass


Assume that you own a store and need to calculate the number of sales transactions that took place in

one day. Which of the following functions should you use? - ANSWER✔✔-COUNT


Because Excel follows the standard mathematical order of operations, it will calculate the formula

=4+2*3 to what? - ANSWER✔✔-10


Chapter 2 suggests that key data referenced by formulas throughout a worksheet should be placed

_____ to make them more accessible. - ANSWER✔✔-near the top of the sheet


If you don't know the exact name of the function you need, you can enter a description of what you

want to do using the - ANSWER✔✔-Insert Function dialog box.


If you move a formula containing a relative reference and an absolute reference to a new location, what

will happen? - ANSWER✔✔-The relative reference will automatically adjust, but the absolute reference

will remain the same.


Imagine that cells C1:C7 contain the hours an employee worked each day for one week. Cell B3 contains

the employee's hourly wage. You want to insert a formula in cells D1:D7 that will calculate the

employee's earnings for each day. What formula, when entered in cell D1 and then copied down the rest

of the column, will give you the correct results? - ANSWER✔✔-=C1*$B$3


In Excel, what formula will return a result of 33? - ANSWER✔✔-=(5+6)*3




Copyright ©Stuvia International BV 2010-2024 Page 1/4

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

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

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