CHQ SOME BASIC MCQ OF EXCEL...

1.   All formula in Excel start with

a.   %

b.   +

c.   =

d.   -

Correct Answer: c

2.   You can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?

a.   & (ampersand)

b.   = (equal sign)

c.   (space)

d.   All of the above

Correct Answer: a

The divide symbol is

a.   /

b.   D

c.   \

d.   )

Correct Answer: a

The divide symbol is

a.   /

b.   D

c.   \

d.   )

Correct Answer: a

To add two cells (A1 and A2) together you use the following formula

a.   =A1 + A2

b.   =Add(A1+A2)

c.   =together(A1:A2)

d.   A1 plus A2

Correct Answer: a

 On an excel sheet the active cell in indicated by …

a.   A dark wide boarder

b.   A dotted border

c.   A blinking border

d.   None of above

Correct Answer: a

On an Excel sheet the active cell in indicated by

a.   A dark wide border

b.   A dotted border

c.   A blinking border

d.   None of above

Correct Answer: a

 Using the F11 shortcut key to create a chart on chart sheet creates

a.   A default chart

b.   A 2-dimensional column chart

c.   A 2-dimensional bar chart

d.   A 3-dimensional  line chart

Correct Answer: b

 You can print

a.   A range of cells by range name

b.   An entire worksheet

c.   A single worksheet

d.   All of the above

Correct Answer: d

You can create hyperlinks from the Excel workbook to

a.   A webpage on company internet

b.   A web page on the internet

c.   Other Office 97 application documents

d.   All

Correct Answer: d

The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is……

a.   B1-G10

b.   B1.G10

c.   B1;G10

d.   B1:G10

Correct Answer: d

 The advantage of using a spreadsheet is:

a.   calculations can be done automatically.

b.   changing data automatically updates calculations

c.   more flexibility

d.   all of the above

Correct Answer: d

The intersection of a row and column is called :

a.   data

b.   a field.

c.   a cell

d.   an equation.

Correct Answer: c

There are three types of data found in a spreadsheet.

a.   data, words, numbers

b.   equations, data, numbers

c.   words, numbers, labels

d.   numbers formulas, labels

Correct Answer: d

To select a column the easiest method is to……

a.   Double click any cell in the column

b.   Drag from the top cell in the column to the last cell in the column

c.   click the column heading

d.   click the column label

Correct Answer: c

If you press ……, the cell accepts your typing as its contents.

a.   Enter

b.   Ctrl+Enter

c.   Tab

d.   Insert

Correct Answer: a

 Late for your investors meeting? How can you quickly apply professional formatting to your sales forecast worksheet?

a.   Apply special attributes using Format Painter

b.   Apply an Auto Format Style

c.   Apply a selected background color

d.   All of above

Correct Answer: b