Skip to content
GyaniX
Create account
← Assessment catalogue

Operations

Excel Data Analysis (Intermediate) Assessment

Learning and self-assessment — AI-reviewed

50 questions75 minutesProctoredLevel: Entry, Junior, Mid-levelEnglishSkill assessment

What this assesses

Excel Data Analysis (Intermediate): 50 questions across 10 topics, about 75 minutes. Questions were drafted with AI and each one checked in a separate evidence-based review (code run, answers recomputed, sources opened); they are not independently expert-validated.

AI-generated and AI-reviewed — not independently expert-validated. For learning and self-assessment only. Not a hiring, academic or professional qualification.

Data & analytics

  • Chart choice & reading5 q
  • Conditional formatting rules5 q
  • Data cleaning & preparation5 q
  • Date functions5 q
  • Dynamic arrays & errors5 q
  • Logical formulas5 q
  • Lookup logic5 q
  • Pivot table summaries5 q
  • SUMIFS, COUNTIFS & related5 q
  • Text functions5 q

Who it is for

  • • College students
  • • Freshers
  • • Working professionals
  • • Career changers
  • • Career re-entry
  • • Employees
  • • Organisation candidates

Levels: Entry, Junior, Mid-level

Structure

  • • 50 questions in 75 minutes, one attempt
  • • Questions drawn from a bank of AI-reviewed questions, each checked with evidence; your paper is fixed when you start
  • • Timer runs on our server; answers save automatically; you can resume after a disconnection
  • • AI tools and outside help are not allowed

Languages and content status

Available to take in: English. You choose the language before you start, and it stays the same for the whole attempt. If your language is not listed, the assessment is not offered in it yet; nothing is switched after you pay.

Questions were drafted with AI and checked one by one with evidence (code run, answers recomputed, sources opened). They have not been validated by an independent expert.

Sample questions

Practice examples of the question style. They are not part of the live assessment.

  1. 1. Sample: cells A1:A4 contain 10, 20, 30 and 40. What does =AVERAGE(A1:A4) return?

    • A. 20
    • B. 25
    • C. 30
    • D. 100

  2. 2. Sample: which function counts the cells in B2:B20 that contain the text North?

    • A. SUMIF
    • B. COUNTIF
    • C. VLOOKUP
    • D. AVERAGEIF

Proctoring requirements

  • ✓A laptop or desktop (not a phone)
  • ✓Camera and microphone, switched on throughout
  • ✓Full-screen browser; stay on the assessment tab
  • ✓A quiet room, alone
  • ✓Consent is asked before you start
  • ✓Warnings are shown to you; persistent breaches can end the attempt