DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
SamhaspainstakinglycreatedaworksheetofSalesfiguresfortheEasternregion.Hisworksheetisbeautifully formatted and contains accurate formulas. Now he needs to create a worksheet just like it for the Western region. How should Sam proceed?
|
|
He should open a new workbook, line his two windows up side-by-side, and create a Western worksheet from scratch, using the Eastern worksheet as a guide.
|
|
|
He should add a new worksheet to the current workbook, view both worksheets side-by-side, and create the Western worksheet from scratch, using the Eastern worksheet as a guide.
|
|
|
He should create a copy of the Eastern worksheet, rename the copy Western, and then enter the figures as appropriate.
|
|
|
He should rename the Eastern worksheet to Western, and then enter the figures as appropriate.
|
Explanation:
Detailed explanation-1: -From the Formulas tab, select Defined Names, Define Name to launch the New Name dialog box pictured below. Enter SheetNames into the Name field, enter the following formula into the Refers to field: =REPLACE(GET. WORKBOOK(1), 1, FIND("]", GET. WORKBOOK(1)), ""), and then select OK.
Detailed explanation-2: -The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
Detailed explanation-3: -Worksheets and charts Was this answer helpful?
There is 1 question to complete.