Ms excel Questions by discover Talent presents

Which keyboard shortcut opens the Go To dialog box?

a. Ctrl + B

b. Ctrl + Shift + B

c. F2

d. F5






@@@@@@@@@@@@@@@@@@@

To keep specific rows and columns from scrolling off the screen you first must 

position the cell pointer


a. to the right of the column you want to remain on the screen

b. below the row you want to remain on the screen

c. on the row you want to remain on the screen

d. both below and right of the row and column you want to remain on the screen


@@@@@@@@@@@@@@@@@@@@@

When you create two or four separate windows containing part of the 

spreadsheet that can be viewed, you have created

a. sections

b. panes

c. views

d. subsheets


@@@@@@@@@@@@@@@@@@@@@

The accounting style shows negative numbers in


a. Bold

b. Brackets

c. Paranthesis

d. Quotes


@@@@@@@@@@@@@@@@@@11

Which of the following component displays the contents of active cell?

a. Name box

b. Formula bar

c. Menu bar

d. Status bar



@@@@@@@@@@@@@@@@@@@

How many sheets are there in Excel Workbook by default?


a. 2

b. 3

c. 4

d. 5


@@@@@@@@@@@@@@@@@1@@@

 Cell E23 has a date value and you wish to place that date on an invoice 

prefaced with the text located in B15. What is the command to do that?


a. =B15&E23

b. =proper(B15)&" "&text(E23,"mmmm dd, yyyy")

c. B15&" "&E23

d. =join(B15&E23)

@@@@@@@@@@@@@@@

To select multiple non-adjecent cells in a worksheet you will click them Holding.


a. CTRL key

b. ALT key

c. Shift Key

d. Ctrl+Shift key


@@@@@@@@@@@@@@@@@@@@

When integrating Word and Excel, Word is usually the ______________

a. Server

b. Client

c. Source

d. None of these


@@@@@@@@@@@@@@@@@@@@


The number of rows in a worksheet is

a. 36500

b. 65536

c. 256

d. 64536


@@@@@@@@@@@@@@@@@@@@@

When a formatted number does not fit within a cell, it displays


a. #####

b. #DIV/0

c. #DIV@

d. None of these


@@@@@@@@@@@@@@@@@@@@@


Which of the following is concantenating operator?

a. Apostrophe (')

b. Exclamation (!)

c. Ampersand (&)

d. Hash #


@@@@@@@@@@@@@@@@@@@@


Red triangle at the top right corner of a cell indicates


a. There is an error in the cell

b. There is a comment associated with the cell

c. The font color of the text in cell is red

d. The cell can't accept fformula