Which of the following is the correct steps based on MS Excel 2013 for naming a range of cell?
(a) Select the range of cells – Click on DATA tab – Click on Define Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(b) Select the range of cells – Click on FORMULA tab – Click on Define Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(c) Select the range of cells – Click on DATA tab – Click on Range Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(d) Select the range of cells – Click on FORMULA tab – Click on Range Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
Answers
Which of the following is the correct steps based on MS Excel 2013 for naming a range of cell?
(a) Select the range of cells – Click on DATA tab – Click on Define Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(b) Select the range of cells – Click on FORMULA tab – Click on Define Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(c) Select the range of cells – Click on DATA tab – Click on Range Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.
(d) Select the range of cells – Click on FORMULA tab – Click on Range Name button – A dialog box will appear – In the Textbox next to NAME type the name of the selected range – Click OK.