Excel Templates | Excel Spreadsheets


Free Excel Templates

Roman Numerals Chart

Posted on July 13, 2009
Filed Under Education | 1 Comment

Share

A roman numeral is the name for a number when it is written in the way the Romans used to write numbers. Roman numerals are not used very often today in the west. They are used to write the names of kings and queens, or popes. They may be used to write the year a book or movie was made. Roman numerals consists of several basic symbol that can written in sequence. But, roman numerals only allow maximum three same symbols to be written together. Whenever the same symbol is written four times, it is replaced by subtracting it from the next higher number (for example 5,50,50,500). That way, IV is written instead of IIII (4), XL instead of XXXX (40), etc. And usually only one number is subtracted, not two. So 8 is always VIII and never IIX.

In excel, there is function to convert numbers into roman numerals. So, if you are confusing about converting numbers or you want to practice your roman numeral skills, you can use that excel function. The syntax is simple. Use roman(number,form) in the cell, where you can fill the “number” you want to convert or just direct to other cell. If you just want to convert into basic roman numerals, just fill the “form” with zero number. Excel provide 5 types of roman numeral conversion that you can use.

Roman Numerals Chart

And learning roman numeral will be a little confusing, so that is the reason I made a roman numeral charts to ease my son learning that kind of number. In the chart, as you can see in the picture, I put some color to help him differentiate number that is formed from basic symbols or formed from combination between symbols to follow addition or subtraction rules.

Read more

Tags: , , , , , ,

Square Root Table

Posted on July 13, 2009
Filed Under Education | 2 Comments

Share

There are several definition of square root found when you googling. Basically, all the definitions  have the same meaning, and I pick one that is easier to understand, “The square root of a number is a number which multiplied by itself, gives you the original number”. Finding the square of 9 or 16 is easy, because the number to be multiplied to give 9 and 16 is integer number. But, when the number is 10 or 17, you need a calculator to get the number fast… or a square root table. I made the dynamic square root table, so you can use it as a quick reference to find the square root without calculator.

Square Root Calculator

Read more

Tags: , , ,

Multiplication Table

Posted on July 12, 2009
Filed Under Education | 1 Comment

Share

Trying to help my son learning multiplication, I tried to find multiplication table in internet. I found some, but I think I need a flexible multiplication table where I can print according to my needs. So, it made me make my own multiplication table.

Multiplication Table

As you can see in the picture, I created two types of multiplication table, one with size of 10 x 10 cells and the other with size of 25 x 25 cells. I put a horizontal and vertical scroll bar in every table, so it will help me to dynamically adjust the range of number to be printed according to my need.

Read more

Tags: , , , , , , , , ,

Page 31 of 42« First...1020...2930313233...40...Last »