USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is not a valid range name?
|
|
Sales Data
|
|
|
|
|
|
SalesQ1
|
|
|
tbl.Holidays
|
Explanation:
Detailed explanation-1: -In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range.
Detailed explanation-2: -Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error.
Detailed explanation-3: -Excel name types Defined name-a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it’s called a named range, or defined range.
Detailed explanation-4: -The correct answer is SUBTRACT().
There is 1 question to complete.