Post on Medial

Sidharth Bidikar

Stealth • 1m

When you apply a VLOOKUP function, what does the “column_index_num” argument represent? A) The number of rows to lookup B) The number of columns in the table C) The column number from which the result will be returned. #excel #data #dataanalyst #dataanalysis #msexcel #vlookup

1 replies6 likes

Replies (1)

Anonymous 1

Stealth • 1m

0 replies1 like

Recommendations from Medial

Sidharth Bidikar

Stealth • 1m

How can you quickly insert a new row or column in Excel using a shortcut? A) Ctrl + Alt + N B) Ctrl + Shift + "+" C) Shift + Enter #excel #dataanalyst #dataanalytics ##dataanalysis #googlesheets

0 replies2 likes

Sidharth Bidikar

Stealth • 1m

What is the most efficient way to combine text from multiple cells into one cell without using the CONCATENATE function? A) Using the TEXTJOIN function B) Using the LEFT function C) Using the SUBSTITUTE function #excel #msexcel #dataanalyst #dataan

0 replies5 likes

Sidharth Bidikar

Stealth • 1m

How do you open the "Go To" dialog box in Excel? #excel #data #dataanalyst #dataanalytics #msexcel #googlesheets

0 replies3 likes

Sidharth Bidikar

Stealth • 1m

Which feature allows you yo Freeze both the top row and the first column simultaneously in excel? #data #dataanalytics #dataanalysis ##googlesheets

1 replies3 likes

Sidharth Bidikar

Stealth • 1m

How do you quickly apply the AutoSum function to a range of cells? A) Alt + A B) Alt + "=" C) Ctrl + Shift + S #excel #dataanalyst #dataanalytics #data #dataanalysis

0 replies5 likes

Sidharth Bidikar

Stealth • 1m

Which function can be used to combine text from different cells into one cell without using the CONCATENATE function? A) TEXTJOIN B) CONCAT C) JOIN #excel #dataanalyst #data #dataanalysis #dataanalytics

0 replies6 likes