• Fundamental Skills and Competencies in Ms Excel and Ms Access Questions

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