Final Flashcards

1
Q

When typing a formula, begin the formula with this sign

A

=

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

This is the keyboard shortcut to display formulas in a worksheet.

A

Control ~

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

To identify an absolute cell reference, type this symbol before the column and row.

A

$

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

This function returns the lowest value in a set of values.

A

MIN

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

If Excel detects an error in a formula, a _____ ____ button appears and a dark green triangle displays in the upper left corner of the cell.

A

Trace Error

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

Use 1-inch top, bottom, and side margins for MLA reports. True or False

A

True

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

Including your class name is a required item in the running head. True or False

A

False. Just last name and page number

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

The first line in the header includes the student name. True or False

A

True

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

The third line in the header includes the class name. True or False

A

True

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

For parenthetical references that have one or two authors, just list the first authors last name followed by et al. True or False

A

False. et al. is for four or more authors

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

For up to three authors list all authors’ last names with page numbers as long as the authors name has not been previously cited. True or False

A

True

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

(119). is an example of a parenthetical reference where the author’s last name has been previously cited. True or False

A

True

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

In PowerPoint, these are effects that are in place when you switch from one slide to the next.

A

transitions

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

Animations that bring a slide element onto the screen are called

A

Entrance effects

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

This is the website we used to create headline logos.

A

Flamingtext.com

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

If you want to add a sound to a custom animation, you would look for a _________ sound.

A

wav sound

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

To select all, press control _ on your keyboard.

A

a

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

MLA reports should be double spaced 2.0 or single spaced 1.0?

A

double spaced 2.0

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

The date in a MLA report should be in military style.

day month year

True or False

A

True

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

The running head information includes your first name and page number.

True or False

A

False

it’s last name and page number.

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

The second line of the header includes the student name.

True or False

A

False

The second line is the Teacher’s Name

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

Which of the following is the correct way to list 2 authors on the Works Cited page in the MLA format?

Smith, J., & S. Jones.

John Smith and Susan Jones.

Smith, John, and Susan Jones.

Smith, J., & Jones, S.

A

Smith, John, and Susan Jones.

First name is backwards and second name is normal order.

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

Your list of citations at the end of your paper, according to MLA standards, should be titled:

A

Works Cited

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

Do not repeat an Author’s name when listing more than 1 book. Instead key —. before the title.

True or False

A

True

In this case, Marie Boroff wrote two books.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
The best way to get a slide show to stop when you're in slide show view is to:
press esc
26
I want a graphic to fly in so I would...
use the Animation tab and set a custom animation, entrance effect
27
If you want to add background music to your PowerPoint presentation, you would add what kind of audio?
MP3
28
To add bold, press control _ on your keyboard.
b
29
To copy, press control _ on your keyboard.
c
30
To paste, press control _ on your keyboard.
v
31
To shrink the font, press control _ on your keyboard.
[
32
To close the program, press alt _ on your keyboard.
F4
33
Seeing (###) in a cell means that the cell width isn't wide enough to see the number. True or False
True
34
In Excel, all formulas begin with what?
=
35
In the following formula =Sum(A1:A5), the : represents what?
through
36
In the following formula =Sum(A1:A3), Sum means to?
add
37
This is the operator for **division** that is used when writing a formula.
/
38
This is the operator for **multiplication** that is used when writing a formula
\*
39
This function returns the largest value in a set of values.
MAX
40
This is the keyboard shortcut to display formulas in a worksheet.
control ~
41
This function finds the **periodic payment** for a loan based on constant payments and a constant interest rate.
PMT
42
This function returns the **future value** of an investment periodic, constant payments and a constant interest rate.
FV
43
1.
File Tab
44
2.
Quick Access toolbar
45
3.
Tabs
46
4.
title bar
47
5.
active cell
48
6.
name box
49
7.
formula bar
50
8.
merge and center button
51
9.
autosum
52
10.
ribbon
53
11.
vertical scroll bar
54
12.
horizontal scroll bar
55
13.
sheet tabs
56
14.
status bar
57
15.
fill handle
58
16.
select all
59
17.
rows
60
18.
columns