1) What is represented with a letter a) Column b) Row c) Cell 2) What is represented with a number a) Column b) Row c) Cell 3) What must all formulae begin with? a) = b) Cell Reference eg A1 c) SUM d) Function 4) B3 is an example of a a) Column b) Row c) Cell Reference 5) What happens when you press the Enter key after typing a formula into a cell? a) The formula moves to the next cell. b) The formula is deleted. c) Nothing happens. d) The formula is executed, and the result is displayed. 6) Which of the following formulae correctly calculates the sum of cells A1 to A5? a) =SUM(A1-A5) b) =sum(A1:A5) c) =SUM(1A:5A) d) =SUM(A1,A5) 7) What is essential when using formulae and functions in Excel? a) Using emojis b) Using different font styles c) Using cell references d) Using random numbers 8) To quickly sum cells in Excel, which shortcut keys can you use? a) Ctrl + = b) Shift + = c) F3 + = d) Alt + =

Excel Quiz

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?