MS Excel — Set 8
Computers · MS Excel · Questions 71–80 of 80
Which of the following is a correct cell address in Excel?
Correct Answer: B. A1
A cell address must always start with the column letter followed by the row number. For example, A1 refers to the very first cell in the top-left corner. This unique coordinate system is used in all formulas.
What is the shortcut to 'Copy' a selected cell?
Correct Answer: B. Ctrl + C
Ctrl + C copies the data and its formatting to the system clipboard. To 'Paste' that information elsewhere, Ctrl + V is used. 'Ctrl + X' is used to cut or move data.
Which function is used to find the lowest number in a range of cells?
Correct Answer: C. MIN
The MIN function scans a selection and returns the smallest numeric value. It is the mathematical opposite of the MAX function. Blank cells and text are excluded from the calculation.
What is the keyboard shortcut for 'Redo' in Excel?
Correct Answer: B. Ctrl + Y
Ctrl + Y reverses an 'Undo' action, allowing you to re-apply a change. This is helpful if you accidentally undid too many steps. It can also be used to repeat the last formatting action on a new cell.
Which function is used to determine the number of characters in a cell?
Correct Answer: B. LEN
LEN stands for 'length' and counts letters, numbers, and even spaces in a text string. For example, =LEN("Excel") would return 5. It is a text-based function often used for data cleaning.
Which tab contains the 'Spell Check' tool in Excel?
Correct Answer: C. Review
The Review tab houses tools for proofing, adding comments, and protecting sheets. The shortcut F7 also triggers the spelling check feature. This ensures that text labels in reports are professionally polished.
What happens if you double-click the boundary between two column headers?
Correct Answer: C. AutoFits the column width
This action automatically adjusts the column width to fit the longest entry present in that column. This is a quick way to ensure all data is visible without manually dragging the mouse. It is a common productivity tip for beginners.
Which shortcut key is used to open a new blank workbook?
Correct Answer: B. Ctrl + N
Ctrl + N immediately creates a fresh Excel file for a new project. To open an existing file, the shortcut is Ctrl + O. This allows for starting new tasks without navigating the file menu.
Which of the following functions removes extra spaces from a text string?
Correct Answer: C. TRIM
The TRIM function removes leading and trailing spaces, as well as multiple spaces between words. This is extremely helpful when handling data exported from other databases. It ensures that 'VLOOKUP' functions work correctly by matching clean text.
What is the shortcut key to 'Print' a worksheet?
Correct Answer: A. Ctrl + P
Ctrl + P opens the print settings and preview window. From here, users can choose specific sheets or pages to print. It is the standard shortcut across all Microsoft Office programs.