Spreadsheets and Databases, Unit 7 Review

Norah is using a spreadsheet to organize her data in a table with rows and columns. What type of layout is Norah using?

• linear layout

• box layout

• vertical layout

• tabular layout

Which of the following terms refers to the entire collection of cells in an excel document?

• layout

• row

• column

• sheet

Up to how many sheets can a user create in Excel?

• 25

• 100

• 200

• 255

In a spreadsheet, which of the following runs horizontally and is labeled with numbers beginning with 1?

• column

• box

• cell

• row

Kerry has completed a comprehensive Excel document and she wants to share it with her group members. However, she does not want anyone in her group to edit the data. Under which tab can Kerry adjust the permissions and restrict editing for her spreadsheet?

• Layout

• Formulas

• View

• Review

Every formula used in an Excel spreadsheet begins with:

• a set of parentheses.

• a colon.

• a plus sign.

• an equal sign.

Moe is organizing a variety of different types of data using Microsoft Excel. How does he add an additional sheet to his document?

• click the File tab

• click the x icon on the right hand side of the window

• click the Tables tab

• click the + icon at the bottom of the screen

In the personal budget template in Excel, which of the following sheets documents the amount of money spent within a month?

• Summary

• Monthly Income

• Monthly Savings

• Monthly Expenses

Morgan is working on a spreadsheet in Excel. Under which of the following tabs can Morgan adjust the font and alignment used in the spreadsheet?

• Charts

• Layout

• Tables

• Home

By default, Ryan’s sheet has the title Sheet 1. How can Ryan change the name of his sheet in Excel?

• right click the Layout tab

• right click File then Open Recent

• right click the Edit tab

• right click on the Sheet 1 and choose Rename