MS Excel — Set 4

Correct Answer: D. 13

Excel follows the order of operations (BODMAS), where multiplication is performed before addition. Thus, 2 multiplied by 5 equals 10, plus 3 equals 13. To perform addition first, parentheses must be used as =(3+2)*5.

Correct Answer: D. 500%

The zoom range in Excel is limited from a minimum of 10% to a maximum of 400%. This allows users to view large worksheets or focus on specific small details. A value of 500% is beyond the software's capability.

Correct Answer: A. Ctrl + Shift + :

The shortcut Ctrl+Shift+:(colon) inserts the current system time as a static value. This value will not change unless manually edited. This is useful for logging specific timestamps in data entry.

Correct Answer: A. Name Box

The Name Box displays the coordinate of the selected cell, such as B12. It can also be used to quickly navigate to a cell by typing its address. Additionally, it shows the names assigned to specific cell ranges.

Correct Answer: C. NOW()

The NOW function provides both the current date and time and updates whenever the sheet is recalculated. The TODAY function provides only the current date. These are useful for dynamic reports and aging calculations.

Correct Answer: C. Clear All

The 'Clear All' command, found under the Clear menu in the Home tab, removes content, formats, and comments. Pressing the 'Delete' key on the keyboard only removes the cell's content, leaving the formatting intact. This is important for preparing a clean workspace.

Correct Answer: C. : (Colon)

The colon is the range operator used in functions like =SUM(A1:A10). It signifies that all cells between the two endpoints are included. A comma is used as a union operator to include non-adjacent cells.

Correct Answer: D. Ctrl + Z

Ctrl + Z reverses the last action performed in the workbook. This is a standard shortcut across almost all Windows applications. To 'Redo' or reverse an undo, the shortcut Ctrl + Y is used.

Correct Answer: C. ROUND

The ROUND function takes a number and a digit count as arguments to adjust the value's precision. It follows standard rounding rules (0.5 and above goes up). Functions like ROUNDUP and ROUNDDOWN offer more specific control.

Correct Answer: A. Format as Table

Format as Table converts a range of cells into a structured data object with headers and sorting capability. It automatically applies alternating row colors and filter buttons. This helps in managing related data more effectively than plain ranges.