Question

In: Accounting

Describe how to open a file in Excel? What is the difference between opening a file...

Describe how to open a file in Excel? What is the difference between opening a file and creating a new file in Excel?

Solutions

Expert Solution

Opening a file in Excel:

If there is a existing file in excel, it can be opened by following procedure:

Click “Microsoft Office Button”.

All programs will be visible.

Click “ File explore”

Select the location where the file exists ( eg. Desktop, downloads, C-drive , E drive).

Lick on the location.

All files and folders available in the location will be visible.

Select the file you want to open.

Double click on the file.

The file will open.

If the file is in a folder.

Click on the folder, the file will be visible.

Select the file and double click on the file to open it.

Creating a file:

Creating a file means , a file does not exist. It needs to be created.

A file which already exists with a file name , it can be opened. Generally such files will contain data.

Creating a file means entering data in the file, giving it a file name and saving it in some location like desk top or in drive.

To create a file ,

Click “Microsoft Office Button”.

Select “Microsoft Office Excel”

Click on Microsoft Office Excel

A new window will open for excel file.

Fill in required data. Save the file and give the it a file name


Related Solutions

What is the difference between Open and Closed Circulatory Systems? What is the difference between atrioventricular...
What is the difference between Open and Closed Circulatory Systems? What is the difference between atrioventricular and semilunar valves?
what is the difference between a normal file and a Webdocument?
what is the difference between a normal file and a Web document?
2. Describe how you save a file with a new filename in Excel.
2. Describe how you save a file with a new filename in Excel.
How do ETF’s work? What is the difference between an ETF and Closed and Open End...
How do ETF’s work? What is the difference between an ETF and Closed and Open End Mutual Funds? If you are saving for your retirement does the choice have a big impact?
What are the difference between an Open Cluster and Globular Cluster? Similarities?
What are the difference between an Open Cluster and Globular Cluster? Similarities?
What is the difference between ordinary annuities and annuities due? How to use Excel® to evaluate...
What is the difference between ordinary annuities and annuities due? How to use Excel® to evaluate annuities?
Describe the functions of open and closed end funds and explain the key difference between them....
Describe the functions of open and closed end funds and explain the key difference between them. Which of the two represents the more attractive investment?
The data on a loan has been collected in the Microsoft Excel Online file below. Open...
The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Amortization schedule Loan amount to be repaid (PV) $39,000.00 Interest rate (r) 11.00% Length of loan (in years) 3 a. Setting up amortization table Formula Calculation of loan payment #N/A Year Beginning Balance Payment Interest 1 2 3 b. Calculating % of Payment Representing Interest and Principal for Each Year Year Payment...
The data on a loan has been collected in the Microsoft Excel Online file below. Open...
The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. a. Complete an amortization schedule for a $22,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $   $  ...
Using the below information open an excel file and create a Sales Budget, a Cash Receipt...
Using the below information open an excel file and create a Sales Budget, a Cash Receipt Schedule and a Production Budget for Fiwrt for the months of Oct, Nov, and Dec. Make sure to use proper format including dollar signs and headers - this will count in the grade. Upload the excel file as your response. Fiwrt Corporation manufactures and sells stainless steel coffee mugs. Expected mug sales (in units) are expected to be as follows: September – 32,000, October...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT