Brainscape's Knowledge GenomeTM

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


See full index

MGST 217 > Section 1 > Flashcards

Section 1 Flashcards

1
Q

What is excel used for?

A

Organizign data, statitics, making predictions

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

ROWS VS COLUMNS
HOW ARE THEY DISTINGUISHED

A

Rows are horizontal!!! They are by number
Columns vertical!!!!!!! they are by letter

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

What is a cell

A

Where row and column intersect named by C,R
B1 H3 J18 F23

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

Range of cells

A

A selection of multiple cells

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

Organization of the top of excel

A

MENU is the one with FIle Home Insert
Ribbon is the big middle one!!!!!! wil cut copy paste
NAME BOX/INSERT FUNCTION/ FORMULA BAR IS WHAT IS RIGHT ABOVE WORKSHEET!

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

How to insert a function to a cell?

A

Directly to the cell

OR

INSERT FUNCTION BUTTON

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

Name box

A

What ssays the active cell/ the first cell in the range

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

Formula bar

A

shows content of active cell and lets you edit

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

Bottom left is the

A

WORKSHEET TAB

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

Status BAR

A

BOTTOM RIGHT! SHOWS: sum count average

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

Active cell

A

the cell you are working in!

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

Functions
ADD
SUBTRACT
MULTIPLY
DIVIDE
EXPONENNT

A

=A2+B2
=A2-B1
=A3*A2
=A1/V3
=H1^N4

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

How to add without using =X1+R1?

A

USE AUTOSUM
=(Find the Auto sum button in the home menu)

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

which function shoul dyou use to detemine how many cell inputs you have?

A

=Count(range)

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

how to count conditionally

A

=COUNTIF( RANGE, “—”)
THE “—” CAN BE REPLACED BY >4 ETC.

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

What is sumproduct

A

Gets the products of everything, and then sums it all up!

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

Logic operator- If?
** KEY TO NOTE?

A

=IF(CELL>4, “YES”, “NO”)

=IF(Cell(logic operation), “true”, “false”)
DONT NEED A QUOTES AROUND THE >4 SIGN HERE BC EXCEL KNOWS WASSUP

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

Formatting where are the decimals/whole numbers?

A

UNDER Menu on our RIBBON! there is everything

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

Formatting:
Decimal
Currencies
Percent
Whole number

A

Use the -> and <- buttons to adjust

$, or the arrow beside > more acct formats > currency > choose symbol

Click Percent button

COMMA

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

Conditionnaly formatting?

A
  1. click conditionally format
  2. HIGHLIGHT CELLS RULE, pick rule
  3. put in number, and then change the colour
21
Q

How to insert a chart?

A
  1. Select entire area
  2. Insert > choose ur type of chart
22
Q

EXCEL ERROR MESSAGES
####
#DIV/0!
#NA
#NAME?
#NULL
#NUM!
#REF!
#VALUE!

A

Cell has negative date/time/column width is not wide

div by 0 or blank cell

No reference cell value available (not necessarily error value)

formula name text not recognized! (wHEN U FORGET “”)

2 or more cell references separated incorrectly by space in aforumla

invalid numeric data for sort of operation!!

reference is invalid

wrong type or argument is used

23
Q

EXCEL ERROR MESSAGES
####
#DIV/0!
#NA
#NAME?
#NULL
#NUM!
#REF!
#VALUE!

A

Cell has negative date/time/column width is not wide

div by 0 or blank cell

No reference cell value available (not necessarily error value)

formula name text not recognized! (wHEN U FORGET “”)

2 or more cell references separated incorrectly by space in aforumla

invalid numeric data for sort of operation!!

reference is invalid

wrong type or argument is used

24
Q

cell reference vs. absolute reference

A

Cell reference: they move with each new cell!!

absolute reference, will always reference one cell even if you move!!!

25
Q

How to do absolute references?

A

When you put the column,row PUT A $ IN FRONT OF BOTH!!!

$E$2 (will refer to the same column adn row)
$E2 (will refer to the same column every time)
E$2 (Will refere to the same row each time)

26
Q

How to make cell adress?

A

=ADDRESS(Row num, cell num)

27
Q

How to find adress

A

=ADDRESS(ROW#,COLUMN#)

make sure you have the numbers not B1, 1,2

28
Q

Root fORMULA

A

ROOT= ^1/2

=(cell)^(1/cell 2)

29
Q

Growing by a percentage
Dying by a percent

NOTE
what r these

A

(cell)*(1+—- %)

(Cell)*(1——%)

IT MUST BE IN PERCENTAGE FORMAT!!!!!!!!!!!
FORMULAS

30
Q

Calculating square root function/ formula

A
  1. either =swrt(cell)
  2. cell^(1/2)
31
Q

FORMULA VS FUCNTION

A

Straight up add subtract w/ +-/*
=SUM =AVERAGE =PRODUCT

32
Q

####

A

negative date/time
column width is not wide

33
Q

DIV/0!

A

Division by zero doesnt work

34
Q

N/A

A

no value available

35
Q

Null

A

cell references are wrong
YOU put a space in the formula

36
Q

num!

A

invalid numeric data (non numbers)

37
Q

ref!

A

reference is invalid!!!!!!!

38
Q

value

A

wrong argument is being used

39
Q

name

A

text in formula not recognized

40
Q

VALUES vs ARRAYS

when does this apply

A

Numbesrs, cell reference, cell ranges

cell ranges

Count(value1,value2)
SUPRODUCT(array1, array 2)

41
Q

How to copy all the data in a sheet to another?
2

A

TRIANGLE IN TOP LEFT CORNER!!!!!!!!

OR CLICK IN TOP LEFT BOX, CTRL SHIFT RIGHT AND CTRL SHIFT DOWN

42
Q

What would you do if you need to find a specific cell sections?

A

FILTER> EDIT> TYPE WHATEVER INTO THE BLANK BOX

43
Q

What is freeze pane

A

Basically making sure you can see a select amount of cells even when scrolling

choose a cell to the bottom right of the two rows that you want to see even if you scroll

44
Q

WHEREVER POSSIBLE DO NOT WHAT?

esp in what sort of scenarios (homework)

A

TYPE NUMBERS!!!!! YOU SHOULD USE CELL REFERENCE!!

=SUM(XXX)/COUNT(XXX)
NOT COUNT 53 OR WHATEEVER

45
Q

How to fill a column verticallyy?

A

Hover over the corner until you can see the white cross and double clikc

46
Q

How to do equal to more than or less?U

A

USE THE <= AND >= FORMULAS

47
Q

WHAT IF CTRL SHIFT GETS TOO MANY CELLS?

A

U USE THE SHIFT UP AND SHUFT FOWN TO MOVE INDIVIDUALLY UP DOWN

48
Q

HOW TO SEE ALL FORMULAS

A

CTRL+APOSTROPHE

49
Q

GROUP EXERCISES?

A

DO THE SHEET BEFOR EYOU START QUIZ

MGST 217 (7 decks)

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