Parcial 3

Question 1

What is an interface?

Answer 1

Is where two systems, subjects, organizations, etc., meet and interact.

Question 2

Gives you fast and easy access to the tools you use most often in any given Excel session.

Answer 2

Quick Access Toolbar

Question 3

Define ribbon:

Answer 3

Contains all of the commands you will need in order to perform common tasks.

Question 4

What are tabs?

Answer 4

Are related to specific kinds of tasks that users perform in Excel.

Question 5

When do the contextual tabs appear? Name examples:

Answer 5

They appear when you work with certain elements:

• Charts
• Pivot tables
• Shapes

Question 6

What are the groups?

Answer 6

Commands which are organized into related tasks called Command Groups.

Question 7

Some Groups have an arrow in their lower-right corner; this is called a:

Answer 7

Dialog Box Launcher

Question 8

What is a command?

Answer 8

Is a specific order from you to Excel.

Question 9

What is the function of the name box?

Answer 9

It tells you the location or the name of a seleced cell.

Question 10

Function of the formula bar:

Answer 10

You can enter or edit data, a formula, or a function that will appear in a specific cell.

Question 11

What is a column?

Answer 11

Is a group of cells that runs from the top of the page to the bottom.

Question 12

They are identified by letters:

Answer 12

Columns

Question 13

What is a row?

Answer 13

Is a group of cells that runs from the left of the page to the right.

Question 14

They are identified by numbers:

Answer 14

Rows

Question 15

What is a cell?

Answer 15

Is the intersection point of a vertical column and a horizontal row, in which you enter data.

Question 16

The current cell you are working on is the:

Answer 16

Active cell

Question 17

Each _______ begins with a letter to indicate the column, followed by a number to indicate the row.

Answer 17

Cell adress

Question 18

What is a range? Name examples:

Answer 18

Is a group of two or more continuous cells.

• A1:A18
• B5:D7
• AS2: B23

Question 19

________ makes it easy to apply common formatting changes to a cell selection within the worksheet area:

Answer 19

Mini Toolbar

Question 20

They identify the worksheets in a workbook.

Answer 20

Worksheet Tabs

Question 21

You can enter three types of data into the cell:

Answer 21

Labels/Text, Values, and Formulas

Question 22

What are formulas?

Answer 22

Equations that perform calculations on values in a worksheet.

Question 23

What are values?

Answer 23

Numbers, currency, dates and times.

Question 24

What are labels?

Answer 24

Headings, labels, notes and explanatory text which can be alpha-numeric.

Question 25

Where is the fill handle located?

Answer 25

In the lower-right corner of the selected cell or range.

Question 26

What is the auto fill?

Answer 26

Options that will automatically fill cells with data and/or formatting.

Question 27

What are the components of the formula?

Answer 27

Equal sign, operands, and mathematical operator.

Question 28

What are some basic operators?

Answer 28

Add, subtract, multiplication, division, exponent or power.

Question 29

What is the precedence?

Answer 29

Is how formulas calculate values in a specific order.

Question 30

Define syntax:

Answer 30

Describes the structure or order of the elements in a formula or function.

Question 31

Describe the function of a cell reference:

Answer 31

Identifies a cell or a range of cells and tells Excel where to look for the values you want it in the formula.

Question 32

Identify the elements of the next formula: =(B4+25)/SUM(D5:F5)

Answer 32

``` B4 - Cell reference 25 - Numeric constant “+” - Addition operator “/“ - Division operand SUM(D5:F5) - Worksheet function (D5:F5) - Range reference ```

Question 33

Function of relative references:

Answer 33

They change in relation to the cell in which the referring formula is originally entered.

Question 34

An _______________ doesn’t change.

Answer 34

Absolute reference

Question 35

What are functions?

Answer 35

Are built-in formulas that performs more complex calculations.

Question 36

You enter __________ in the parentheses, separated by commas.

Answer 36

Arguments

Question 37

The arguments can be a/an...

Answer 37

- Value - Cell or range reference - Cell or range name or other function

Question 38

Name basic functions and their description:

Answer 38

SUM - Totals a set of numbers. AVERAGE - Averages a set of numbers. MIN - Finds the minimum value in a set. MAX - Finds the maximum value of a set. COUNT - Counts the cells that have numbers. COUNTA - Counts the cells that are not empty.

Question 39

This monetary value places the dollar sign right next to the number:

Answer 39

Currency

Question 40

This monetary value aligns the dollar signs at the left edge of the cell and displays a dash for zero values:

Answer 40

Accounting

Question 41

What are the charts?

Answer 41

Are graphical representation of the data in spreadsheets.

Question 42

Describe what is a column:

Answer 42

Is useful to analyze variations in value over time or to see comparisons.

Question 43

Describe what is a line (chart):

Answer 43

Shows multiple data trends over evenly intervals.

Question 44

Describe what is a pie (chart):

Answer 44

Represents a portion of each value to the total in a data series.

Question 45

Describe what is a bar (chart):

Answer 45

Is useful to compare between individual items

Question 46

Other types of graphs:

Answer 46

Area, scatter, bubble, radar

Question 47

Elements of charts:

Answer 47

- Chart area - Chart title - Plot area - Gridline - Data label - Axis title - Legend (Por favor revisen la imagen de la presentación para ver la ubicación de los elementos)