BUSI 520 Week 11 Quiz Questions with complete solution 2025

BUSI 520 Week 11 Quiz Questions with
complete solution 2025
_____ can be used as a method to share data and a description of that data in
an open nonproprietary format for use by different programs.


A. XML
B. None of the answers listed.
C. HTTP
D. FTP
E. HTML - correct answer ✔A


True or False: To convert lowercase letters in a text string to uppercase, use
the UPPER function. - correct answer ✔True


True or False: You cannot use the Subtotal tool (in the Data menu/ribbon) on
data that has been converted to an Excel "Table." - correct answer ✔True


True or False: A database is a collection of fields that describe a specific
entity. - correct answer ✔False


The _____ function returns the serial number of the current date and time.


A. DATE
B. TODAY
C. TIME
D. None of the answers listed.

, E. NOW - correct answer ✔E


To remove spaces from a text string, except for spaces between words, use
the _____ function.


A. TRIM
B. REMOVE
C. SPACE
D. None of the answers listed.
E. TEXT - correct answer ✔A


_____ is a function that will return the number of years between two dates.


A. DAYS360
B. All of the answers listed.
C. None of the answers listed.
D. YEAR
E. YEARFRAC - correct answer ✔E


The _____ function returns the serial number of the date that is the indicated
number of months before or after the start_date.


A. DAY
B. EDATE
C. WEEKNUM
D. EOMONTH
E. None of the answers listed. - correct answer ✔B