ログイン

Excel

Excel
55問 • 1年前
  • Jhen Rose Barroga
  • 通報

    問題一覧

  • 1

    - Last column

    XFD

  • 2

    - Last row

    1048576

  • 3

    - Is a spreadsheet program, designed to create, organized, and analyzed data.

    Excel

  • 4

    - The intersection of rows and columns

    Cell

  • 5

    - The sheet you’re working on in a workbook.

    Active sheet

  • 6

    - A rectangular object on a worksheet or chart

    Textbox

  • 7

    - Wrong type of data.

    #VALUE!

  • 8

    - Can’t find the name of the function,

    #NAME?

  • 9

    - There is a problem with one of the numbers.

    #NUM!

  • 10

    - Also occurs to divide on a blank cell.

    #DIV/0

  • 11

    - Your reference is invalid.

    #REF!

  • 12

    - Can’t display your formula in the cell.

    ####

  • 13

    - Are text entries consisting of any combination of letters and number.

    Label

  • 14

    - A group of incremental numbers, dates, or periods.

    Series

  • 15

    - Use a constant value to increase and decrease values.

    Linear Series

  • 16

    - A group of incremental numbers, dates, or periods.

    Series

  • 17

    - Freezes all the rows above the active cell and all the columns to the left of the active cell.

    Freeze panes

  • 18

    - Multiplied by the preceding number by the step value.

    Grown Series

  • 19

    - Shows the relationship between sets of data in picture form.

    Chart

  • 20

    - Visual presentation of a worksheet data.

    Microsoft Excel Chart

  • 21

    - Found in the analysis of the layout tab.

    Editing Line Charts

  • 22

    - Used to see progressed and direction

    Trendline

  • 23

    - Used to clearly see the items in. the chart

    Line

  • 24

    - Used to calculate values

    Formula

  • 25

    - Letter, symbol, numbers

    Text

  • 26

    - Number that you enter into a cell

    Value

  • 27

    - Set of predefined rules

    Order of Precedence

  • 28

    - Named operation that returns the value

    Function

  • 29

    - Summarize all the values

    AUTOSUM

  • 30

    - Table direction is horizontal or across

    HLOOKUP

  • 31

    - Table direction is vertical or down

    VLOOKUP

  • 32

    - Summarizes large amounts of data

    Pivot Table

  • 33

    - Used to get particular result

    Goal seek

  • 34

    - Range of cells that display results

    Data Tables

  • 35

    - What-if projection using multiple variables

    Scenario

  • 36

    - Calculate required to pay off a loan.

    PMT function

  • 37

    - Sequence of commands and actions

    macro

  • 38

    - Organize collection of information arranged in a row and column format

    database

  • 39

    - Use to display your database

    data form

  • 40

    - Average the values in the specified fields

    DAVERAGE

  • 41

    - Count the cells

    DCOUNT

  • 42

    - Add values

    DSUM

  • 43

    - Extract single field

    DGET

  • 44

    - Estimate the standard deviation

    DSTDEV

  • 45

    Replace the file menu

    Office Button

  • 46

    Set commands that independent

    QAT

  • 47

    Display commands

    Tabs

  • 48

    Display program name

    Title Bar

  • 49

    Display the excel help window

    Help Button

  • 50

    Bounded by heavy border

    Active Cell

  • 51

    Use to name a selected cell

    Name Box

  • 52

    Shows columns

    Column Heading

  • 53

    Display content of the active cell

    Formula Bar

  • 54

    Show rows

    Row Heading

  • 55

    Shows sheet name

    Sheet Tab

  • Shortcut Keys

    Shortcut Keys

    Jhen Rose Barroga · 27問 · 2年前

    Shortcut Keys

    Shortcut Keys

    27問 • 2年前
    Jhen Rose Barroga

    Integrated Hardware

    Integrated Hardware

    Jhen Rose Barroga · 25問 · 1年前

    Integrated Hardware

    Integrated Hardware

    25問 • 1年前
    Jhen Rose Barroga

    Excel and PPT

    Excel and PPT

    Jhen Rose Barroga · 87問 · 1年前

    Excel and PPT

    Excel and PPT

    87問 • 1年前
    Jhen Rose Barroga

    Quiz 1

    Quiz 1

    Jhen Rose Barroga · 22問 · 1年前

    Quiz 1

    Quiz 1

    22問 • 1年前
    Jhen Rose Barroga

    Quiz #1

    Quiz #1

    Jhen Rose Barroga · 39問 · 1年前

    Quiz #1

    Quiz #1

    39問 • 1年前
    Jhen Rose Barroga

    Access

    Access

    Jhen Rose Barroga · 17問 · 1年前

    Access

    Access

    17問 • 1年前
    Jhen Rose Barroga

    Photoshop

    Photoshop

    Jhen Rose Barroga · 100問 · 1年前

    Photoshop

    Photoshop

    100問 • 1年前
    Jhen Rose Barroga

    Quiz in Excel

    Quiz in Excel

    Jhen Rose Barroga · 20問 · 1年前

    Quiz in Excel

    Quiz in Excel

    20問 • 1年前
    Jhen Rose Barroga

    Excel and PPT

    Excel and PPT

    Jhen Rose Barroga · 87問 · 1年前

    Excel and PPT

    Excel and PPT

    87問 • 1年前
    Jhen Rose Barroga

    Photoshop 2

    Photoshop 2

    Jhen Rose Barroga · 7問 · 1年前

    Photoshop 2

    Photoshop 2

    7問 • 1年前
    Jhen Rose Barroga

    問題一覧

  • 1

    - Last column

    XFD

  • 2

    - Last row

    1048576

  • 3

    - Is a spreadsheet program, designed to create, organized, and analyzed data.

    Excel

  • 4

    - The intersection of rows and columns

    Cell

  • 5

    - The sheet you’re working on in a workbook.

    Active sheet

  • 6

    - A rectangular object on a worksheet or chart

    Textbox

  • 7

    - Wrong type of data.

    #VALUE!

  • 8

    - Can’t find the name of the function,

    #NAME?

  • 9

    - There is a problem with one of the numbers.

    #NUM!

  • 10

    - Also occurs to divide on a blank cell.

    #DIV/0

  • 11

    - Your reference is invalid.

    #REF!

  • 12

    - Can’t display your formula in the cell.

    ####

  • 13

    - Are text entries consisting of any combination of letters and number.

    Label

  • 14

    - A group of incremental numbers, dates, or periods.

    Series

  • 15

    - Use a constant value to increase and decrease values.

    Linear Series

  • 16

    - A group of incremental numbers, dates, or periods.

    Series

  • 17

    - Freezes all the rows above the active cell and all the columns to the left of the active cell.

    Freeze panes

  • 18

    - Multiplied by the preceding number by the step value.

    Grown Series

  • 19

    - Shows the relationship between sets of data in picture form.

    Chart

  • 20

    - Visual presentation of a worksheet data.

    Microsoft Excel Chart

  • 21

    - Found in the analysis of the layout tab.

    Editing Line Charts

  • 22

    - Used to see progressed and direction

    Trendline

  • 23

    - Used to clearly see the items in. the chart

    Line

  • 24

    - Used to calculate values

    Formula

  • 25

    - Letter, symbol, numbers

    Text

  • 26

    - Number that you enter into a cell

    Value

  • 27

    - Set of predefined rules

    Order of Precedence

  • 28

    - Named operation that returns the value

    Function

  • 29

    - Summarize all the values

    AUTOSUM

  • 30

    - Table direction is horizontal or across

    HLOOKUP

  • 31

    - Table direction is vertical or down

    VLOOKUP

  • 32

    - Summarizes large amounts of data

    Pivot Table

  • 33

    - Used to get particular result

    Goal seek

  • 34

    - Range of cells that display results

    Data Tables

  • 35

    - What-if projection using multiple variables

    Scenario

  • 36

    - Calculate required to pay off a loan.

    PMT function

  • 37

    - Sequence of commands and actions

    macro

  • 38

    - Organize collection of information arranged in a row and column format

    database

  • 39

    - Use to display your database

    data form

  • 40

    - Average the values in the specified fields

    DAVERAGE

  • 41

    - Count the cells

    DCOUNT

  • 42

    - Add values

    DSUM

  • 43

    - Extract single field

    DGET

  • 44

    - Estimate the standard deviation

    DSTDEV

  • 45

    Replace the file menu

    Office Button

  • 46

    Set commands that independent

    QAT

  • 47

    Display commands

    Tabs

  • 48

    Display program name

    Title Bar

  • 49

    Display the excel help window

    Help Button

  • 50

    Bounded by heavy border

    Active Cell

  • 51

    Use to name a selected cell

    Name Box

  • 52

    Shows columns

    Column Heading

  • 53

    Display content of the active cell

    Formula Bar

  • 54

    Show rows

    Row Heading

  • 55

    Shows sheet name

    Sheet Tab