Scribd
Upload
49 views2 pages

Exercises

The document outlines a practical assessment for spreadsheet skills, detailing tasks such as selecting data, formatting cells, and using formulas. It includes specific instructions for manipulating a dataset of grocery items, including inserting rows, formatting currency, and calculating totals. Additionally, it asks for a screenshot or detailed explanation of the completed tasks as submission instructions.

Uploaded by

mugoteresawairimu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
49 views2 pages

Exercises

The document outlines a practical assessment for spreadsheet skills, detailing tasks such as selecting data, formatting cells, and using formulas. It includes specific instructions for manipulating a dataset of grocery items, including inserting rows, formatting currency, and calculating totals. Additionally, it asks for a screenshot or detailed explanation of the completed tasks as submission instructions.

Uploaded by

mugoteresawairimu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PRACTICAL QUESTION

Spreadsheet Skills Assessment Question

You are given the following dataset in a spreadsheet:

A B C D E

Item Category Price ($) Quantity Total ($)

Apple Fruit 2.50 10

Banana Fruit 1.20 15

Carrot Vegetable 0.90 20

Potato Vegetable 1.50 25

Perform the following tasks using spreadsheet software:

1. Selection:

o Select the entire table (A1:E5). What keyboard shortcut can you use to select all the data in the
spreadsheet?

2. Working with Columns and Rows:

o Insert a new row above the first row and add a title "Grocery List" (merge and center it across
columns A to E).

o Resize Column A to fit the longest item name.

3. Number Formatting:

o Format the values in column C and column E as currency with two decimal places.

4. Text Formatting:

o Make the column headers (Row 2) bold and change their background color to light gray.

5. Cell Formatting:

o Apply a border around the entire table, including the headers.

6. Tables:

o Convert the dataset into a table and apply a built-in table style. What is the benefit of using a
table in spreadsheets?

7. Formulas:

o In E3, enter a formula to calculate the total cost (Price × Quantity) for Apples.
o Copy the formula down to fill in the rest of the Total ($) column.

8. Cut, Copy, and Pasting:

o Copy the row containing Carrot and paste it at the bottom of the table as a new row.

o Cut the row containing Potato and move it above Banana.

9. Bonus:

o What formula would you use to calculate the total cost of all items in column E?

Submission Instructions:

Provide a screenshot of your completed spreadsheet or explain each step in detail.

You might also like