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

Cetak
Menyematkan

Papan Peringkat

Gaya visual

Pilihan

Berganti templat

Pulihkan simpan otomatis: ?