Etech Unit 6 Test: Advanced Spreadsheet Skills

What is a spreadsheet software primarily used for?

• Creating slideshows

• Organizing data in rows and columns and performing calculations

• Editing images

• Writing essays

Which of the following is NOT an example of spreadsheet software?

• Microsoft Excel

• Google Sheets

• Adobe Photoshop

• LibreOffice Calc

In Excel, what is the intersection of a row and column called?

• Formula Bar

• Cell

• Pivot Table

• Worksheet

To forecast next month's expenses (assuming a 10% increase), which formula adjusts Column B?

• =B2*1.1

• =B2+10

• =SUM(B:B)

• =AVERAGE(B:B)

Which term refers to the VERTICAL line of entries in a spreadsheet?

• Row

• Column

• Cell Reference

• Active Cell

What is the name of the selected cell in Excel?

• Merged Cell

• Active Cell

• Column Heading

• Formula Bar

What does the formula =SUM(A1:A5) do?

• Multiplies the values in cells A1 to A5

• Adds the values in cells A1 to A5

• Counts the number of cells from A1 to A5

• Averages the values in cells A1 to A5

Which function joins two or more text strings into one?

• =CONCATENATE()

• =SUM()

• =AVERAGE()

• =IF()

What does =IF(A1>10, "Yes", "No") return if A1 contains 15?

• "No"

• "Yes"

• "True"

• "False"

Which function rounds a number to a specified number of digits?

• =ROUND()

• =SQRT()

• =ABS()

• =TRIM()