Why you should use Excel & datatolkningstest?

The Excel & datatolkningstest makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects: Mastering af grundlæggende Excel -formler Forståelse og anvendelse af avancerede Excel -matematikformler Analyse af data i Excel ved hjælp af drejepunkter og filtre Visualisering af data i Excel gennem diagrammer og grafer Tolkning af grafer for at drage konklusioner Analyse af tabeller for at udtrække indsigt Brug af Excel's datavisualiseringsværktøjer effektivt Anvendelse af statistiske koncepter og teknikker til at udmærke data Forståelse og anvendelse af avancerede excel -funktioner Oprettelse af dynamiske rapporter og dashboards i Excel

Excel & datatolkningstest

Q: What topics are covered in the Excel & datatolkningstest?

Grundlæggende Excel -formler Excel matematikformler Analyse af data i Excel ved hjælp af drejepunkter og filtre Visualisering af data i Excel Fortolkning af grafer Analyse af tabeller Tegning af konklusioner Analyse af diagrammer Datavisualisering

About the test:

Excel & Data-fortolkningstesten bruger scenariebaserede MCQ'er til at evaluere kandidaternes evne til at udføre opgaver såsom datamanipulation, statistisk analyse, finansiel modellering, problemløsning og kritisk tænkning. Kandidater kan også evalueres om deres evne til at fortolke og trække indsigt fra data og til at kommunikere deres fund effektivt gennem visualiseringer og rapporter.

Covered skills:

Grundlæggende Excel -formler
Analyse af data i Excel ved hjælp af drejepunkter og filtre
Fortolkning af grafer
Tegning af konklusioner
Datavisualisering

Excel matematikformler
Visualisering af data i Excel
Analyse af tabeller
Analyse af diagrammer

Preview this test

Se prøvescorekort

9 reasons why

Adaface Excel & datatolknings Test is the most accurate way to shortlist Dataanalytikers

Reason #1

Tests for on-the-job skills

The Excel & datatolkningstest helps recruiters and hiring managers identify qualified candidates from a pool of resumes, and helps in taking objective hiring decisions. It reduces the administrative overhead of interviewing too many candidates and saves time by filtering out unqualified candidates at the first step of the hiring process.

The test screens for the following skills that hiring managers look for in candidates:

Dygtige til at bruge basale excel -formler
Stærk forståelse af Excel -matematikformler
Evne til at analysere data i Excel ved hjælp af drejepunkter og filtre
Dygtige til at visualisere data i Excel
Dygtige til at fortolke grafer til dataanalyse
Evne til at analysere tabeller og tegne konklusioner
Stærk forståelse af analyse af diagrammer i Excel
Dygtige til datavisualiseringsteknikker
Evne til at fortolke og give mening om data
Dygtige til at bruge forskellige Excel -funktioner til dataanalyse

Reason #2

No trick questions

Traditional assessment tools use trick questions and puzzles for the screening, which creates a lot of frustration among candidates about having to go through irrelevant screening assessments.

View sample questions

The main reason we started Adaface is that traditional pre-employment assessment platforms are not a fair way for companies to evaluate candidates. At Adaface, our mission is to help companies find great candidates by assessing on-the-job skills required for a role.

Why we started Adaface

Preview this test

Se prøvescorekort

Reason #3

Non-googleable questions

We have a very high focus on the quality of questions that test for on-the-job skills. Every question is non-googleable and we have a very high bar for the level of subject matter experts we onboard to create these questions. We have crawlers to check if any of the questions are leaked online. If/ when a question gets leaked, we get an alert. We change the question for you & let you know.

How we design questions

Dette er kun en lille prøve fra vores bibliotek med 10.000+ spørgsmål. De faktiske spørgsmål om dette Excel & datatolkningstest vil være ikke-gåbart.

🧐 Question
Medium MATCH INDEX LOOKUP	Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
Medium Organization data Data transformation	Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved: We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data? A: Select the Organization ID and Country columns, and then click Keep Duplicates. B: Select the Organization ID and Country columns, and then click Remove Duplicates. C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation. D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.
Medium Student scores Data formatting	Solve
Here’s a sample Excel data source: Here’s the expected data format: Which of the following is the correct way to transform the data from the query editor to achieve the result? A: Columns to Select: Student Only B: Columns to Select: Student and Student ID C: Columns to Select: Primary and Secondary D: Command to Use: Pivot Column E: Command to Use: Reverse Rows F: Command to Use: Unpivot Columns
Medium VLOOKUP blood donor	Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)). A: =VLOOKUP("O-", A1:E10, 3, TRUE) B: =VLOOKUP("O-", A1:E10, 3, FALSE) C: =VLOOKUP("O-", D1:D10, 4) D: =VLOOKUP("O-", D1:D10, 3) E: =VLOOKUP("O-", A1:E10, 4, TRUE) F: =VLOOKUP("O-", A1:E10, 4, FALSE) G: =VLOOKUP("Kane", A1:E10, 4)
Medium Dividends Financial Analysis Percentage and Average Calculations	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
Medium Laptop Brands Proportions and Percentages Financial Reasoning	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
Hard Median Trend Analysis Statistical Reasoning	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

	🧐 Question	🔧 Skill
	Medium MATCH INDEX LOOKUP	2 mins Excel	Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
	Medium Organization data Data transformation	3 mins Excel	Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved: We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data? A: Select the Organization ID and Country columns, and then click Keep Duplicates. B: Select the Organization ID and Country columns, and then click Remove Duplicates. C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation. D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.
	Medium Student scores Data formatting	2 mins Excel	Solve
