Unit 4 Lesson 1: Familiarizing with Spreadsheet Application Flashcards

1
Q

-a spreadsheet software used to input and analyze data

-contains grids where you
can place values

-although it is commonly used for computations, you can also place
images, graphs, and charts to represent various data in a document for easier understanding and presentation

A

Excel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

-document itself when you open your Excel

-can contain many spreadsheets

A

Workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

one portion of your document

A

Spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  • works as your normal arithmetic operation

-you need to place an
equal sign (=) before performing any operation between two or more values

A

Formulas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

specialized operations with assigned names that use predefined
formulas and return a value

A

Functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Parts of an Excel Document:

-is a rectangular box where you can input your values

-each one can contain texts, numbers, images, or formulas

A

Cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Parts of an Excel Document:

  • shows the number in a row of the currently selected cell

-these numbers are
arranged in numeric order

A

Row Number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Parts of an Excel Document:

-shows the letter in a column of the currently selected cell

  • are in alphabetical order from A-Z, and will have a combination afterwards such as AA, AB, AC,
    and so on
A

Column Letter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Parts of an Excel Document:

-shows the cell currently selected if you are selecting only one cell

A

Name Box

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Parts of an Excel Document:

  • also shows the number of rows and columns if you are trying to select a big portion of your document which contains several cells
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Parts of an Excel Document:

-is the long rectangle beside the name box where you can input your formulas for your data

-can also use this to input a value in a cell

A

Formula Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Parts of an Excel Document:

-is found on the top of the grid in Excel

A

Ribbon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Parts of an Excel Document:

-allows you to access frequently used tools such as save, undo, and
redo

A

Quick Access Toolbar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Parts of an Excel Document:

-also known as sheets, is where you can select a different sheet to look at its contents

A

Spreadsheet Tab

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Parts of an Excel Document:

-shows different information about the document

A

Status Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly