152,847 views
#Computer Skills Level 2 Practical #Computer Ability #Computer Skills Constant Restoration #Constant Restoration #Clear Gi-pung Teacher #Gi-pung Teacher Problems and Problem Sheet Download: https://blog.naver.com/won2520179/222... 00:00 2023 Constant Restoration Past Questions Solution 1 01:27 Basic Operation 2 (Cell Format) 08:18 Basic Operation 3 (Conditional Format) 12:33 Calculation Operation (Function 1) Finding the ratio with COUNTIF, COUNTA 15:54 Calculation Operation (Function 2) IF, SMALL, LARGE Top 2 ★, Bottom 2 ☆ 22:47 Calculation Operation (Function 3) IF, OR, RANK.EQ 'Pass' if within 3rd place 28:18 Calculation Operation (Function 4) IF, RIGHT 31:52 Calculation Operation (Function 5) IFERROR, HLOOKUP English: 36:59 Analysis work (integration) 39:00 Analysis work (pivot table) 46:36 Other work (macro) 51:03 Train work (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... 🌳🌳🌳 Ending series 🌳🌳🌳 01 02 2nd grade computer skills practice test, finishing functions in one day, 5 sets of solutions: • 2nd grade computer skills practice test (2nd grade computer skills practice test) past questions, calculation problems, functions, 5 sets_computer... 03 2nd grade computer skills practice test, finishing functions in one day, 5 sets of solutions: • 2nd grade computer skills practice test (2nd grade computer skills practice test) past questions, calculation problems, functions, 5 sets_computer... 04 Finish analysis work in 2 hours: • 2nd grade computer skills practice test (2nd grade computer skills practice test) finishing analysis work in 2 hours 05 Finish advanced filter in 30 minutes: • 2nd grade computer skills practice test (2nd grade computer skills practice test) finishing advanced filter in 15 minutes 06 Finish conditional formatting in 30 minutes: • Computer Skills Level 2 Practical (Computer Utilization Ability Level 2 Practical) Conditional Formatting Finish in 30 Minutes 07 Chart Finish in 1 Hour (Excel 2016 Version): • Computer Skills Level 2 Chart Work Finish in 1 Hour [Excel 2016 Version] 08 Basic Work (Text Split, Paste by Connection) Finish in 20 Minutes: • Computer Skills Level 2 Practical (Computer Utilization Ability Level 2 Practical) Basic Work Miscellaneous Finish in 10 Minutes 09 Macro Finish in 30 Minutes: • Computer Skills Level 2 Practical Macro Finish in 30 Minutes 🌷🌷🌷 Always Restoring Previous Exam Questions Solutions 🌷🌷🌷 10 2018 4th Always Restoring Previous Exam Questions Solutions: • Computer Skills Level 2 Practical (Computer Skills Level 2 Practical) 2018 4th (Always Restoring 1) 11 2019 1st regular restoration past exam questions and answers: • Computer Utilization Ability Level 2 Practical (Computer Utilization Level 2 Practical) 2019 1st (regular) 12 2019 2nd regular restoration past exam questions and answers: • Computer Utilization Ability Level 2 Practical (Computer Utilization Level 2 Practical) 2019 2nd (regular 2) 13 2019 3rd regular restoration past exam questions and answers: • Computer Utilization Ability Level 2 Practical (Computer Utilization Level 2 Practical) 2019 3rd (regular 3) August 14 2019 4th regular restoration past exam questions and answers: • Computer Utilization Ability Level 2 PracticalComputer Utilization Level 2 Practical 2019 4th (regular 4) 2019 1... 15 2019 5th calculation restoration past exam questions and answers: • Computer Proficiency Level 2 Practical_2019, 5th regular session_Calculation problems (only 6 functions) 16 2020, 1st regular restoration, past exam questions and solutions: • Computer Proficiency Level 2 Practical (Computer Proficiency Level 2 Practical) 2020, 1st (regular) 17 2020, 2nd regular restoration, past exam questions and solutions: • Computer Proficiency Level 2 Practical Computer Proficiency Level 2 Practical 2020, 2nd regular session (8 calculation tasks) 18 2020, 3rd regular restoration, past exam questions and solutions: • Computer Proficiency Level 2 Practical (Computer Proficiency Level 2 Practical) 2020, 3rd regular session 19 2020, 4th regular restoration, past exam questions and solutions: • Computer Proficiency Level 2 Practical (Computer Proficiency Level 2 Practical) 2020, 4th regular session 20 2020, 5th Continuous restoration of past exam questions and solutions: • Computer Proficiency Level 2 Practical Test (Computer Proficiency Level 2 Practical Test) 5 times in 2020 21 Sample problem solving (Type A) provided by the Korea Chamber of Commerce and Industry in 2021: • 01 Computer Proficiency Level 2 Practical Test (2021 Korea Chamber of Commerce and Industry Sample problem solving (Type B) provided by the Korea Chamber of Commerce and Industry in 2021: • 02 Computer Proficiency Level 2 Practical Test (2021 Korea Chamber of Commerce and Industry Sample problem solving Type B) 23 2021 1st regular restoration of past exam questions and solutions: • 03 Computer Proficiency Level 2 Practical Test (2021 regular past exam questions and solutions 1st time) Subscriber's questions... 24 2021 2nd regular restoration of past exam questions and solutions: • 04 Computer Proficiency Level 2 Practical Test (2021 regular past exam questions and solutions 2nd time) Subscriber's questions... 25 2021 Regular 3rd Regular Restoration Past Exam Problem Solving: • 05 Computer Skills Level 2 Practical (2021 Regular Past Exam Problem 3rd) Subscriber's Questions... 26 2021 Regular Exam Function Problem Solving Part 1 (9 Problems) : • 2021 Regular Exam Function Problem Solving Part 1 (1 to 9... 27 2021 Regular 4th Regular Restoration Past Exam Problem Solving: • 06 Computer Skills Level 2 Practical (2021 Regular Past Exam Problem 4th) Subscriber's Questions... 28 2022 Regular 1st Regular Restoration Past Exam Problem Solving: • 01 Computer Skills Level 2 Practical (2022 Regular Past Exam Problem 1st) Subscriber's Questions... 29 2022 Regular 2nd Regular Restoration Past Exam Problem Solving: • 02 Computer Skills Level 2 Practical (2022 Regular Past Exam Problem 2nd) Subscriber Questions... 30 2022 3rd regular regular restoration past exam questions and answers: • 03 Computer Proficiency Level 2 Practical Exam Questions and Answers 3 times 31 2022 4th regular regular restoration past exam questions and answers: • 04 Computer Proficiency Level 2 Practical Exam Questions and Answers 4 times Solution Calculation Operation Function 1... 32 2022 5th regular regular restoration past exam questions and answers: • 05 Computer Proficiency Level 2 Practical Exam (2022 5th regular regular exam questions) Subscriber Questions...