1. How do we insert a new worksheet in Excel 2016?
A. Right-click on a sheet tab and choose the” Insert” option.
B.Go to “Home” tab then click the” Insert sheet”
C. press the button “Ctrl+N”
D.Both A and B are correct.
2. What is the shortcut key for copying cells in Excel 2016?
A.CTRL+X
B.CTRL+C
C.CTRL+V
D.CTRL+Z
3. What is the meaning of the term “cell” in Excel?
A.A group of workbook
B.The intersection of Row and columns
C.A type of bar graph
D.A formatting option
4. Choose the correct answer which function we can use to calculate the sum of cell values of cells?
A.AVG()
B.MAX()
C.SUM()
D.TOTAL()
5. What is the extinction of the MS Excel file?
A.xls
B.ppt
C.accdb
D.xlsx
6. Which shortcut key saves an Excel file on your storage device?
A. Ctrl + S
B. Ctrl + C
C. Ctrl + V
D. Ctrl + P
7. In MSExcel 2016 Which symbol is used to start a formula?
A. =
B. +
C. –
D. @
8. How will you quickly adjust a column’s width to fit the content?
A. Double-click on the column header boundary
B. Right-click and select the option “Adjust Width”
C. Use the “Format” option
D. None of the above
9. Which of the following is not a valid function of Ms-Excel 2016?
A. =MAX()
B. =SUMIF()
C. =DIVIDE()
D. =LEFT()
10. Which of the following is the shortcut key to open a new file or workbook in Excel?
A. Ctrl + N
B. Ctrl + O
C. Ctrl + W
D. Ctrl + Shift + N
11. What is the shortcut key to delete/cut selected data in Excel 2016?
A. Ctrl + C
B. Ctrl + X
C. Ctrl + V
D. Ctrl + Z
12. What is the number of rows in Excel 2016?
A. 10,000
B. 1,048,576
C. 65,536
D. Unlimited
13. What is the number of columns in MS Excel 2016?
A)16385
B)16384
C)16584
D)16384
14. What is the shortcut of undo and redo in MS Excel?
A)CTRL+Z and CTRL+X
B)CTRL+Y and CTRL+Z
C)CTRL+X and CTRL+O
d)CTRL+Z and CTRL+Y
15. Which shortcut key is used to insert a new worksheet?
A. Ctrl + N
B. Shift + F11
C. Alt + Shift + N
D. Ctrl + Shift + F
16. Which of the following shortcut keys is used to select the entire sheet?
A. Ctrl + A
B. Shift + A
C. Alt + A
D. F2
17. Which is used for Autofill in Ms-Excel 2016?
A. Header Handle
B. Fill Handle
C. Selection Handle
D. Pointer Handle
18. Which symbol will appear when you use Fill Handle?
A. Plus (+)
B. Crosshair (+)
C. Arrow (→)
D. Hand pointer
19. Which of the following shortcut keys is used to move the active cell to the beginning of the row?
A. Ctrl + End
B. Ctrl + Home
C. Home
D. Shift + Home
20.What will be happened if we press Enter in the Active cell?
A. The cell contents are deleted
B. You move to the next cell below
C. The cell becomes inactive
D. A new worksheet is created
21. How can we edit the contents of the active cell without replacing them?
A. Press F2 key.
B. Double-click on the cell
C. Click on the Formula Bar
D. All of the above
22.What is the default position of the active cell when we open a new workbook ?
A. A1
B. B1
C. It depends on user settings
D.None of these
23.What is the default row Height in Excel ?
A. 12.75
B. 15.25
C. 20.36
D. 25.37
24.What is the default column width in Excel?
A. 8
B. 8.43
C. 10.25
D. 12
25.What is the maximum row height and column width allowed in Excel?
A. 255,255
B. 409,125
C. 1,000,525
D. Unlimited