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 Basics - Wall Street Prep Questions And Answers With Verified Solutions 100% Correct (Graded A+) Latest Update 2024/2025. $7.79
Add to cart
Quickly navigate to
Preview
  2.  
  3. Wall Street Prep
  4.  
  5. Wall Street Prep

Exam (elaborations)

Excel Basics - Wall Street Prep Questions And Answers With Verified Solutions 100% Correct (Graded A+) Latest Update 2024/2025.
 0 purchase
  • Course
  • Wall Street Prep
  • Institution
  • Wall Street Prep

Excel Basics - Wall Street Prep Questions And Answers With Verified Solutions 100% Correct (Graded A+) Latest Update 2024/2025.

Preview 2 out of 5  pages

Document information

  • November 20, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

Written for

  • Wall Street Prep
  • Wall Street Prep

Seller

avatar-seller
Amazingsirpaul

Reviews received

Content preview

Excel Basics - Wall Street Prep Questions And Answers
With Verified Solutions 100% Correct (Graded A+) Latest
Update 2024/2025.
Create new sheet - ANSWER ctrl i w

switch between sheets - ANSWER ctrl page up / ctrl page down

access anything on the ribbon - ANSWER atl

toggle between excel books - ANSWER ctrl tab

open new file - ANSWER ctrl o

bold - ANSWER ctrl b

options - ANSWER alt f t

auto size cell - ANSWER alt h o i

designate width of box - ANSWER alt h o w

highlight column - ANSWER ctrl space

highlight row - ANSWER shift space

undo - ANSWER ctrl z

redo - ANSWER ctrl y

formatting - ANSWER ctrl 1

highlight all columns next - ANSWER ctrl shift > / <

paste special - ANSWER alt e s

zoom in / out - ANSWER alt v z

freeze pane - ANSWER alt w f f

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the
worksheet scrolls.

split pane - ANSWER alt w s

hop between panes - ANSWER F6

go inside cell to see functions - ANSWER F2

go inside cell to clear specific info - ANSWER ALT h e

input comment - ANSWER Shift F2

, Fill Highlighted Area Right / Down - ANSWER ctrl r / ctrl d

Input New Row - ANSWER ALT i r

input new column - ANSWER alt i c

deleting columns / rows - ANSWER ALT H D R / ALT H D C

Paste Special Formatting - ANSWER ALT E S T

Trace Precedents - ANSWER ATL M P / (delete it ALT M A A) allows you to see which cells are
referenced in a particular formula or function

Trace Dependents - ANSWER ALT M D

find and replace - ANSWER ctrl h

IF - ANSWER criteria, output if true, output if false

IF(AND( - ANSWER IF(AND(first test, 2nd test), output is true, output if false)

Date function - ANSWER (year,month,day) but if you do DATE(Year(cell w/ date to reference)+1,
Month(cell w/ date), Day(cell with date)) makes easier to drag out a list of dates increasing each year by
1

YearFrac - ANSWER Start, End, Basis (Basis = 0 or omitted = 30/360, 1 = actual / actual, 2 =
actual over / 360, 3 = actual / 365) _____ is a function that will return the number of years between two
dates.

HLookup - ANSWER (look up value, table range, row number) - searches for a value in the top
row of a table or an array of values, and then returns a value in the same column from a row you specify
in the table or array - use HLOOKUP when your comparison values are located in row across the top of a
table of data, and you want to look a specified number of rows.

Vlookup - ANSWER (look up value, table range, column number) - searches for a value in the
leftmost column of a table, and then returns a value in the same row from a column you specify in the
table or array - use VLOOKUP when you comparison values are located in a column to the left of a table
of data, and you want to look across (and to the right) a specified number of columns) *if looking up
words add a 4th value as 0 aka (look up value, table range, column number, 0)

MATCH - ANSWER (look up value, lookup array, match type) - returns the relative position
(number) of an item in an array that matches specified look up value. Best when combing this function
w/ HLOOKUP, VLOOKUP, OFFSET, INDEX, CHOOSE to make formulas more durable and dynamic.

Create Drop Down Menu - ANSWER ALT + D L

OFFSET - ANSWER reference point (make above top left data), rows, columns

Input Data Table - ANSWER Highlight Table

ALT D T

Vertical Table (No Row Input Needed)

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

Will I be stuck with a subscription?

No, you only buy these notes for $7.79. 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

Recently viewed by you

Exam (elaborations) ·

(0)

Intuit Bookkeeping Professional Certificate Exam Questions With Revised Correct Answers Updated

$7.79
  • (0)
Add to cart
Added