Fundamental Skills and Competencies in Ms Excel and Ms Access Questions

Question Description

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

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$
Need Help? Reach us here via Whatsapp.