ChatGPT

$1$CWK$50-$ O$..$

ChatGPT

In a PESTEL...

PESTEL anal...

Sign ou

Dashboard Myareas My Media Student Help $vv$ Staff Help $vv$

$\backslash$table$[[,$A$,B,$C$,$D$],[1,$Monthly production,$],[2,,,,],[3,$Month,Alpha,Beta,Gamma$],[4,$Jan,$149,152,],[5,$Feb,$247,365,],[6,$Mar,$382,456,],[7,$Apr,$451,854,],[8,$May,$300,125,],[9,$Jun,$298,148,],[10,$Jul,$187,854,],[11,$Aug,$361,632,],[12,$Sep,$85,320,],[13,$Oct,$394,321,],[14,$Nov,$322,465,],[15,$Dec,$400,157,],[16],[17,$Total,$3576,,],[18],[19,$Average,$298,,]]$

The information in the table shows a schedule of working for a production department

Which of the following would achieve the total in Cell C$17$

What is the best formula to put in cell B$19,$ which makes it easy to copy the formula across for Beta and Gamma?

If a cell contains ####$,$ this means

Choose...

$?$