Test&Track | 06 - Functions in Excel

Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.

2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists.

3. Student and Teacher User Guides | Schemes of Work | Real Teacher use Videos |

Join 36000+ teachers and students using TTIO.

Level

Beginner (KS3) or Primary

Topic

18 - Spreadsheets (Microsoft Excel)

Test

06 - Functions in Excel

Functions in Microsoft Excel

Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read this introduction to Formulas and Functions first.

Additional Functions

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

2 Logical: Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function.

3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

4 Date & Time: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

5 Text: Excel has many functions to offer when it comes to manipulating text strings.

6 Lookup & Reference: Learn all about Excel's lookup & reference functions such as the VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE function.

7 Financial: This chapter illustrates Excel's most popular financial functions.

8 Statistical: An overview of some very useful statistical functions in Excel.

-->