download Mastguru Android App

Question Detail

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

  • Transpose
  • Index
  • Rows
  • Hyperlinks

Answer: Option A

Similar Questions :

1. Macros can be executed from the which of the following menu ?

  • Format
  • Home
  • Insert
  • Tools

Answer: Option D

2. Which of these will not select all the cells in a document ?

  • Using the Edit – Select All menu
  • Pressing Ctrl + A on the keyboard
  • Clicking three times with the right mouse button in the spreadsheet

Answer: Option C

3. When you press Ctrl + X after selecting some cells in Excel, what will happen then

  • The cell content of selected cells disappear from cell and stored in clipboard
  • The selected cells are deleted and cells are shifted up
  • The selected cells are deleted and the cells are shifted left
  • The cells selected are marked for cutting

Answer: Option D

4. Shortcut to edit the selected cell ?

  • F3
  • F8
  • F4
  • F2

Answer: Option D

5. Merge cells option can be applied from ?

  • Formatting toolbar
  • Format Cells dialog box Alignment Tab
  • Both of above
  • None of above

Answer: Option B

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs