Excel 2010

Question 0

-

Answer 0

Subtraction or negation

Question 1

+

Answer 1

Addition

Question 2

*

Answer 2

Multiplication

Question 3

/

Answer 3

Division

Question 4

%

Answer 4

Percent

Answer 5

(Caret)

Purpose….exponent

Question 6

Name box

Answer 6

Displays the active cell address

Question 7

Formula bar

Answer 7

Allows you to enter or edit data in the worksheet

Question 8

Cell

Answer 8

The intersection of a row

Question 9

Cell address

Answer 9

Every cell has its own unique location

Question 10

Cell pointer

Answer 10

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

Question 11

Cell pointer

Answer 11

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

Question 12

Sheet tabs

Answer 12

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.

Question 13

Sheet tab Scroll button

Answer 13

Lets you navigate to additional sheet tabs when available

Question 14

Status bar

Answer 14

Is located at the bottom of the Excel window

Question 15

Mode indicator

Answer 15

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

Question 16

Electronic spreadsheet

Answer 16

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

Question 17

Worksheet

Answer 17

The electronic spreadsheet you Work on

Question 18

Workbook

Answer 18

Is a file extension

Question 19

What if analysis

Answer 19

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

Question 20

Template

Answer 20

Preformated formatted files

Question 21

Perform calculations

Answer 21

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

Question 22

Represent values graphically

Answer 22

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

Question 23

Generate reports

Answer 23

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

Question 24

Organize data

Answer 24

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

Question 25

Analyze data

Answer 25

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

Question 26

Create what if data scenarios

Answer 26

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

Question 27

Range

Answer 27

A selection of two or more cells is called a range

Question 28

Formula

Answer 28

Is an equation in a worksheet

Question 29

What do formulas begin with

Answer 29

All Excel formulas begin with the =