Quiz: Excel Ch 2 Terms1 (technology)


Excel Ch 2 Terms1Online version Match the definition with the correct term. by Kerri Stegman 1 A formula in a cell that contains a reference back to itself a order of operations b circular reference c function d trace error 2 A prewritten formula that is built into Excel a average function b auto fill options c function d arguments 3 Button that gives options for how to fill cells following a fill operation a order of operations b fill handle c paste options d auto fill options 4 Can be assigned to a cell and will calculate a result a formula b function c circular reference d trace error 5 Contains the numerical value of zero a point mode b blank cell c trace error d arguments 6 Order in which arithmetic operators are calculated a fill handle b formula c order of operations d circular reference 7 Button that specifies how moved or pasted items should appear a function b fill handle c insert options d paste options 8 Small rectangle in lower-right corner of a cell that is used to copy formulas a fill handle b blank cell c auto fill options d rows 9 Sums numbers in a specified range and then divides by the number of values a formula b average function c insert options d equal sign 10 Select cells and create formulas with the mouse, rather than typing a cell reference a average function b row c arguments d point mode 11 values or cell references that a function uses to perform its calculation a average function b arguments c point mode d formula 12 Used to indicate the start of a formula or function a formula b equal sign c circular reference d rows 13 Occurs when Excel does not understand a cell reference used in a formula a invalid reference b circular reference c blank cell d trace error 14 Displays the lowest value in a range a Max b Min c Lowest d Bottom 15 Displays the highest value in a range a Max b Min c Average d Highest 16 Used to check which cells are referenced in a formula a values version b formula version c range finder d formula version 17 A predefined set of colors, fonts, chart styles, cell styles, and fill effects a best fit b conditional formatting c values version d theme

1

A formula in a cell that contains a reference back to itself

a

order of operations

b

circular reference

c

function

d

trace error

2

A prewritten formula that is built into Excel

a

average function

b

auto fill options

c

function

d

arguments

3

Button that gives options for how to fill cells following a fill operation

a

order of operations

b

fill handle

c

paste options

d

auto fill options

4

Can be assigned to a cell and will calculate a result

a

formula

b

function

c

circular reference

d

trace error

5

Contains the numerical value of zero

a

point mode

b

blank cell

c

trace error

d

arguments

6

Order in which arithmetic operators are calculated

a

fill handle

b

formula

c

order of operations

d

circular reference

7

Button that specifies how moved or pasted items should appear

a

function

b

fill handle

c

insert options

d

paste options

8

Small rectangle in lower-right corner of a cell that is used to copy formulas

a

fill handle

b

blank cell

c

auto fill options

d

rows

9

Sums numbers in a specified range and then divides by the number of values

a

formula

b

average function

c

insert options

d

equal sign

10

Select cells and create formulas with the mouse, rather than typing a cell reference

a

average function

b

row

c

arguments

d

point mode

11

values or cell references that a function uses to perform its calculation

a

average function

b

arguments

c

point mode

d

formula

12

Used to indicate the start of a formula or function

a

formula

b

equal sign

c

circular reference

d

rows

13

Occurs when Excel does not understand a cell reference used in a formula

a

invalid reference

b

circular reference

c

blank cell

d

trace error

14

Displays the lowest value in a range

a

Max

b

Min

c

Lowest

d

Bottom

15

Displays the highest value in a range

a

Max

b

Min

c

Average

d

Highest

16

Used to check which cells are referenced in a formula

a

values version

b

formula version

c

range finder

d

formula version

17

A predefined set of colors, fonts, chart styles, cell styles, and fill effects

a

best fit

b

conditional formatting

c

values version

d

theme

Excel Ch 2 Terms1

You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.

Excel Ch 2 Terms1

Quiz

Download the paper version to play

Created by

Top 10 results

Top Games

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

Spanish Alphabet Listening

Quiz

Tissues - Practice Quiz

Quiz

UPS 5 Seeing Habits Quiz

Excel Ch 2 Terms1Online version

by Kerri Stegman

A formula in a cell that contains a reference back to itself

A prewritten formula that is built into Excel

Button that gives options for how to fill cells following a fill operation

Can be assigned to a cell and will calculate a result

Contains the numerical value of zero

Order in which arithmetic operators are calculated

Button that specifies how moved or pasted items should appear

Small rectangle in lower-right corner of a cell that is used to copy formulas

Sums numbers in a specified range and then divides by the number of values

Select cells and create formulas with the mouse, rather than typing a cell reference

values or cell references that a function uses to perform its calculation

Used to indicate the start of a formula or function

Occurs when Excel does not understand a cell reference used in a formula

Displays the lowest value in a range

Displays the highest value in a range

Used to check which cells are referenced in a formula

A predefined set of colors, fonts, chart styles, cell styles, and fill effects