CS Unit 7 Spreadsheet Test

Which of the following spreadsheet applications is free to use online and provides the best collaboration tools for letting multiple people work on a spreadsheet at the same time?

• Google Sheets

• Apple Numbers

• LibreOffice Calc

• Microsoft Excel

Which of the following Excel spreadsheet formulas (calculations) can you enter in cell C2 to add the Deposit and Monthly Rent in the worksheet below?

• sum=A2+B2

• A2+B2

• =A2+B2

• =A2plusB2

In the Math Class worksheet below, you want to insert a new column between Grade (Points) and Grade (Letter). How do you insert the new column between these existing columns?

• Right-click the B column heading and select Insert.

• Click the C column heading, and then select Editing > Insert.

• Click the B column heading, and then select Editing > Insert.

• Right-click the C column heading and select Insert.

Which of the following spreadsheet tools is one of the most powerful and popular spreadsheet applications and has the most advanced statistical analysis tools?

• Google Sheets

• LibreOffice Calc

• Microsoft Excel

• Apple Numbers

Which of the following is the BEST definition of an Excel spreadsheet formula?

• Any cell content that begins and ends with double quotes (").

• Any cell content that ends with an equals sign.

• Any cell content that starts with an equals sign.

• Any cell content that starts with a colon (:).

Which type of software is specifically designed to organize data into rows and columns that let you create charts and tables from the organized data?

• Word processor

• Spreadsheet

• Database

• Presentation

In the illustration below, there are three worksheets available in the Class Grades workbook. What can you select to switch between the worksheets in the workbook?

• Select the Plus (+) sign at the bottom of the workbook.

• Select the Cells button and select a worksheet.

• Select a tab at the bottom of the workbook.

• Select the Editing button and select a worksheet.

In the Excel spreadsheet below, you have decided to use numbers (instead of words) to represent each calendar month. You've already typed the first three numbers, but want Excel to fill in the rest of the numbers from 4 through 12. What can you do to have Excel automatically fill in the rest of the month numbers?

• Select the fill handle in the lower right corner of cell A4 and drag it down to cell A13.

• Copy the selected cells, then paste the contents in cells A5 through A13.

• Right-click the selected cells and select Insert > Fill Cells.

• Right-click the fill handle in the lower right corner of cell A4 and select Fill Cells.

Which feature of spreadsheet software lets you easily sort, search, or perform mathematical calculations on the data in the rows and columns?

• Effects

• Ranges

• Charts

• Functions

You have just purchased a high-end television and sound bar for $3500 dollars. You can make monthly payments for the first year without any interest. Which of the following Excel spreadsheet formulas (calculations) can you enter in cell C2 to find what you will pay each month for the purchase?

• =A2divideB2

• =A2/B2

• A2/B2

• =A2\B2