What does this formula do? =Sum(Sheet1:Sheet4!D18)
It adds data from cell D18 of Sheet1 and cell D18 of Sheet4 It adds data from cell A1 of…
Multiple choice questions & answers (MCQs),
It adds data from cell D18 of Sheet1 and cell D18 of Sheet4 It adds data from cell A1 of…
Value Formatting Cell Style Formatting Conditional Formatting Tabular format
Fill color Font Color Pattern Style Cell Style
=MAXIMUM (H2:H30) =MAX(H2:H30) =LARGE (H2:H30, 29) =UPPER(H2:H30,1)
OR(B3=>15,B3<=20) AND (B3>=15,B3<=20) OR(B3>15,B3<20) AND(B3>15, B3<20)
pie chart XY scatter chart bar chart line chart
Cell style Fill color Pattern style Font color