MS Excell MCQS

Trim is correct answer, it is used to remove all spaces from a text string except for single spaces between words.

The valid zoom range in Excel goes from a minimum of 10% to a maximum of 400%. This allows you to adjust the view of your spreadsheet to focus on specific details or see more of the overall data at once.

Here's a breakdown of the valid options:

A. 10: This allows you to see a very small portion of the spreadsheet with high magnification.

B. 100: This represents the default zoom level, showing the data at its actual size.

C. 300: This offers a zoomed-in view with three times the normal size, helpful for examining specific cells.

While there's no technical limitation preventing a zoom percentage beyond 400%, Excel doesn't offer options exceeding that level. It might become impractical to work with the spreadsheet at such high magnifications.

Here's why:

Excel 2011: This is a much older version, released in 2011 for Mac.

Excel 2017: This version was released in 2016 and is no longer the latest.

Excel 2021: This was a one-time release version and is not the most recent offering.

Office 365 (Correct): This is a subscription service that includes the latest version of Excel, along with other productivity applications like Word, PowerPoint, and more. Since Microsoft updates Office 365 regularly, it offers the most up-to-date features and functionality for Excel.

Additional points:

While you can purchase standalone versions of Excel (like Excel 2021), Office 365 provides the benefit of automatic updates, ensuring you have access to the latest features.

Office 365 also offers cloud storage and collaboration features not available in standalone versions.

Ctrl + ”: This keyboard shortcut is a quick way to copy the value from the cell directly above the active cell. The double quotation mark (") tells Excel to paste the value and not the formatting of the cell above.

Ctrl + E: This keyboard shortcut doesn't have a predefined function for copying in Excel.

Ctrl + C: This is the standard shortcut for copying any selection in Excel, but it wouldn't be specific to the cell above.

Ctrl + D: This shortcut is typically used to fill down the contents of the active cell to the cells below it in the same column.

Therefore, if you want to quickly copy the value from the cell above without its formatting, Ctrl + ” is the most efficient option in Excel.

When you click on a cell in your Excel spreadsheet and then press F2, you enter edit mode for that cell. This allows you to directly modify the contents of the cell, making corrections, updates, or adding information as needed.

Here's a breakdown of why the other options aren't used for editing data:

A. F1 Key: This key typically displays the Excel Help menu, which can be helpful for finding information about functions and features, but it's not used for direct data editing.

C. F3 Key: This key can have various functions depending on the context. In some cases, it might cycle through different cell references or paste a named range, but it's not the primary way to enter edit mode.

D. F4 Key: This key can be used to repeat the last action you performed, but it's not directly related to editing data.

So, remember F2 as your go-to key for quickly modifying data within your Excel cells.

Document 1: This is the default name for Word documents, not Excel spreadsheets.

Workbook 1: While technically accurate, "Workbook" isn't the standard default file extension used by Excel.

Worksheet: This refers to a single sheet within a workbook, not the entire workbook itself.

Modern versions of Excel typically use Book1.xlsx as the default filename. The ".xlsx" extension signifies the file format, which is the default for newer Excel files.

Alt+F1: This combination quickly creates a basic chart, typically a clustered column chart, based on the data you've currently selected. It's a convenient way to visualize your data without needing to navigate through menus.

While the other options have their uses in Excel, they aren't specifically designed for chart insertion:

B. F2: This key is used to edit the content of the active cell.

C. F3: This key can be used for various purposes depending on the context, such as pasting a named range or finding a specific cell reference.

D. F4: This key can be used to repeat the last action you performed, but it's not directly related to chart insertion.

So, if you want to quickly create a chart from your selected data in Excel, remember the handy shortcut Alt+F1!