MS Excel

Question 111 : If you want to combine the text from multiple cells into one cell, which function is best?

Question 112 : Which tab on the Ribbon contains the option to protect a worksheet with a password?

Question 113 : What is the keyboard shortcut to open the Format Cells dialog box?

Question 114 : Which function would you use to find the highest value in a selected range of cells?

Question 115 : What happens if you type '0123 (with a leading apostrophe) into a cell?

Question 116 : Which feature is used to print specific portions of a worksheet rather than the entire sheet?

Question 117 : Which function returns the serial number of the last day of the month before or after a specified number of months?

Question 118 : In a PivotTable, what area do you drag a field into if you want to perform calculations (like SUM or AVERAGE) on it?

Question 119 : What is the primary difference between COUNTIF and COUNTIFS?

Question 120 : Which function returns the relative position of an item in an array that matches a specified value?