Using the OpenOffice (OpenOffice Download) spreadsheet, Calc, complete the assig

Question

Using the OpenOffice (OpenOffice Download) spreadsheet, Calc, complete the assignment9 spreadsheet

concordia.blackboard.com/bbcswebdav/pid-636616-dt-content-rid-3541075_1/xid-3541075_1

Download the assignment9 spreadsheet and open the data file in Calc (the OpenOffice spreadsheet). The document contains three spreadsheets. Review the information on cell references in the first sheet. Using the third sheet as a guide, complete the second sheet, assignment9.

In order to complete the assignment, use appropriate relative and absolute cell addressing in your formulas. Use appropriate spreadsheet functions to compute: average, slowest, fastest, and number. (You should remove the blue “comment” text within the assignment spreadsheet.) Enter your own data for “commuting miles” and the “minutes” for each day (you may make up values, of course).

Feel free to use the help feature within Calc and any other online reference material to determine the appropriate functions to use.

Once you have completed the assignment, upload the assignment9.ods file.

I will answer questions regarding step 1 of the problem solving process, Understand the Problem. However, I will not answer questions regarding steps 2 - 4 of the problem solving process for this assignment. You must be a problem solver and figure it out. Be sure to plan and design before you begin implementation in the spreadsheet.

***Important***

Temporary Login:

Username: F00439700

Login: Basketball99

Explanation / Answer

It is normal to add the date to a spreadsheet. Built into Open Office Calc are a number of DATE functions that can be used to do this.

Click on cell C4.
Type = TODAY ( )
Press the ENTER key on the keyboard.
The current date should appear in cell C4

Change font color

1) Click the cell of the spreadsheet which you want to be the top left

of your data including the column names.

2) Press F4 to open the database source window and select the table

containing the data you want to use.

3) Select the rows of data you want to add to the spreadsheet:

• Click the gray box to the left of the row you want to select if

only selecting one row. That row is highlighted.

• To select multiple adjacent rows, hold down the Shift key

while clicking the gray box of the rows you need.

• To select multiple separate rows, hold down the Control key

while selecting the rows. The selected rows are highlighted.

• To select all the rows, click the gray box in the upper left

corner. All rows are highlighted.

4) Click the Data to text icon to insert the data into the

spreadsheet cells.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.