All Free Computer Science and IT MCQs with Answers

971. In Excel which key is used for format number in time format?

• A. Ctrl+Shift+6
• B. Ctrl+Shift+3
• C. Ctrl+Shift+5
• D. Ctrl+Shift+2

Explanation: In Excel, Ctrl+Shift+2 applies the time format, typically displaying hours and minutes with an AM or PM indicator. This corresponds to option d.

972. In Excel which key is used for format number in scientific format?

• A. Ctrl+Shift+6
• B. Ctrl+Shift+3
• C. Ctrl+Shift+5
• D. Ctrl+Shift+4

Explanation: Ctrl+Shift+6 applies Scientific number formatting in Excel, displaying values using a coefficient and an exponent. Therefore the shortcut is option a.

973. In Excel which key is used for format number in percentage format?

• A. Ctrl+Shift+6
• B. Ctrl+Shift+3
• C. Ctrl+Shift+5
• D. Ctrl+1

Explanation: Ctrl+Shift+5 applies Percentage formatting in Excel, multiplying the displayed value by 100 and adding a percent sign. Ctrl+1 opens the Format Cells dialog instead.

974. In Excel which key is used for format number in date format?

• A. Ctrl+Shift+6
• B. Ctrl+Shift+4
• C. Ctrl+Shift+3
• D. Shift+1

Explanation: Ctrl+Shift+3 applies the Date format in Excel. Ctrl+Shift+4 is used for currency formatting, so it is not the correct shortcut here.

975. In Excel which key is used for format number in currency format?

• A. Ctrl+Shift+1
• B. Ctrl+Shift+4
• C. Ctrl+1
• D. Shift+1

Explanation: Ctrl+Shift+4 applies Currency formatting in Excel, usually displaying a currency symbol and two decimal places. Ctrl+1 opens formatting options rather than directly applying this format.

976. In Excel which key is used for format number in comma format?

• A. Ctrl+Shift+1
• B. Ctrl+Shift+4
• C. Ctrl+1
• D. Shift+1

Explanation: Ctrl+Shift+1 applies Excel's comma-style number format with two decimal places. Ctrl+Shift+4 applies currency formatting, while Ctrl+1 opens the Format Cells dialog.

977. In Excel which key is used for create a formula to sum all of the above cells?

• A. Ctrl+=
• B. Alt+-
• C. Alt+=
• D. Ctrl+-

Explanation: Alt+= inserts Excel's AutoSum formula, normally adding the contiguous numeric cells above the active cell. The Ctrl+= combination is not the standard AutoSum shortcut.

978. In Excel which key is used to open the excel formula window?

• A. Shift+F6
• B. Shift+F3
• C. Alt+Shift+F3
• D. Alt+Shift+F6

Explanation: Shift+F3 opens Excel's Insert Function dialog, which helps users search for and build formulas. It is therefore the closest match to opening the formula window among these choices.

979. Which shortcut key is used to Fill Down?

• A. CTRL+D
• B. CTRL+T
• C. ALT+D
• D. ALT+D

Explanation: Ctrl+D uses Excel's Fill Down command to copy the contents or formula from the top cell of a selected range into the cells below. Ctrl+T creates a table instead.

980. Which key is used to insert new worksheet in excel?

• A. Alt+F2
• B. Alt+F1
• C. Alt+Shift+F1
• D. Alt+Shift+F2

Explanation: Alt+Shift+F1 inserts a new worksheet in Excel, equivalent to the commonly used Shift+F11 shortcut. Alt+F1 creates an embedded chart rather than a worksheet.