Skip to document
Welcome to StudocuSign in to access the best study resources
Guest user
0followers
HomeMy LibraryAsk AI
  • You don't have any recent items yet.
My Library
  • You don't have any courses yet.
  • You don't have any books yet.
  • You don't have any Studylists yet.

Excel Competencey Exam Practice Test 2018 Su

dhe dve d dvd d d d dvdvd d d f d d r
Course

Mathematics

666 Documents
Students shared 666 documents in this course
Academic year: 2019/2020
Uploaded by:
Anonymous Student
This document has been uploaded by a student, just like you, who decided to remain anonymous.
Technische Universiteit Delft

Recommended for you

Comments

Please sign in or register to post comments.

Students also viewed

Related documents

Preview text

Excel Competency Exam Practice Test

The contents of this exam are based on the topics provided here: bauer.uh/departments/undergraduate-advising-center/current- students/excel_topics

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:

  1. The best formula to calculate Profits for January is: a) =SUM(B2:B3) b) =B2-B c) =B4-(B2+B3) d) =A4-(A2+A3) e) =SUBTRACT(B2:B3)

  2. The best formula to calculate the Average for Profits is: a) =(B4+C4+D4)/ b) =MEAN(B4:E4) c) =AVERAGE(B4:D4) d) =AVERAGE(B4:E4)

  3. As a general rule, Excel will _____-align numbers. a) right b) left c) top d) bottom

Topic 3: 7. Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5? a) =C1+C b) =$C1+$C c) =D2+D d) =E6+E

  1. When you copy a formula that contains an absolute reference to a new location, the reference ____. a) is updated automatically b) does not change c) becomes bold d) has a dotted outline in its cell

  2. Which of the following is a logical function? a) AVERAGE b) IF c) SUMPRODUCT d) VLOOKUP

  3. The words "Pre-sales" and “Conference Attendance” in the image above are called the chart ______: a) accent b) key c) labels d) legend

Topic 5: 13. ____ order arranges content in reverse alphabetical order, from Z to A. a) Reverse b) Major c) Ascending d) Descending

  1. _______ are a powerful tool to quickly group, summarize, and rearrange larger datasets. a) Cell references b) Functions c) Pivot tables d) Ranges

  2. Selecting the “Food” button on the slicer on the right will mean that the data table on the left will: a) Show items that match “Food” only. b) Show items that match everything except for “Food”. c) Not be impacted by the “Food” slicer at all. d) All of the above.

Topic 6: 16. A worksheet ____ is a collection of two or more selected worksheets. a) index b) roster c) group d) cluster

  1. A reference that refers to the same cell or range on multiple sheets is called a(n) __________ reference. a) 3-D b) Clustered c) Indexed d) Pivotal

Topic 7: 18. A(n) _______________ helps automate repetitive tasks in Excel by recording your steps. a) formula b) macro c) solver d) process

  1. You can use data ___________ to restrict the type of data or the values that users enter into a cell. a) auditing b) checking c) tracking d) validation

Topic 8: 20. The ______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. a) AND b) OR c) SOME d) LOOKUP

  1. To determine the number of sales people by region who have 50 or more orders, we use the: a) COUNT b) COUNTA c) COUNTIF d) COUNTIFS

Solutions

  1. False
  2. b
  3. b
  4. b
  5. c
  6. a
  7. c
  8. b
  9. b
  10. a
  11. d
  12. d
  13. d
  14. c
  15. a
  16. c
  17. a
  18. b
  19. d
  20. b
  21. d
  22. c
  23. d
  24. c
  25. b
Was this document helpful?

Excel Competencey Exam Practice Test 2018 Su

Course: Mathematics

666 Documents
Students shared 666 documents in this course

University: Sikkim Manipal University

Was this document helpful?
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)

Students also viewed

Related documents