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!
FREE Typing - Keyboarding
A~Z of Tests and 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