Microsoft | MCQs

Explanation

A spreadsheet is a file that exists of cells in rows and columns and can help arrange, calculate and sort data.

Data in a spreadsheet can be numeric values, as well as text, formulas, references and functions.

Explanation

 Alt+K is a keyboard shortcut most often used to open the Transitions tab in the Ribbon.

Explanation

Explanation

The formula tab allows you to select from over 300 Excel functions.

Explanation

• move to the next cell in the sheet in ms excel: shift + page down
• ***
• move to the next cell in the row in ms excel: Tab
• ***
• MS Excel stands for Microsoft Excel
  

• In Excel, a Data Series is defined as a collection of related data.

   Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

• In MS Excel, automatically total a column or row of values: SUM

Explanation

• ctrl +', keys are used in ms excel to copy formulas from the above cell
• ***
• 
  
  

Explanation

Data Source is a name given to the connection set up to a database from a server. 

Explanation

Right-click the tab and choose Delete from its shortcut menu in All version of excel.

In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS

Microsoft Excel 2007 and earlier Press ‘ALT’ + ‘E’, then the ‘L’ key.

***************

vu FIA CBT PAPER 15-12-2021

Explanation

In Excel, a Data Series is defined as a collection of related data.

 Microsoft Excel features calculation or computation capabilities, graphing tools, pivot tables etc.

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.