Here’s a sample Excel data source: Here’s the expected data format: Which of the following is the correct way to transform the data from the query editor to achieve the result? A: Columns to Select: Student Only B: Columns to Select: Student and Student ID C: Columns to Select: Primary and Secondary D: Command to Use: Pivot Column E: Command to Use: Reverse Rows F: Command to Use: Unpivot Columns
	Medium VLOOKUP blood donor	2 mins Excel	Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)). A: =VLOOKUP("O-", A1:E10, 3, TRUE) B: =VLOOKUP("O-", A1:E10, 3, FALSE) C: =VLOOKUP("O-", D1:D10, 4) D: =VLOOKUP("O-", D1:D10, 3) E: =VLOOKUP("O-", A1:E10, 4, TRUE) F: =VLOOKUP("O-", A1:E10, 4, FALSE) G: =VLOOKUP("Kane", A1:E10, 4)
	Medium Dividends Financial Analysis Percentage and Average Calculations	3 mins Data Interpretation	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
	Medium Laptop Brands Proportions and Percentages Financial Reasoning	2 mins Data Interpretation	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
	Hard Median Trend Analysis Statistical Reasoning	3 mins Data Interpretation	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

	🧐 Question	🔧 Skill	💪 Difficulty	⌛ Time
	MATCH INDEX LOOKUP	Excel	Medium	2 mins	Solve
Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?
	Organization data Data transformation	Excel	Medium	3 mins	Solve
We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved: We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data? A: Select the Organization ID and Country columns, and then click Keep Duplicates. B: Select the Organization ID and Country columns, and then click Remove Duplicates. C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation. D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.
	Student scores Data formatting	Excel	Medium	2 mins	Solve
Here’s a sample Excel data source: Here’s the expected data format: Which of the following is the correct way to transform the data from the query editor to achieve the result? A: Columns to Select: Student Only B: Columns to Select: Student and Student ID C: Columns to Select: Primary and Secondary D: Command to Use: Pivot Column E: Command to Use: Reverse Rows F: Command to Use: Unpivot Columns
	VLOOKUP blood donor	Excel	Medium	2 mins	Solve
We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)). A: =VLOOKUP("O-", A1:E10, 3, TRUE) B: =VLOOKUP("O-", A1:E10, 3, FALSE) C: =VLOOKUP("O-", D1:D10, 4) D: =VLOOKUP("O-", D1:D10, 3) E: =VLOOKUP("O-", A1:E10, 4, TRUE) F: =VLOOKUP("O-", A1:E10, 4, FALSE) G: =VLOOKUP("Kane", A1:E10, 4)
	Dividends Financial Analysis Percentage and Average Calculations	Data Interpretation	Medium	3 mins	Solve
Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?
	Laptop Brands Proportions and Percentages Financial Reasoning	Data Interpretation	Medium	2 mins	Solve
Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?
	Median Trend Analysis Statistical Reasoning	Data Interpretation	Hard	3 mins	Solve
Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

Reason #4

1200+ customers in 75 countries

Med Adaface var vi i stand til at optimere vores indledende screeningsproces med op mod 75 %, hvilket frigjorde kostbar tid for både ansættelsesledere og vores talentanskaffelsesteam!

Brandon Lee, Leder af mennesker, Love, Bonito

Preview this test

Se prøvescorekort

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Excel & datatolkningstest in your hiring process is that it is an elimination tool, not a selection tool. In other words: you want to use the test to eliminate the candidates who do poorly on the test, not to select the candidates who come out at the top. While they are super valuable, pre-employment tests do not paint the entire picture of a candidate’s abilities, knowledge, and motivations. Multiple easy questions are more predictive of a candidate's ability than fewer hard questions. Harder questions are often "trick" based questions, which do not provide any meaningful signal about the candidate's skillset.

Science behind Adaface tests

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Excel & datatolkningstest from your dashboard by entering their email address.

