CS Unit 7 Spreadsheet Test

Front

Which spreadsheet application is free to use online and provides the best collaboration tools for multiple users?

Back

Google Sheets

Front

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? Options: sum=A2+B2, A2+B2, =A2+B2, =A2plusB2

Back

=A2+B2

Front

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?

Back

Right-click the C column heading and select Insert.

Front

Which of the following spreadsheet tools is one of the most powerful and popular spreadsheet applications and has the most advanced statistical analysis tools?
Options: Google Sheets, LibreOffice Calc, Microsoft Excel, Apple Numbers

Back

Microsoft Excel

Front

Which of the following is the BEST definition of an Excel spreadsheet formula? Any cell content that starts with an equals sign.

Back

Any cell content that starts with an equals sign.

Front

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?

Back

Spreadsheet

Front

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?

Back

Select a tab at the bottom of the workbook.

Front

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?

Back

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

Front

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

Back

Functions

Front

What Excel formula can you enter in cell C2 to find the monthly payment for a $3500 purchase with no interest? Options: =A2divideB2, =A2/B2, A2/B2, =A2\B2

Back

=A2/B2