MS excel set 2 Detailed Explanation And More Example

Question : 1

In Excel circular reference is

a) Geometric modeling tool

b) A cell that points to a drawing object

c) A formula that either directly or indirectly depends on itself

d) Always erroneous

Question : 2

The short cut key Ctrl +R is used in Excel to

a) Right align the content of cell

b) Remove the cell contents of selected cells

c) Fill the selection with active t cells to the right

d) All of above

e) None of these

Question : 3

The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row lOis......

a) DB1-G10

b) B1.G10

c) B1;G10

d) B1:G10

e) None of these

Question : 4

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed

a) Format Report

b) Pivot Table

c) Refresh Data

d) Show Detail

e) None of these

Question : 5

In Excel Hyperlinks can be

a) Text

b) Drawing objects

c) Pictures

d) All of above

Question : 6

The Cancel and Enter buttons appear In the:

a) Title bar

b) Formula bar

c) Menu bar

d) Sheet tabs

e) None of these