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
- Which command will you choose to convert a column of data into row?
- How can you print three copies of a workbook?
- A numeric value can be treated as label value if ...... precedes it.
- Rounding errors can occur
- Which tool you will use to join some cells and place the content at the middle of joined cell?
- What is represented by the small, black square in the lower-right corner of an active cell or range?
- To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
- B7:B9 indicates:
- Which of the cell pointer indicates you that you can make selection?
- How do you insert a row?
- In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
- Comments put in cells are called
- When you want to insert a blank imbedded excel object in a word document you can
- Microsoft Excel is a powerful ...........
- Getting data from a cell located in a different sheet is called ......
- Where can you change automatic or manual calculation mode in Excel?
- Tab scrolling button
- To create a formula, you first:
- Which button do you click to add up a series of numbers?
- You can set Page Border in Excel from
- A worksheet range is a
- What are the tabs that appear at the bottom of each workbook called?
- By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
- MS Excel provides the default value for step in Fill Series dialog box
- Hyperlinks can be
- A circular reference is
- An Excel Workbook is a collection of .......
- When you insert an excel file into a word document. The data are
- To edit in an embedded excel worksheet object in a word document
- You can use the formula palette to