Mathematical and Physical Journal
for High Schools
Issued by the MATFUND Foundation
 Already signed up? New to KöMaL?

# Problem I. 399. (March 2016)

I. 399. The first spreadsheet application, VisiCalc, was created by Dan Bricklin and Bob Frankston in 1979. Although the program development ended in 1985, the application (with text-based interface and occupying only approx. 28 KB) can still be found on the Internet at http://www.bricklin.com/history/vcexecutable.htm. It can directly be run under 32-bit Windows 7; under Windows 10, for example, some emulator (like DosBox) is necessary. The VisiCalc manual is available at http://toastytech.com/manuals/VisiCalc%201.1.pdf.

In this task you are going to process data of a grocery store from the first half of 1979. Columns A and B contain the code of sold items in chronological order, and the sold amount. The range F2:H8 contains the item codes, names and unit prices.

1. By using VisiCalc, open the file visi.vc and solve the following tasks. The sheet containing your solution should be saved as noszt.vc.

2. By using a function in cell C2, determine the unit price of the item in cell A2.

3. By using a formula in cell D2, compute the total price of the item whose quantity is found in B2 and unit price in A2.

4. Copy the formula in cells C2 and D2 to the cells beneath them up to line 50.

5. Determine the sold amount for each item in the range I2:I8. You can use auxiliary columns to the right of column L.

6. Determine the income from each item in the range J2:J8.

7. Fill the range F9:J9 with a horizontal dashed line.

8. By using a formula in the range G10:G13, determine the number of items that can be purchased, the average income from the items, the total income, and the maximum income.

9. Set the cell width to 11 characters.

10. Display in column K the relative income for each item by using ,,$\displaystyle \mathtt{*}$'' characters so that the maximum income is represented by 10 ,,$\displaystyle \mathtt{*}$'' characters.

The file noszt.vc should be submitted in a compressed file i399.zip.