What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
- In Excel, the Fill Color button on the Formatting toolbar is used for what?
- Where can you set the shading color for a range of cells in Excel?
- Excel files have a default extension of
- What is the correct way to refer the cell A10 on sheet3 from sheet1?
- Which elements of worksheet can be protected from accidental modification
- How many worksheets can a workbook have?
- You cannot link excel worksheet data to a word document
- Long text can be broken down into many lines within a cell. You can do this through
- What is the short cut key to replace a data with another in sheet?
- How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
- To copy formatting from one area in a worksheet and apply it to another area you would use:
- You can copy data or formulas
- Excel worksheet cells work very similarly to what common element of the windows graphical user interface
- Which of the cell pointer indicate that you can move the content to other cell?
- To edit in an embedded excel worksheet object in a word document
- Which tool you will use to join some cells and place the content at the middle of joined cell?
- How do you delete a column?
- You can use the drag and drop method to
- You can use drag-and-drop to embed excel worksheet data in a word document
- In Excel, a Data Series is defined as what?
- To copy cell contents using drag and drop press the
- MS-EXCEL is based on .........?
- Rounding errors can occur
- Which of the following is not true regarding Conditional Formatting?
- It is acceptable to let long text flow into adjacent cells on a worksheet when
- To select an entire column in MS-EXCEL, press?
- Which menu option can be sued to split windows into two
- Right clicking something in Excel:
- A numeric value can be treated as label value if ...... precedes it.
- Which of the following is invalid statement?