bus 110 Exam 2026 Questions and
Answers
By how many levels will Excel allow you to sort?
16
32
64
128 - Correct answer-64
Which one of the following filter options is not found on the text filter sub menu?
Begins With
Includes
Contains
Custom Filter - Correct answer-includes
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, Which one of the following filter options is not found on the number filter
submenu?
Greater Than...
Between...
Below Average
Bottom 10... - Correct answer-bottom 10
If you use the Icon sets conditional formatting, you are limited to how many
categories?
One, two, or three
Two, three, or four
Three, four, or five
Four, five, or six - Correct answer-3,4,or 5
What is true about adding a new field to the right side of an existing data table?
You must convert the table back to a range, add the field, then recreate the table.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2
Answers
By how many levels will Excel allow you to sort?
16
32
64
128 - Correct answer-64
Which one of the following filter options is not found on the text filter sub menu?
Begins With
Includes
Contains
Custom Filter - Correct answer-includes
©COPYRIGHT 2025, ALL RIGHTS RESERVED 1
, Which one of the following filter options is not found on the number filter
submenu?
Greater Than...
Between...
Below Average
Bottom 10... - Correct answer-bottom 10
If you use the Icon sets conditional formatting, you are limited to how many
categories?
One, two, or three
Two, three, or four
Three, four, or five
Four, five, or six - Correct answer-3,4,or 5
What is true about adding a new field to the right side of an existing data table?
You must convert the table back to a range, add the field, then recreate the table.
©COPYRIGHT 2025, ALL RIGHTS RESERVED 2