Quiz: Excel Ch 2 Terms1 (technology)


Excel Ch 2 Terms1Online version Match the definition with the correct term. by Kerri Stegman 1 Button that lists formatting options following an insertion of cells, rows, or columns a insert options b paste options c arguments d auto fill options 2 A formula in a cell that contains a reference back to itself a order of operations b circular reference c function d trace error 3 A prewritten formula that is built into Excel a average function b auto fill options c function d arguments 4 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 5 Can be assigned to a cell and will calculate a result a formula b function c circular reference d trace error 6 Contains the numerical value of zero a point mode b blank cell c trace error d arguments 7 Order in which arithmetic operators are calculated a fill handle b formula c order of operations d circular reference 8 Button that specifies how moved or pasted items should appear a function b fill handle c insert options d paste options 9 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 10 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 11 Select cells and create formulas with the mouse, rather than typing a cell reference a average function b row c arguments d point mode 12 The values that are used with a function a average function b arguments c point mode d formula 13 Button that lists error-checking options following the assignment of an invalid formula to a cell a blank cell b fill handle c trace error d function 14 Typically contain items analogous to items in a list a rows b point mode c blank cell d order of operations 15 Used to indicate the start of a formula or function a formula b equal sign c circular reference d rows 16 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

1

Button that lists formatting options following an insertion of cells, rows, or columns

a

insert options

b

paste options

c

arguments

d

auto fill options

2

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

a

order of operations

b

circular reference

c

function

d

trace error

3

A prewritten formula that is built into Excel

a

average function

b

auto fill options

c

function

d

arguments

4

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

5

Can be assigned to a cell and will calculate a result

a

formula

b

function

c

circular reference

d

trace error

6

Contains the numerical value of zero

a

point mode

b

blank cell

c

trace error

d

arguments

7

Order in which arithmetic operators are calculated

a

fill handle

b

formula

c

order of operations

d

circular reference

8

Button that specifies how moved or pasted items should appear

a

function

b

fill handle

c

insert options

d

paste options

9

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

10

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

11

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

a

average function

b

row

c

arguments

d

point mode

12

The values that are used with a function

a

average function

b

arguments

c

point mode

d

formula

13

Button that lists error-checking options following the assignment of an invalid formula to a cell

a

blank cell

b

fill handle

c

trace error

d

function

14

Typically contain items analogous to items in a list

a

rows

b

point mode

c

blank cell

d

order of operations

15

Used to indicate the start of a formula or function

a

formula

b

equal sign

c

circular reference

d

rows

16

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

Excel Ch 2 Terms1

Use these credentials to 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

Practice Quiz - Punnett Square, Variation, and Mutations

Quiz

UPS 5 Seeing Habits Quiz

Quiz

Tissues - Practice Quiz

Quiz

Photosynthesis vs Cellular Respiration - Practice Quiz

Quiz

Spanish Alphabet Listening

Excel Ch 2 Terms1Online version

by Kerri Stegman

Button that lists formatting options following an insertion of cells, rows, or columns

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

The values that are used with a function

Button that lists error-checking options following the assignment of an invalid formula to a cell

Typically contain items analogous to items in a list

Used to indicate the start of a formula or function

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