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 Exam 2024 Update $17.99
Add to cart
Quickly navigate to
Preview
  2.  
  3. Excel Crash Course
  4.  
  5. Excel Crash Course

Exam (elaborations)

Excel Crash Course Exam 2024 Update
 0 purchase
  • Course
  • Excel Crash Course
  • Institution
  • Excel Crash Course

Excel Crash Course Exam 2024 Update What is the keyboard shortcut to freeze panes within a worksheet? Alt F W V Alt W S Alt W F F Alt A W T - ANSWER-The correct answer is: Alt w f f. Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alt a w t is a shortcut t...

[Show more]

Preview 3 out of 16  pages

Document information

  • September 17, 2024
  • 16
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • Excel Crash Course
  • Excel Crash Course

Seller

avatar-seller
NURSING2EXAM

Reviews received

Content preview

Excel Crash Course
Exam 2024 Update




What is the keyboard shortcut to freeze panes within a worksheet?
Alt F W V
Alt W S
Alt W F F
Alt A W T - ✔✔✔ANSWER-The correct answer is: Alt w f f.
Alt f w v is the shortcut for Print Preview. Alt w s is the shortcut to split panes. Alt
a w t is a shortcut to build data tables.


What is the keyboard shortcut to open the formatting cells dialog box?
Ctrl 1
Ctrl 2

,Ctrl Shift 1
Ctrl Shift 2 - ✔✔✔ANSWER-The correct answer is: Ctrl 1.
Ctrl 2 is not a valid shortcut. Ctrl Shift 1 is the shortcut to cycle through different
number formats. Ctrl Shift 2 is the shortcut to cycle through different date formats.


What is the keyboard shortcut to open the paste special dialog box?
Ctrl v
Ctrl e s
Alt e s or Alt h v s
Ctrl h v - ✔✔✔ANSWER-The correct answer is: Alt e s or Alt h v s


All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT:
Alt i w
Alt h i s
Shift F11
Alt Shift F1
Alt h i w
Incorrect - ✔✔✔ANSWER-Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all
keyboard shortcuts for adding more sheets to a workbook.
Alt h i w is not a valid shortcut.


Below is a Data Table designed to display the effect on 2015 Net Profit based of
changes in 2015 Revenue Growth and 2015 COGS %. Please provide:
The cell reference required in D22.
The row input cell required by the Data Table.

, The column input cell required by the Data Table.
Provide all three cell references, in order above, separated by commas with no
space (i.e. A1,A2,A3) Note: Do not include spaces within answer -
✔✔✔ANSWER-The correct answer is: E8,E10,E11
E8 is the cell reference for 2018 Net Income, the output variable, which must be in
the top left corner of the table. E10, the 2015 revenue growth rate, is the row input
cell, the variable that is being sensitized in the top row of the table. E11, the COGS
%, is the column input variable that is being sensitized.


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.


Identify the best formula that will output 2016 expenses. Hint: Only select the
'range lookup' argument if it is necessary.
=HLOOKUP(2016,B2:D4,2,0)
=HLOOKUP(2016,A1:D4,3)
=HLOOKUP("Expenses",A1:D4,2)
=HLOOKUP(2016,B2:D4,2) - ✔✔✔ANSWER-The correct answer is:
=HLOOKUP(2016,A1:D4,3)
=HLOOKUP(2016,B2:D4,2,0) will not result in a valid output because 2016 is not
selected in the table array argument.

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

Will I be stuck with a subscription?

No, you only buy these notes for $17.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
$17.99
  • (0)
Add to cart
Added