MS excel set 10 Detailed Explanation And More Example

Question : 1

What's a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

a) Select both cells, and then drag the fill handle over the range you- want, for instance 18 more rows

b) Select the range you want, include both cells, point to fill on the Edit menu, and then click down.

c) Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

d) All of above

e) None of these

Question : 2

In Excel the following is not an underline option in the format cells dialog box

a) Double

b) Single Engineering

c) Single Accounting

d) Double Accounting

Question : 3

In Excel intersection of a row and column is called :

a) Cata

b) A field.

c) A cell

d) An equation.

Question : 4

In Excel A data map is helpful

a) When you have too much data to chart

b) To show a geographic distribution of data

c) To compare data points

d) To show changes in data over time

Question : 5

Which area in an Excel window allows entering values and formulas

a) Title Bar

b) Menu Bar

c) Formula Bar

d) Standard Tool Bar

e) None of these