Microsoft Excel MCQs

?

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






?

Which of the following will not cut information?






?

Which of the following is not a way to complete a cell entry?






?

You can activate a cell by






?

Text formulas:






?

How do you insert a row?






?

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






?

How do you select an entire column?






?

How can you print three copies of a workbook?






?

To create a formula, you first:






?

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






?

How do you delete a column?






?

How can you find specific information in a list?






?

When integrating word and excel, word is usually the






?

When a label is too long to fit within a worksheet cell, you typically must






?

The name box






?

Comments put in cells are called






?

Which is used to perform what if analysis?






?

You can use the horizontal and vertical scroll bars to






?

Multiple calculations can be made in a single formula using






?

Hyperlinks can be






?

To activate the previous cell in a pre-selected range, press






?

Which button do you click to add up a series of numbers?






?

When the formula bar is active, you can see






?

To copy formatting from one area in a worksheet and apply it to another area you would use:






?

In a worksheet you can select






?

When you link data maintained in an excel workbook to a word document






?

Which area in an excel window allows entering values and formulas






?

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the






?

To edit in an embedded excel worksheet object in a word document






?

To create a formula, you can use:






?

Status indicators are located on the






?

Which of the following is the oldest spreadsheet package?






?

Rounding errors can occur






?

You can copy data or formulas






?

You can not link excel worksheet data to a word document






?

Which of the following is a popular DOS based spreadsheet package?






?

An excel workbook is a collection of






?

Excel files have a default extension of






?

You can use the format painter multiple times before you turn it off by






?

You can use the formula palette to






?

You can convert existing excel worksheet data an charts to an HTML document by using






?

A circular reference is






?

Which of following is Not one of Excel’s what-if function?






?

When you insert an excel file into a word document. The data are






?

Which of the following is not information you can specify using the solver?






?

Each excel file is called a workbook because






?

Excel probably considers the cell entry January 1, 2000 to be a






?

You can enter which types of data into worksheet cells?






?

All worksheet formula






?

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






?

The Paste Special command lets you copy and paste:






?

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?






?

Which of the following is not a valid data type in excel






?

Excel worksheet cells work very similarly to what common element of the windows graphical user interface






?

Which of the following options is not located in the Page Setup dialog box?






?

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?






?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?






?

Which of the following methods can not be used to edit the contents of a cell?






?

If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:






?

to view a cell comment






?

When you want to insert a blank imbedded excel object in a word document you can






?

To save a workbook, you:






?

You can edit a cell by






?

You can select a single range of cells by






?

Which elements of the worksheet can be protected from accidental modification






?

You can use the drag and drop method to






?

It is acceptable ot let long text flow into adjacent cells on a worksheet when






?

How can you delete a record?






?

Right clicking something in Excel:






?

Documentation should include






?

Files created with Lotus 1-2-3 have an extension






?

To delete embedded objects, first






?

Comments can be added to cells using






?

Which of the following is not a worksheet design criterion?






?

To copy cell contents using drag and drop press the






?

Which of the following is the latest version of Excel






?

When you copy a formula






?

The autofill feature






?

Which menu option can be sued to split windows into two






?

Which of the following is an absolute cell reference?






?

What symbol is used before a number to make it a label?






?

Which symbol must all formula begin with?






?

Which of the following formulas is not entered correctly?






?

Which of the following formulas will Excel Not be able to calculate?






?

A typical worksheet has …. Number of columns






?

How many characters can be typed in a single cell in Excel?






?

A worksheet can have a maximum of …. Number of rows






?

Which of the following is not an example of a value?






?

The chart wizard term data series refers to






?

The Chart wizard term data categories refers to;






?

A worksheet range is a






?

Getting data from a cell located in a different sheet is called






?

Tab scrolling button






?

A numeric value can be treated as a label value if it precedes with






?

Concatenation of text can be done using






?

Data can be arranged in a worksheet in a easy to understand manner using






?

You can use drag-and-drop to embed excel worksheet data in a word document






?

The auto calculate feature






?

Excel uniquely identifies cells within a worksheet with a cell name