暗記メーカー

暗記メーカー

​
ログイン

Excel and PPT

Excel and PPT
87問 • 1年前
  • Jhen Rose Barroga
    • 通報

    問題一覧

  • 1

    Last Column

    XFD

  • 2

    Last Row

    1048576

  • 3

    A spreadsheet program, designed to create, organized, and analyzed data

    Excel

  • 4

    The intersection or rows and columns

    Cell

  • 5

    The sheet you're working in a workbook

    Active Sheet

  • 6

    A rectangular object on a worksheet or chart.

    Text Box

  • 7

    Wrong type of data

    #VALUE!

  • 8

    Can't find the name of the function

    #NAME?

  • 9

    There's a problem with one of the numbers

    #NUM!

  • 10

    Divide on a blank cell

    #DIV/0

  • 11

    You're reference is invalid

    #REF!

  • 12

    Can't display your formula in the cell

    ########

  • 13

    Parts of Excel

    Office Button, Quick Access Toolbar, Tabs, Dialog Box Launcher, Title Bar, Ribbon, Help Button, Vertical Scroll Bar, Active Cell, Name Box, Column Heading, Formula Box, Row Heading, Sheet Tab, Status Bar, Horizontal Scroll Bar, View Buttons, Zoom Controls

  • 14

    Are text entries consisting of any combination of letters and number

    Label

  • 15

    Group of Incremental number, dates, or periods

    Series

  • 16

    Use a constant value to increase and decrease value

    Linear Series

  • 17

    Multiplied by the preceding number by the step value

    Growth Series

  • 18

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

    Freeze Panes

  • 19

    Show 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

    Lines

  • 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

    Organizer collection of information arranged in a row and column format

    Database

  • 39

    Used to display your database

    Data Form

  • 40

    Average the values in the specified values

    DAVERAGE

  • 41

    count the cells

    DCOUNT

  • 42

    add values

    DSUM

  • 43

    extract single field

    DGET

  • 44

    estimate the Standard deviation

    DSTDEV

  • 45

    File that holds all the worksheets

    Workbook

  • 46

    Most commonly used buttons

    Home

  • 47

    Add tables, graphics, charts, hyperlink, textbox and wordArt.

    Insert

  • 48

    Setup margins, paper orientation, and other page settings.

    Page Layout

  • 49

    Contains mathematical instructions Helps you build smart formula.

    Formula

  • 50

    Get information from an outside source

    Data

  • 51

    Visible only if you have loaded a workbook.

    Add-ins

  • 52

    Replaces the File Menu available in earlier versions of MS office and contains the same basic commands to open, save, and print.

    Office Button

  • 53

    Customizable toolbar that contains a set of commands that’s independent of the tab that is currently displayed.

    QAT

  • 54

    Display the program name and the workbook name you’re working it.

    Title Bar

  • 55

    Display the commands that are most relevant for each of the task areas in the app.

    Tabs

  • 56

    Displays the Excel Help window

    Help Button

  • 57

    Shows the selected cell, drawing object or chart item.

    Name Box

  • 58

    Display the content of the active cell.

    Formula Bar

  • 59

    Data is entered when you begin typing.

    Active Cell

  • 60

    Column reference letter

    Column Heading

  • 61

    Row reference number

    Row Heading

  • 62

    Shows the sheet name.

    Sheet tab

  • 63

    Help you to scroll through your worksheet using the mouse.

    Horizontal/vertical Scroll Bar

  • 64

    Display information about a selected command or an operated in progress.

    Status Bar

  • 65

    File that holds all the worksheets

    Workbook

  • 66

    Series values using horizontal bars.

    Bar Chart

  • 67

    Series values as points on a line.

    Line Chart

  • 68

    Use two values axes gridlines to plot pairs of data points in a line showing the correlation between two series.

    Scatter Chart

  • 69

    Plots data series as cumulative lines.

    Area Chart

  • 70

    Plot data series in rings.

    Doughnut Chart

  • 71

    Series value using a separate value axis for each category.

    Radar Chart

  • 72

    Series as lines of a grid.

    Surface Chart

  • 73

    Compares sets of three values like a scatter chart

    Bubble Chart

  • 74

    Requires four series of values in the order.

    Stock Chart

  • 75

    Named operation that returns the value Built-in formulas that perform special and advanced calculations. Called Function Name

    Function

  • 76

    Find the largest numbers

    Max

  • 77

    Finds the smallest number

    Min

  • 78

    Average

    Average

  • 79

    Count the number of cells that contain the number from the arguments

    count

  • 80

    Counts the number of cells from the arguments that are not empty

    CountA

  • 81

    Workbook that contains more than one worksheet

    Multiple Worksheet Workbook

  • 82

    Worksheet contain the cell pointer

    active worksheets

  • 83

    Used to perform operations in excel based on some criteria supplied by a user.

    If statement

  • 84

    Formula for multiple values using one input cell.

    One-input data table

  • 85

    Formula for multiple values using two input cells

    two-input data table

  • 86

    Stores all scenarios created within the workbook.

    Scenario Manager

  • 87

    Built-in formula you use ti perform database calculations based on a specified field and criteria

    Database Function

    • 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

    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

    Excel

    Jhen Rose Barroga · 55問 · 1年前

    Excel

    Excel

    55問 • 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

    A spreadsheet program, designed to create, organized, and analyzed data

    Excel

  • 4

    The intersection or rows and columns

    Cell

  • 5

    The sheet you're working in a workbook

    Active Sheet

  • 6

    A rectangular object on a worksheet or chart.

    Text Box

  • 7

    Wrong type of data

    #VALUE!

  • 8

    Can't find the name of the function

    #NAME?

  • 9

    There's a problem with one of the numbers

    #NUM!

  • 10

    Divide on a blank cell

    #DIV/0

  • 11

    You're reference is invalid

    #REF!

  • 12

    Can't display your formula in the cell

    ########

  • 13

    Parts of Excel

    Office Button, Quick Access Toolbar, Tabs, Dialog Box Launcher, Title Bar, Ribbon, Help Button, Vertical Scroll Bar, Active Cell, Name Box, Column Heading, Formula Box, Row Heading, Sheet Tab, Status Bar, Horizontal Scroll Bar, View Buttons, Zoom Controls

  • 14

    Are text entries consisting of any combination of letters and number

    Label

  • 15

    Group of Incremental number, dates, or periods

    Series

  • 16

    Use a constant value to increase and decrease value

    Linear Series

  • 17

    Multiplied by the preceding number by the step value

    Growth Series

  • 18

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

    Freeze Panes

  • 19

    Show 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

    Lines

  • 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

    Organizer collection of information arranged in a row and column format

    Database

  • 39

    Used to display your database

    Data Form

  • 40

    Average the values in the specified values

    DAVERAGE

  • 41

    count the cells

    DCOUNT

  • 42

    add values

    DSUM

  • 43

    extract single field

    DGET

  • 44

    estimate the Standard deviation

    DSTDEV

  • 45

    File that holds all the worksheets

    Workbook

  • 46

    Most commonly used buttons

    Home

  • 47

    Add tables, graphics, charts, hyperlink, textbox and wordArt.

    Insert

  • 48

    Setup margins, paper orientation, and other page settings.

    Page Layout

  • 49

    Contains mathematical instructions Helps you build smart formula.

    Formula

  • 50

    Get information from an outside source

    Data

  • 51

    Visible only if you have loaded a workbook.

    Add-ins

  • 52

    Replaces the File Menu available in earlier versions of MS office and contains the same basic commands to open, save, and print.

    Office Button

  • 53

    Customizable toolbar that contains a set of commands that’s independent of the tab that is currently displayed.

    QAT

  • 54

    Display the program name and the workbook name you’re working it.

    Title Bar

  • 55

    Display the commands that are most relevant for each of the task areas in the app.

    Tabs

  • 56

    Displays the Excel Help window

    Help Button

  • 57

    Shows the selected cell, drawing object or chart item.

    Name Box

  • 58

    Display the content of the active cell.

    Formula Bar

  • 59

    Data is entered when you begin typing.

    Active Cell

  • 60

    Column reference letter

    Column Heading

  • 61

    Row reference number

    Row Heading

  • 62

    Shows the sheet name.

    Sheet tab

  • 63

    Help you to scroll through your worksheet using the mouse.

    Horizontal/vertical Scroll Bar

  • 64

    Display information about a selected command or an operated in progress.

    Status Bar

  • 65

    File that holds all the worksheets

    Workbook

  • 66

    Series values using horizontal bars.

    Bar Chart

  • 67

    Series values as points on a line.

    Line Chart

  • 68

    Use two values axes gridlines to plot pairs of data points in a line showing the correlation between two series.

    Scatter Chart

  • 69

    Plots data series as cumulative lines.

    Area Chart

  • 70

    Plot data series in rings.

    Doughnut Chart

  • 71

    Series value using a separate value axis for each category.

    Radar Chart

  • 72

    Series as lines of a grid.

    Surface Chart

  • 73

    Compares sets of three values like a scatter chart

    Bubble Chart

  • 74

    Requires four series of values in the order.

    Stock Chart

  • 75

    Named operation that returns the value Built-in formulas that perform special and advanced calculations. Called Function Name

    Function

  • 76

    Find the largest numbers

    Max

  • 77

    Finds the smallest number

    Min

  • 78

    Average

    Average

  • 79

    Count the number of cells that contain the number from the arguments

    count

  • 80

    Counts the number of cells from the arguments that are not empty

    CountA

  • 81

    Workbook that contains more than one worksheet

    Multiple Worksheet Workbook

  • 82

    Worksheet contain the cell pointer

    active worksheets

  • 83

    Used to perform operations in excel based on some criteria supplied by a user.

    If statement

  • 84

    Formula for multiple values using one input cell.

    One-input data table

  • 85

    Formula for multiple values using two input cells

    two-input data table

  • 86

    Stores all scenarios created within the workbook.

    Scenario Manager

  • 87

    Built-in formula you use ti perform database calculations based on a specified field and criteria

    Database Function