Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Botany > MS EXCEL > Flashcards

MS EXCEL Flashcards

1
Q

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.

A

MS EXCEL

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

It’s made up of Columns, Rows and cell

A

MS EXCEL

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

It is an environment that can make number manipulation easy

A

MS EXCEL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  • a spreadsheet file.
A

Workbook

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

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

A

3

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

–Working area IN EXCEL

It is made up of rows and columns

A

Worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  • a rectangular bar that intersect columns and rows.
A

Cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q
  • In an Excel 2007 worksheet, the cell with the black outline. l
A

Active Cell

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

Data is always entered into the ____

A

ACTIVE CELL

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

displays the data or formula stored in the active cell.

A

formula bar

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

is a mathematical equation used to calculate a value

A

A formula in a spreadsheet, such as Excel

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

In Excel formulas must begin with an ____ sign.

A

equal ( = )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  • Columns run vertically on a worksheet and each one is identified by a letter in the column header.
A

Column Letter

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

the last column letter

A

XFD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  • run horizontally in an Excel worksheet. They are identified by a number in the row header.
A

Row Header

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

last row number

A

1048576

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

– active workbook on a worksheet.

A

Sheet tabs

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

Switching between worksheets in an Excel 2007 file is done

A

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

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

– guidelines on a worksheet

A

Gridlines

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

– file extension

A

.xlsx

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

default filename

A

Book1

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

– default font style and size

A

Calibri 11

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

keyboard command to edit cell

A

F2 –

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

default location of active cell

A

A1 -

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

Displays the name of the workbook and the program

A

Title Bar

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

Minimize, Restore Down/Max, and close buttons

Close button to exit excel.

A

Used to control the program window.

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

button to hide the window.

A

Minimize button

28
Q

button to adjust the size of the windows

A

Restore Down/Max button

29
Q

button to exit excel.

A

Close button

30
Q

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

A

Quick Access Toolbar

31
Q

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

A

Ribbon

32
Q

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.

A

Formula bar

33
Q

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

A

Name box

34
Q

Displays a portion of a the worksheet

A

Workbook window

35
Q

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

A

Sheet tabs

36
Q

Used to scroll through the worksheet

A

Scroll bars

37
Q

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

A

Status bar

38
Q

shortcut for file

A

Alt F

39
Q

shortcut for Home

A

Alt H

40
Q

shortcut for insert

A

Alt N

41
Q

shortcut for Page Layout

A

Alt P

42
Q

shortcut for FORMULAS

A

Alt M

43
Q

shortcut for DATA

A

Alt D

44
Q

shortcut for REVIEWS

A

Alt R

45
Q

shortcut for VIEW

A

Alt W

46
Q

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.

A

LABELS

47
Q

TYPES OF DATA IN EXCEL

contains numbers and can be used in calculations.

A

VALUES

48
Q

TYPES OF DATA IN EXCEL

data is just that, a date or the time entered into a cell.

A

DATES/TIMES

49
Q

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

A

right

50
Q

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

A

values

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

Formula

52
Q

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

A

Function

53
Q
  • 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.
A

Charts

54
Q

– are used to show percentages

A

Pie Charts

55
Q

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

A

Column Charts –

56
Q

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

A

Bar Charts –

57
Q

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

A

Line Charts –

58
Q

Other chart types (5)

A 
 Doughnut chart
 Scatter (XY)
 Stock
 Surface
 Bubble radar
59
Q

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

A

Ctrl + Page Down keys

60
Q

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

A

Home key:

61
Q

moves the active cell highlight to cell A1.

A

Ctrl + Home keys:

62
Q

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

A

Ctrl + End keys:

63
Q

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

A

Ctrl + Down Arrow keys

64
Q

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

A

Ctrl + Up Arrow keys

65
Q

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

A

Ctrl + Page Up keys

Botany (324 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions