Explanation

• In MS Excel, most data tools are found in the Data tab.
• What-If Analysis, Data Validation, and Text to Columns are all part of Data tools.
• PivotTable is located in the Insert tab, not Data tab.
• It is used for summarizing and analyzing large datasets.

Last verified on 29-05-2026

Explanation

• Cloud storage is an internet-based service for storing data remotely.
• Users can save files on online servers instead of local devices.
• It allows access to data from anywhere with internet connection.
• It is widely used for backup and file sharing.

Last verified on 29-05-2026

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