Excel Unit A

Question 1

Excel

Answer 1

Electronic Spreadsheet within Microsoft Office.

Question 2

Electronic Spreadsheet

Answer 2

Program used to perform numeric calculations and analyze and present numeric data. Calculations are updated automatically.

Question 3

Worksheet

Answer 3

Each individual spreadsheet you work in.

Question 4

Workbook

Answer 4

File of several worksheets.
File extension: .xlsx

Question 5

What if analysis

Answer 5

Using a worksheet to ask a question.

Question 6

Templates

Answer 6

Predesigned, formatted files.

Question 7

You can use spreadsheets to:

Answer 7

• perform calculations
• represents values graphically
• generate reports
• organize data
• analyze data
• create “what if” scenarios

Question 8

Name box

Answer 8

Displays the active cell address (e.g.: A1)

Question 9

Formula bar

Answer 9

Allows you to enter or edit data in worksheet.

Question 10

Cell

Answer 10

Intersection of a column and row.

Question 11

Cell address

Answer 11

Unique location identified of the coordinated of the intersecting column & row.

Question 12

Cell pointer

Answer 12

Dark rectangle that outlines the cell in which you are working.

Question 13

Active cell

Answer 13

The cell that is outlined.

Question 14

Sheet tabs

Answer 14

Below the worksheet grid - lets you switch from sheet to sheet in a workbook.

Question 15

Sheet tab scrolling buttons

Answer 15

Let you navigate to additional sheet tabs when available.

Question 16

Status bar

Answer 16

At bottom, provides brief description on the active command or task in progress.

Question 17

Mode indicator

Answer 17

In bottom-left corner of the status bar - provides additional info about certain tasks.

Question 18

Range

Answer 18

Highlight 2 or more cells.

Question 19

Formula

Answer 19

Mathematical equation in a worksheet.

Question 20

Addition

Answer 20

+ = a5+a7

Question 21

Subtraction

Answer 21

• =a5-10

Question 22

Multiplication

Answer 22

• =5*a7

Question 23

Division

Answer 23

/ =a5/a7

Question 24

Percent

Answer 24

% =35%

Question 25

Exponent

Answer 25

^ =6^2

Question 26

Labels

Answer 26

Entires that contain text & numerical information not used in calculations (2009 sales).

Question 27

Values

Answer 27

Are numbers, formulas, and functions used in calculations.

Question 28

Function

Answer 28

Built-in formula.

Question 29

Argument

Answer 29

Information necessary to calculate and answer - cell reference.

Question 30

Edit

Answer 30

To edit a cell, double click it.

Question 31

Formula prefix

Answer 31

=(what a formula starts with)

Question 32

Operators

Answer 32

Indicate what type of calculation you want to perform on the cells. (+,-,/,^,*, etc.)

Question 33

Arithmetic operations

Answer 33

Perform mathematical calculations.

Question 34

Cloud computing

Answer 34

Work done in a virtual environment.

Question 35

Reference operators

Answer 35

Enable you to use ranges in calculations.

Question 36

Normal view

Answer 36

Shows the worksheet without including certain details like headers and footers or rulers.

Question 37

Page layout view

Answer 37

Provides a more accurate view of how it looks when printed.

Question 38

Dotted lines

Answer 38

Indicates print area.