general knowledge Online Quiz - 2753

The ampersand (&) operator in Excel concatenates (joins) text strings from multiple cells. For example, =A1&B1 combines the text from both cells. The equal sign (=) starts formulas, and space is not a concatenation operator in Excel.

Excel uses * (asterisk) to represent any number of characters and ? (question mark) to represent exactly one character as wildcards. For example, 'Sm*' matches 'Smith', 'Small', etc. while 'Sm?th' matches 'Smith' but not 'Smyth'. Characters like <, >, ^, /, +, - are not Excel wildcards.

To make a number 10% smaller, multiply by 0.90 (which is 100% - 10%). This gives you 90% of the original value. Option A (=C3*1.10) would make it 10% larger, not smaller. Option C (=C3%10) is incorrect Excel syntax for percentage calculations.

In Excel, the active cell is indicated by a dark, wide border that makes it stand out from other cells. This border is solid and prominent, unlike the blinking cursor in text editing software.

When you press F11 on a selected data range in Excel, it creates a default chart on a new chart sheet, which is a 2-dimensional column chart. This is Excel's default chart type.

In Excel, horizontal page breaks are controlled by row selections. To create a horizontal page break, you select a row (any cell in row 1 works as reference point) OR select a cell in column A as the starting column. Option D combines both correct approaches.

Excel uses a colon (:) to specify ranges. The format is always top-left cell:bottom-right cell. For a range starting at B1 and extending to G10, the correct notation is B1:G10.

In spreadsheets, the three fundamental data types are numbers (numeric values), formulas (calculations that reference other cells), and labels (text entries for headers and descriptions). This classification helps distinguish between raw data, computed values, and descriptive elements.

Brendon McCullum holds the record for the fastest fifty in international cricket, achieving it in just 18 balls during a T20 International match against Australia in 2016. This remains the fastest half-century in professional cricket.

Bankim Chandra Chatterjee, the renowned Bengali novelist and composer of 'Vande Mataram', was born on June 27, 1838. He is a central figure in Bengali literature and the Indian independence movement through his writings.

Rabindranath Tagore, Asia's first Nobel laureate and composer of India's national anthem, was born on May 7, 1861, in Calcutta. His birthday is celebrated as Rabindra Jayanti across West Bengal and by Bengalis worldwide.

C.V. Raman, the Indian physicist who won the 1930 Nobel Prize in Physics for the Raman Effect, was born on November 7, 1888. His discovery revolutionized the understanding of light scattering and molecular structure.

JRD Tata, the pioneering Indian industrialist and founder of Tata Airlines (later Air India), was born on July 29, 1904. He was a key figure in India's industrial development and aviation history.

Dhirubhai Ambani, founder of Reliance Industries and one of India's most successful entrepreneurs, was born on December 28, 1932. He built Reliance from a small textile trader into a massive conglomerate.

Jamsetji Tata, founder of the Tata Group, was born on March 3, 1839. Option A matches this historical fact. Options B and C have incorrect dates, while D places his birth a decade too early.

Annie Besant, the British theosophist and women's rights activist who supported India's Home Rule movement, was born on October 1, 1847. Option A is accurate. Options B, C, and D confuse the specific date.

Bal Gangadhar Tilak, the nationalist leader who gave the slogan 'Swaraj is my birthright', was born on July 23, 1856. Option A is correct. Options B, C, and D vary either the date or year.

Bhagat Singh, the revolutionary freedom fighter, was born on September 27, 1907. Option A is correct. Option B places his birth a decade later, while C and D have incorrect dates.