AVID Protools 110 Certification Exam Questions And
Answers Practice Questions with Solutions Newest |
Already Graded A+
1. Which of the following views requires at least two date columns to be displayed?
A. Resource Sheet
B. Task Sheet
C. Calendar
D. Gantt
Answer: D
Rationale: The Gantt view is a timeline-based view that visually represents tasks and their durations,
which requires both start and end date columns to render the horizontal bars. Other views like Resource
Sheet, Calendar, or Task Sheet may function with a single date or no date columns.
2. Which view requires two date columns to be displayed?
A. Gantt
B. Task Usage
C. Resource Sheet
D. Calendar
Answer: A
Rationale: The Gantt view displays tasks as bars along a timeline, which requires both a start date and
an end date (two date columns) to render correctly. Other views like Task Usage or Resource Sheet do
not inherently need two date columns for display.
3. The "Send..." action, available from the row menu, allows you to provide a view-only version of
one or more rows to anyone you specify. Which two of the following options can be customized?
A. The expiration date of the shared link
B. The ability for recipients to edit the rows
C. Whether to include attachments in the rows
D. File format of the rows (PDF or Excel)
Answer: D
Rationale: The "Send..." action is designed to share a view-only snapshot, so recipients cannot edit the
rows. The customization options are limited to the file format (PDF or Excel) and the specific rows
included; expiration dates and attachment inclusion are not configurable in this feature.
Page 1
,4. Joy is the director of a sales team that manages its pipeline in Smartsheet. Whenever an
opportunity status is changed to "Closed Lost", team members should provide details in a column
called "Reason Won/Lost". What is an automated way for Joy to ensure that reps fill out this
column if they initially fail to do so?
A. Use conditional formatting to highlight the row red when the status is "Closed Lost" and the "Reason
Won/Lost" column is empty.
B. Create a formula in the "Reason Won/Lost" column that displays a reminder message when the status is
"Closed Lost".
C. Set up a workflow that sends an automated Update Request when the opportunity status changes to "Closed
Lost" and the "Reason Won/Lost" column is blank.
D. Set up a report that filters for rows where the status is "Closed Lost" and the "Reason Won/Lost" column is
blank, and manually email the rep each time.
Answer: C
Rationale: Option A is correct because it automates the request for information exactly when needed,
ensuring reps fill out the column promptly. The other options either rely on manual follow-up, delayed
reporting, or incorrect data entry.
5. Through which of the following cannot the data sent to and from 3CX be routed?
A. Transparent proxy
B. HTTP proxy
C. HTTPS proxy
D. SOCKS proxy
Answer: C
Rationale: 3CX uses HTTPS for secure communication, and an HTTPS proxy is designed to handle such
traffic. The other proxy types are not specifically for HTTPS or may not support the encryption required.
6. What can NAT be used in conjunction with to restrict access to a server?
A. VPN
B. Firewall
C. ACL
D. DNS
Answer: C
Rationale: NAT can be used with Access Control Lists (ACLs) to limit which external hosts can access
internal servers. ACLs define permitted or denied traffic based on IP addresses or ports.
7. Based on the settings shown above, what permission level would Don Miller have on the sheet?
A. Contributor
B. Editor
C. Viewer
D. Owner
Answer: B
Rationale: The settings indicate that Don Miller has the ability to edit the sheet, which corresponds to the
'Editor' permission level. 'Viewer' only allows read access, 'Contributor' typically allows adding
Page 2
,comments but not editing, and 'Owner' has full administrative rights beyond editing.
8. In the context of conditional formatting rules applied to a cell or range, which rule takes priority
when multiple rules apply?
A. The one that was created most recently
B. The one with the most specific condition
C. The one with the highest numerical value in the rule condition
D. The one on the top
Answer: D
Rationale: Conditional formatting rules are evaluated in order from top to bottom. The first rule that is
true is applied, so the rule at the top of the list has priority over those below it.
9. Through which of the following options can a report be published?
A. FTP (File Transfer Protocol)
B. iCal (calendar)
C. WebDAV
D. Email (SMTP)
Answer: B
Rationale: Reports in Pro Tools can be published directly to an iCal calendar, allowing users to share
session timelines and notes in a calendar format. The other options are not supported for report
publishing in Pro Tools.
10. You want to keep track of new attachments as they are added to a sheet. Which of the following
is the best way to achieve this goal?
A. Manually check the sheet periodically for new attachments
B. Set up a filter to show only rows with attachments
C. Create an alert to notify you when an attachment is added or changed
D. Use a formula to count attachments in the sheet
Answer: C
Rationale: Alerts provide automatic notifications when attachments are added or changed, ensuring you
are immediately informed without manual effort. Manual checking is inefficient, filters only display
existing attachments without tracking changes, and formulas cannot detect new additions in real time.
11. You want to display a count of at-risk tasks on a dashboard. One approach is to use a
dropdown column to mark a task as at-risk. Which other column type can be used to mark at-risk
items that can be counted and displayed on a dashboard?
A. Checkbox Column
B. Number Column
C. Symbol Column
D. Text Column
Answer: C
Page 3
, Rationale: A Symbol column allows you to assign symbols (like flags or icons) to rows, which can be filtered and counted in
dashboard widgets. Text, Number, and Checkbox columns do not provide the same visual marking and counting flexibility for
at-risk status.
12. When entering formulas in Smartsheet, cell references use the syntax of column name and row
number. What symbol must be placed around a column name when it includes a space, special
character, or number?
A. { } Curly braces
B. ( ) Parentheses
C. " " Quotation marks
D. [ ] Square brackets
Answer: D
Rationale: In Smartsheet formulas, square brackets are required to enclose column names containing
spaces, special characters, or numbers to ensure proper parsing. Parentheses are used for grouping
expressions, quotation marks for text strings, and curly braces are not used for this purpose.
13. Changes in cell formatting can be used to capture the attention of a user. Which of the following
features allows collaborators to see updates since they last viewed the sheet?
A. Cell comments
B. Conditional formatting
C. Version history
D. Highlight changes
Answer: D
Rationale: Highlight changes is a feature that visually marks cells that have been modified since the last
time the sheet was viewed, making it easy for collaborators to see what has been updated. Conditional
formatting applies rules to cells based on their values, not changes. Cell comments are notes attached to
cells, and version history shows past versions but not changes since last view.
14. Which two methods allow you to add additional fields to a report beyond those already used as
criteria?
A. Go to the File menu, choose "Report Properties", and then add fields under the "Fields" tab.
B. Use the keyboard shortcut Ctrl+Shift+F to open the field picker and select new fields.
C. Right-click on the report header and select "Add Field" from the context menu.
D. In the toolbar, click the "Columns Displayed" button and add additional columns.
Answer: D
Rationale: The correct method is to click the "Columns Displayed" button in the toolbar, which allows
you to add or remove columns from the report view. The other options are not standard methods for
adding fields in this context.
15. When creating a form, which type of field allows you to input a default value into a column on
a sheet without requiring the form submitter to create it?
A. Hidden
Page 4
Answers Practice Questions with Solutions Newest |
Already Graded A+
1. Which of the following views requires at least two date columns to be displayed?
A. Resource Sheet
B. Task Sheet
C. Calendar
D. Gantt
Answer: D
Rationale: The Gantt view is a timeline-based view that visually represents tasks and their durations,
which requires both start and end date columns to render the horizontal bars. Other views like Resource
Sheet, Calendar, or Task Sheet may function with a single date or no date columns.
2. Which view requires two date columns to be displayed?
A. Gantt
B. Task Usage
C. Resource Sheet
D. Calendar
Answer: A
Rationale: The Gantt view displays tasks as bars along a timeline, which requires both a start date and
an end date (two date columns) to render correctly. Other views like Task Usage or Resource Sheet do
not inherently need two date columns for display.
3. The "Send..." action, available from the row menu, allows you to provide a view-only version of
one or more rows to anyone you specify. Which two of the following options can be customized?
A. The expiration date of the shared link
B. The ability for recipients to edit the rows
C. Whether to include attachments in the rows
D. File format of the rows (PDF or Excel)
Answer: D
Rationale: The "Send..." action is designed to share a view-only snapshot, so recipients cannot edit the
rows. The customization options are limited to the file format (PDF or Excel) and the specific rows
included; expiration dates and attachment inclusion are not configurable in this feature.
Page 1
,4. Joy is the director of a sales team that manages its pipeline in Smartsheet. Whenever an
opportunity status is changed to "Closed Lost", team members should provide details in a column
called "Reason Won/Lost". What is an automated way for Joy to ensure that reps fill out this
column if they initially fail to do so?
A. Use conditional formatting to highlight the row red when the status is "Closed Lost" and the "Reason
Won/Lost" column is empty.
B. Create a formula in the "Reason Won/Lost" column that displays a reminder message when the status is
"Closed Lost".
C. Set up a workflow that sends an automated Update Request when the opportunity status changes to "Closed
Lost" and the "Reason Won/Lost" column is blank.
D. Set up a report that filters for rows where the status is "Closed Lost" and the "Reason Won/Lost" column is
blank, and manually email the rep each time.
Answer: C
Rationale: Option A is correct because it automates the request for information exactly when needed,
ensuring reps fill out the column promptly. The other options either rely on manual follow-up, delayed
reporting, or incorrect data entry.
5. Through which of the following cannot the data sent to and from 3CX be routed?
A. Transparent proxy
B. HTTP proxy
C. HTTPS proxy
D. SOCKS proxy
Answer: C
Rationale: 3CX uses HTTPS for secure communication, and an HTTPS proxy is designed to handle such
traffic. The other proxy types are not specifically for HTTPS or may not support the encryption required.
6. What can NAT be used in conjunction with to restrict access to a server?
A. VPN
B. Firewall
C. ACL
D. DNS
Answer: C
Rationale: NAT can be used with Access Control Lists (ACLs) to limit which external hosts can access
internal servers. ACLs define permitted or denied traffic based on IP addresses or ports.
7. Based on the settings shown above, what permission level would Don Miller have on the sheet?
A. Contributor
B. Editor
C. Viewer
D. Owner
Answer: B
Rationale: The settings indicate that Don Miller has the ability to edit the sheet, which corresponds to the
'Editor' permission level. 'Viewer' only allows read access, 'Contributor' typically allows adding
Page 2
,comments but not editing, and 'Owner' has full administrative rights beyond editing.
8. In the context of conditional formatting rules applied to a cell or range, which rule takes priority
when multiple rules apply?
A. The one that was created most recently
B. The one with the most specific condition
C. The one with the highest numerical value in the rule condition
D. The one on the top
Answer: D
Rationale: Conditional formatting rules are evaluated in order from top to bottom. The first rule that is
true is applied, so the rule at the top of the list has priority over those below it.
9. Through which of the following options can a report be published?
A. FTP (File Transfer Protocol)
B. iCal (calendar)
C. WebDAV
D. Email (SMTP)
Answer: B
Rationale: Reports in Pro Tools can be published directly to an iCal calendar, allowing users to share
session timelines and notes in a calendar format. The other options are not supported for report
publishing in Pro Tools.
10. You want to keep track of new attachments as they are added to a sheet. Which of the following
is the best way to achieve this goal?
A. Manually check the sheet periodically for new attachments
B. Set up a filter to show only rows with attachments
C. Create an alert to notify you when an attachment is added or changed
D. Use a formula to count attachments in the sheet
Answer: C
Rationale: Alerts provide automatic notifications when attachments are added or changed, ensuring you
are immediately informed without manual effort. Manual checking is inefficient, filters only display
existing attachments without tracking changes, and formulas cannot detect new additions in real time.
11. You want to display a count of at-risk tasks on a dashboard. One approach is to use a
dropdown column to mark a task as at-risk. Which other column type can be used to mark at-risk
items that can be counted and displayed on a dashboard?
A. Checkbox Column
B. Number Column
C. Symbol Column
D. Text Column
Answer: C
Page 3
, Rationale: A Symbol column allows you to assign symbols (like flags or icons) to rows, which can be filtered and counted in
dashboard widgets. Text, Number, and Checkbox columns do not provide the same visual marking and counting flexibility for
at-risk status.
12. When entering formulas in Smartsheet, cell references use the syntax of column name and row
number. What symbol must be placed around a column name when it includes a space, special
character, or number?
A. { } Curly braces
B. ( ) Parentheses
C. " " Quotation marks
D. [ ] Square brackets
Answer: D
Rationale: In Smartsheet formulas, square brackets are required to enclose column names containing
spaces, special characters, or numbers to ensure proper parsing. Parentheses are used for grouping
expressions, quotation marks for text strings, and curly braces are not used for this purpose.
13. Changes in cell formatting can be used to capture the attention of a user. Which of the following
features allows collaborators to see updates since they last viewed the sheet?
A. Cell comments
B. Conditional formatting
C. Version history
D. Highlight changes
Answer: D
Rationale: Highlight changes is a feature that visually marks cells that have been modified since the last
time the sheet was viewed, making it easy for collaborators to see what has been updated. Conditional
formatting applies rules to cells based on their values, not changes. Cell comments are notes attached to
cells, and version history shows past versions but not changes since last view.
14. Which two methods allow you to add additional fields to a report beyond those already used as
criteria?
A. Go to the File menu, choose "Report Properties", and then add fields under the "Fields" tab.
B. Use the keyboard shortcut Ctrl+Shift+F to open the field picker and select new fields.
C. Right-click on the report header and select "Add Field" from the context menu.
D. In the toolbar, click the "Columns Displayed" button and add additional columns.
Answer: D
Rationale: The correct method is to click the "Columns Displayed" button in the toolbar, which allows
you to add or remove columns from the report view. The other options are not standard methods for
adding fields in this context.
15. When creating a form, which type of field allows you to input a default value into a column on
a sheet without requiring the form submitter to create it?
A. Hidden
Page 4
