Which of the following methods cannot be used to enter data in a cell?
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Which of the following is correct syntax in Excel?
If particular workbook have to open each time Excel started, where that workbook should be placed?
You can not link Excel worksheet data to a Word document
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
MS-EXCEL is based on __________?
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
What does the VLOOKUP function do?
To create a formula, you first:
To edit in an embedded excel worksheet object in a word document
Which function is not available in the Consolidate dialog box?
The Chart wizard term data categories refers to;
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
What is the short cut key to highlight the entire column?
What is the keyboard shortcut for creating a chart from the selected cell range?
Data can be arranged in a worksheet in a easy to understand manner using
When you group worksheets
Which area in an Excel window allows entering values and formulas?
You can check the conditions against __________ when applying conditional formatting
What term refers to a specific set of values saved with the workbook?
You can automatically adjust the size of text in a cell if they do not fit in width by
To remove the content of selected cells you must issue ______ command.
The default header for a worksheet is
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
Which of the following is not information you can specify using the solver?
What do you mean by a Workspace?
You can convert existing excel worksheet data an charts to an HTML document by using
In order to perform a calculation in a spreadsheet, you need to use a:
Which of the following is not the correct method of editing the cell content?
To drag a selected range of data to another worksheet in the same workbook, use the
Which button do you click to add up a series of numbers?
When you work with large worksheets, you may need to
Which of the following options is not located in the Page Setup dialog box?
You can merge the main document with data source in Excel. In mail merge operation, Word is usually