1) The Symbol in Excel for MULTIPLY a) b) c) 2) Excel Symbol for DIVIDE a) b) c) 3) Formulas always start with this symbol a) (brackets) b) = c) SUM d) =SUM 4) Autosum (=SUM) ONLY adds cells/range of cells a) b) 5) These can be found at the bottom of your spreadsheet with several tabs a) Workbook b) Worksheet c) Workcell 6) =B5*C5 is a... a) Function b) Formula c) Cell Reference 7) Identify Datatype a) Currency b) Date c) Header/Footer d) Time e) AVE (average) f) Percentage 8) Symbol/s for more than and equal to... a) <= b) > c) >= d) < 9) MIN, MAX & AVE are all inserted in the same way a) b) 10) To lock a cell reference within a formula so that it DOES NOT replicate, we format to... a) Relative cell reference b) Absolute cell reference c) Autosum cell reference 11) To apply Absolute Referencing I can press F4 OR manually type in the Dollar $ symbols a) b) 12) B2+D2*10% a) add cells B2 to D2 and multiply by 10 percent b) add cells B2 and D2 and multiply by 10 percent c) data and not a function or formula

Excel Keywords & Symbols

由
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?