MS EXCEL Flashcards Preview

Botany > MS EXCEL > Flashcards

Flashcards in MS EXCEL Deck (65):
1

a spreadsheet program that allow the user to apply mathematical functions (simply a predefined formula just to make the process easier) to calculate different sets of values and apply the changes in the result when the input values are changed.

MS EXCEL

2

It’s made up of Columns, Rows and cell

MS EXCEL

3

It is an environment that can make number manipulation easy

MS EXCEL

4

- a spreadsheet file.

Workbook

5

By default, each workbook in Excel contains __ pages or worksheets

3

6

–Working area IN EXCEL
It is made up of rows and columns

Worksheet

7

- a rectangular bar that intersect columns and rows.

Cell

8

- In an Excel 2007 worksheet, the cell with the black outline. l

Active Cell

9

Data is always entered into the ____

ACTIVE CELL

10

displays the data or formula stored in the active cell.

formula bar

11

is a mathematical equation used to calculate a value

A formula in a spreadsheet, such as Excel

12

In Excel formulas must begin with an ____ sign.

equal ( = )

13

- Columns run vertically on a worksheet and each one is identified by a letter in the column header.

Column Letter

14

the last column letter

XFD

15

- run horizontally in an Excel worksheet. They are identified by a number in the row header.

Row Header

16

last row number

1048576

17

– active workbook on a worksheet.

Sheet tabs

18

Switching between worksheets in an Excel 2007 file is done

by clicking on the sheet tab at the bottom of the screen.

19

– guidelines on a worksheet

Gridlines

20

– file extension


.xlsx

21

default filename

Book1

22

– default font style and size

Calibri 11

23

keyboard command to edit cell

F2 –

24

default location of active cell

A1 -

25

Displays the name of the workbook and the program

Title Bar

26

Minimize, Restore Down/Max, and close buttons
Close button to exit excel.

Used to control the program window.

27

button to hide the window.

Minimize button

28

button to adjust the size of the windows

Restore Down/Max button

29

button to exit excel.

Close button

30


Contains frequently used commands that are independent of the tab displayed on the Ribbon

Quick Access Toolbar

31

Contains all the commands related to managing workbooks and working with workbook content.

Ribbon

32


Displays the data or formula stored in the active cell. It can also be used to enter or edit a formula, a function, or data in a cell.

Formula bar

33


Displays the active cell address or the name of the selected cell, range, or objects.

Name box

34


Displays a portion of a the worksheet

Workbook window

35


Each tab represents a different worksheet in the workbook. Workbook can have any number of sheets and each sheet has its name displayed on its___ tab

Sheet tabs

36


Used to scroll through the worksheet

Scroll bars

37


Displays various messages as well as the status of NumLock, Caps Lock, and scroll lock keys on the keyboard.

Status bar

38

shortcut for file

Alt F

39

shortcut for Home

Alt H

40

shortcut for insert

Alt N

41

shortcut for Page Layout

Alt P

42

shortcut for FORMULAS

Alt M

43

shortcut for DATA

Alt D

44

shortcut for REVIEWS

Alt R

45

shortcut for VIEW

Alt W

46

TYPES OF DATA IN EXCEL
an entry that is usually used for headings, names, and for identifying columns of data. Labels can contain letters and numbers. By default, labels are left aligned in a cell.

LABELS

47

TYPES OF DATA IN EXCEL
contains numbers and can be used in calculations.

VALUES

48

TYPES OF DATA IN EXCEL
data is just that, a date or the time entered into a cell.

DATES/TIMES

49

by default, date/time data is___ aligned in a cell.

right

50

Sometimes dates are combined with numbers and considered to be what type of data instead of a separate type of data.

values

51

– a mathematical statement using operations such as:
 (+) for addition
 (-) for subtraction
 (*) for multiplication
 (/) for division

Formula

52

– simply a predefined formula just to make the process easier.

Function

53

-are graphical representations of worksheet data
-often makes it easier to understand the data in a worksheet because users can easily pick out patterns and trends illustrated in the chart that are otherwise difficult to see.

Charts

54

-- are used to show percentages

Pie Charts

55

are used to show comparisons between items of data. Each column in the chart represents the value of one item of data.

Column Charts --

56

are very similar to column charts, except they run horizontally on the page instead of vertically like column charts.

Bar Charts --

57

are used to show trends over time. Each line in the graph shows the changes in the value of one item of data.

Line Charts --

58

Other chart types (5)

 Doughnut chart
 Scatter (XY)
 Stock
 Surface
 Bubble radar

59

moves the active cell highlight to the next sheet of the spreadsheet.

Ctrl + Page Down keys

60

moves the active cell highlight to column A without changing rows.

Home key:

61

moves the active cell highlight to cell A1.

Ctrl + Home keys:

62

moves the active cell highlight to the last cell of the spreadsheet containing data.

Ctrl + End keys:

63

moves the active cell highlight to the last row of the spreadsheet without changing columns

Ctrl + Down Arrow keys

64

moves the active cell highlight to the first row of the spreadsheet without changing columns.

Ctrl + Up Arrow keys

65

moves the active cell highlight to the previous sheet of the spreadsheet.

Ctrl + Page Up keys

Decks in Botany Class (324):