Part 1 Basics

Chapter 0.
Warm-up

Chapter 1.
Basic tasks
1.
Cell format
2.
Conditional formatting
3.
Advanced Filter/Auto Filter
4.
Split text

Chapter 2.
Calculation work
5.
Function 1: Statistical functions, text functions
6.
Function 2: Math/Trigonometric functions, lookup/reference functions
7.
Function 3: Database functions, date/time functions
8.
Function 4: Logical Functions

Chapter 3 Analysis Work
9.
array
10.
partial sum
11.
Pivot Table
12.
data table
13.
scenario
14.
Integration
15.
Finding the target value

Chapter 4.
Other work
16.
Macro
17.
chart

Chapter 5.
The actual testing site has been moved!
18.
The actual testing site has been moved!

Part 2: Practical

Chapter 1.
Basic mock exam
Basic Mock Exam 01
Basic Mock Exam 2
Basic Mock Exam 03
Basic Mock Exam 4
Basic Mock Exam 05
Basic Mock Exam 06
Basic Mock Exam 7
Basic Mock Exam 08
Basic Mock Exam 9
10 basic mock exams

Chapter 2.
Practice exam
Practice Test Type A
Practice Test Type B
Practice Test Type C
Practice Test Type D
Practice Test E
Practice Test F (PDF provided)
Practice Test Type G (PDF provided)
Practice Test H (PDF provided)
Practice Test Type I (PDF provided)
Practice Test J (PDF provided)

[Special Appendix] Part 3.
Latest past exam questions + computer function dictionary + calculation problems

Chapter 1.
Computer Function Dictionary
Chapter 2.
Collection of calculation problems
Chapter 3.
Latest past exam questions
2025 Permanent 01 2nd Grade
2025 Regular 02 Grade 2
2025 Regular 03 Grade 2
2025 Regular 04 Grade 2
2024 Regular 01 Grade 2
2024 Regular 02 Grade 2 (PDF provided)
2024 Regular 03 Level 2 (PDF provided)
2024 Regular 04 Level 2 (PDF provided)
2023 Regular 01 Level 2 (PDF provided)
2023 Regular 02 Level 2 (PDF provided)

■ The secret to passing the exam that can only be found in "Sinagong"

- 17 frequently tested features carefully selected: We have compressed only the 17 features that are sure to appear on the exam into a follow-along format.
- Essential problem structure: 20 mock exams and 10 recent exam questions will train you to solve any problem that may appear on the exam.
- Selective learning through section grades: By assigning grades of A, B, C, and D based on the frequency of appearance on the exam, you can prioritize and maximize learning efficiency according to your individual situation.
A book within a book! Includes 10 latest exam questions, a computer function dictionary, and 20 calculation problems.
- Free lecture support from the author: We provide free lectures by author on key topics on YouTube and our website.
- Continuously updated latest materials: You can check the materials needed for the exam, such as key summaries and the latest past exam questions, on the Sinagong website (sinagong.co.kr).
- Online Grading Service: Any number of times, anywhere! Check your skills before the test with our online grading service.


■ I tried not to feel frustrated while studying.

When learning a function you don't know, there is no solution if you get stuck in the middle of following the given function's explanation.
This book explains every step without leaving anything out so that anyone can follow along and see results.
In particular, you can follow along with confidence because several beginners followed along and revised it repeatedly before the book was published.

■ We have tried to provide a learning direction.

It is inefficient to just read the contents of the textbook without understanding the learning direction.
We provide additional, friendly explanations as if a teacher were right next to you, through corners such as ‘Expert Advice,’ ‘Sina Gong Q&A Best,’ and ‘Just a Moment.’

■ Video lectures are provided.

The Sina Gong Computer Utilization Proficiency Level 2 Practical Textbook is composed of detailed and easy-to-understand explanations so that even beginners in computer science can study with ease. However, depending on the test taker's situation, they may experience difficulties in learning.
For these people, we provide video lectures on the difficult parts of the textbook.
Scan the QR code in the text to access clear and refreshing video lectures directly from the author, allowing you to continue learning without any interruptions.


- Sina Gong FAQ -

Q.
What kind of information can I get from the Sina Gong website?
A.
In addition to the lectures provided for each certification, you can also receive various exam preparation materials on the Sina Gong website.
New past exam questions and mock exams are constantly updated, and practice files, key summaries, special lectures, and various other lectures are provided.
After selecting the certification subject, download and study the materials appropriate to the purchased book.

Q.
Why is the year added to the title of this book? How is it different from last year's edition?
A.
The reason the year is added before the exam is to indicate that it perfectly reflects the previous year's exam trends.
Sina Gong does not stand still, but moves forward every year in line with the changing test questions, types, and trends.


Q.
I heard that the version used by the test administration for the practical exam is MS Office LTSC 2021. What is the difference between this and the Office Professional version used at home?
A. MS Office LTSC is a corporate license and is difficult to use personally.
The Sina Gong book has been produced in the LTSC 2021 version to suit the testing environment.
Therefore, the screen you see with the Office Professional version used at home may differ from the notation in the book.
This section provides guidance on the differences through 'expert advice', so there is no problem in learning.