MICR | MCQs

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.

Explanation

The shortcut key to change case in MS-Word is: Shift + F3

1. Sentence Case
2. Lowercase
3. Uppercase
4. Title Case
5. Toggle Case

Explanation

Mail Merge in MS Word is used to create personalized documents (like letters or emails) for multiple recipients using a data source.

It inserts individual names, addresses, or other details into a template for mass communication.

Explanation

Styles in MS Word are used to apply consistent formatting like font, size, and color across headings, paragraphs, etc.

They help maintain a uniform look throughout the document.