PART 01.
Follow the spreadsheet test pattern
SECTION 01 [Basic Operation] Advanced Filter
SECTION 02 [Basic Operations] Conditional Formatting
SECTION 03 [Basic Tasks] Page Layout
SECTION 04 [Calculation Work] Calculation Work
SECTION 05 [Analysis Task] Pivot Table
SECTION 06 [Analysis Task] Custom Filter
SECTION 07 [Analysis Task] Splitting Text
SECTION 08 [Analysis Task] Removing Duplicate Items
SECTION 09 [Analysis Task] Data Sorting
SECTION 10 [Analysis Task] Partial Sum
SECTION 11 [Analysis Task] Finding the Target Value
SECTION 12 [Analysis Task] Data Table
SECTION 13 [Analysis Work] Scenario
SECTION 14 [Analysis Task] Data Integration
SECTION 15 [Analysis Work] Validation
SECTION 16 [Other Work] Chart
SECTION 17 [Other Tasks] Macros
SECTION 18 [Other Tasks] Procedure

PART 02.
Follow the spreadsheet questions
Follow the pattern of previous questions

PART 03.
Spreadsheet exam questions
Previous Type Problem 01
Previous Type Questions 02
Previous exam type questions 03
Previous exam type questions 04
Previous exam type questions 05

PART 04.
Follow the database exam pattern
SECTION 01 DB Construction
SECTION 02 Implementing input and edit functions
SECTION 03 Implementing query and output functions
SECTION 04 Implementing Processing Functions

PART 05.
Follow the database question types
Follow the pattern of previous questions

PART 06.
Database exam questions
Previous exam type question 01
Previous exam type questions 02
Previous exam type questions 03
Previous exam type questions 04
Previous exam type questions 05

[Appendix 1] Another Miraculous Passing Materials Collection
- Preview of the actual test, sketch of the test site
- A study planner that will help you pass the exam in one go
- A book in one page, a glimpse of the miracle tips
- Complete analysis of first-class functions, function strategy book
- From Start to Practice, a Checklist of Successful Habits
- Quick work, quick pass, spreadsheet and database shortcuts
[Appendix 2] Free YouTube video lectures directly from the author

Experience the miracle of passing the exam with this one book.
Igijeok is rooting for your success and employment!

- Basic skills to quickly grasp only the key points
We have selected only the core types with a high proportion of questions and organized them in a 'follow-along' format.
Rather than explaining complex theories at length, we have concisely summarized only the essential concepts.
Focusing on frequently appearing questions on actual exams, we've enhanced learning efficiency with a variety of study tips. Watch the author's lectures directly via QR code, and gain hands-on experience by seeing and learning with your own eyes.

- Following the pattern of previous exam questions + 6 sets of previous exam questions provided for each subject
Learn the core types of questions that frequently appear in each subject by 'following' them, and thoroughly master them with 5 sets of questions of the same type.
If you can quickly read the exam trends and become familiar with the problem-solving flow, you won't be shaken during the exam.
Each session is linked with detailed explanations and live lectures, allowing for three stages of learning: self-study, books, and videos.
Analyze past exam questions, solve them yourself, and practice repeatedly to achieve a short-term pass.

- Automatic scoring service provided
We provide an automatic grading program that allows you to check your results immediately after learning.
You can quickly identify your weaknesses by pinpointing the points of deduction, and you can immediately print the grading results for review.
The teacher version allows you to grade and print the same type of questions at once, making it efficient for class or study management.

- This concept passed the test like a miracle
The selfish study materials collection is available as a PDF file and is provided exclusively by selfish study cafe as a purchase verification material.
The concepts you see again right before the test, on the go, or during breaks will miraculously appear on the test.
※ How to participate: Search for 'Selfish Study Cafe' → Access the Selfish Study Cafe (cafe.naver.com/yjbooks) → 'Purchase Verification PDF Giveaway' bulletin board → Purchase Verification → Receive materials by email

- Optimal study guide for beginners and self-students
The more difficult the exam is, the lower the passing rate, and the more important it is to choose the lectures and study materials.
To help you pass the exam, YouTube's 'Comijoaga Hyunsam' and Leegijeok Youngjin.com have come together.
Anyone can pass the exam with the free lectures of ‘Comijoaga Hyunsam’.
Study quickly and comfortably with more friendly and easier theory lectures.

- Selfish reader support service unique to Leegijeok
If you don't understand something or have any questions while studying on your own, feel free to ask.
I will personally and honestly answer all your questions.
We're here to serve as a study zone for self-studying! Ask questions at the YJ Books Study Cafe (https://cafe.naver.com/yjbooks) and get your questions answered.