Numeric Value Prefix Rules
In MS Excel if a numeric value start with ____ then this value can be treated as a table?Hash, Equal Sign, Apostrophe, Tide
Answer: Equal Sign
Explanation
In MS Excel, if a numeric value starts with = (Equal Sign)
It is treated as a formula rather than a table.
Tables in Excel are typically created by formatting a range of cells as a table using Ctrl + T or the "Format as Table" option.
This question appeared in
Past Papers (5 times)
PPSC 5 Years Past Papers Subject Wise (Solved with Details) (2 times)
PPSC Past Papers (1 times)
PPSC PHP ASI Past Papers and Syllabus (1 times)
PPSC Punjab Police ASI Past Papers and Syllabus (1 times)
This question appeared in
Subjects (1 times)
COMPUTER (1 times)
Related MCQs
- A numeric value can be treated as label value if ___precedes it
- A numeric value can be treated as label value if it is precedes with
- A numeric value can be treated as label value if ________ precedes it.
- What is the time complexity of searching in a Hash Table?
- In MS Excel formula and function start with ____?
- Which function in Excel tells how many numeric entries are there?
- Which function is used in Excel to count numeric values in a range?
- Which sign is used to create an absolute cell reference in MS Excel?
- In MS Excel, through which of the following table options can charts be created?
- In Excel, The rows of a table correspond to _____?
