Q46. Which of the following option is used to convert the horizontal table in a vertical table? H lookup V lookup Transpose Both a and b

What is the HLOOKUP Function?HLOOKUP stands for Vertical LookupHLOOKUP stands for Horizontal LookupBoth a and bBoth a and b

Which command will you choose to convert a column of data into row?Cut and PastePaste Special > TransposeBoth of aboveNone of above

Which command will you choose to convert a column of data into row?*Cut and PasteTransposeBoth of aboveNone of above

Refer to the tables shown in the image. Which of the given steps will help you change the table on the left to match the table on the right?OPTIONS Select data → F6 → blanks → Alt + (+) Select data → F6 → blanks → Ctrl + (+) Select data → F5 → blanks → Alt + (-) Select data → F5 → blanks → Ctrl + (-)

In order to adjust any row's height in a spreadsheet, which of the following key combinations can be used ?Question 52Answera.Alt+A+O+Hb.Alt+N+O+Hc.Alt+H+O+Hd.Alt+M+O+H