Test: Excel Ch 2 Terms1 (technology)


Excel Ch 2 Terms1Version en ligne Match the definition with the correct term. par 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

Utilisez ces identifiants pour intégrer le jeu dans un LMS compatible avec LTI 1.1 ou LTI 1.3 comme Canvas, Moodle ou Blackboard. Les scores seront ainsi automatiquement enregistrés dans le carnet de notes de la plateforme.

Excel Ch 2 Terms1

Test

Téléchargez la version pour jouer sur papier

Créé par

Top 10 résultats

Top Jeux

Test

Tissues - Practice Quiz

Test

UPS 5 Seeing Habits Quiz

Test

Photosynthesis vs Cellular Respiration - Practice Quiz

Test

Practice Quiz - Punnett Square, Variation, and Mutations

Test

Spanish Alphabet Listening

Excel Ch 2 Terms1Version en ligne

par 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