Question

Which areas can be used to create names in the Create from Selection feature in the Formula tab? Check all that

Answer 1

Answer:

Look at the picture provided

Explanation:

Answer 2

Answer:

top row, left column, right column, bottom row and Apply or ok.

Explanation:

The question above wants to test our knowledge on the use of Excel app. (application) or software worksheet and this is in how create names in the Create from Selection feature in the Formula tab.

Check the steps in the creation of names in the Create from Selection feature in the Formula tab below;

(1). Highlight your range(note that this must include the rows and the columns) , (2). Click on FORMULAS, then select CREATE FROM SELECTION from the pop up options, (3). Then, in the section where you can see CREATE NAMES FROM SELECTION make sure you click on all the check boxes included, (4). Click on TOP ROW(If you have only the row at the header) and vice versa, (5). Click on TOP ROW and LEFT COLUMN(if both are involved) and vice versa, and (6). Click on APPLY or OK.