For a single die, A = 1 and B = 6. The correct Excel expression is given by:
RANDBETWEEN(1,6)
To simulate rolling a pair of dice, each die must be simulated and the results added together as follows:
1st Die + 2nd Die=RANDBETWEEN(1,6) + RANDBETWEEN(1,6)