Functions | MCQs

Explanation

VLOOKUP stands for Vertical Lookup.

It is used to search for a value in the first column of a table.

It is categorized under Lookup and Reference functions in Excel.

Explanation

Keyboard Key Categories:

Navigation Keys: Include Page Up/Down, Arrow Keys, Home, End, Delete, and Insert. They help move the cursor or scroll through content.

Control Keys: Ctrl, Alt, Esc (used for shortcuts).

Function Keys: F1-F12 (perform specific tasks).

Explanation

First-person pronouns: We, us, our,and ourselves

Second-person pronouns: you, your, yours

Third-person pronouns: he, him, his, himself, she, her, hers, herself, it, its, itself, they, them, their, theirs, and themselves

Explanation

The MAX function in Excel returns the highest value in a set of data that you specify.

It can be used to find the maximum value in a range of cells, a list of numbers, or an array.

Example: =MAX(A1:A10) returns the highest value in cells A1 through A10.

Explanation

The F4 key is commonly used to repeat the last action in programs like Microsoft Word and Excel.

For example, if you format text or perform a specific action, pressing F4 will repeat it.

Explanation

A Linker is a computer program that combines object codes (from various source files) into a single executable program.

It resolves references between modules and links library files if needed.

Explanation

Explanation

The function key to quickly navigate to a specific cell in MS Excel is F5 or Ctrl+G.

These keys open the "Go To" dialog box, where you can enter the cell reference (e.g., B3) and press Enter to jump to that cell

Explanation

In Microsoft Word, Ctrl M is used to indent a paragraph. 

Explanation

Shift + Enter 

shortcut key used for  manual line break.