ExamVeda
Login
Home
81
Which symbol must all formula begin with?
Discuss
Answer & Solution
Answer: Option A
Solution:
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
82
Which of the following formulas is not entered correctly?
Discuss
Answer & Solution
Answer: Option D
Solution:
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Here in option D 10+50 there is no equal sign (=), so it is not correct.
83
Which of the following formulas will Excel not be able to calculate?
Discuss
Answer & Solution
Answer: Option A
Solution:
SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.
84
A typical worksheet has ________ number of columns.
Discuss
Answer & Solution
Answer: Option D
Solution:
Excel 2003 and earlier 256
(as label 'IV') columns.
Excel 2007 and higher 16,384 (as label 'XFD') columns.
85
How many characters can be typed in a single cell in Excel?
Discuss
Answer & Solution
Answer: Option C
Solution:
A cell can contain 32,767 number of characters.
86
A worksheet can have a maximum of ________ number of rows.
Discuss
Answer & Solution
Answer: Option D
Solution:
Excel 2003 and earlier 65,536 Rows.
Excel 2007 and higher 1,048,576 Rows.
87
Which of the following is not an example of a value?
Discuss
Answer & Solution
Answer: Option D
Solution:
Serial Number 50771 is alpha numeric can not be considered as value.
88
The chart wizard term data series refers to
Discuss
Answer & Solution
Answer: Option B
Solution:
The chart wizard term data series refers to a collection of chart data markers.
89
The Chart wizard term data categories refers to;
Discuss
Answer & Solution
Answer: Option B
Solution:
The Chart wizard term data categories refers to a horizontal axis.
90
A worksheet range is a
Discuss
Answer & Solution
Answer: Option C
Solution:
A worksheet range is a group of cells.