Navigate

Question Detail

3-D reference in a formula ?

  • Spans worksheets
  • Can not be modified
  • Only appears on summary worksheets
  • Limits the formatting options

Answer: Option A

Similar Questions :

1. To drag a selected range of data to another worksheet in the same workbook, use the ?

  • Ctrl key
  • Shift key
  • Alt key
  • Tab key

Answer: Option A

2. One cell format can be copied to another cell by using ?

  • Format Painter
  • Format Setting
  • Format Showing
  • Format Checking

Answer: Option A

3. How is data organized in a spreadsheet ?

  • Rows and columns
  • Layers and planes
  • Lines and spaces
  • Height and width

Answer: Option A

4. What function displays row data in a column or column data in a row ?

  • Transpose
  • Index
  • Rows
  • Hyperlinks

Answer: Option A

5. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ?

  • HTML
  • Pivot Table Field List
  • Pivot Table Report
  • Pivot Table List

Answer: Option C

Read more from - MS Excel Questions Answers