Online Access Free Desktop-Specialist Practice Test

For Bullet Graphs we need at least ____________ measures

• A.4
• B.3
• C.2
• D.1

________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

• A..tbm
• B..tde
• C..tds
• D..twb

You have the following string value: Sales Data.
Which calculated field produces an output of Sales?

• A.LTRIM("Sales Data")
• B.LEFT ("Sales Data")
• C.LEFT ("Sales Data", 5)
• D.RTRIM( "Sales Data")

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

• A..tbm file
• B..twb file
• C..twbx file
• D..tde file

If you see the following Filter, then you're working with _______________________ Larger image

• A.Date Parts
• B.Grouped Dates
• C.Date Functions
• D.Date Values