To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
- You can enter which types of data into worksheet cells?
- Hyperlinks can be
- If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
- Which is used to perform what if analysis?
- Which of the following is not a way to complete a cell entry?
- Which key do you press to check spelling?
- What are the tabs that appear at the bottom of each workbook called?
- What is the short cut key to highlight the entire column?
- If you need to remove only the formatting done in a range (numbers and formula typed there should not…
- Tab scroll buttons are place on Excel screen
- Ctrl + D shortcut key in Excel will
- Excel probably considers the cell entry January 1, 2000 to be a
- In help menu of Excel, which of the following tabs are found?
- Which of the following is an absolute cell reference?
- The active cell:
- To delete an embedded objects, first
- Concatenation of text can be done using
- Edit >> Delete command
- Which of following is Not one of Excels what-if function?
- The Cancel and Enter buttons appear in the:
- When you insert an excel file into a word document. The data are
- How do you display current date only in MS Excel?
- How do you insert a row?
- A numeric value can be treated as a label value if it precedes with
- You can use the formula palette to
- How many worksheets can a workbook have?
- Where can you set the shading color for a range of cells in Excel?
- Which of the following is not a valid data type in excel
- Which of the following is invalid statement?
- To select an entire column in MS-EXCEL, press?