Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.	Which function key generates a bar graph from the values entered in excel?1. F92. F103. F114. F12
Answer» Correct Answer - Option 3 : F11 The correct answer is F11. An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the text and numbers and merged into a single workbook knows as a File. Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them. Function Key Shortcuts: F11:Generates a bar graph from the values entered F2: Edit Cells F4: Anchor Cells F7: Spell Check F12: Save As SHIFT + F2: Insert a Comment SHIFT + F8: Add to Selection SHIFT + F10: Right Click CTRL + F3: Name a Cell Windows Flag + D: Minimize Programs Hence, we conclude that F11 generates a bar graph from the values entered.

Which function key generates a bar graph from the values entered in excel?1. F92. F103. F114. F12

Answer» Correct Answer - Option 3 : F11

The correct answer is F11.

An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the text and numbers and merged into a single workbook knows as a File.
Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them.

Function Key Shortcuts:

F11:Generates a bar graph from the values entered
F2: Edit Cells
F4: Anchor Cells
F7: Spell Check
F12: Save As
SHIFT + F2: Insert a Comment
SHIFT + F8: Add to Selection
SHIFT + F10: Right Click
CTRL + F3: Name a Cell
Windows Flag + D: Minimize Programs

Hence, we conclude that F11 generates a bar graph from the values entered.

Discussion

2.	Addressing a cell as $A$4 is called:‐1. Absolute Addressing2. Relative Addressing3. Mixed Addressing4. None of these
Answer» Correct Answer - Option 1 : Absolute Addressing The correct answer is Absolute Addressing Cell References: There are 16384 rows and 256 columns in one worksheet. The first cell is labelled as A1 (column as A and row number as 1). The cell reference is given in the format as “Starting cell:ColumnRow” so a cell starting in B1 with column G and row 10 will be given as “B1:G10” in Microsoft excel. Types of Cell Reference: Relative:This refers to the cell relative to the given position. Absolute:This refers to the specific cell irrespective of the position of the formula. The '$' sign is used to denote an absolute reference. Mixed:It is a combination of both relative and mixed references. It has one absolute co-ordinate and one relative co-ordinate. $D1 and D$1 are both examples of mixed references. Hence, we conclude thatAddressing a cell as $A$4 is called Absolute Addressing.

Addressing a cell as $A$4 is called:‐1. Absolute Addressing2. Relative Addressing3. Mixed Addressing4. None of these

Answer» Correct Answer - Option 1 : Absolute Addressing

The correct answer is Absolute Addressing

Cell References:

There are 16384 rows and 256 columns in one worksheet. The first cell is labelled as A1 (column as A and row number as 1).
The cell reference is given in the format as “Starting cell:ColumnRow” so a cell starting in B1 with column G and row 10 will be given as “B1:G10” in Microsoft excel.

Types of Cell Reference:

Relative:This refers to the cell relative to the given position.
Absolute:This refers to the specific cell irrespective of the position of the formula. The '$' sign is used to denote an absolute reference.
Mixed:It is a combination of both relative and mixed references. It has one absolute co-ordinate and one relative co-ordinate. $D1 and D$1 are both examples of mixed references.

Hence, we conclude thatAddressing a cell as $A$4 is called Absolute Addressing.

Discussion