100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
CGS Test 1 Exam Questions and Answers 100% Solved | Graded A+ $10.49
Add to cart

Exam (elaborations)

CGS Test 1 Exam Questions and Answers 100% Solved | Graded A+

 2 views  0 purchase
  • Course
  • CGSS
  • Institution
  • CGSS

CGS Test 1 Exam Questions and Answers 100% Solved | Graded A+ Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the following is not a method for going to cell B10? Use the Go To dialog box. Type B10 in the Name Box and press Enter. Use the scroll arrows on the k...

[Show more]

Preview 3 out of 27  pages

  • December 23, 2024
  • 27
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • CGSS
  • CGSS
avatar-seller
JOSHCLAY
CGS Test 1 Exam Questions and

Answers 100% Solved | Graded A+


Cell A5 is the active cell. You want to make cell B10 the active cell. Which

of the following is not a method for going to cell B10?



Use the Go To dialog box.



Type B10 in the Name Box and press Enter.



Use the scroll arrows on the keyboard.



Type B10 in the Formula Bar and press Enter. - ✔✔Type B10 in the

Formula Bar and press Enter.

Which step is not part of planning a worksheet design?



Decide what input values are required.



Enter labels, values, and formulas.
1
©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.

,State the purpose of the worksheet.



Decide what outputs are required to achieve the purpose. - ✔✔Enter

labels, values, and formulas

Cell A2 contains the regular price $100. Cell B2 contains the discount rate

15%. Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which

of the following formulas produces the same result?



=A2*(B2-1)



=A2-(A2*B2)



=A2*B2-1



=A2*1-B2 - ✔✔=A2-(A2*B2)

What should you do if you see pound signs (###) instead of values or

results of formulas?



Increase the column width.

2
©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.

, Increase the zoom percentage.



Delete the column.



Adjust the row height. - ✔✔Increase the column width

You just copied a range of data containing formulas. However, you want to

preserve the formula results and the original number and text formatting in

the pasted range. Which paste option would you select?



Formulas



Keep Source Formatting



Values & Source Formatting



Values & Number Formatting - ✔✔Values & Source Formatting

The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1.

You select the range A1:E1 and click Merge & Center. What is the result?



3
©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.

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

51292 documents were sold in the last 30 days

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

Start selling
$10.49
  • (0)
Add to cart
Added