What function displays row data in a column or column data in a row?
An excel workbook is a collection of
Which of following is Not one of Excel’s what-if function?
You can auto fit the width of column by
The Paste Special command lets you copy and paste:
What is the short cut key to highlight the entire column?
Files created with Lotus 1-2-3 have an extension
Excel displays the current cell address in the ____________.
Which of the following is not a valid data type in Excel?
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Which of the cell pointer indicates that you can fill series?
Which of the following is an absolute cell reference?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
When you link data maintained in an excel workbook to a word document
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Formatting a cell in Currency, you can specify
In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
Which of the following you can paste selectively using Paste Special command?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
When a label is too long to fit within a worksheet cell, you typically must
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Microsoft Excel is a powerful _________.
232. When a row of data is to be converted into columns
Which of the following methods can not be used to edit the contents of a cell?
Ctrl + D shortcut key in Excel will
What is entered by the function =today()
What is the shortcut key to hide entire row?
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Worksheet can be renamed by
You can automatically adjust the size of text in a cell if they do not fit in width by
How to specify cell range from A9 to A99 in Excel?
“Qtr 1, Qtr 2, Qtr 3” is an example of a
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
Which of the following function will use to find the highest number in a series of number?
How to remove the unwanted action from recorded macro without recording the whole macro again?
Data can be arranged in a worksheet in a easy to understand manner using
You can quickly change the appearance of your work by choosing Auto Format from the ________ Menu.