Post on Medial

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

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

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

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 inserts the current date into a selected cell? #excel #data #dataanalyst #googlesheets #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 can you remove duplicate values from a column in #Excel? #data #dataanalytics #dataanalysis #googlesheet

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

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