IF, IFS, LEFT, SMALL, Large function Computer Practice N6 excel November 2025 Question 8A answered

Computer Practice N6 November 2025 | Spreadsheet Tutorial Using IF, IFS, LEFT, SMALL and LARGE Functions In this video, we work through another important Computer Practice N6 November 2025 spreadsheet question step by step. This tutorial focuses on using the correct Excel functions to solve exam-style spreadsheet tasks accurately and confidently. In this lesson, you will learn how to: Use IF to determine CHEAP TRANSACTIONS Use IFS to calculate AFFORDABLE? Use LEFT to display only the first four letters of each transaction in the ABBREVIATION column Use SMALL to calculate the 3rd smallest traffic fine Use LARGE to calculate the 2nd largest traffic fine This video is ideal for students preparing for: Computer Practice N6 Spreadsheet practical exams TVET and college computer studies November 2025 exam revision If you are studying for your spreadsheet practical and want to understand how to apply logical functions, text functions, and ranking functions in Excel, this tutorial will help you revise with confidence. Watch until the end for clear explanations and exam tips that can help you improve your marks. 00:00 Intro 00:19 Use the IF Function to determine Cheap transactions if admin costs are lesser than R350 04:55 Use the IFS Function to calculate AFFORDABLE if the Traffic Fine (No Licence is Lesser than R250) 09:15 Use the LEFT Function to show only the first 4 letters of each transaction in the Abbreviation column 11:00 Use the SMALL and 2nd LARGE Functions to calculate the 3rd smallest and Largest Traffic Fines #ComputerPracticeN6 #N6November2025 #SpreadsheetTutorial #ExcelFunctions #IFFunction #IFSFunction #LEFTFunction #SMALLFunction #LARGEFunction #ExamRevision #TVET #PastExamPaper #ComputerPractice #exceltutorials