Explore topic-wise MCQs in MS Excel.

When creating a vertical page break

Got functions? No? You need the insert function dialog box. How do you get it?

Which of the following describes how to select all the cells in a single column?

Which of the following methods cannot be used to edit the content of cell?

What term refers to a specific set of values saved with the workbook?

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

You can edit existing Excel data by pressing the

Qtr 1, Qtr 2, Qtr 3 is an example of a

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

you can use the formula palette to

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

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

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

To copy cell contents using drag and drop, press the

Macros are run or executed from the .. menu.

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

Except for the function, a formula with a logical function shows the word TRUE or FALSE as a result

Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros?

How should you print a selected area of a worksheet, if you ll want to print a different area next time?

A function inside another function is called a .. function.

What does the VLOOKUP function do?

Which of the following is a correct order of precedence in a formula calculation?

Gridlines

You can print only an embedded chart by

Each excel file is called a workbook because

How are data organized in a spreadsheet?

Which types of charts can excel produce?

When you insert an Excel file into a Word document, the data are

What function displays row data in a column or column data in a row?

what term describes a background that appears as a grainy, non smooth surface

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

Excel is a

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Which of the following methods can not be used to enter data in a cell?

Which of the following will not set text in selected cells to italics?

If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

Which function calculates your monthly mortage payment?

How do you change column width to fit the contents?

Charts tips can

The Name box

To center worksheet titles across a range of cell, you must

When integrating Ms-Word and Excel, Word is usually the

To insert three columns between columns D and E you would

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

Which of the following is not a basic step in creating a worksheet?

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

when you use the fill effects in the format data series dialog box, you can not

Which of the following setup options can not be set in the page setup dialog box?

You can activate a cell by