- What is the shortcut key to insert new sheet in current workbook?
a. F11
b. Alt + F11
c. Ctrl + F11
d. Shift + F11 - Which one is the last column header in Excel 2007?
a. XFD
b. XFX
c. XFL
d. XFT - In maximum, how many sheets can be set as default while creating new workbook?
a. 254
b. 255
c. 256
d. No Limit - “New Comment” option can be found under _ tab
a. Insert
b. Data
c. Review
d. View - In Excel, by default Numeric Values appears in
a. Left aligned
b. Right aligned
c. Center aligned
d. Justify aligned - To show/hide the grid lines in Microsoft Excel 2007
a. Page Layout -> Grid lines -> View
b. Insert -> Grid lines -> View
c. View -> Grid lines -> View
d. Edit -> Grid lines -> View - What will be the result if you type =A1=B1 in cell C1?
a. Yes or No
b. True or False
c. Value of A1
d. Value of B1 - In Excel _ may not contain in Formula
a. Text Constant
b. Number Constant
c. Circular Reference
d. All of them
Leave a Reply