Excell Unit 8 Flashcards

1
Q

Excell

A

electronic spreadsheet within Microsoft Office

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

Electronic spreadsheet

A

program used to perform numerical calculations and analyze and present numeric data calculations are updated automatically

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

Worksheets

A

each individual spreadsheet you work in

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

Workbook

A

file of several worksheets, File extension: .xlsx

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

What is analysis

A

using a worksheet to ask a question

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

Templates

A

predesigned, formatted files.

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

You can use spreadsheets to

A

Perform calculations, Represent values graphically, Generate reports, Organize data, Analyze data, Create what if scenarios.

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

Name box

A

displays the active cell address (A1)

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

Formula bar

A

allows you to enter or edit data in worksheet

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

Cell

A

intersection of a column and row

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

Cell address

A

unique location identified by the coordinated of the intersecting column & row

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

Cell pointer

A

dark rectangle that outlines the cell in which you are working

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

Active cell

A

the cell that is outlined

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

Sheet tabs

A

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

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

Sheet tab scrolling buttons

A

let you navigate to additional sheet tabs when available

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

Status bar

A

at bottom, provides brief description of the active command or task in progress

17
Q

Mode indicator

A

in bottom-left corner of the status bar - provides additional info.
About certain task.

18
Q

Range

A

a selection of 2 or more cells is a range

19
Q

Formulas

A

equations in a worksheet.

20
Q

Addition

A

+ =a5+a7

21
Q

Subtraction

A

-

22
Q

Multication

A

*

23
Q

Division

A

/

24
Q

Percent

A

%

25
Q

Exponent

A
26
Q

Labels

A

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

27
Q

Values

A

are numbers, formulas, and functions used in calculations

28
Q

Function

A

built in formula

29
Q

Arguments

A

Information. Necessary to calculate and answer - cell reference

30
Q

Edit

A

to edit a cell, double click it

31
Q

Formula prefix

A

= (what a formula starts with)

32
Q

Calculations operator

A

indicate what type of calculation you want to perform on the cells

33
Q

Arithmetic operators

A

perform mathematical calculations

34
Q

Cloud computing

A

work done in a virtual environment

35
Q

Reference operators

A

enable you to use ranges in calculations

36
Q

Normal view

A

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

37
Q

Page layout view

A

provides a more accurate view of how it will look when printed

38
Q

Dotted lines

A

indicates print area