Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Exercise

    Uploaded by

    oluoch

    Copyright:

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

    Exercise

    Uploaded by

    oluoch
    5 views5 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views5 pages

    Exercise

    Uploaded by

    oluoch

    Copyright:

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

    ICT IGCSE Practical Paper 2 Revision for Word Processing

    Excel Test Questions

    (Note: Questions on Excel shortcut keys are only applicable to PC users)

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


    o CTRL

    o ALT

    o F2

    o F4
     2. What are the shortcut keys for AutoSum?*
    o ALT and S

    o CTRL and S

    o ALT and =

    o CTRL and =
     3. Which of the following is the correct formula to calculate the weighted average score
    in cell C8 as shown below?*

    o =SUMPRODUCT(C2:C5,B2:B5)

    o =SUMPRODUCT(C2:C4,B2:B4)

    o =AVERAGE(B2:B4)

    o =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?*
    ICT IGCSE Practical Paper 2 Revision for Word Processing

    o =IF(B2>=E2,"Accept","Reject")

    o =IF(B2>=$E2,"Accept","Reject")

    o =IF(B2>=E$2,"Accept","Reject")

    o =IF(B2>=$E$2,"Accept","Reject")
     5. What are the shortcut keys to insert a new row in an Excel spreadsheet?*
    o ALT + H + I + R

    o ALT + H + I + C

    o ALT + H + I + I

    o ALT + H + I + S
     6. What are the shortcut keys to group rows so you can expand/contract a section of
    data?*
    o ALT + A + U + U

    o ALT + A + W + G

    o ALT + A + G + G

    o ALT + A + B
     7. Which of the following Excel features allows you to select/highlight all cells that are
    formulas?*
    o Find

    o Replace

    o Go To

    o Go To Special
     8. What formula should be entered in cell A3 to display the results as shown below?*
    ICT IGCSE Practical Paper 2 Revision for Word Processing

    o ="Income Statement"&A1

    o ="Income Statement "&A1

    o ="Income Statement "+A1

    o ="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?*

    o =EOMONTH($B$2,B1)

    o =EOMONTH($B$2,G1)

    o =EOMONTH($B$2,C1)

    o =MONTH($G$2)
     10. What are the keyboard shortcut keys to paste special?*
    o ALT + H + V + F

    o ALT + H + V + P

    o ALT + H + V + O

    o 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?*
    o =MROUND(A1,100)
    ICT IGCSE Practical Paper 2 Revision for Word Processing

    o =MROUND(A1,10)

    o =ROUND(A1,0)

    o =ROUND(A1,1)
     12. What are the keyboard shortcut keys to edit formula in a cell?*
    o F2

    o F4

    o CTRL + 1

    o CTRL + F
     13. What are the keyboard shortcut keys to insert a table?*
    o ALT + N + R

    o ALT + N + C

    o ALT + N + V

    o ALT + N + T
     14. In which tab of the ribbon can you change Workbook Views to Page Break Preview?*
    o View

    o Review

    o Page Layout

    o Data
     15. What is the best practice for financial modeling in excel?*
    o Use black font for all hard-coded numbers and formulas and blue font for only the
    totals

    o Use blue font for all hard-coded numbers and formulas and black font for only the
    totals

    o Use blue font for hard-coded numbers and black font for formulas

    o 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?*
    o What-If Analysis

    o PivotTable

    o Data Validation

    o Text to Columns
     17. The shortcut keys to increase the number of decimal places are*
    o ALT + H + 9

    o ALT + H + P
    ICT IGCSE Practical Paper 2 Revision for Word Processing

    o ALT + H + D

    o 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?*

    o =IF(E2<$B$6,E2,0)

    o =IF(E2<$B$6,0,E2)

    o =IF(E2>$B$6,E2,0)

    o =IF(E2>$B$6,0,E2)
     19. What are the shortcut keys to open up the Find and Replace window?*
    o ALT + H + FD + R

    o CTRL + FD

    o ALT + H + R

    o ALT + H + FD
     20. Which tab of the ribbon should you go to for removing gridlines on a worksheet?*
    o Formulas

    o View

    o Review

    o Developer

    You might also like