Fundamental Skills and Competencies in Ms Excel and Ms Access Questions – coursefighter.com
Fundamental Skills and Competencies in Ms Excel and Ms Access Questions – coursefighter.com
Business Finance – coursefighter.com
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