Excel 2010 Flashcards

0
Q

-

A

Subtraction or negation

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

+

A

Addition

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

*

A

Multiplication

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

/

A

Division

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

%

A

Percent

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

(Caret)

Purpose….exponent

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

Name box

A

Displays the active cell address

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

Formula bar

A

Allows you to enter or edit data in the worksheet

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

Cell

A

The intersection of a row

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

Cell address

A

Every cell has its own unique location

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

Cell pointer

A

Is a dark green rectangle that outlines the cell you are working in

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

Cell pointer

A

A dark green rectangle that outlines the cell you were working in, This cell is called an active cell

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

Sheet tabs

A

Worksheet group lets you switch from one sheet to sheet in a workbook, By default, a workbook file contains three sheets – but you can use just one, or have as many as 255.

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

Sheet tab Scroll button

A

Lets you navigate to additional sheet tabs when available

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

Status bar

A

Is located at the bottom of the Excel window

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

Mode indicator

A

Is in the lower left corner of the status bar and provides additional information about certain task

16
Q

Electronic spreadsheet

A

Is an application you use to perform numeric calculations and to analyze and present numerical data

17
Q

Worksheet

A

The electronic spreadsheet you Work on

18
Q

Workbook

A

Is a file extension

19
Q

What if analysis

A

Any time you use a worksheet to ask the question what if? You’re performing a what if analysis Excel also includes a scenario manager where you can name and save different what if versions of your worksheet

20
Q

Template

A

Preformated formatted files

21
Q

Perform calculations

A

Adding formulas and functions to a worksheet data; for example, adding a list of sales results or calculating a car payment

22
Q

Represent values graphically

A

Creating charts based on worksheet data; for example, creating a chart that displays expenses

23
Q

Generate reports

A

Creating workbooks that combine information from multiple worksheets, such as summarized sales information and multiple stores

24
Q

Organize data

A

Sorting data in ascending or descending order; for example, alphabetizing a list of products or customer names, or prioritizing order by date

25
Q

Analyze data

A

Creating data summaries and shortlist see using Tivitt tables or auto fillers; for example, making a list of top 10 customer based on spending habits

26
Q

Create what if data scenarios

A

Using variable values to investigate and sample different outcomes, such as changing the interest rate for payment schedule on a loan

27
Q

Range

A

A selection of two or more cells is called a range

28
Q

Formula

A

Is an equation in a worksheet

29
Q

What do formulas begin with

A

All Excel formulas begin with the =