Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Profil sexy_andrea2006
 | Femeie
22 ani
Sibiu
cauta Barbat
22 - 48 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2241
|
|
2025 is a mathematical year
1. 2025 - it is a perfect square number:
45² = 2025
2. It is a product of two square numbers:
9² × 5² = 2025
3. It is a sum of three square numbers:
40² + 20² + 5² = 2025
4. 2025 it is the next perfect square after year 1936:
44² = year 1936
45² = year 2025
5. It is the sum of cubes of numbers from 1 to 9:
1³ + 2³ + 3³ + 4³ + 5³ + 6³ + 7³ + 8³ + 9³ = 2025
I want to verify all these formulas in Excel.
In column A I will write the number from above corresponding to each exercise. I will leave a space between exercises to make them visible. I will leave the space in Excel as well.
In column B I will write the numbers and in column C their powers.
Column D will be used for calculating single results between B and C. But below I will write the formula instead, that should be typed in D1, D3, D4, D6 etc. (the missing cells are for the rows left between exercises).
Column E will be used for calculating final results (eg. 9² × 5² etc.). But below I will write the formula instead, that should be typed in E1, E3, E6, E10 and E13.
Code:
A B C D E
1 45 2 =A1^B1 =D1
2 9 2 =A3^B3 =PRODUCT(D3:D4)
5 2 =A4^B4
3 40 2 =A6^B6 =SUM(D6:D8)
20 2 =A7^B7
5 2 =A8^B8
4 44 2 =A10^B10 nothing to be calculated
45 2 =A11^B11
5 1 3 =A13^B13 =SUM(D13:D21)
2 3 =A14^B14
3 3 =A15^B15
4 3 =A16^B16
5 3 =A17^B17
6 3 =A18^B18
7 3 =A19^B19
8 3 =A20^B20
9 3 =A21^B21 |
Note 1: Spacing in the above CODE tag is done with a combination of Alt+09 and Alt+32 characters. (i.e., hold Alt key, then press 0 0 9 on the Numeric Pad on the keyboard, then release Alt key)
Note 2: If you don't have a Numeric Pad, well, copy the characters from below by double clicking in the top left corner inside the QUOTE tags below (you should see some space selected, then press CTRL+C to copy)
Tab character (on NumPad it is Alt+09)
Space character (on NumPad it is Alt+32)
_______________________________________
|
|
| pus acum 3 saptamani |
|