74,799 views
Download data Naver Cafe: https://cafe.naver.com/gipoongssam/297 Naver Blog: https://blog.naver.com/won2520179/223... 00:00 2023 Permanent Restoration Past Questions Solution 2 02:46 Basic Operation 2 (Cell Format) 07:05 Basic Operation 3 (Text Division) 10:07 Calculation Operation (Function 1) Using DAVERAGE, ROUND Functions 17:07 Calculation Operation (Function 2) Using UPPER, LEFT, RIGHT Functions and & Operator 23:04 Calculation Operation (Function 3) Using AVERAGEIF, MEDIAN Functions and & Operator 26:09 Calculation Operation (Function 4) Using DATE, LEFT, MID Functions 30:20 Calculation Operation (Function 5) Using DMAX, DMIN Functions 33:27 Analysis Operation (Data Table) 35:30 Analysis Operation (Find target value) 37:10 Other tasks (macro) 42:22 Other tasks (chart) 💖💖💖Computer proficiency level 2 practical 2023 regular restoration past questions 💖💖💖 ✔ 01st: • 01 Computer proficiency level 2 practical (2023 regular past questions 1st) Subscriber questions... ✔ 02nd: https://youtube.com/live/QgNaccp5Jz0 ✔ 03rd: • 03 Computer proficiency level 2 practical (2023 regular past questions 3rd) Subscriber questions... 🔴🔴🔴Computer proficiency level 2 function summary download: https://blog.naver.com/won2520179/222... ▶▶▶▶ Finishing series ◀◀◀◀ 01 Computer proficiency level 2 practical finishing functions in one day 5 solutions: • Computer proficiency level 2 practical (computer utilization ability level 2 practical) past questions calculation problem function 5th_Computer... 02 Completing the function in one day for the 2nd level computer skills 5th part solution: • Computing skill level 2 practical (computer utilization ability level 2 practical) past questions, calculation problem function 5th_Computer... 03 Completing the function in one day for the 2nd level computer skills 5th part solution: • Computing skill level 2 practical (computer utilization ability level 2 practical) past questions, calculation problem function 5th part computer... 04 Completing the analysis work in 2 hours: • Computing skill level 2 practical (computer utilization ability level 2 practical) Completing the analysis work in 2 hours 05 Completing the advanced filter in 30 minutes: • Computing skill level 2 practical (computer utilization ability level 2 practical) Completing the advanced filter in 15 minutes 06 Completing the conditional format in 30 minutes: • Computing skill level 2 practical (computer utilization ability level 2 practical) Conditional format in 30 minutes 07 Chart in 1 hour Finish (Excel 2016 version): • Finish computer proficiency level 2 chart work in 1 hour [Excel 2016 version] 08 Basic work (split text, connect and paste) Finish in 20 minutes: • Computer proficiency level 2 practical (computer utilization ability level 2 practical) Basic work etc. Finish in 10 minutes 09 Macro Finish in 30 minutes: • Computer proficiency level 2 practical macro Finish in 30 minutes ▶▶▶▶ Always restored past exam questions ◀◀◀◀ 10 2018 4th Always restored past exam questions solution: • Computer utilization ability level 2 practical (computer utilization ability level 2 practical) 4th in 2018 (always 1) 11 2019 1st Always restored past exam questions solution: • Computer utilization ability level 2 practical (computer utilization ability level 2 practical) 1st in 2019 (always) 12 2019 2nd regular restoration past exam questions and solutions: • Computer Proficiency Level 2 Practical (Computer Proficiency Level 2 Practical) 2019 2nd (Regular 2) 13 2019 3rd regular restoration past exam questions and solutions: • Computer Proficiency Level 2 Practical (Computer Proficiency Level 2 Practical) 2019 3rd (Regular 3) August 2019 14 2019 4th regular restoration past exam questions and solutions: • Computer Proficiency Level 2 PracticalComputer Proficiency Level 2 Practical 2019 4th (Regular 4) 2019 1... 15 2019 5th calculation restoration past exam questions and solutions: • Computer Proficiency Level 2 Practical_2019 Regular 5th_Calculation Problems (Only 6 Functions) 16 2020 1st regular restoration past exam questions and solutions: • Computer Proficiency Level 2 Practical Test (Computer Proficiency Level 2 Practical Test) 1st time in 2020 (regular) 17 2020 2nd time Regularly restored past exam questions and answers: • Computer Proficiency Level 2 Practical Test (Computer Proficiency Level 2 Practical Test) 20 ... 2021 Provided by the Korea Chamber of Commerce and Industry Sample problem solving (Type A): • 01 Computer Skills Level 2 Practical (2021 Korea Chamber of Commerce and Industry provided sample problem solving Type A) 22 2021 Korea Chamber of Commerce and Industry provided sample problem solving (Type B): • 02 Computer Skills Level 2 Practical (2021 Korea Chamber of Commerce and Industry provided sample problem solving Type B) 23 2021 Regular 1 time Regularly restored past exam question solving: • 03 Computer Skills Level 2 Practical (2021 Regularly restored past exam question 1 time) Subscriber's question... 24 2021 Regularly restored past exam question solving: • 04 Computer Skills Level 2 Practical (2021 Regularly restored past exam question 2 times) Subscriber's question... 25 2021 Regularly restored past exam question solving: • 05 Computer Skills Level 2 Practical (2021 Regularly restored past exam question 3 times) Subscriber's question... 26 2021 Regular Exam Function Problems Solved Part 1 (9 Problems) : • 2021 Regular Exam Function Problems Solved Part 1 (1 to 9) : • 27 2021 Regular 4th Regular Restoration Past Questions Problem Solving : • 06 Computer Proficiency Level 2 Practical (2021 Regular Past Questions 4th) Subscriber Questions ... 28 2022 Regular 1st Regular Restoration Past Questions Problem Solving : • 01 Computer Proficiency Level 2 Practical (2022 Regular Past Questions 1st) Subscriber Questions ... 29 2022 Regular 2nd Regular Restoration Past Questions Problem Solving : • 02 Computer Proficiency Level 2 Practical (2022 Regular Past Questions 2nd) Subscriber Questions ... 30 2022 Regular 3rd Regular Restoration Past Questions Problem Solving : • 03 Computer Proficiency Level 2 Practical Test Past Questions Solution 3 times 31 2022 4th regular exam questions and solutions: • 04 Computer Proficiency Level 2 Practical Exam Questions and Solutions 4th Solution Calculation Operation Function 1... 32 2022 5th regular exam questions and solutions: • 05 Computer Proficiency Level 2 Practical Exam (2022 regular exam questions and solutions 5 times) Subscriber's Questions... 33 2023 1st regular exam questions and solutions: • 01 Computer Proficiency Level 2 Practical Exam (2023 regular exam questions and solutions 1 time) Subscriber's Questions... 34 2023 2nd regular exam questions and solutions: https://youtube.com/live/QgNaccp5Jz0