Data Analyst Excel Quiz
Settings
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.
- 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
Back to top