In MS Excel, a comment is inserted by using the ____ key. A. Shift + F2 B. Alt + F2 C. Ctrl + F2 D. CTRL + V Explanation: Shift + F2 inserts a comment.
In MS Excel, a comment is inserted by using the ____ keys. A. Shift + F2 B. Alt + F2 C. Ctrl + F2 D. CTRL + V Explanation: Shift + F2 inserts a comment in the selected cell.
Which shortcut in Excel is used to create a chart? A. F1 B. F5 C. F11 D. F12 Explanation: F11 instantly creates a chart from selected data.
Shift + F11 is used to add new ____ in excel. A. Cell B. Sheet C. Row D. Column Explanation: Shift+F11 inserts a new worksheet.
Which key is used to minimize an Excel Worksheet? A. Ctrl + F5 B. Ctrl + F7 C. Ctrl + F9 D. Ctrl + F11 Explanation: Ctrl+F9 minimizes the workbook window.
Which key is used for renaming? A. F1 B. F2 C. F7 D. F9 Explanation: F2 allows you to rename a cell, sheet, or file.
What is the Keyboard shortcut for creating a chart from the selected cell range? A. F2 B. F4 C. F8 D. F11 Explanation: F11 creates a chart from the selected data.
Which key is used to copy the formula from the above cell? A. Ctrl + ; B. Ctrl + ' C. Ctrl + D D. None Explanation: Ctrl + D copies the formula from the cell above.
Which is an example of a formula? A. = A1 + B1 B. add(A1:A2) C. A1+A2 D. SUM (A1:A2) Explanation: Excel formulas begin with = and use functions such as SUM.
____ adds new line in same cell shortcut key in Excel. A. Alt + Shift B. Ctrl + Enter C. Alt + Enter D. Shift + Enter Explanation: Alt+Enter inserts a new line in the same cell.