excel trotters

+254 738 00 22 22

 excel trotters

training@exceltrotters.com

Take the survey, Gauge your excel skills and knowledge

  1. Excel has how many views?
    One
    Two
    Three
    Four
    Doesn’t know
  2. Is the Excel Quick Access Toolbar customizable?
    Yes
    No
    Doesn’t know
  3. Is the Excel ribbon customizable?
    Yes
    No
    Doesn’t know
  4. Excel has how many sets of cell referencing styles?
    One
    Two
    Three
    Four
    Doesn’t know
  5. What sign is used to reference cells in Excel?
    #
    &
    $
    *
    Doesn’t know
  6. What does the $ sign mean in the following formula: =$A1$*$B1/C1
    The cell reference for column A is absolute while column B and C are not relative
    The cell reference for Column A and B are absolute while column C is relative
    The cell reference for Column A is fixed, column B is relative absolute while column C is relative
    The cell reference for cell A1 is fixed, cell B1 is absolute relative, while C1 is relative
    Doesn’t know
  7. Are Charts linked to the source data?
    Yes
    No
    Doesn’t
  8. Can the source data be changed after creating a pivot table?
    Yes
    No
    Doesn’t know
    Doesn’t
  9. Can a Worksheet be moved from one Workbook to another?
    Yes
    No
    Doesn’t know
  10. Are you proficient with creating formulas between Worksheets?
    Yes
    No
  11. Are you proficient with creating formulas between Workbooks?
    Yes
    No
  12. Are you proficient with auditing formulas?
    Yes
    No
  13. In what scenario is theVLookup function used?
    When the table is taller than is wide
    When the table is wider than is tall
    When the table is the same width
    Doesn’t know
  14. In what scenario is the HLookup function used?
    When the table is taller than is wide
    When the table is wider than is tall
    When the table is the same width
    Doesn’t know
  15. What does Conditional Formatting do?
    It creates a Chart based on certain formatting
    It is used to apply special Formatting to Charts
    It is used to apply formatting based on a condition(s)
    Doesn’t know
  16. Is there a difference between a range formatted with borders from a table?
    Yes
    No
    Doesn’t know
  17. What is the difference between arranging pages Down, then over and Over, then down before printing?
    One orders pages towards the bottom then to the right while the other orders the page to the right then to the bottom
    It means order pages down then over
    Doesn’t know
  18. Are you proficient with adding page numbers and customizing footers and headers?
    Yes
    No
  19. Are you proficient with using multiple column sort command?
    Yes
    No
  20. Are you proficient with creating data validation lists?
    Yes
    No
  21. Are your proficient with creating Custom lists for data analysis and custom sorting?
    Yes
    No
  22. Can the active cell movement be changed?
    Yes
    No
    Doesn’t know
  23. How many options exists for transposing data?
    One
    Two
    Three
    Doesn’t know
  24. How many methods exist for splitting data?
    One
    Two
    Three
    Doesn’t know
  25. How many methods exists for joining data?
    One
    Two
    Three
    Doesn’t know

 

Contact info

excel trottersExcelTrotters Limited

excel trottersNairobi,Kenya

excel trottersMobile : +254 782 00 22 22

excel trottersPhone : +254 782 00 22 22

excel trottersEmail : training@exceltrotters.com