Quiz 4

What is the purpose of encrypting an Excel file?

• To allow anyone to open and edit the file

• To lock the file with a password so only authorized users can open it

• To enable hyperlinks in the file

• To remove all hyperlinks from the file

Which level of protection in Excel allows you to restrict users from adding or moving worksheets within a workbook?

• File-level protection

• Worksheet-level protection

• Workbook-level protection

• Cell-level protection

If you want users to click hyperlinks in a protected worksheet but not edit the sheet, what option must be enabled when protecting the sheet?

• Allow users to format cells

• Select locked cells

• Allow users to insert rows

• Allow users to delete columns

What happens if you protect a worksheet and uncheck "Select locked cells"?

• Users can click hyperlinks in locked cells

• Users cannot select or activate hyperlinks in locked cells

• Users can edit locked cells

• Users can insert new hyperlinks

Which Excel feature opens files from untrusted sources in a mode that disables most editing functions, including hyperlinks?

• Workbook protection

• Protected View

• Data Validation

• Macro Security

What is the first step to create a PivotTable in Excel?

• Select the Insert tab and click PivotTable after selecting your data range or table

• Format your data as a chart

• Protect the worksheet

• Create hyperlinks in your data

Where can you place a newly created PivotTable?

• Only in a new worksheet

• Only in an existing worksheet

• In either a new worksheet or an existing worksheet at a selected cell

• Only in a chart sheet

How do you start a formula in Excel?

• With a plus sign (+)

• With an equal sign (=)

• With a hashtag (#)

• With a dollar sign ($)

Which tab on the Ribbon contains options for formatting cells, such as font size and color?

• Insert

• Home

• Data

• Review