which of the following features is used to create direct access to other sheet or object in th worksheet
Answers
Answer:
Create and Manage Workbooks and Worksheets: Excel 2013
This is the ‘Create and Manage Workbooks and Worksheets’ tutorial of the Excel 2013 MOS Foundation course offered by Simplilearn.
Creating a Blank Excel Workbook
Excel 2013 allows users to create a new workbook from a blank document. There is also an option to create a new workbook based on the existing workbook. By default, a new workbook contains three worksheets. However, we can change the number of worksheets in a workbook as per the requirements.
Create a Workbook from an Excel Template
A template is a pre-designed worksheet which could be modified to suit users needs. The Excel template contains predefined formulas and custom formatting. This saves a lot of time and effort while working on a new project.
To create a workbook from a template, we need to select an appropriate template, as per the requirements. Besides Microsoft, there are many individual users as well as third-party providers to create customized templates.
Open an Existing Excel Workbook
An existing workbook is one that has been previously saved and stored in the computer or on the web. One can open existing workbooks from local computer drives, Skydrive, online storage and other online storage places. Skydrive is a Microsoft product, and anyone can sign in or register on Skydrive for storing files online.
Business Scenarios
John has been assigned the task of creating an inventory data sheet for his company’s assets. To do this, he has to work extensively on Microsoft Excel 2013. He needs to enter and edit data in workbooks, starting with creating a workbook.
Let us take a look at the overview of the steps for opening an Excel workbook.
To create a new worksheet, open Microsoft Excel and click the File tab.
Click New and then click the Blank Workbook option.
To create a workbook from a template, under New, click the Search for Online Templates search bar and enter the type of template required
Click the Search icon.
Select any of the available Templates and click Create.
To open an existing workbook, click File, then click Open.
Click Computer and then click Browse.
In the open pop-up window, navigate to the Excel file you want to open, select it and click open.
Native and Non-Native Files
Let us first understand was Native and Non-Native files are.
The type of file format that each software program can create or accept is called as native files.
A software program that allows us to work and save files in a different format is called non-native files.
Some popular native file format in Excel 2013:
thanks