Which of the following is not the correct method of editing the cell content?
Which of the following is not true regarding Conditional Formatting?
When you want to insert a blank imbedded excel object in a word document you can
Which of the following methods cannot be used to edit the content of cell?
If the cell B1 contains the formula = $A$1, which of the following statements is true
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Which of the following is correct?
The Software which contains rows and columns is called ______.
Which of the following you can paste selectively using Paste Special command?
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
The Chart wizard term data categories refers to;
You can open the Highlight Changes dialog box by choosing Track Changes from the ________ Menu.
Which function is not available in the Consolidate dialog box?
Which of the following is a correct order of precedence in a formula calculation?
The Name box on to the left of formula bar
Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
To copy formatting from one area in a worksheet and apply it to another area you would use:
Which elements of a worksheet can be protected from accidental modification?
What is the correct way to refer the cell A10 on sheet3 from sheet1?
What is the short cut key to replace a data with another in sheet?
You can open the scenario Manager dialog box by choosing scenarios from the ______ menu.
Which of the following is the latest version of Excel
What are the tabs that appear at the bottom of each workbook called?
How can you find specific information in a list?
Which of the following syntax is correct regarding to SUM function in Excel?
Comments put in cells are called ________.
Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
What term describes a background that appears as a grainy, non smooth surface
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
How do you change column width to fit the contents?
Concatenation of text can be done using
Formulas in Excel start with
If you need a text to show vertically in a cell. How will you achieve this?
You can check the conditions against __________ when applying conditional formatting
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
Special category of Number tab in Format Cells dialog box can be used to apply formats like
Tab scroll buttons are place on Excel screen
How do you wrap the text in a cell?