Post on Medial

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

Which function allows you to count the number of cells that meet a specific condition? #excel #msexcel #data #dataanalytics #googlesheets #functions

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

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

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

Which shortcut can be used to create an absolute cell reference while editing a formula? A) F4 B) F2 C) Alt + F4 #excel #data #dataanalyst #dataanalytics #dataanalysis #googlesheets

Which shortcut inserts the current date into a selected cell? #excel #data #dataanalyst #googlesheets #dataanalytics

What is the shortcut key to insert a new worksheet in Excel? #excel #msexcel #data #dataanalytics #googlesheets

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

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 #d