Final Flashcards
When typing a formula, begin the formula with this sign
=
This is the keyboard shortcut to display formulas in a worksheet.
Control ~
To identify an absolute cell reference, type this symbol before the column and row.
$
This function returns the lowest value in a set of values.
MIN
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.
Trace Error
Use 1-inch top, bottom, and side margins for MLA reports. True or False
True
Including your class name is a required item in the running head. True or False
False. Just last name and page number
The first line in the header includes the student name. True or False
True
The third line in the header includes the class name. True or False
True
For parenthetical references that have one or two authors, just list the first authors last name followed by et al. True or False
False. et al. is for four or more authors
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
True
(119). is an example of a parenthetical reference where the author’s last name has been previously cited. True or False
True
In PowerPoint, these are effects that are in place when you switch from one slide to the next.
transitions
Animations that bring a slide element onto the screen are called
Entrance effects
This is the website we used to create headline logos.
Flamingtext.com
If you want to add a sound to a custom animation, you would look for a _________ sound.
wav sound
To select all, press control _ on your keyboard.
a
MLA reports should be double spaced 2.0 or single spaced 1.0?
double spaced 2.0
The date in a MLA report should be in military style.
day month year
True or False
True
The running head information includes your first name and page number.
True or False
False
it’s last name and page number.
The second line of the header includes the student name.
True or False
False
The second line is the Teacher’s Name
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.
Smith, John, and Susan Jones.
First name is backwards and second name is normal order.
Your list of citations at the end of your paper, according to MLA standards, should be titled:
Works Cited
Do not repeat an Author’s name when listing more than 1 book. Instead key —. before the title.
True or False
True
In this case, Marie Boroff wrote two books.
The best way to get a slide show to stop when you’re in slide show view is to:
press esc
I want a graphic to fly in so I would…
use the Animation tab and set a custom animation, entrance effect
If you want to add background music to your PowerPoint presentation, you would add what kind of audio?
MP3
To add bold, press control _ on your keyboard.
b
To copy, press control _ on your keyboard.
c
To paste, press control _ on your keyboard.
v
To shrink the font, press control _ on your keyboard.
[
To close the program, press alt _ on your keyboard.
F4
Seeing (###) in a cell means that the cell width isn’t wide enough to see the number.
True or False
True
In Excel, all formulas begin with what?
=
In the following formula =Sum(A1:A5), the : represents what?
through
In the following formula =Sum(A1:A3), Sum means to?
add
This is the operator for division that is used when writing a formula.
/
This is the operator for multiplication that is used when writing a formula
*
This function returns the largest value in a set of values.
MAX
This is the keyboard shortcut to display formulas in a worksheet.
control ~
This function finds the periodic payment for a loan based on constant payments and a constant interest rate.
PMT
This function returns the future value of an investment periodic, constant payments and a constant interest rate.
FV
1.
File Tab
2.
Quick Access toolbar
3.
Tabs
4.
title bar
5.
active cell
6.
name box
7.
formula bar
8.
merge and center button
9.
autosum
10.
ribbon
11.
vertical scroll bar
12.
horizontal scroll bar
13.
sheet tabs
14.
status bar
15.
fill handle
16.
select all
17.
rows
18.
columns
