MS excel set 10 Detailed Explanation And More Example

Question : 1

In Excel Tab scrolling buttons

a) Allow you to view a different worksheet

b) Allow you to view additional worksheet row down

c) Allow you to view additional worksheet columns to the right

d) Allow you to view additional sheet tabs

Question : 2

Which function will you use to enter current time In a worksheet cell?

a) =today( )

b) -now ( )

c) -time ( )

d) =CurrentTime ( )

e) None of these

Question : 3

In Excel you can select a single range of cells by

a) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

b) Pressing the Ctrl key while dragging over the desired cells

c) Pressing the Shift key and an arrow key

d) Dragging over the desired cells .

Question : 4

You can open the consolidate dialog box by choosing' Consolidate from the...... menu.

a) Insert

b) Format

c) Tools

d) Data

e) None of these

Question : 5

Two common wildcard characters that Excel recognizes are

a) * and?

b) < and >

c) * and /

d) + and –

e) None of these

Question : 6

Which types of charts can excel produce?

a) Line graphs and pie charts only

b) Only line graphs

c) Bar charts, line graphs and pie charts

d) Bar charts and line graphs only

e) None of these