Identify the file type.

Answer: CSV – Values separated by commas, one record per line, form a CSV (Comma Separated Values) file.

Which option displays the rows that meet certain conditions in MS Excel?

Answer: Filter – Filter shows only the rows that match your condition and hides the rest.

Which Excel tab is used for importing, outlining and subtotalling the data placed in a worksheet data list?

Answer: Data – The Data tab has Get Data (import), Group/Outline and Subtotal commands.

Which box is present in Pivot Table fields list?

Answer: Column Labels – The PivotTable field list has boxes: Filters, Column Labels, Row Labels and Values.

Which is the best spreadsheet method that prints and fits all the columns in one page?

Answer: Page Layout → set width to 1 page – Page Layout → Scale to Fit → Width = 1 page fits all columns on one page.

Which starts with “=” sign in Excel 2010?

Answer: Formulas – Every formula in Excel begins with the = sign, e.g. =A1+B1.

Which excel analysis tool is best for solving problem with one variable?

Answer: Goal Seek – Goal Seek finds the input value needed to get a desired result for one variable.

In which application data validation is used?

Answer: MS Excel – Data Validation (Data tab of MS Excel) restricts what can be typed in a cell.

What is the use of "Ctrl + T" key in MS Excel?

Answer: Opens the create table dialog box – Ctrl + T converts the selected range into a table via the Create Table dialog.

Which type of chart is used in MS Excel?

Answer: Bubble – Bubble chart is an Excel chart type that shows three values (X, Y and bubble size).

Which view in excel displays the pages exactly as they appear while printing?

Answer: Page Layout view – Page Layout view shows pages, margins, headers and footers exactly as printed.

Which ribbon menu displays the Page Setup grouping of commands?

Answer: Layout – The Page Setup group (margins, orientation, size) is on the Page Layout / Layout tab.

Which Excel option rearranges the rows based on the content of a particular column?

Answer: Sort – Sort rearranges rows based on the values of a chosen column.

Which key combined with ctrl key creates a macro key in Excel?

Answer: Alphabetic – A macro shortcut is Ctrl + a letter (alphabetic key), e.g. Ctrl + M.

Which operation sequence inserts the hidden formula bar in Excel worksheet?

Answer: View → Show/hide → Formula bar – View tab → Show group → tick Formula Bar to display it again.

What is the maximum limit of rows in MS Excel 2010?

Answer: 1048576 – Excel 2007 onwards has 1,048,576 rows and 16,384 columns (XFD).

What arranges data in Ascending (A-Z) or Descending (Z-A) order?

Answer: Sorting – Sorting arranges data in ascending (A–Z) or descending (Z–A) order.

Which function key opens save as dialogue box in MS Excel?

Answer: F12 – F12 opens the Save As dialog box in Office programs.

Which tab adds pivot table, charts and hyperlinks in a spread sheet?

Answer: Insert – The Insert tab adds PivotTables, charts, pictures and hyperlinks.

How to insert chart in MS Excel?

Answer: Insert Tab-Charts – Select the data, then use Insert tab → Charts group.

Which option inserts a Pivot Table?

Answer: Insert Tab - Tables Group – A PivotTable is inserted from Insert tab → Tables group → PivotTable.

Which chart shows the proportions of how one or more data elements relate to another data element?

Answer: Pie Chart – A pie chart shows each part as a slice (percentage) of the whole.

Which is a ‘Date and Time’ function in Excel?

Answer: NOW() – NOW() returns the current date and time; FIND, MOD and MID are text/maths functions.

Which function counts the number of cells that contains numbers in a range?

Answer: Count() – COUNT() counts cells that contain numbers; COUNTA counts non-empty cells.

Which tab is used to access the What-if Analysis Excel tools?

Answer: Data Tab – What-If Analysis (Goal Seek, Scenario Manager, Data Table) is in the Data tab.