BG-8

Q1. What is the shortcut to copy any value?

A. Ctrl + V

B. Ctrl + Z

C. Ctrl + C

D. Ctrl + X

Q2. What is the shortcut to add Filter to the worksheet?

A. Ctrl + V

B. Ctrl + Shift + L

C. Ctrl + Shift + A

D. Ctrl + X

Q3. What is the shortcut to Paste copied values?

A. Ctrl + V

B. Ctrl + Z

C. Ctrl + C

D. Ctrl + X

Q4. The extension of database file in excel is

A. .doc

B. .xls

C. bmp

D. .dbf

Q5. # VALUE! Refers to ___

A. Font value

B. Error in value

C. Subscript of the number value

D. Addition of value

Q6. While selecting multiple data in Excel, the following key must be used when clicking each row/column

A. Alt

B. Ctrl

C. Shift

D. Insert

Q7. Press ____ to close the window of MS Excel.

A. Esc

B. Ctrl + Alt + C

C. Alt + F4

D. Ctrl + W

Q8. What is the keyboard shortcut to undo the most recent action?

A. F1

B. Ctrl+U

C. Ctrl+Z

D. Alt+X

Q9. You can align cell contents:

A. Horizontally but not vertically.

B. Vertically but not horizontally.

C. Both vertically and horizontally

Q10. When you hide a row or column, its data is removed from the workbook. True or false?

A. True

B. False