ExamVeda
Login
Home
91
Getting data from a cell located in a different sheet is called ________
Discuss
Answer & Solution
Answer: Option B
Solution:
Getting data from a cell located in a different sheet is called Cell reference.
There are Three types of Cell reference in Excel
Relative
Absolute
Mixed
92
Tab scrolling button
Discuss
Answer & Solution
Answer: Option D
Solution:
Tab scrolling button allow us to view additional sheets tabs.
93
A numeric value can be treated as a label value if it precedes with
Discuss
Answer & Solution
Answer: Option A
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.
94
Concatenation of text can be done using
Discuss
Answer & Solution
Answer: Option D
Solution:
Concatenation of text can be done using Ampersand (&).
95
Data can be arranged in a worksheet in a easy to understand manner using
Discuss
Answer & Solution
Answer: Option D
Solution:
Data can be arranged in a worksheet in a easy to understand manner using all or any of the above options.
96
You can use drag-and-drop to embed excel worksheet data in a word document
Discuss
Answer & Solution
Answer: Option A
Solution:
We can use drag-and-drop to embed excel worksheet data in a word document by dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key.
97
The auto calculate feature
Discuss
Answer & Solution
Answer: Option B
Solution:
The auto calculate feature provides a quick way to view the result of an arithmetic operation on a range of cells.
98
Excel uniquely identifies cells within a worksheet with a cell name
Discuss
Answer & Solution
Answer: Option C
Solution:
Column letters and row numbers in Excel uniquely identifies cells within a worksheet with a cell name.