MICR | MCQs

Explanation

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• Apply conditional formatting to text
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Point to Highlight Cells Rules, and then click Text that Contains.
• Type the text that you want to highlight, and then click OK.

• ****

  RY 16-01-2023

Explanation

Microsoft Access (MS Access) organizes data in tables, which are the fundamental building blocks of any database: 

Data organization: Stores data in tables with rows and columns

Data types: Supports various data types, such as text, number, date/time, currency, and more

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

VU CBT FIA PAPER 26-12-2021

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

Excel allowed you to create a chart by selecting the data and pressing the F11 key. 

Explanation

Magnetic ink character recognition (MICR) is a technology used primarily to identify and process checks.

The MICR on a check is the string of characters that appears at the bottom left of the check. 

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

Explanation

In PowerPoint, the "Color scheme" option allows you to change the colors of different objects, such as shapes, graphs, and charts, without affecting the content.

This option is found in the "Design" tab, and it enables you to select a new color scheme that will be applied to all elements in the presentation, while keeping the content unchanged.

Explanation

In MS Word, the "Home" keyboard key is used to move the cursor to the beginning of the current line.

This shortcut is often used to quickly navigate to the start of a line, especially when editing or formatting text.

Explanation

In Microsoft Word, Superscript, subscript, and strikethrough are known as Font effects.

On the Home tab, in the Font group, pick the Font Dialog Box Launcher.

On the Font tab, under Effects, select the Superscript or Subscript check box.

Explanation

To move to the previous cell in a table, press Shift + Tab.

This allows you to navigate backward within the table.

To move to the next cell, press The Tab Key.

This advances the cursor to the following cell in the table.

Explanation

• "Ctrl + Left Arrow" is used to: Moves the cursor one word left.
• "Ctrl + Right Arrow" is used to: Moves the cursor one word right.