暗記メーカー

I.T FINALS REVIEWER SORTING DATA

I.T FINALS REVIEWER SORTING DATA

20問 • 2年前

nicollette claire

問題一覧

1

helps you quickly visualize and understand your data better, organize and find the data that you want.

Sorting Data

2

used to temporarily hide some of the data in a table. It helps creating a subset of the data and display records that meet certain criteria.

Filters

3

Can be used to narrow down the data in your worksheet, allowing you to view only the information you need

Filters

4

symbols that compare two values. is a statement that is either true or false.

comparison or logical operators

5

an expression that calculates values in a cell or in a range of cells.

formula

6

predefined formula already available in Excel. ______ perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

Function

7

structure and order of a formula, including functions, references, operators, and parameters. The specific way to write a function.

syntax

8

Also termed as parameters. contain the information you want to calculate. can refer to both individual cells and cell ranges and must be enclosed within parentheses.

arguments

9

This function adds all the values of the cells in the argument.

sum

10

It calculates the sum of the cells and then divides that value by the number of cells in the argument.

average

11

This function counts the number of cells with numerical data in the argument.

count

12

This function determines the highest cell value included in the argument.

max

13

This function determines the lowest cell value included in the argument.

min

14

Counts all the cells with numerical values, text, and any other data format. Does not count any blank cells.

counta()

15

Used to count the number of empty cells in a given range of cells.

countblank()

16

function works on returning the remainder when a particular number is divided by a divisor.

mod()

17

returns the result of a number raised to a certain power.

power()

18

The default operator is

equals

19

When a logical operator is included with a number, the number and operator must be enclosed in quotes. In general, text values are enclosed in (“”)

double quotes

20

function in Excel calculates the average (arithmetic mean) of all the cells that meet specified criteria.

AVERAGEIF

Quiz I.T Week 3

Quiz I.T Week 3

nicollette claire · 34問 · 2年前

Quiz I.T Week 3

Quiz I.T Week 3

34問 • 2年前

nicollette claire

Quiz I.T. Week 4

Quiz I.T. Week 4

nicollette claire · 29問 · 2年前

Quiz I.T. Week 4

Quiz I.T. Week 4

29問 • 2年前

nicollette claire

Quiz I.T. Week 5

Quiz I.T. Week 5

nicollette claire · 7問 · 2年前

Quiz I.T. Week 5

Quiz I.T. Week 5

7問 • 2年前

nicollette claire

midterm exam FAR

midterm exam FAR

nicollette claire · 40問 · 2年前

midterm exam FAR

midterm exam FAR

40問 • 2年前

nicollette claire

midterm qui

midterm qui

nicollette claire · 20問 · 2年前

midterm qui

midterm qui

20問 • 2年前

nicollette claire

CFAS CHAPTER 1

CFAS CHAPTER 1

nicollette claire · 41問 · 2年前

CFAS CHAPTER 1

CFAS CHAPTER 1

41問 • 2年前

nicollette claire

CFAS CHAPTER 2

CFAS CHAPTER 2

nicollette claire · 28問 · 2年前

CFAS CHAPTER 2

CFAS CHAPTER 2

28問 • 2年前

nicollette claire

CFAS CHAPTER 3

CFAS CHAPTER 3

nicollette claire · 9問 · 2年前

CFAS CHAPTER 3

CFAS CHAPTER 3

9問 • 2年前

nicollette claire

I.T FINALS R3VIEWER EXCEL 1

I.T FINALS R3VIEWER EXCEL 1

nicollette claire · 35問 · 2年前

I.T FINALS R3VIEWER EXCEL 1

I.T FINALS R3VIEWER EXCEL 1

35問 • 2年前

nicollette claire

I.T REGIEWER VLOOKUP

I.T REGIEWER VLOOKUP

nicollette claire · 9問 · 2年前

I.T REGIEWER VLOOKUP

I.T REGIEWER VLOOKUP

9問 • 2年前

nicollette claire

chapter 4

chapter 4

nicollette claire · 30問 · 1年前

chapter 4

chapter 4

30問 • 1年前

nicollette claire

chapter 5

chapter 5

nicollette claire · 10問 · 1年前

chapter 5

chapter 5

10問 • 1年前

nicollette claire

Chapter 6

Chapter 6

nicollette claire · 20問 · 1年前

Chapter 6

Chapter 6

20問 • 1年前

nicollette claire

chapter 7

chapter 7

nicollette claire · 15問 · 1年前

chapter 7

chapter 7

15問 • 1年前

nicollette claire

chapter 9

chapter 9

nicollette claire · 10問 · 1年前

chapter 9

chapter 9

10問 • 1年前

nicollette claire

Chapter 14

Chapter 14

nicollette claire · 5問 · 1年前

Chapter 14

Chapter 14

5問 • 1年前

nicollette claire

chapter 14

chapter 14

nicollette claire · 24問 · 1年前

chapter 14

chapter 14

24問 • 1年前

nicollette claire

Chapter 16

Chapter 16

nicollette claire · 20問 · 1年前

Chapter 16

Chapter 16

20問 • 1年前

nicollette claire

chapter 24

chapter 24

nicollette claire · 25問 · 1年前

chapter 24

chapter 24

25問 • 1年前

nicollette claire

chapter 25

chapter 25

nicollette claire · 10問 · 1年前

chapter 25

chapter 25

10問 • 1年前

nicollette claire

chapter 17

chapter 17

nicollette claire · 20問 · 1年前

chapter 17

chapter 17

20問 • 1年前

nicollette claire

chapter 18

chapter 18

nicollette claire · 15問 · 1年前

chapter 18

chapter 18

15問 • 1年前

nicollette claire

問題一覧

1

helps you quickly visualize and understand your data better, organize and find the data that you want.

Sorting Data

2

used to temporarily hide some of the data in a table. It helps creating a subset of the data and display records that meet certain criteria.

Filters

3

Can be used to narrow down the data in your worksheet, allowing you to view only the information you need

Filters

4

symbols that compare two values. is a statement that is either true or false.

comparison or logical operators

5

an expression that calculates values in a cell or in a range of cells.

formula

6

predefined formula already available in Excel. ______ perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

Function

7

structure and order of a formula, including functions, references, operators, and parameters. The specific way to write a function.

syntax

8

Also termed as parameters. contain the information you want to calculate. can refer to both individual cells and cell ranges and must be enclosed within parentheses.

arguments

9

This function adds all the values of the cells in the argument.

sum

10

It calculates the sum of the cells and then divides that value by the number of cells in the argument.

average

11

This function counts the number of cells with numerical data in the argument.

count

12

This function determines the highest cell value included in the argument.

max

13

This function determines the lowest cell value included in the argument.

min

14

Counts all the cells with numerical values, text, and any other data format. Does not count any blank cells.

counta()

15

Used to count the number of empty cells in a given range of cells.

countblank()

16

function works on returning the remainder when a particular number is divided by a divisor.

mod()

17

returns the result of a number raised to a certain power.

power()

18

The default operator is

equals

19

When a logical operator is included with a number, the number and operator must be enclosed in quotes. In general, text values are enclosed in (“”)

double quotes

20

function in Excel calculates the average (arithmetic mean) of all the cells that meet specified criteria.

AVERAGEIF