Excel: Tips and Tricks

Which of the following best describes Excel?

• A database app.

• The coolest app of all time!

• A text file processing app.

• A spreadsheet and data processing app.

Excel is saved as workbooks made up of multiple ______________.

• Spreadsheets

• Cells

• Rows

• Columns

What's wrong with this absolute reference?

=$c1+A2

• Nothing, it's a perfect reference!

• It's missing a $ in front of the 1.

• There should be no $ in front of the C.

• A is missing a $ in front of it.

True or False: In Excel you can use IF THEN statements to create conditional data processes.

• True

• False

Which control allows you to lock a row or column in place to use as a reference?

• The lock button.

• The freeze pane button.

• The function button

• The Windows button.