50 questions multiple and tf only

you shoule good at fundamental skills/and competencies in MS Excel and MS Access

sample quetsions

1. In Excel, a number can contain the characters _____.

a. 0 1 2 3 4 5 6 7 8 9

b. + – ( ) , /

c. $ % E e

d. all of the above

2. When Excel follows the order of operations, the formula 8 * 3 + 2, equals _____.

a. 40

b. 26

c. 48

d. 13

3. If the IF function =IF(b4>=$b$24, $b$19, 0) is assigned to cell B9, and the value in cell B4 is greater than the value in cell B24, Excel displays _____ in cell B9.

a. the value in cell B24

b. the value in cell B19

c. the value in cell B4

d. 0

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.