PracticeVideosBlogFlashcardsEspañol
All Practice Exams

Free Practice Questions for Computer Specialist in Spreadsheet Level 2

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More South Korea Computer Specialist in Spreadsheet & Database Examinations (컴퓨터활용능력 1급·2급 — KCCI)

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Computer Specialist in Spreadsheet & Database Level 1 (컴퓨터활용능력 1급, South Korea)

Practice Questions
Exam Review

Key Facts: Computer Specialist in Spreadsheet Level 2 Exam

40 items

Official written paper length (2 subjects × 20)

KCCI License qualification test guidelines

40 minutes

Written exam time limit (1 minute per question)

KCCI License qualification test guidelines

40 / 60

Written per-subject floor (과락) and overall passing average

KCCI qualification grading rules

70 / 100

Practical spreadsheet exam passing score (40 minutes)

KCCI qualification grading rules

KRW 20,500

Written examination fee

KCCI license.korcham.net, checked 2026

KRW 25,000

Practical examination fee

KCCI license.korcham.net, checked 2026

2 years

Written pass exemption period for practical exam

National Technical Qualifications Act Enforcement Decree Article 21

컴퓨터활용능력 2급 is KCCI's national qualification evaluating computer literacy and spreadsheet proficiency. The written exam consists of 40 questions across Computer General (20) and Spreadsheet General (20) in 40 minutes, graded with a 40-point subject floor and 60 overall average. The practical exam is a 40-minute hands-on Excel session requiring 70/100. Official KCCI fees are KRW 20,500 written and KRW 25,000 practical. OpenExamPrep offers independent English MCQ study for the written topics, not an official translation or practical simulation.

Sample Computer Specialist in Spreadsheet Level 2 Practice Questions

