Data Analyst Excel Quiz

10 Questions  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

Related Topics