Excel Competency Exam Practice Test
The contents of this exam are based on the topics provided here:
https://www.bauer.uh.edu/departments/undergraduate-advising-center/current-
students/excel_topics.php
Solutions provided at the end of this document.
Topic 1:
1. The AutoAdd function adds up numbers in a column or row you specify.
a) True
b) False
2. "AAA" is an example of a ____ in Excel.
a) cell reference
b) column heading
c) name box
d) row heading
3. _______ quickly highlight(s) important information in a spreadsheet that match your criteria by
applying formatting options, data bars, color scales, or icon sets.
a) cell references
b) conditional formatting
c) Excel tables
d) pivot tables
Topic 2:
4. The best formula to calculate Profits for January is:
a) =SUM(B2:B3)
b) =B2-B3
c) =B4-(B2+B3)
d) =A4-(A2+A3)
e) =SUBTRACT(B2:B3)