Correct Answer: B. F4

In MS Excel F4 key is used to repeat last, like inserting a column, row, formatting cells, copy and pasting etc.

Correct Answer: A. Shift + F3

Formula Window in MS Excel alternatively referred to as a formula box. Pressing Shift + F3 key will open formula window, which contains functions, references, operators, and constants.

Correct Answer: A. Alt + Shift + F1

In MS Excel, Alt + Shift + F1 key is used to insert new worksheet.

Correct Answer: B. F11 

F11 key in MS Excel used create chart. First select the data you want to use to create a chart. Press F11, excel will creates a chart on a new sheet using the default chart type.

Correct Answer: B. F2

F2 function key in Microsoft Excel used to edit the selected cell’s Data.

Correct Answer: A. Ctrl + 1

Ctrl + 1 key is used to open the Format Cell window in Microsoft Excel 2007. The Format Cells dialog box is where you set the formatting options for your objects.

Correct Answer: B. Pie Chart

Pie Chart in Microsoft Excel represents only one value for each variable. Pie chart is a primary chart in ms excel, it meant to express a “Part to Whole” relationship, where all pieces together represent 100%. Pie Charts work best to display data with a small number of categories. 

Correct Answer: A. Browser

Browser is not a term of pertaining to spreadsheets. Character and Formulas are one of the terms of spreadsheets in Microsoft Excel. Spreadsheets are used to arrange, calculate and manage the data in the rows and columns.

Correct Answer: A. 1048576

In Microsoft Excel Version 2007 and onwards, there are 1048576 rows are present. By pressing Ctrl + Down arrow you can See the total number of rows in worksheet.

Correct Answer:D. Avg 

The Avg is not a function in MS-Excel at the time of writing, but if you mean Average, then the syntax for it is also Average  not Avg.