I.T FINALS R3VIEWER EXCEL 1

I.T FINALS R3VIEWER EXCEL 1
35問 • 2年前
  • nicollette claire
  • 通報

    問題一覧

  • 1

    ______ a computer program that can capture, display and manipulate data arranged in rows and columns.

    spreadsheet

  • 2

    It can contain numerical data and short text strings.

    Spreadsheet

  • 3

    Each row and column can be manipulated with formulas, commands, and formats.

    Spreadsheet

  • 4

    It is also called an electronic work sheet.

    Spreadsheet

  • 5

    what is this?

    Traditional Paper Worksheet

  • 6

    known as The Father of Modern Day Spreadsheets

    Dan Bricklin

  • 7

    VisiCalc (1978) was developed by?

    Dan Bricklin

  • 8

    It could only calculate data within a matrix of 5 columns by 20 rows. The first ever electronic spreadsheet released for Apple II.

    VisiCalc

  • 9

    Released by Sorcim Bundled with Wordstar. Platform used MS DOS.

    SuperCalc

  • 10

    Competed with Lotus123 and SuperCalc. Used MS DOS platform. Replaced by Excel.

    Microsoft MultiPlan (1982)

  • 11

    developed Lotus 1-2-3

    Mitch Kapor

  • 12

    With charting, graphing, database and basic arithmetic capabilities. Outshined Microsoft MultiPlan.

    Lotus 1-2-3 (1983)

  • 13

    A spreadsheet software that used user interface, pull down menus and point and click capabilities using the mouse. The first version released for Macintosh.

    Microsoft Excel (1985)

  • 14

    The first spreadsheet to run on Windows Mac Version Also run-time version of Windows

    Excel 2.0 (1987)

  • 15

    spreadsheet program used to record and analyze numerical and statistical data. enables users to format, organize and calculate data in a spreadsheet.

    Microsoft Excel

  • 16

    The name of Excel was picked to give impression of

    It can do everything Lotus 123 does, but exceptionally better.’

  • 17

    provides shortcuts to commands in Excel. A command is an action that the user performs.

    The Ribbon

  • 18

    small arrow in the lower-right corner of a group that brings up more related commands. Dialog launchers appear in groups that contain more commands than available space.

    Dialog launcher

  • 19

    is the button you click to perform a particular action.

    Command button

  • 20

    smallest unit but most powerful part of a spreadsheet.

    Cell

  • 21

    A cell that is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar.

    Active Cell

  • 22

    TOTAL OF Rows TOTAL OF Columns TOTAL OF Cells TOTAL OF Worksheets

    1,048,576 16,384 17,179,869,184 255

  • 23

    The specification for a series of cells. A colon ":" separates the start and end cell references.

    Cell Range

  • 24

    made up of individual cells which can contain a value, a formula, or text.

    Worksheet

  • 25

    vertical set of cells. A single worksheet contains 16,384 of it

    Column

  • 26

    horizontal set of cells. A single worksheet contains 1,048,576 total of it.

    Rows

  • 27

    separate file just like every other application has.

    Workbook

  • 28

    It’s a small dot present in the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc.

    Fill Handle

  • 29

    is an input bar, below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell.

    Formula Bar

  • 30

    will show the name of your workbook, followed by the application name (“Microsoft Excel”).

    Title Bar

  • 31

    simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc).

    File Menu

  • 32

    A toolbar to quickly access the options which you frequently use.

    Quick Access Toolbar

  • 33

    transparent image or text in the background of the document.

    watermark

  • 34

    this will specify exactly what types of values are stored in a cell.

    Number Format

  • 35

    Two types of cell

    Relative and Absolute

  • 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 REVIEWER SORTING DATA

    I.T FINALS REVIEWER SORTING DATA

    nicollette claire · 20問 · 2年前

    I.T FINALS REVIEWER SORTING DATA

    I.T FINALS REVIEWER SORTING DATA

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

    ______ a computer program that can capture, display and manipulate data arranged in rows and columns.

    spreadsheet

  • 2

    It can contain numerical data and short text strings.

    Spreadsheet

  • 3

    Each row and column can be manipulated with formulas, commands, and formats.

    Spreadsheet

  • 4

    It is also called an electronic work sheet.

    Spreadsheet

  • 5

    what is this?

    Traditional Paper Worksheet

  • 6

    known as The Father of Modern Day Spreadsheets

    Dan Bricklin

  • 7

    VisiCalc (1978) was developed by?

    Dan Bricklin

  • 8

    It could only calculate data within a matrix of 5 columns by 20 rows. The first ever electronic spreadsheet released for Apple II.

    VisiCalc

  • 9

    Released by Sorcim Bundled with Wordstar. Platform used MS DOS.

    SuperCalc

  • 10

    Competed with Lotus123 and SuperCalc. Used MS DOS platform. Replaced by Excel.

    Microsoft MultiPlan (1982)

  • 11

    developed Lotus 1-2-3

    Mitch Kapor

  • 12

    With charting, graphing, database and basic arithmetic capabilities. Outshined Microsoft MultiPlan.

    Lotus 1-2-3 (1983)

  • 13

    A spreadsheet software that used user interface, pull down menus and point and click capabilities using the mouse. The first version released for Macintosh.

    Microsoft Excel (1985)

  • 14

    The first spreadsheet to run on Windows Mac Version Also run-time version of Windows

    Excel 2.0 (1987)

  • 15

    spreadsheet program used to record and analyze numerical and statistical data. enables users to format, organize and calculate data in a spreadsheet.

    Microsoft Excel

  • 16

    The name of Excel was picked to give impression of

    It can do everything Lotus 123 does, but exceptionally better.’

  • 17

    provides shortcuts to commands in Excel. A command is an action that the user performs.

    The Ribbon

  • 18

    small arrow in the lower-right corner of a group that brings up more related commands. Dialog launchers appear in groups that contain more commands than available space.

    Dialog launcher

  • 19

    is the button you click to perform a particular action.

    Command button

  • 20

    smallest unit but most powerful part of a spreadsheet.

    Cell

  • 21

    A cell that is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar.

    Active Cell

  • 22

    TOTAL OF Rows TOTAL OF Columns TOTAL OF Cells TOTAL OF Worksheets

    1,048,576 16,384 17,179,869,184 255

  • 23

    The specification for a series of cells. A colon ":" separates the start and end cell references.

    Cell Range

  • 24

    made up of individual cells which can contain a value, a formula, or text.

    Worksheet

  • 25

    vertical set of cells. A single worksheet contains 16,384 of it

    Column

  • 26

    horizontal set of cells. A single worksheet contains 1,048,576 total of it.

    Rows

  • 27

    separate file just like every other application has.

    Workbook

  • 28

    It’s a small dot present in the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc.

    Fill Handle

  • 29

    is an input bar, below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell.

    Formula Bar

  • 30

    will show the name of your workbook, followed by the application name (“Microsoft Excel”).

    Title Bar

  • 31

    simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc).

    File Menu

  • 32

    A toolbar to quickly access the options which you frequently use.

    Quick Access Toolbar

  • 33

    transparent image or text in the background of the document.

    watermark

  • 34

    this will specify exactly what types of values are stored in a cell.

    Number Format

  • 35

    Two types of cell

    Relative and Absolute