Try these sample questions to review concepts for the Computer Specialist in Spreadsheet Level 2 exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which CPU register stores the memory address of the next instruction scheduled to be fetched and executed?
A.Program Counter (프로그램 카운터, PC)
B.Instruction Register (명령 레지스터, IR)
C.Memory Buffer Register (기억 버퍼 레지스터, MBR)
D.Accumulator (누산기, AC)
Explanation: The Program Counter (프로그램 카운터, PC) holds the memory address of the next instruction to be fetched from main memory. As each instruction is fetched into the processor, the PC is automatically incremented to point to the subsequent sequential instruction.
2What is the primary function of cache memory (캐시 메모리) in modern computer architecture?
A.To compensate for the speed disparity between the high-speed CPU and slower main memory
B.To permanently store operating system startup routines and power-on self-test programs
C.To expand the logical address space beyond physical RAM limits using secondary storage
D.To perform high-speed floating-point mathematical computations directly on operands
Explanation: Cache memory (캐시 메모리) is a small, ultra-fast memory composed of Static RAM (SRAM) located between the CPU and dynamic main memory (DRAM). Its primary purpose is to store frequently referenced instructions and data to bridge the operational speed gap between the fast processor and slower main memory.
3Which type of read-only memory (ROM) allows stored data to be erased and reprogrammed electrically at the block level without removal from the circuit board?
A.Mask ROM (마스크 롬)
B.PROM (프로그래머블 롬)
C.UV-EPROM (자외선 지우기 롬)
D.EEPROM / Flash Memory (플래시 메모리)
Explanation: EEPROM (Electrically Erasable Programmable ROM) and its derivative Flash Memory allow contents to be rewritten and erased electrically in-circuit without physical removal. This technology forms the foundation for modern motherboard BIOS/UEFI firmware updates and solid-state drives.
4Which statement correctly describes the operational principle of virtual memory (가상기억장치)?
A.It combines high-speed CPU registers to accelerate peripheral input/output operations
B.It uses part of secondary storage (hard drive or SSD) as if it were additional main memory
C.It mirrors physical RAM in non-volatile ROM chips to prevent volatile data loss during power failure
D.It allocates optical disc storage as an auxiliary cache for real-time video processing
Explanation: Virtual memory (가상기억장치) is a memory management technique in which the operating system uses a portion of secondary storage (such as a paging file or swap partition) as an extension of physical RAM. This enables programs requiring more memory than physically installed RAM to execute smoothly through paging or segmentation.
5In a computer system bus architecture, which bus carries memory cell identifiers and peripheral port designations unidirectionally from the CPU to system components?
A.Address Bus (주소 버스)
B.Data Bus (데이터 버스)
C.Control Bus (제어 버스)
D.Power Bus (전원 버스)
Explanation: The Address Bus (주소 버스) transmits memory addresses or I/O port addresses from the CPU to memory and peripheral interfaces. It is unidirectional because the CPU generates and broadcasts the target address to determine which storage location or device is accessed.
6What is the primary role of the Basic Input/Output System (BIOS / UEFI) during personal computer bootup?
A.Compiling high-level user application source code into native machine code
B.Executing power-on self-tests (POST) and initializing essential hardware before loading the OS
C.Managing spreadsheet calculations and formula dependencies in memory
D.Allocating dynamic IP addresses to networked client computers via DHCP
Explanation: The BIOS / UEFI firmware stored in non-volatile motherboard memory initializes hardware components, conducts the Power-On Self-Test (POST, 전원 켜짐 자체 검사), and locates the boot loader on the designated storage drive to hand control over to the operating system.
7Which interrupt (인터럽트) condition possesses the highest processing priority in computer systems?
A.Hardware power failure interrupt (정전 인터럽트)
B.Input/output device completion interrupt (입출력 완료 인터럽트)
C.Timer tick interrupt (타이머 인터럽트)
D.Supervisor Call software interrupt (SVC 인터럽트)
Explanation: Hardware power failure (정전) and machine check errors have the highest non-maskable interrupt (NMI) priority because immediate action must be taken to preserve volatile state and protect hardware components before complete electrical failure occurs.
8Which metric specifically measures a central processor's computational capacity in terms of executing millions of basic machine instructions per second?
A.MIPS (Million Instructions Per Second)
B.FLOPS (Floating-Point Operations Per Second)
C.BPS (Bits Per Second)
D.RPM (Revolutions Per Minute)
Explanation: MIPS (Million Instructions Per Second) is an established benchmark metric measuring how many millions of integer machine instructions a CPU can execute each second under typical operating conditions.
9Which interface standard features reversible connectors, supports hot-swapping (핫 스와핑), and can deliver high-speed data transmission along with up to 100W or 240W of power delivery (USB-PD)?
A.USB Type-C (USB-C)
B.PS/2 port
C.VGA (D-Sub) connector
D.Parallel (IEEE 1284) printer port
Explanation: USB Type-C is a 24-pin reversible connector standard supporting hot-swapping, high data bandwidth (USB 3.x, USB4, Thunderbolt), DisplayPort video output, and bi-directional Power Delivery (USB-PD) up to 100W or 240W.
10In solid-state drive (SSD) storage technology, what is the primary purpose of the TRIM command?
A.To inform the SSD controller which data blocks are no longer considered in use so they can be wiped internally in advance
B.To compress text files automatically into encrypted zip archives during system idle time
C.To physically spin down rotating platters to reduce acoustic noise and power consumption
D.To mechanically re-align drive heads with magnetic track boundaries across bad sectors
Explanation: The TRIM command allows an operating system to inform the SSD's flash controller that specific logical data blocks are invalid after file deletion. This enables the drive to execute background garbage collection and wear leveling efficiently, preventing write speed degradation over time.

About the Computer Specialist in Spreadsheet Level 2 Exam

Computer Specialist in Spreadsheet Level 2 (컴퓨터활용능력 2급) is a prestigious national technical qualification administered by the Korea Chamber of Commerce and Industry (KCCI / 대한상공회의소) under the Ministry of Employment and Labor. Widely recognized in South Korea by private corporations, public enterprises, and civil service examinations for hiring points and promotions, the credential validates competency in computer fundamentals, Windows operating systems, networking, and hands-on spreadsheet data processing and analysis. The written paper tests 40 four-choice questions across two subjects (Computer General and Spreadsheet General) within 40 minutes, requiring a minimum of 40 points in each subject and a 60-point average. The subsequent practical exam tests spreadsheet software operation under time pressure (40 minutes, 70/100 pass). The questions on this page are independent English-language MCQ study practice for those written topics; they are not an official translation, not a format simulation, and not a substitute for the practical stage.

Exam sponsor: Korea Chamber of Commerce and Industry (KCCI / 대한상공회의소). The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Assessment

Written exam consisting of 2 subjects: Computer General (20 items) and Spreadsheet General (20 items), totaling 40 items in 40 minutes. Followed by a 40-minute hands-on practical exam in spreadsheet software scoring at least 70/100 to achieve qualification. OpenExamPrep study weights match the two equal written subjects.

Time Limit

40 minutes written; 40 minutes practical

Passing Score

Written: 40+ per subject floor and 60 average; practical: 70/100

Exam / Certification Fees

KRW 20,500 written / KRW 25,000 practical (KCCI, 2026)

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Official sources

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

50%

Computer General (컴퓨터 일반)

Computer hardware architecture, CPU, memory hierarchy, Windows OS features, file management, data communication, internet protocols, multimedia, and information security.

50%

Spreadsheet General (스프레드시트 일반)

Worksheet editing, cell formatting, relative/absolute referencing, mathematical, text, lookup, and statistical formulas, sorting, autofilter, advanced filters, charting, and print setup.

Preparing for the Computer Specialist in Spreadsheet Level 2 Exam

What You Need to Know

  • Passing score: Written: 40+ per subject floor and 60 average; practical: 70/100
  • Assessment: Written exam consisting of 2 subjects: Computer General (20 items) and Spreadsheet General (20 items), totaling 40 items in 40 minutes. Followed by a 40-minute hands-on practical exam in spreadsheet software scoring at least 70/100 to achieve qualification. OpenExamPrep study weights match the two equal written subjects.
  • Time limit: 40 minutes written; 40 minutes practical
  • Exam / certification fees: KRW 20,500 written / KRW 25,000 practical (KCCI, 2026) Official sources

Using Our Practice Resources

  • Work through all 100 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

Computer Specialist in Spreadsheet Level 2: Suggested Study Strategy

1Ensure you balance study time across both subjects to prevent failing the 40-point per-subject cutoff (과락), especially in technical hardware/networking concepts.
2Thoroughly memorize Windows shortcut keys, Task Manager utilities, system configuration settings, and memory types in Computer General.
3Understand the exact syntax, arguments, and return values of essential spreadsheet functions including SUM, AVERAGE, IF, AND/OR, COUNTIF, RANK.EQ, VLOOKUP, HLOOKUP, and MID/LEFT/RIGHT.
4Master cell referencing rules (relative A1, absolute $A$1, mixed $A1 and A$1) and how formulas adjust when copied across rows or columns.
5Pay close attention to custom number formats (사용자 지정 서식) like #,##0, 0.00, @, and conditional formatting rules that frequently appear on the written CBT.

Frequently Asked Questions

What is Computer Specialist in Spreadsheet Level 2 (컴퓨터활용능력 2급)?

It is a National Technical Qualification administered by the Korea Chamber of Commerce and Industry (KCCI / 대한상공회의소) under the National Technical Qualifications Act. It certifies foundational practical competence in personal computer operating systems and spreadsheet software.

How is the official exam structured in 2026?

The written examination contains 40 four-option multiple-choice questions (20 items in Computer General and 20 items in Spreadsheet General) in 40 minutes. Candidates must score at least 40 points in each subject (과락 기준) and achieve an overall average of 60 points out of 100. Passing the written exam qualifies candidates to take the 40-minute computer practical examination in spreadsheet software, where 70 out of 100 points is required to pass.

What language is the official exam, and what is this study bank?

The official KCCI examinations are conducted in Korean. This bank is an independent English-language MCQ study adaptation created by OpenExamPrep to assist learners and international candidates in mastering the official curriculum topics. It includes key Korean terms in parentheses for bilingual reference and is not an official KCCI publication or practical software simulator.

What are the 2026 official fees and test schedules?

As listed on the KCCI License portal (license.korcham.net), registration fees are KRW 20,500 for the written exam and KRW 25,000 for the practical exam (checked 2026). Regular CBT sessions (상설시험) run frequently throughout the year at regional chamber test centers across South Korea.

How long is a written exam pass valid for taking the practical exam?

Under Article 21 of the Enforcement Decree of the National Technical Qualifications Act, a written exam pass remains valid for 2 years from the date of the written pass announcement. Candidates must pass the practical exam within this 2-year window to obtain the qualification certificate.