www.TestsTestsTests.com

www.TestsTestsTests.com

What can I do at Tests Tests Tests.com?

Scroll down and find out...

Let us EDUTAIN YOU!!! Our mission is to make education entertaining, fun and free. We appreciate feedback!




What's New?

typing quizzes
    21st April 2016
    Working with Images & Graphical Elements Excel Tutorial
    Working with Images & Graphical Elements Excel Test
    * How to Insert an Image
    * How to Insert Shapes
    * Working with SmartArt
    * Changing the Background Color

    Just because a worksheet contains a lot of numbers or data does not mean it cannot look good. You can insert images and shapes, background colors and use SmartArt to make a worksheet in Excel visually more appealing.

    1st April 2016
    Using Financial Functions Excel Tutorial
    Using Financial Functions Excel Test
    * Overview of the PMT Function
    * Calculate Monthly Payments (PMT)
    * Calculate Interest Rate (Rate)
    * Calculate Number of Payments (NPER)
    * Calculate Amount You Can Afford to Loan (PV)

    Do you know how to use the most popular Financial Functions? PMT (payment for a loan), PV (present value of a loan), RATE (interest rate of a loan) and NPER (number of payments that have to be made to repay a loan).

    14th March 2016
    Customizing the Quick Access Toolbar Excel Tutorial
    Customizing the Quick Access Toolbar Excel Test
    * What is the Quick Access Toolbar?
    * Move the Quick Access Toolbar
    * Customize the Quick Access Toolbar
    * Organize buttons on the Quick Access Toolbar

    The Quick Access Toolbar can be customized with your most frequently used buttons. Learn how to add, delete and change the position of the buttons you use the most.

    9th March 2016
    Using Nested IFs, SUMIFs & COUNTIFs in Functions (Advanced) Excel Tutorial
    Using Nested IFs, SUMIFs & COUNTIFs in Functions (Advanced) Excel Test
    * How to Use Nested IF statements
    * How to Use SUMIFs in a Function
    * How to Use COUNTIFs in a Function

    IF functions such as IF, COUNTIF and SUMIF in Excel allow you to create formulas based on evaluating an argument as either true or false, but what happens if you need to evaluate multiple arguments in a single function? This is where nested IF statements, COUNTIFs and SUMIFs come in.

    1st March 2016
    Using Nested Functions Tutorial
    Using Nested Functions Test
    * Using a Nested IF function
    * Using the OR function
    * Using the AND function
    * Using the NOT function

    Nested functions add super powers to your normal formulas and functions and allow you to perform more complex calculations. Nested functions can contain OR, AND, NOT and multiple IF arguments.

    26th February 2016
    Using the Ribbon Excel Excel Tutorial
    Using the Ribbon Excel Test
    * How is the Ribbon organized?
    * How are Tabs organized?
    * What are Contextual Tabs?
    * Identifying Groups on the Ribbon
    * Show/ Hide the Ribbon

    The Ribbon replaces the old Menu system. Learn how the tabs are organized into groups, how to open the group dialog box and how to hide the ribbon.

    16th February 2016
    Using Macros Excel Tutorial
    Using Macros Excel Test
    * Running a Macro
    * Recording a Macro
    * Assign a Macro to a Button
    * Save a Macro-Enabled Workbook
    * Delete a Macro

    Macros let you perform the same steps over and over again with the click of a button. How to create and edit macros is easy and makes you an Excel pro. 
     

          For a full list of what's new on www.TestsTestsTests.com
          in the last 60 days see our New Content page