1) What is a formula in Excel? a) a chemical experiment b) a calculator c) a calculation d) a potion 2) What is a function in Excel? a) a banquet b) a cell name c) a pre-defined formula d) a worksheet 3) What does cell referencing mean in formula and functions? a) the value in the cell is used rather than the cell address b) the cell address is used rather than the value in the cell c) the name of the function being used 4) What is a relative cell reference? a) the cell address changes relative to the row or column it is copied to b) the cell address does not change no matter where it is copied to c) a cell that relates to another cell 5) What is an absolute cell reference in a formula? a) the cell address does not change no matter where it is copied to b) the cell address does change every time it is copied to another location c) the cell address must be entered 6) How do you make a cell absolute? a) use the F2 Key b) use the F3 key c) use the F4 key d) use the F5 key 7) Which of the following formulae contains an absolute cell reference? a) =A2+B2 b) =A2*B$2$ c) =A2*$B$2

Formula, Functions & Cell Referencing

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?