Explanation

• To show the gridlines, in Excel, PowerPoint, or Word, click the View tab, and then check the Gridlines box.
• To hide the gridlines, clear the Gridlines check box.
• The keyboard shortcut to remove the gridlines is to press Alt and enter W, V, G.

Last verified on 29-05-2026

Explanation

• In MS Excel, different workbook views are available to change how data is displayed.
• Page Break Preview is found in the View tab.
• It helps users see how pages will be printed.
• It is useful for adjusting print layout.

Last verified on 29-05-2026

Explanation

• In MS Excel, Paste Special is used to paste only specific parts like values, formulas, or formats.
• The correct shortcut in Ribbon-based Excel is Alt + H + V + S.
• It opens the Paste Special dialog box.
• From there, you can choose different paste options.

Last verified on 29-05-2026

Explanation

• A Pivot Table is a powerful Excel tool used for data analysis.
• It summarizes large datasets into meaningful reports.
• It helps in identifying trends, comparisons, and patterns easily.

Last verified on 29-05-2026

Explanation

• The VLOOKUP is used when data is listed in columns.
• This function searches for a value in the left-most column.
• You can use VLOOKUP to find data in a sorted or unsorted table.
• VLOOKUP stands for Vertical Lookup function.

Last verified on 29-05-2026

Explanation

Split data into multiple columns:

1. Select the "Sales Rep" column, and then select Home > Transform > Split Column.
2. Select Choose the By Delimiter.
3. Select the default Each occurrence of the delimiter option, and then select OK. ...
4. To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".

Last verified on 29-05-2026

Explanation

• "Link to home" is not a valid option to insert a hyperlink in Excel.

Additional information:

To insert a hyperlink in Excel, you can follow these steps:

1. Select the cell or text where you want to insert the hyperlink.
2. Right-click on the selected cell or text and choose "Hyperlink" from the context menu.
3. In the "Insert Hyperlink" dialog box, you will see different options to choose from. "Existing File or Web Page"

Last verified on 29-05-2026

Explanation

Freeze Panes in Excel is used to keep rows or columns visible while scrolling.

Go to View tab

• Freeze Top Row
• Freeze First Column
• Freeze Panes (custom)

Last verified on 29-05-2026

Explanation

• South Korean currency is the South Korean Won
• The won is technically equal to 100 jeon
• Symbol:₩
• Date of introduction 1949 (first introduced)
• 1962 (current version after re-introduction)

Additional information

• The capital is Seoul.
• The official language is Korean.
• Located is in the Continent of Asia.
• Primary Religion is atheism (but some follow Buddhist & Christian).
• South Korea Parliament is called  the National Assembly

Tricks for Remember

WON

Mind Trick: Korea’s Won in the Battle

1) South Korea

2) North Korea

Last updated question by NA on 12-JUNE-2026

Explanation

• The Three Sisters are volcanic peaks in the U.S. State of Oregon.
• They are at the boundary of Lane and Deschutes counties.
• The three peaks are the third-, fourth-, and fifth-highest in Oregon.

The Sisters are now known as:

1. South Sister: 10,363 ft (3,158.5 m)
2. Middle Sister: 10,052 ft (3,063.7 m)
3. North Sister: 10,090 ft (3,075.3 m)

Last verified on 29-05-2026