TR - BITM215 Excel Exam 3

What is the purpose of grouped worked sheets?

• To detect hackers

• To see how changes in data affects formulas on other worksheets

• To see how changes in data affect tables

• To apply formatting or data to multiple sheets at the same time

• To conflate absolute and relative references

Hyperlinks can point to:

• Only external websites

• Only internal locations of a single worksheet

• Only internal locations of a single workbook

• Any combination of websites or workbook

• Any combination of websites or workbook locations

Split screen windows:

• Are used to view two sections of the same workbook

• Are used to view multiple websites at the same time

• Are used to create an overlay window

• Are used to identify problems with formulas

• Are used to view external data, like websites

What is the purpose of a 3-D workbook?

• To have graphics that pop

• To create holograms

• Organizing data from a database

• To collect worksheets into a workbook

• To work with data across multiple worksheets

What is the purpose of linking workbooks?

• To make sure that there is always a backup

• To work with data across multiple worksheets

• To make sure that valid data is being collected

• To work with data sources across multiple workbooks

• To make sure that source data is valid and complete

What two traces are provided by the audit options?

• Forwards, Backwards

• Precedent, Dependents

• Vertical, Horizontal

• Workbook, Worksheets

• Internal, External

What is the purpose of a Watch Window?

• To detect hackers

• To see how changes in data affect formulas on another table

• To see how changes in data affect tables

• To arrange windows in an easy-to-read format

• To conflate absolute and relative references

What is the purpose of data validation?

• To detect hackers

• To see how changes in data affect formulas on another table

• To see how changes in data affect tables

• To limit the number of data entry errors

• To conflate absolute and relative references

If you password protect a workbook and you forget the password, how can you recover the password?

• Call Microsoft tech support

• Use online Microsoft office support

• You can't recover a workbook protection password

• The default recovery password is "Password"

• The default recovery password is "MSOffice365"

What type(s) of data cannot be imported into Excel?

• Open-source data

• Data tables from websites

• Audio and video data

• Databases, like Access

• Comma Separated Value (CSV) data