Public link: You can create a public link for each test that you can share with candidates.

API or integrations: You can invite candidates directly from your ATS by using our pre-built integrations with popular ATS systems or building a custom integration with your in-house ATS.

Reason #7

Detailed scorecards & benchmarks

Se prøvescorekort

Preview this test

Se prøvescorekort

Reason #8

High completion rate

Adaface tests are conversational, low-stress, and take just 25-40 mins to complete.

This is why Adaface has the highest test-completion rate (86%), which is more than 2x better than traditional assessments.

Reason #9

Advanced Proctoring

Learn more

Preview this test

Se prøvescorekort

About the Excel & datatolknings Assessment Test

Why you should use Pre-employment Excel & datatolkningstest?

The Excel & datatolkningstest makes use of scenario-based questions to test for on-the-job skills as opposed to theoretical knowledge, ensuring that candidates who do well on this screening test have the relavant skills. The questions are designed to covered following on-the-job aspects:

Mastering af grundlæggende Excel -formler
Forståelse og anvendelse af avancerede Excel -matematikformler
Analyse af data i Excel ved hjælp af drejepunkter og filtre
Visualisering af data i Excel gennem diagrammer og grafer
Tolkning af grafer for at drage konklusioner
Analyse af tabeller for at udtrække indsigt
Brug af Excel's datavisualiseringsværktøjer effektivt
Anvendelse af statistiske koncepter og teknikker til at udmærke data
Forståelse og anvendelse af avancerede excel -funktioner
Oprettelse af dynamiske rapporter og dashboards i Excel

Once the test is sent to a candidate, the candidate receives a link in email to take the test. For each candidate, you will receive a detailed report with skills breakdown and benchmarks to shortlist the top candidates from your pool.

What topics are covered in the Excel & datatolkningstest?

excel matematikformler
Denne færdighed fokuserer på at bruge brug Matematiske formler i Excel til udførelse af beregninger, såsom tilføjelse, subtraktion, multiplikation og opdeling. Det er vigtigt at måle denne færdighed, da den demonstrerer evnen til at udføre grundlæggende talfærdighedsoperationer inden for Excel, hvilket er vigtigt for at arbejde med numeriske data.
analyse af data i Excel ved hjælp af pivots og filtre </h4> <p > Med denne færdighed kan individer analysere og opsummere store datasæt ved hjælp af Excel's pivot -tabeller og filtre. Måling af denne færdighed giver rekrutterere mulighed for at vurdere en kandidats dygtighed i datamanipulation og deres evne til at udtrække meningsfuld indsigt fra komplekse datasæt. </p> <h4> visualisering af data i Excel
Denne færdighed involverer at præsentere data i et visuelt Format, såsom diagrammer eller grafer, for at lette bedre forståelse og analyse. Evaluering af denne færdighed hjælper rekrutterere med at måle en kandidats evne til effektivt at kommunikere datadrevet indsigt og gøre information mere tilgængelig.
Fortolkning af grafer
Denne færdighed fokuserer på at forstå og fortolke grafer og diagrammer oprettet ved hjælp af ved hjælp af Excel. Evaluering af denne færdighed giver rekrutterere indsigt i en kandidats evne til at udtrække indsigt fra visuelle repræsentationer af data og drage informerede konklusioner.
analyse af tabeller
Denne færdighed involverer at arbejde med tabulære data i Excel, inklusive sortering, filtrering og udførelse af beregninger. Måling af denne færdighed hjælper med at evaluere en kandidats evne til at analysere strukturerede data og spotmønstre eller tendenser inden for tabeller Om tilgængelig information i Excel. Evaluering af denne færdighed giver rekrutterere mulighed for at evaluere en kandidats evne til at fortolke data og træffe informerede beslutninger baseret på de analyserede fund.
analyse af diagrammer
Denne færdighed fokuserer på at undersøge og fortolke forskellige typer diagrammer Oprettet i Excel, såsom søjlediagrammer, linjediagrammer eller cirkeldiagrammer. Evaluering af denne færdighed giver indsigt i en kandidats evne til at analysere grafiske repræsentationer af data og udtrække meningsfuld information.
datavisualisering
Denne færdighed involverer at præsentere data i en visuelt tiltalende og let at- Forstå måde ved hjælp af diagrammer, grafer eller andre visuelle elementer. Måling af denne færdighed sikrer, at kandidater har evnen til effektivt at kommunikere dataindsigt og visuelt repræsentere information for bedre beslutningstagning.
Full list of covered topics
The actual topics of the questions in the final test will depend on your job description and requirements. However, here's a list of topics you can expect the questions for Excel & datatolkningstest to be based on.
Sumfunktion
Tælfunktion
Gennemsnitlig funktion
Hvis funktion
Vlookup -funktion
Pivottables
Filtrering af data
Betinget formatering
Diagrammer
Sparklines
Data validering
Datasortering
Datafiltrering
Dataformatering
Dataanalyse
Datavisualisering
Cellehenvisninger
Dato fungerer
Logiske funktioner
Tekstfunktioner
Statistiske funktioner
Opslagsfunktioner
Korttyper
Kortformatering
Graffortolkning
Tabelanalyse
Tabelformatering
Tabelfunktioner
Tegning af konklusioner
Datatendenser
Datamønstre
Datakorrelation
Datasammenligning
Datapræsentation
Datatolkning
Datamanipulation
Dataudforskning
Dataekstraktion
Datasammendrag
Datafiltrering
Datagruppering
Datakeregninger
Data rapportering
Datavisualiseringsværktøjer
Dataanalyseteknikker
Datavisualiseringsteknikker
Datatolkningsteknikker
Dataanalyse bedste praksis
Excel genveje og tip
Dataindgangsteknikker
Data Formula Revision
Håndtering af datafejl
Datakvalitetssikring
Verifikation af datanøjagtighed
Datasikkerhedsforanstaltninger

