How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
What value will display if the formula = “$55.00″+5 is entered into a cell?
An Excel Workbook is a collection of ________.
Multiple calculations can be made in a single formula using ________.
To remove the content of selected cells you must issue ______ command.
Which of the following is not a valid data type in Excel?
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
232. When a row of data is to be converted into columns
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A worksheet can have a maximum of …. Number of rows
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?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
In order to perform a calculation in a spreadsheet, you need to use a:
Which of following is Not one of Excel’s what-if function?
Which of the following is not information you can specify using the solver?
Which area in an excel window allows entering values and formulas
What should be add before a fraction to avoid entering it as a date?
To delete an embedded objects, first
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Can you set 0.5 inch left indentation for a cell in Excel?
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
How to restrict to run a macro automatically when starting Microsoft Excel?
How can you delete a record?
The command Edit >> Fill Across Worksheet is active only when
In a worksheet you can select
How do you display current date and time in MS Excel?
Which of the following options is not located in the Page Setup dialog box?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Which elements of a worksheet can be protected from accidental modification?
Which of the following will not cut information?
If 4/6 entered in a cell without applying any formats, Excel will treat this as
Which would you choose to create a bar diagram?
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
-
-
-
-
To activate the previous cell in a pre-selected range, press
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
When you link data maintained in Excel workbook to a Word document