Final Exam Flashcards

(92 cards)

1
Q

What is the easiest way to find journal/newspapers and magazines

A

ABI/INFORM Collection

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

How do you find current magazines/journals

A

click Newspapers then “Pressreader”

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

where do you find Business Statistics or Demographic Statistics

A

click Data and Statistics, then click Canada and scroll to find Statistics Canada

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

the first place to look for Company Information

A

NOT in the library but the company’s website

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

other place to look for Company Information

A

FPinformart.ca: FP Advisor or Mint Global

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

Industries or market research

A

IBISWorld and Passport (GMID)

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

What is the top section of word/power point called

A

ribbon

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

Home, Insert, Design are

A

Tabs

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

Groups on the ribbon

A

font groups

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

bold, italics, underline are

A

tools

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

tells you what the tool does before you use it

A

tool tip

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

what is underneath the ribbon

A

document window (the paper)

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

What does the mouse printer look like when its on the document window

A

Upper case letter I

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

Where we have similar tools grouped together on the ribbon

A

Group

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

Top left of screen you have save, undo, redo

A

quick access tool bar

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

words that are misspelled in word will be

A

underlined in red

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

words with grammar errors in word will be

A

underlined in blue

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

Ctrl A is the short cut key for

A

select all

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

ctlr X

A

copy

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

short cut key for Cut is

A

ctlr C

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

short cut key for paste is

A

ctrl V

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

Tool used to help us see what is going on

A

Show/Hide

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

if you want to edit/format a picture

A

context tab

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

what is default way a picture will be placed into word

A

in Line with Text

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
the way we want a picture wrapped is
Top and Bottom
26
If i want one part of my document in word to be different then another part of the same document
section break
27
for a new page on top (like title page)
Next page section break
28
Nice footer
view master horizontal
29
If i want to unlink one section from the other section I would
link to
30
help automatically format pieces of our document
styles
31
how can i easily format 1 piece of my document to another piece of the document
format printer
32
Why do they call it Excel
it's made out of cells
33
Letters are
columns
34
Numbers are
rows
35
A1, A2 are examples of
cells
36
what tells us the address of the cell you're currently on
name box
37
the litlle fx beside the name box is the
insert function
38
Long bar beside fx in Excel
formula bar
39
lines between cells
grid lines
40
what does your mouse printer look like on Excel
white plus sign
41
* in Excel is
multiplication sign
42
formulas in Excel start with
equal sign (=)
43
what is the black plus sign
fill handle
44
every regular cell is a
relative cell
45
when you insert a column it
goes to the left
46
when you insert a row it
goes above
47
what are formulas that are already built into Excel
functions
48
cell that can't change
absolute cell
49
when do you use $
to lock down a cell
50
what does an exclamation point do on Excel
tells Excel were talking about sheet
51
is what's tracing before
tracing precedents
52
is what's tracing after
Tracing dependents
53
shows what Excel sees. ex: we see 4000, excel sees B4+C4=D4*E4
Shows formulas
54
Can place things at the center of a cell/numerous cells
Merge and Center
55
If you have 3 open brackets you must close with
3 brackets
56
Formula with 1 closed bracket and 3 open brackets or formula with an equal sign are examples of
wrong answers
57
Protect workbook and protect sheet
review
58
by default if you protect a sheet
every cell will be locked
59
changes the shape and order of the data forever
sort
60
are temporary and allow us to ask questions
filters
61
allows you to paste only specific aspect of the data
paste special
62
value to look up, range to loom up, column to look in
VLOOKUP
63
value to look up, range to look in, row to look in
HLOOKUP
64
theme or design template
slide background
65
under design, slide size, which will take up full screen
4 by 3
66
a way for us to design a business model or diagram on PP
Smart art (green arrow)
67
animation that occurs when we move from slide to slide
slide transition
68
3 kinds of slide transitions
subtle, exciting and dynamic
69
what are the 4 types of animations
entrance, emphasis, exit, custom
70
shows basic building blocs of our presentations
slide master
71
If I want one part of my document in word to be different then another part of the same document:
format paper or layout, break and next page
72
where do you find vlab Visio
vlab.usask.ca
73
where do you save your Visio shapes
Cabinet Drive
74
what are 3 things we drew in vision
organizational chart, floor plan and a simple business model
75
what unit of measure would we chose if we did a business model/organizational chart
it doesn't matter
76
if we go to the view tab we can turn on grid options which
turns into graphing paper
77
how can i select more than one shape
i can hold shift or ctrl or take my mouse and draw around them
78
how to change your ORG chart
go to ORG chart
79
how would i connect 2 shapes in visio that werent already connected
dynamic connector
80
if i want access to more shapes in the template i click
more shapes
81
paste special as a picture
put into word as a j-peg
82
what do you press to stop a presentation early or zoom out
ESC
83
animate something from off the screen
entrance
84
to draw attention
emphasis
85
using themes we click the
design tab
86
online sources of other templates and themes
file tab --> new
87
where do we find slide master
view tab
88
automatically enters a formula into Excel
auto sum
89
groups of cells are
cell ranges or ranges of cells
90
a set of values that Excel saves and can substitute automatically on your worksheet
scenario analysis
91
can perform a logical test and return one value for a TRUE result and another for a FALSE result
IF functions
92
a tiny chart in a worksheet cell that provides a visual representation of data
sparklines