ExamVeda
Login
Home
71
To delete an embedded objects, first
Discuss
Answer & Solution
Answer: Option D
Solution:
To delete an embedded objects, first select it and then press the delete key.
72
Comments can be added to cells using
Discuss
Answer & Solution
Answer: Option B
Solution:
Comments can be added to cells using Insert > Comments. MS Excel mcq solution image
73
Which of the following is not a worksheet design criterion?
Discuss
Answer & Solution
Answer: Option C
Solution:
Description
74
To copy cell contents using drag and drop press the
Discuss
Answer & Solution
Answer: Option C
Solution:
To copy cell contents using drag and drop press the Ctrl key else it will move the data.
75
Which of the following is the latest version of Excel
Discuss
Answer & Solution
Answer: Option C
Solution:
Office 365, always receive updates to the latest version of Office.
76
When you copy a formula
Discuss
Answer & Solution
Answer: Option B
Solution:
When you copy a formula Excel edits cell references in the newly copied formula.
77
The autofill feature
Discuss
Answer & Solution
Answer: Option D
Solution:
The autofill feature:

Extends a sequential series of data: The autofill feature in MS Excel is designed to quickly fill cells with data that follows a pattern. For example, if you have the numbers 1 and 2 in consecutive cells, you can use the autofill handle to drag down and automatically fill in the sequence (3, 4, 5, etc.). This feature works with various types of data, including numbers, dates, and text patterns (like months or days of the week).

Automatically adds range of cell values: This statement is somewhat misleading in the context of the autofill feature. While the autofill can copy values and extend patterns, it does not automatically add a range of cell values. Summing or calculating values across a range of cells typically requires functions like SUM, which is different from autofill.

Applies a border around the selected cells: The autofill feature does not apply borders around cells. Applying borders is a formatting task done through the Format Cells option or the Borders tool in the toolbar. Autofill is specifically for populating cells with data based on a recognized pattern.

All of the above: Since the autofill feature's primary function is to extend a sequential series of data and it does not inherently add ranges of values or apply borders, this option is incorrect. The correct description of the autofill feature is its ability to extend a series of data, making Option A the correct choice.
78
Which menu option can be used to split windows into two
Discuss
Answer & Solution
Answer: Option B
Solution:
View > Window > Split option can be used to split windows into two.
79
Which of the following is an absolute cell reference?
Discuss
Answer & Solution
Answer: Option B
Solution:
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
80
What symbol is used before a number to make it a label?
Discuss
Answer & Solution
Answer: Option D
Solution:
An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.