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
Excel Crash Course& Wall Street Actual Exam Combined Questions With Revised Correct Detailed Answers & Rationales >>Latest Update> >With Images $22.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. EXCEL CRASH COURSE
  4.  
  5. EXCEL CRASH COURSE

Exam (elaborations)

Excel Crash Course& Wall Street Actual Exam Combined Questions With Revised Correct Detailed Answers & Rationales >>Latest Update> >With Images

 0 purchase
  • Course
  • EXCEL CRASH COURSE
  • Institution
  • EXCEL CRASH COURSE

Excel Crash Course& Wall Street Actual Exam Combined Questions With Revised Correct Detailed Answers & Rationales >>Latest Update> >With Images 1. Please select the answer that best describes the shortcut to Split (not freeze) an excel sheet into just two panes (top ...

[Show more]

Preview 4 out of 124  pages

Document information

  • November 3, 2024
  • 124
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • EXCEL CRASH COURSE
  • EXCEL CRASH COURSE

Seller

avatar-seller
NURSINGDICTIONARY

Reviews received

Content preview

Excel Crash Course& Wall Street
Actual Exam Combined Questions
With Revised Correct Detailed
Answers & Rationales >>Latest
Update>
>With Images


1. Please select the answer that best describes the shortcut to
Split (not freeze) an excel sheet into just two panes (top and bottom)
To navigate from pane to pane
1. Anywhere in the Excel worksheet hit Alt W S to split the panes to a top and
bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel you will
need to hit F6 several times to get from one pane to the other).
1. With the active cell on any row but in column A, hit Alt W S to split the panes to
a top and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel
you will need to hit F6 several times to get from one pane to the other).
1. With the active cell on any column but in row 1, hit Alt W S to split the panes to
a top and bottom. 2. Hit F6 to jump from pane to pane (in some versions of Excel
you will need to hit F6 several times to get from one pane to the other). -
ANSWER The correct answer is:
With the active cell on any row but in column A, hit Alt w s to split the panes to a
top and bottom.

,Hit F6 to jump from pane to pane (in some versions of Excel you will need to hit
F6 several times to get from one pane to the other).
If the active cell is not in Column A, the user will have more than 2 panes. If the
active cell is in Row 1, the user will get two vertical panes.


2. You are in cell A1 and start a formula by typing = in a worksheet with split
top and bottom panes. In order to jump to the bottom pane while working
on the formula:
Hit Tab
Hit F6
Hit Alt F6

Hit Alt Tab - ANSWER The correct answer is: Hit F6
Tab will navigate to the next cell. Alt F6 is not a valid shortcut. Alt Tab will
navigate to a different window.
See lesson: Splitting & Freezing Panes


3. Identify the commands to insert a comment and delete a comment
1)Alt e m 2) Alt e m
1)Alt h e m 2) Alt I m
1)Shift F2 2) Alt h e m

1)Alt h e m 2) Alt I s - ANSWER The correct answer is Shift F2, Alt h e m.
Alt e m is a shortcut to open the menu to move or copy a selected sheet. Alt I s is
the shortcut to insert a symbol.


4. Identify the utility used to create a dropdown menu in Excel.
Alt d t

,Alt d v l
Alt d l

Alt d d t - ANSWER The correct answer is: alt d l.
Alt d t is the shortcut to build a data table. Alt d v l is not a valid shortcut. Alt d d t
is not a valid shortcut.


5. Which of the following is NOT a shortcut for changing the format of a cell
Ctrl Tab
Ctrl Shift 1
Ctrl B

Alt h f c - ANSWER The correct answer is Ctrl Tab.
Ctrl Tab will move the selected cell. It is not a shortcut used to format cells. Ctrl
Shift 1 will change the cell to a Number format, Ctrl B makes the cell text bold, Alt
h f c will allow to change the text color.


6. Identify the shortcut to remove arrows from Trace Precedents or Trace
Dependents.
Alt d t
Alt m p
Alt m d

Alt m a - ANSWER The correct answer is Alt m a.
Alt d t inserts a data table. Alt m p is the shortcut to trace precedents. Alt m d is
the shortcut to trace dependents.


7. Identify a function in cell D6 that will return the fraction of the year elapsed
assuming a 360 day count basis.

, =STUB(D4,D5)
=YEARFRAC(D4,D5,2)
=DAYS360(D4,D5)

=YEARFRAC(D4,D5) - ANSWER The correct answer is: =YEARFRAC(D4,D5,2).
STUB is not an Excel formula. DAYS360 will return the number of days in a 360 day
year. YEARFRAC(D4,D5) will calculate the fraction using a 365-day year.


8. Identify the formula that will always output a date that is the end-of-month
date 3 months after the date inputted in D5.
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5))
=EOMONTH(3,D5)

=EOMONTH(D5,3) - ANSWER The correct answer is: =EOMONTH(D5,3)
=DATE(YEAR(D5),MONTH(D5)+3,DAY(D5)) will add 3 months to the data inputted
in D5. EOMONTH(3,D5) reverses the arguments required for this function.


9. Identify the formula that, based in user inputs in cells B1 and B2, outputs the
text "animal lover" for users who have at least 1 dog and at least one cat, and
outputs "lonely person" when those conditions are not met.
=IF(OR(B1>0,B2>0),"animal lover","lonely person")
=IF(AND(B1>1,B2>1),"animal lover","lonely person")
=IF(AND(B1>0,B2>0),"animal lover","lonely person")
=AND(IF(B1>0,"animal lover","lonely person"),IF(B2>0,"animal lover","lonely
person")) - ANSWER The correct answer is: =IF(AND(B1>0,B2>0),"animal
lover","lonely person")
=IF(OR(B1>0,B2>0),"animal lover","lonely person") will output "animal lover" if
the user owns a dog OR a cat.

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

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69411 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
$22.99
  • (0)
Add to cart
Added