TEXT, VALUE, EXACT, CHAR and CODE Excel Practice Questions with Solutions
Introduction Excel often needs to convert numbers into formatted text, text into numbers, compare text values, and work with character
Excel Practice Questions
CONCAT, CONCATENATE and TEXTJOIN Practice Questions with Solutions
Introduction Excel often stores related information in separate cells, such as first name and last name, city and state, product
FIND SEARCH SUBSTITUTE and REPLACE Practice Questions with Solutions
Introduction Excel text functions are very useful when you need to find, replace, or modify specific parts of text. FIND
TRIM, CLEAN, UPPER and PROPER Practice Questions with Solutions
Introduction Text data copied from websites, emails, PDFs, and other systems often contains extra spaces, unwanted characters, or inconsistent capitalization.
LEFT, RIGHT, MID and LEN Practice Questions with Solutions
Introduction Excel text functions are useful when you need to extract specific parts of text from a cell. LEFT extracts
Advanced Logical Functions Practice Questions with Solutions
Introduction Advanced logical formulas help Excel handle more complex decisions and business rules. In this chapter, you will practice IFS,
Excel-IFERROR IFNA and SWITCH Practice Questions with Solutions
Introduction Excel formulas sometimes return errors when data is missing, incorrect, or does not match the expected condition. IFERROR, IFNA,
Excel-AND, OR and NOT with IF Practice Questions with Solutions
Introduction The AND, OR, and NOT functions become especially useful when an Excel formula needs to check more than one
Excel-IF Nested IF and IFS Practice Questions with Solutions
Introduction The IF function is one of the most useful Excel functions for making decisions based on conditions. It can