The most 10 commonly used Microsoft Excel FORMULAS!

 

1.    SUM: Calculates the sum of a range of cells. For example, =SUM(A1:A10) will add up the values in cells A1 through A10.

2.       AVERAGE: Calculates the average of a range of cells. For example, =AVERAGE(A1:A10) will calculate the average of the values in cells A1 through A10.

 

3.       MAX: Returns the largest value in a range of cells. For example, =MAX(A1:A10) will return the largest value in cells A1 through A10.

 

4.       MIN: Returns the smallest value in a range of cells. For example, =MIN(A1:A10) will return the smallest value in cells A1 through A10.

 

5.       COUNT: Counts the number of cells in a range that contain numeric values. For example, =COUNT(A1:A10) will count the number of cells in cells A1 through A10 that contain numeric values.

 

6.       COUNTIF: Counts the number of cells in a range that meet a certain condition. For example, =COUNTIF(A1:A10, ">5") will count the number of cells in cells A1 through A10 that are greater than 5.

 

7.       IF: Returns one value if a condition is true and another value if it is false. For example, =IF(A1>5, "Yes", "No") will return "Yes" if the value in cell A1 is greater than 5, and "No" if it is not.

 

8.       CONCATENATE: Joins two or more strings of text together. For example, =CONCATENATE(A1, " ", B1) will join the text in cell A1 and B1 with a space in between.

 

9.       VLOOKUP: Searches for a value in the first column of a table and returns a corresponding value in the same row from a specified column. For example, =VLOOKUP(A1, Table1, 2, FALSE) will search for the value in cell A1 in the first column of Table1 and return the corresponding value from the second column.

 

10.   INDEX/MATCH: A combination of two formulas that searches for a value in a column and returns a corresponding value in the same row from a different column. For example, =INDEX(Table1[Column2],MATCH(A1,Table1[Column1],0)) will search for the value in cell A1 in the column named Column1 of Table1 and return the corresponding value from the column named Column2.

10 Facts about Donald Trump!

 

1. President Donald John Trump presided over the country as the 45th president from January 20, 2017, to January 20, 2021.  

2. On June 14, 1946, in Queens, New York City, Trump was born. 

3. He is a politician, businessman, and TV personality.  

4. He earned a Bachelor of Science in economics from the University of Pennsylvania's Wharton School in 1968. 

5. Trump founded The Trump Organization, a global real estate development and management organization with a wide range of assets and enterprises. 

6. From 2004 to 2015, he served as the host of the reality TV program "The Apprentice." 

7. On June 16, 2015, Trump declared his intention to run for president. In July 2016, he received the Republican nomination. 

8. During his administration, the House of Representatives impeached him twice; the first time was in December 2019 and the second time was in January 2021; both times, the Senate found him not guilty. 

9. During the Capitol riot in January 2021, Trump was blocked from a number of social media sites, including Twitter, Facebook, and Instagram. 

10. Trump is the only president in American history to be impeached twice, lose the popular vote in both the 2016 and 2020 elections, but win the electoral college in one (2016).

The most venomous snake in the world!!

The inland taipan (Oxyuranus microlepidotus), often known as the "fierce snake," is thought to be the most venomous snake in the world. This exceedingly dangerous snake, which can be found in Australia, is thought to have venom that is up to 50 times more toxic than that of a normal rattlesnake and up to 10 times more toxic than that of an Indian cobra.

15 amazing and top searched trivia questions and their answers!

1.  Which planet is known as the "Red Planet"?
Answer: Mars

2. Who painted the famous work "Starry Night"?
Answer: Vincent van Gogh

3. What is the smallest country in the world by land area?
Answer: Vatican City

4. In what year did the first moon landing occur?
Answer: 1969

5. Which bird is known for its distinctive laugh-like call?
Answer: Kookaburra

6. Who wrote the book "The Adventures of Tom Sawyer"?
Answer: Mark Twain

7. Which actor played the role of Harry Potter in the film series?
Answer: Daniel Radcliffe

8. Which city is known as the "City of Love"?
Answer: Paris

9. What is the largest mammal in the world?
Answer: Blue whale

10. Who invented the telephone?
Answer: Alexander Graham Bell

11. What is the name of the character played by Arnold Schwarzenegger in the "Terminator" movies?
Answer: The Terminator or T-800

12. Which planet has the most moons?
Answer: Jupiter

13. Which country gifted the Statue of Liberty to the United States?
Answer: France

14. What is the largest ocean in the world?
Answer: Pacific Ocean

15. What is the tallest mammal in the world?

Answer: Giraffe

How to Screenshot on Mac (IOS) computer?

 You can take a screenshot on a Mac using several keyboard shortcuts. Here are the different methods:

• Press the Command (⌘) + Shift + 3 keys simultaneously. The screenshot will be saved to your desktop.

• Press the Command (⌘) + Shift + 4 keys simultaneously.  It will change from a cursor to a crosshair. You can select the area you want to capture by clicking and dragging the crosshair. To take a screenshot, let go of the mouse button. Your desktop will store the screenshot.

•  Press the Command (⌘) + Shift + 4 + Spacebar keys simultaneously.  The camera icon will appear as your cursor. To take a screenshot, move the camera icon over the window you wish to record and then click. Your desktop will store the screenshot.

Please note:  You might also be able to take a screenshot with the Touch Bar on some recent Mac models. To access the various screenshot choices, simply touch the Screenshot button on the Touch Bar.

Why the sky is BLUE?

 

During the day, Rayleigh scattering, a phenomenon, gives the sky its blue appearance. Sunlight strikes air molecules like oxygen and nitrogen when it enters the atmosphere of the planet. Blue light, which has shorter wavelengths than other colors, is scattered more than other colors by these gas molecules in all directions.  This causes the blue light to be more widely dispersed and visible from all angles, giving the appearance that the sky is blue. As the sun is lower in the sky at sunrise and sunset, more of the Earth's atmosphere must be traversed by the light, which scatters even more of the shorter blue wavelengths and causes the sky to seem more red, orange, or yellow.

How many words are there in English?

Unfortunately, there's no exact count of the number of words in the English language because languages are flexible and expanding.