DIT Semester 2 Review

Problem with Merged Cells

... is they cannot be used in calculations without causing an error

Conflict Resolution

A meeting between the people in conflict and a neutral party

no impact on work performance

A person's race, religion or gender has...

=SUM(B1:B35)

Add the values in a range of cells

=AVERAGE(B1:B35)

Adds the values of a range of cells and divides that total by the number of cells in the range

=

All formulas and functions start with this character

Access Database

Allows user to create relationships between tables, called queries, to make forms and reports

Merge Cells (Merge and Center)

Although not recommended, often done to create titles of spreadsheets - Use Header instead

Insert, Link, Hyperlink or Actions

Apply this to an object to go to another slide, web page or open an application

Illustrations

Art-related objects including drawing, clip art, images and shapes

Bad teams

Bickering, no work gets done, a central plan is not made, or not cooperate

Negativity and Gossip

Breeds contempt and bad feelings, lowers productivity

Quick Access Toolbar

Can be customized to have commonly used commands within one click

Handouts

Can be set to prints 3 slides with blank notes lines

Transitions

Changes between slides

Delete Chart

Click the outer frame to highlight the entire chart and press backspace

Bar Chart

Compares several values in relation to each other

Line Graph

Compares values, typically used to show changes over time

Good Leader

Confident, listens to team members, innovative, considers others both in team and outside, ingenuitive

Access Reports

Create PDF's or printed documents based on criteria from a table or query

Hide Column

Does not show column, but still uses the values in calculations

Where do you change how a textbox is formatted?

Drawing Tools Contextual ribbon tab, Format, Shape Styles

Professional Attire

Dress for Success - Construction worker looks different than banker

Template

File that is prepopulated with content that new documents can be made from

C3

Identifies the cell at the third row, third column

Seven steps to problem solving

Identify, Explore, Set Goals, Alternatives, Select, Implement, Evaluate

Center

In Word we use Home, Paragraph, but in Excel it is Home, Alignment ...

Range

In a function the cells in which we perform calculations on. I.e., (B1:B35)

Argument

In a function, this is a term for the values used to make a calculation.

Screen Clipping

Insert an image of your computer screen

Pictures

Insert, Illustrations, ....

Insert Picture

Insert, Images and Picture

Header & Footer

Insert, Text ....

Frequent, but short, team meetings

Keep all team members on the "same page" and allows for input from all stakehoders

F5

Key to activate slideshow view

Esc

Key to end a slideshow presentation

Conditional Formatting

Makes a visual indicator, like coloring cells, based on a criteria we specify

Slide Sorter View

Makes it easy to see duration for slides, rearrange slide order, but not for editing slide content

Formula (Function)

Mathematical equation used in Excel to perform calculations

Column Width

Move the cursor between the column letters. When you see a double arrow click and drag to change...

is illeagel

Music, movies and application sharinging

Currency

Number format for money

Accounting

Number format for money that displays negative balances as $(55.00)

Animations

Objects that move

Alt Text

Open Format Picture Pane, Size & Properties and enter a title and description of what a photo is about for ADA compliance

Constructive Critisism

Politely phrased feedback to help someone improve

Password Protect

Prevents unauthorized access to a spreadsheet

S.M.A.R.T

Specific, Measurable, Achievable, Relevant, Time-bound

Home, Cells, Insert Row or Colums

Tab, group and command to add a row or column

Queries

Take data from one table and create relationships with data in another table to organize the output

WordArt

Test that can have additional formatting such as stroke, fill gradients and more

Comma

The character used to separate fields (columns) in a .csv file

Number

To do math calculations cells must be formatted as a ...

shows commitment

Turning work in on time, volunteering to take on a job, quality and care put into work

sexual harassment

Using profanity in the workplace is considered

Pie Chart

Visually compares the partial values to the values in total

######

What we see when a number does not fit in a cell's width

$B1

When filling across the column will stay absolute

B$1

When filling down the row will stay absolute

Notes Panel below slide in Slide View

Where the presenter can put information for themselves to supplement a slides discussion

=B2

Will transfer the value from the second row, second column where ever this formula is typed

Fill Series

You want to continue numbering sequentially so you enter the first two numbers and ...

Work uniforms

create a consistent image across employees and often serve other purposes such as safety

acceptable use policy

defined do's and don'ts regarding technology

Themes

predefined combination of colors, fonts and font effects

Time management plan

should allot a realistic amount of time to complete tasks, prioritize tasks and leave time for unexpected priorities