Preview this test

Se prøvescorekort

What roles can I use the Excel & datatolkningstest for?

Dataanalytiker
Finansiel analytiker
Business analytiker
Specialist i dataindtastning
Projektleder
Operations Manager
Revisor
Marketinganalytiker

How is the Excel & datatolkningstest customized for senior candidates?

For intermediate/ experienced candidates, we customize the assessment questions to include advanced topics and increase the difficulty level of the questions. This might include adding questions on topics like

Udnyttelse af betinget formatering og datavalidering i Excel
Udførelse af trendanalyse på Excel -data
Brug af Excel's opslag og referencefunktioner effektivt
Anvendelse af Excel's dataanalyseværktøjer til beslutningstagning
Anvendelse af datarensningsteknikker i Excel
Brug af Excel's Pivottable og PivotChart -funktioner
Analyse og fortolkning af Excel -data til prognoser
Anvendelse af regressionsanalyse til at udmærke data
Oprettelse af interaktive datavisualiseringer i Excel
Brug af Excel's Power -forespørgsel og Power Pivot -kapaciteter

Preview this test

Se prøvescorekort

Ansættelseslederne mente, at de gennem de tekniske spørgsmål, som de stillede under panelinterviewene, var i stand til at fortælle, hvilke kandidater der havde bedre score og differentieret med dem, der ikke scorede så godt. De er meget tilfreds med kvaliteten af de kandidater, der er nomineret med Adaface-screeningen.

85%

Reduktion i screeningstid

Se den fulde casestudie

Excel & datatolknings Online Test Ofte stillede spørgsmål

Kan jeg kombinere flere færdigheder i en brugerdefineret vurdering?

Ja absolut. Brugerdefinerede vurderinger er oprettet baseret på din jobbeskrivelse og vil omfatte spørgsmål om alle must-have-færdigheder, du angiver.

Har du nogen anti-cheating eller proctoring-funktioner på plads?

Vi har følgende anti-cheating-funktioner på plads:

Ikke-gåbare spørgsmål
IP Proctoring
Webproctoring
Webcam Proctoring
Detektion af plagiering
Sikker browser

Læs mere om Proctoring Features.

Hvordan fortolker jeg testresultater?

Den primære ting at huske på er, at en vurdering er et elimineringsværktøj, ikke et udvælgelsesværktøj. En færdighedsvurdering er optimeret for at hjælpe dig med at eliminere kandidater, der ikke er teknisk kvalificerede til rollen, den er ikke optimeret til at hjælpe dig med at finde den bedste kandidat til rollen. Så den ideelle måde at bruge en vurdering på er at beslutte en tærskelværdi (typisk 55%, vi hjælper dig med benchmark) og inviterer alle kandidater, der scorer over tærsklen for de næste interviewrunder.

Hvilken oplevelsesniveau kan jeg bruge denne test til?

Hver Adaface -vurdering tilpasses til din jobbeskrivelse/ ideel kandidatperson (vores emneeksperter vælger de rigtige spørgsmål til din vurdering fra vores bibliotek på 10000+ spørgsmål). Denne vurdering kan tilpasses til ethvert erfaringsniveau.

Får hver kandidat de samme spørgsmål?

Ja, det gør det meget lettere for dig at sammenligne kandidater. Valgmuligheder for MCQ -spørgsmål og rækkefølgen af spørgsmål randomiseres. Vi har anti-cheating/proctoring funktioner på plads. I vores virksomhedsplan har vi også muligheden for at oprette flere versioner af den samme vurdering med spørgsmål om lignende vanskelighedsniveauer.