Question

what are the three benefits of having seprate spreadsheets in a workbook also, describe a situation in where you would use the "hide/unhide" function from the above video.

Answer 1

Answer)

The benefits are

1) If we use separate spreadsheets then we can have individual information for same type of topic, like monthly or yearly information, here we will create a spreadsheet for every month, instead of all the month in a single spreadsheet. Another example is branch wise spreadsheet in a single workbook. etc

2) We can rename the spreadsheet , so we can easily identify the spreadsheet.

3) We can apply macro or VBA separately on the spreadsheets of a workbook. Or we can apply separate theme or formatting on different spreadsheets.

Hide/unhide are used not to display some columns when we are looking or printing the spreadsheet. The unwanted row or columns can be hide to have a proper look, after that we can unhide the row or column. Like we want to hide the column of date of birth when age is calculated, etc.