Flash Cards (current)
Games
Teachers

Spreadsheets

Test Description: Spreadsheets Unit Test 2021

Instructions: Answer all questions to get your test result.

1) A group of adjacent cells referenced in a formula are called a ____________.

ASelection BRange CCell Reference DGroup

2) If you want to add a range of cells, use this function:

ASUM BCOUNTIF CCOUNTA DCOUNT

3) In the following spreadsheet formula, what is the CONDITION? =COUNTIF(B2:B25;16)

A(B2:B25;16) BB2:B25 CCOUNTIF D16

4) Changing how cells look when they meet a certain criteria is called:

AA function BConditional Formatting CCountIF DAuto Format

5) In the following spreadsheet formula, what does the YES mean? =IF(C6=100, Yes, No)

AThe cell will display YES if C6 is greater than 100 BThe cell will display YES if C6 is 100 CIt tells the cell to calculate the formula. DThe cell will subtract C6 from 100

6) The Fill Handle

ACalculates the result of a formula BCopies a cell's formula or data to other cells CIs the box where you select a function for your formula DIs used to set up Conditional Formatting

7) The OR function allows:

AConditional Formatting to choose which way to calculate a cell BThe cells to sort in the correct ORDER CMultiple conditions to be used with an IF function when all have to be true DMultiple conditions to be used with an IF function when only one needs to be true

8) One difference in using the Function box to add a function to a cell, vs typing it in the cell yourself:

AThe function box will always fill in the range BThe function box will add all of the semicolons for you CThe Function box will add the parenthesis for you DThe function box will fill in the criteria

9) The AND function is used:

AWhen you want to add several criteria to an IF, and only one has to be true BWhen you want to use a COUNTIF and a SUM in the same formula CWhen you want to add several criteria to a COUNTIF DWhen you want to add several criteria to an IF, and all must be true

10) If you see ###### instead of numbers:

AYou sank my battleship BYour function is wrong CYour cell size is too narrow DYour formula is wrong

*select an answer for all questions

Play Games with the Questions Above

WAIT! Find what you needed?

Still Looking for the Answers? Have Another Question? Play a Review Game with These Questions? Want to Make Your Own Test Like This One?