Which function is not available in the Consolidate dialog box?
Which one is the last column header in Excel 2007?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Which of the following methods can not be used to enter data in a cell?
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
What is the correct way to refer the cell A10 on sheet3 from sheet1?
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Merge cells option can be applied from
Which is used to perform what if analysis?
What is the keyboard shortcut for creating a chart from the selected cell range?
A typical worksheet has …. Number of columns
Which of the following is not an option of the spelling dialog box?
MS-EXCEL is based on __________?
How do you rearrange the data in ascending or descending order?
When you use the fill effects in the format data series dialog box, you can not
A smart tag will be removed from a cell when
Which of the following methods can not be used to edit the contents of a cell?
You can convert existing excel worksheet data an charts to an HTML document by using
If you press ________, the cell accepts your typing as its contents.
Formulas in Excel start with
Which of the following is not true about Find and Replace in Excel
What function displays row data in a column or column data in a row?
MS-EXCEL can be used to automate
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
In EXCEL, you can sum a large range of data by simply selecting a tool button called _________?
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
You can open the scenario Manager dialog box by choosing scenarios from the ______ menu.
The command Edit >> Fill Across Worksheet is active only when
Which of the following is not a basic step in creating a worksheet?
Comments put in cells are called
Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
How to specify cell range from A9 to A99 in Excel?
Which of the following is a popular DOS based spreadsheet package?
232. When a row of data is to be converted into columns
To activate the previous cell in a pre-selected range, press
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be:
When the formula bar is active, you can see
Multiple calculations can be made in a single formula using ________.