Q90.
Technology
Ms. F is to summarize the last month’s sales performance in a table, by product. Using the
sales performance data, which of the following is an appropriate process to compute the
monthly sales performance by product?
a) 1. Calculate the total sales of products with the same “Product_name.”
2. Sort the data by “Category.”
3. Extract the data of products that were sold last month, based on “Sales_date.”
b) 1. Extract the data for last month, based on “Sales_date.”
2. Sort the extracted data by “Category.”
3. Calculate the total of unit prices for products in the same “Category.”
c) 1. Extract the data for last month, based on “Sales_date.”
2. Sort the extracted data by “Product_name.”
3. Calculate the total sales of products with the same “Product_name.”
d) 1. Sort the data by “Product_name.”
2. Calculate the total sales of products with the same “Product_name.”
3. Extract the data of products that were sold last month, based on “Sales_date.”
Q91.
Technology
To check the rate of increase in monthly sales by product, Ms. F is to compare the monthly
sales performance for last month and the month before last, by product. Which of the following expressions is used to calculate the rate of increase?
a) Sales performance last month – sales performance two months ago
b) (Sales performance last month – sales performance two months ago) / 2
c) (Sales performance last month – sales performance two months ago) /
Sales performance last month
d) (Sales performance last month – sales performance two months ago) /
Sales performance two months ago
333