Data Analyst Excel Quiz

10 Questions

Settings
Please wait...
Data Analyst Excel Quiz

A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a better decision for its advancement. Most data analysts implement the use of Microsoft Excel. Here is a short quiz.


Questions and Answers
  • 1. 
    What add-in program serves as the data analyzing tool in Excel?
    • A. 

      Excel Analyse

    • B. 

      Analyse Tool Excel

    • C. 

      Analyz Tools

    • D. 

      Analysis Toolpak

  • 2. 
    Which of these is true about data analysis function?
    • A. 

      It can be used on multiple worksheets at a time

    • B. 

      It can't be used offline

    • C. 

      It can be used on only one worksheet at a time

    • D. 

      It can only be used in excel 2016

  • 3. 
    Where does the result appear when a data analyst performs data analysis on a grouped worksheet?
    • A. 

      First worksheet

    • B. 

      Last Worksheet

    • C. 

      All other worksheets except the first

    • D. 

      All other worksheets except the last

  • 4. 
    How does a data analyst performs data analysis on the remainder of the worksheets without results?
    • A. 

      You can't work on the rest of the worksheets

    • B. 

      Delete the Previous results

    • C. 

      Restart the analysis operation

    • D. 

      Recalculate the analysis tool for each worksheet

  • 5. 
    What type of analysis tool creates a sample from a population by treating the input range as a population?
    • A. 

      Regression analysis tools

    • B. 

      Fourier analysis tools

    • C. 

      Anova analysis tools

    • D. 

      Sampling analysis tools

  • 6. 
    What type of analysis tool performs linear abalysis by using the "Least Squares" to fit a line through a set of observations?
    • A. 

      Regression

    • B. 

      Fourier analysis

    • C. 

      Linear analysis

    • D. 

      Anova

  • 7. 
    What type of analysis tool fills a range with independent random numbers that are drawn from one several distribuctions?
    • A. 

      Resonance

    • B. 

      Distribution range

    • C. 

      Banoulli

    • D. 

      Random number generation

  • 8. 
    What do data analysts call FFT in Fourier analysis?
    • A. 

      Fourth Fourier text

    • B. 

      Fountain Fourier type

    • C. 

      Fast Fourier transform

    • D. 

      Fourier Fest Treat

  • 9. 
    What analysis tool type tests for equality of the population means that underlie each sample?
    • A. 

      Equality test

    • B. 

      T-equaliry

    • C. 

      Two-sample t-Test

    • D. 

      Equality sample test

  • 10. 
    What tab leads a data analyst to the analysis tool pak in the Excel 2016?
    • A. 

      Home

    • B. 

      Review

    • C. 

      File

    • D. 

      Insert