Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Quiz 4

    Uploaded by

    Kyneth Joy

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Quiz 4

    Uploaded by

    Kyneth Joy
    15 views6 pages

    Original Title

    QUIZ 4

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    15 views6 pages

    Quiz 4

    Uploaded by

    Kyneth Joy

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 6

    QUIZ # 4

    Write your answer in separate sheet. Select the LETTER ONLY

    1. What is the keyboard shortcut key to lock cell references in a formula?*


    a. CTRL
    b. ALT
    c. F2
    d. F4
    2. What are the shortcut keys for AutoSum?*
    a. ALT and S
    b. CTRL and S
    c. ALT and =
    d. CTRL and =
    3. Which of the following is the correct formula to calculate the weighted average
    score in cell C8 as shown below?*

    a. =SUMPRODUCT(C2:C5,B2:B5)
    b. =SUMPRODUCT(C2:C4,B2:B4)
    c. =AVERAGE(B2:B4)
    d. =AVERAGE(C2:C4)
    4. Company A is looking into four potential projects and will accept them if the
    IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2,
    which can be copied down to cell C3 through C5, to generate the results shown
    below?*
    a. =IF(B2>=E2,"Accept","Reject")
    b. =IF(B2>=$E2,"Accept","Reject")
    c. =IF(B2>=E$2,"Accept","Reject")
    d. =IF(B2>=$E$2,"Accept","Reject")
    5. What are the shortcut keys to insert a new row in an Excel spreadsheet?*
    a. ALT + H + I + R
    b. ALT + H + I + C
    c. ALT + H + I + I
    d. ALT + H + I + S
    6. What are the shortcut keys to group rows so you can expand/contract a section
    of data?*
    a. ALT + A + U + U
    b. ALT + A + W + G
    c. ALT + A + G + G
    d. ALT + A + B
    7. Which of the following Excel features allows you to select/highlight all cells
    that are formulas?*
    a. Find
    b. Replace
    c. Go To
    d. Go To Special
    8. What formula should be entered in cell A3 to display the results as shown
    below?*
    a. ="Income Statement"&A1
    b. ="Income Statement "&A1
    c. ="Income Statement "+A1
    d. ="Income Statement "&"A1"
    9. What formula can be used in cell G2 to create a dynamic date which shows the
    last day of each month?*

    a. =EOMONTH($B$2,B1)
    b. =EOMONTH($B$2,G1)
    c. =EOMONTH($B$2,C1)
    d. =MONTH($G$2)
    10.What are the keyboard shortcut keys to paste special?*
    a. ALT + H + V + F
    b. ALT + H + V + P
    c. ALT + H + V + O
    d. ALT + H + V + S
    11.Assuming cell A1 is displaying the number "12000.7789". What formula
    should be used to round this number to the closest integer?*
    a. =MROUND(A1,100)
    b. =MROUND(A1,10)
    c. =ROUND(A1,0)
    d. =ROUND(A1,1)
    12.What are the keyboard shortcut keys to edit formula in a cell?*
    a. F2
    b. F4
    c. CTRL + 1
    d. CTRL + F
    13.What are the keyboard shortcut keys to insert a table?*
    a. ALT + N + R
    b. ALT + N + C
    c. ALT + N + V
    d. ALT + N + T
    14.In which tab of the ribbon can you change Workbook Views to Page Break
    Preview?*
    a. View
    b. Review
    c. Page Layout
    d. Data
    15.What is the best practice for financial modeling in excel?*
    a. Use black font for all hard-coded numbers and formulas and blue font
    for only the totals
    b. Use blue font for all hard-coded numbers and formulas and black font
    for only the totals
    c. Use blue font for hard-coded numbers and black font for formulas
    d. Use black font for hard-coded numbers and blue font for formulas
    16.Which of the following features cannot be found in the Data ribbon?*
    a. What-If Analysis
    b. PivotTable
    c. Data Validation
    d. Text to Columns
    17.The shortcut keys to increase the number of decimal places are*
    a. ALT + H + 9
    b. ALT + H + P
    c. ALT + H + D
    d. ALT + H + 0
    18.Suppose a company expected its revenue to be $180,000 for 2014-2018. What
    formula should be entered in cell E6 so it displays revenue in 2016 if it was
    above budget, otherwise it'll show 0?*
    a. =IF(E2<$B$6,E2,0)
    b. =IF(E2<$B$6,0,E2)
    c. =IF(E2>$B$6,E2,0)
    d. =IF(E2>$B$6,0,E2)
    19.What are the shortcut keys to open up the Find and Replace window?*
    a. ALT + H + FD + R
    b. CTRL + FD
    c. ALT + H + R
    d. ALT + H + FD
    20.Which tab of the ribbon should you go to for removing gridlines on a
    worksheet?*
    a. Formulas
    b. View
    c. Review
    d. Developer
    ANSWERS:

    1. D
    2. C
    3. D
    4. D
    5. A
    6. C
    7. D
    8. A
    9. A
    10. D
    11. C
    12. A
    13. D
    14. A
    15. C
    16. B
    17. D
    18. C
    19. C
    20. B

    You might also like