Hvorfor skal du bruge denne Excel Online -test

Microsoft Excel online vurderingstest er designet og valideret af brancheksperter til at hjælpe rekrutterere og ansætte ledere til at vurdere kandidatens Excel -færdigheder. Excel -testskærmene kandidater til følgende færdigheder, som ansættelse af ledere ser efter i kandidater: Brug til formler som sum, indeks, iferror vs hvis + iserror, indirekte og offset Brug af opslagsformler som Vlookup med kamp Avanceret brug af cellerne og rækkeviddeobjekter Udnyttelse af data med drejeborde og drejekort Tilføjelse af filtre til at rapportere menuer for at indsnævre posterne Oprettelse af kraftfulde beregninger med Excel -funktioner Brug af relative, absolutte og blandede referencer Brug af dataværktøjer som sortering, subtotaling og filtrering Brug af diagrammer og grafer til at repræsentere tabulære data Dataoprydning og transformationer (fjernelse af duplikater, transponering, frysning) automatisering med makroer Håndtering af fejl 3-data konsolidering Komboseknikker til rengøring af data

Excel -test

About the test:

The Excel test uses scenario-based MCQ questions to evaluate a candidate's ability to work with large datasets in Excel, navigate multiple spreadsheets, use advanced formulas and create reports. The test screens for the ability to sort/filter data, analyze data using PivotTables, create dashboards using charts, provide forms for user inputs, and record/ modify/ write macros.

Covered skills:

Basic formulas (MATCH; INDEX)
Advanced formulas (IF; VLOOKUP; HLOOKUP)
Analyzing data (Pivots; Filters;)
Working with dates and times
Error handling
Sparklines and data bars
3-Data Consolidation

Math formulas (SUM; MIN; AVG)
Data types
Visualizing data (Charts; graphs)
Data validation
Inserting and formatting tables
User form controls
Automation with macros

See all covered skills

Preview this test

Se prøvescorekort

9 reasons why

Adaface Excel -test is the most accurate way to shortlist Data Analysts

Reason #1

Tests for on-the-job skills

Microsoft Excel online vurderingstest er designet og valideret af brancheksperter til at hjælpe rekrutterere og ansætte ledere til at vurdere kandidatens Excel -færdigheder.

Excel -testskærmene kandidater til følgende færdigheder, som ansættelse af ledere ser efter i kandidater:

Brug til formler som sum, indeks, iferror vs hvis + iserror, indirekte og offset
Brug af opslagsformler som Vlookup med kamp
Avanceret brug af cellerne og rækkeviddeobjekter
Udnyttelse af data med drejeborde og drejekort
Tilføjelse af filtre til at rapportere menuer for at indsnævre posterne
Oprettelse af kraftfulde beregninger med Excel -funktioner
Brug af relative, absolutte og blandede referencer
Brug af dataværktøjer som sortering, subtotaling og filtrering
Brug af diagrammer og grafer til at repræsentere tabulære data
Dataoprydning og transformationer (fjernelse af duplikater, transponering, frysning)
automatisering med makroer
Håndtering af fejl
3-data konsolidering
Komboseknikker til rengøring af data

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.

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

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.

Dette er kun en lille prøve fra vores bibliotek med 10.000+ spørgsmål. De faktiske spørgsmål om dette Excel Test 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)

	🧐 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)

	🧐 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)

Reason #4

1200+ customers in 75 countries

Med Adaface var vi i stand til at optimere vores indledende screeningsproces med op til 75%, hvilket frigør dyrebar tid for både ansættelsesledere og vores talentindsamlingsteam!

Brandon Lee, Leder af mennesker, Love, Bonito

Reason #5

Designed for elimination, not selection

The most important thing while implementing the pre-employment Excel Test 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.

Reason #6

1 click candidate invites

Email invites: You can send candidates an email invite to the Excel Test 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 & comparative results

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

Preview this test

Se prøvescorekort

Hvordan man evaluerer avancerede excel -færdigheder

Spørgsmålene vil være baseret på avancerede Excel -emner:

Pivot -tabel tricks ved beregning af den automatiske sum, tælling, procentdel og generering af grupperede dataoverskrifter
Brug variable typer: Konstanter, statisk, modulniveau, offentlig, privat 'option privat modul' osv.
Søgning af celler og strenge med avanceret mønstermatchning og sammenligning, som operatør- og instruktionsfunktioner
Oprettelse af en forventet resultatopgørelse, balance og pengestrøm
Brug af dato og tidsmatematiske funktioner til beregning af varighed, længde og intervaller
Udløsende makroer ved hjælp af regneark og formkontroller (knapper, former, dropdowns, listboxes, klik handlinger)
Afsendelse af data fra en makro til en anden ved hjælp af ByRef- og ByVal -metoder
Statistiske funktioner til forudsigelse og interferens
Oprettelse af brugerdefinerede funktioner
Tilslutning til eksterne data
Oprettelse af økonomiske modeller
Programmatisk ændring af regneark
Tilfældige nummergeneratorer

What roles can I use the Excel Test for?

Data Analyst
Senior Data Analyst
Data Entry (Excel)
Business Analyst
Accountant
Financial Analyst
Senior Financial Analyst

What topics are covered in the Excel -test?

Datatyper

Grundlæggende formler (match; indeks)

Matematikformler (sum; min; Avg; Sumifs)

Avancerede formler (if; vlookup; hlookup)

Analyse af data (pivots; filtre;)

Visualisering af data (diagrammer; grafer)

Pivot -diagrammer og borde

Opslag og reference

Betinget formatering

Datasammendrag

Datamanipulation

Arbejder med datoer og tider

Fejlhåndtering

Indsættelse og formateringstabeller

Sparklines og datalarer

3-data konsolidering

Automation med makroer

3-data konsolidering

Formelbaseret betinget formatering

Formularer og handlinger

Preview this test

Se prøvescorekort

De ansættelsesledere mente, at de gennem de tekniske spørgsmål, som de stillede under panelinterviewene, kunne fortælle, hvilke kandidater der havde bedre scoringer, og differentierede med dem, der ikke scorede så godt. De er meget tilfreds med kvaliteten af kandidater, der er på listen med Adaface -screeningen.

85%

Reduktion i screeningstid

Se den fulde casestudie

Excel Test FAQs

Kan jeg evaluere Excel- og SQL -færdigheder i den samme test?

Ja. Vi understøtter evaluering af flere færdigheder i den samme test. Du kan gennemgå vores SQL-test for at få en fornemmelse af, hvilken slags spørgsmål der vil blive brugt til at evaluere SQL.

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.