Excel Expert 1 Quizizz

What folder do you always save your work to when using gmetrix?

• documents

• GmetrixTemplates

• Custom Office Templates

• My Data Sources

Edit the custom property Review to have a value of Hideki Tomo. What are the first few steps ?

• file tab, properties drop down, custom tab, etc

• file tab, properties drop down, general tab, etc

• file tab, properties drop down, summary tab, etc

• file tab, properties, type Hideki Tomo in the title, etc

Require a password to open the current workbook using the password ReviewHR9. What tab do you go to first?

• file

• developer

• formulas

• view

What's the first 2 steps you should do? See picture

• click on the Employee Data Worksheet, review tab

• click on the review tab, click on the protect sheet button in the protect group

• click on the Employee Data Pivot Chart Worksheet, review tab

• click on the file tab, click on the protect workbook button

Track all changes that have ever been made by any shared document, only highlight changes when lasted saved. What tab do you go to first?

• review

• view

• page layout

• insert

What tab is this?

• view

• review

• developer

• data

What tab is this?

• view

• review

• developer

• data

Use the Trace Precedents for cell G18 to determine the problem, and fix the formula. What are the rest of the steps after you select G18?

• formulas tab, formula auditing group click Trace Precedents, home tab editing group, autosum, click sum, hit enter key

• formulas tab, formula auditing group click Trace Dependents

• formulas tab, formula auditing group click Trace Precedents

• formulas tab, formula auditing group click Trace Dependents,home tab editing group, autosum, click sum, hit enter key

Configure Excel formulas to have the R1CI reference style and enable Error Checking using the color Blue. What are the few steps?

• file tab, click options, click on formulas

• file tab, click options, click on general

• file tab, click options, click on save

• none of the above

How do you add watches to cell I4?

• formulas tab, formula auditing group, click watch window, add watch, select I4, click ok

• formulas tab, formula auditing group, click watch window, delete watch, select I4, click ok

• select I4, formulas tab, formula auditing group, click watch window

• formulas tab, formula auditing group, click watch window, add watch, select L4, click ok