Crestsage/TQ Excel Training

You are using Microsoft Excel Online to analyze your company's quarterly performance data. After making several adjustments to your spreadsheet, you want to ensure that your work is saved. What should you do?

• Click on the save icon in the upper right corner of the screen.

• Go to the "File" menu and select "Save As" to save your changes.

• Press Ctrl + S on your keyboard to save your work.

• All changes are saved automatically, so no action is needed.

You are analyzing the sales data for office chairs and need to determine the total revenue generated from the second order. In this second order, 8 chairs were sold (cell D3) and the price per chair is $85 (cell E3). What formula would you use to calculate the total revenue for this order?

• = D3 x E3

• = D3 + E3

• = D3 / E3

• = D3 * E3

Bashir is analyzing the sales data for office desks and wants to calculate the total profits for the year 2024. What function would she use to calculate the total profits, which are located in the cell range B2 to B220?

• = TOTAL (B2 : B220)

• = SUM ( B2 : B220)

• = B2 + B220

• = B2 : B220

Chidinma is performing an analysis on the popularity of the office desk models sold in 2024 and has written the following SUMIF function: = SUMIF (A2:A220, I7, D2:D220) For reference - The model names in the sales data are in column A. - Cells I7 to I10 have the names of the 4 models that are sold. - The number of items sold in each order are in column D. The SUMIF function works fine in the first cell, but he gets an error when dragging the function to the other cells. Why could this be?

• You did not use the dollar sign to anchor the range and sum range.

• You did not use the dollar sign to anchor the criteria cell.

• The information for the criteria cell is not correct.

Jumoke has recorded the monthly expenses for office supplies in the cell range K1 (January) to K12 (December). What formula would you use to find the total expenses for the year?

• = SUM( K1 : K12 )

• = TOTAL (K1 : K12)

• = K1 + K12

• = AVERAGE (K1 : K12)