Nested and Combined Excel Functions Practice Questions with Solutions
Introduction Excel becomes much more powerful when two or more functions are combined in a single formula. A nested formula
Excel Practice Questions
Lookup with IFERROR Excel Practice Question with Solutions
Introduction Excel lookups become more useful when your data is incomplete, contains partial text, or requires approximate matching. In this
Two-Way and Multiple-Criteria Lookup Practice Questions with Solutions
Introduction Two-way and multiple-criteria lookups are useful when one lookup condition is not enough. For example, you may need to
INDEX, MATCH Excel Practice Questions with Solutions
Introduction INDEX and MATCH are powerful Excel functions for finding and returning data from tables. They are especially useful when
VLOOKUP, HLOOKUP and XLOOKUP Practice Questions With Solutions
Introduction Lookup functions help you find information from a table using a matching value. VLOOKUP, HLOOKUP, and XLOOKUP are commonly
Age, Experience, Tenure and Date Difference in excel Practice Questions with Solutions
Introduction Date calculations are common in employee records, student databases, customer information, subscriptions, and business reports. In this chapter, you
WORKDAY NETWORKDAYS and Working Days Practice Questions with Solutions
Introduction Working-day calculations are useful when weekends should not be counted in a project, delivery, employee, or business schedule. Excel
Week-Based Calculations Excel Practice Questions with Solutions
Introduction Week-based calculations are useful when working with attendance, sales, employee schedules, appointments, project timelines, and weekly reports. Excel provides
DATEDIF, DAYS, EDATE and EOMONTH Excel Practice Questions with Solutions
Introduction Excel date calculations become much more useful when you need to find the difference between dates, calculate future or