stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Final Review Flashcards | StudBud
Explore
/
Final Review
Final Review
57 terms
·
StudBud Administration
·
911 plays
This is a review for the IBA Final Exam used Spring and Fall 2016
Flashcards
57 cards
F
Practice quiz
P
Host live
L
Questions
57
Answers
1
Textboxes are useful in Microsoft programs because
Place text anywhere on the presentation
They say what you are thinking
Place text in a shape
Add captions to pictures
2
A header is located where in Word?
Bottom of the page
left of the page
centered on the page
top of the page
3
When you want to add another worksheet to a workbook how do you do it?
Click the plus sign at the bottom by worksheet tabs
Click add
Use the insert tab
Click File tab and then new
4
In Word, under what tab can you find a thesaurus from which you can find synonyms for words?
Insert
Home
Review
References
5
What group is used to change textbox style?
Arrange
Insert Shapes
Shape Styles
WordArt Styles
6
In the paragraph dialog box, where do you click to indent the first line of a paragraph
Alignment
Special indention
Spacing
Left in indention
7
To create a table you go to which tab
Formulas
Page Layout
Data
Insert
8
What page orientation allows you to see more information horizontally on the page?
Portrait
Landscape
9
How do you know if a spreadsheet you are looking at has a hidden row or column?
Letters and numbers are duplicated
Letters and numbers are missing in sequence
Letters or numbers are missing in sequence
Rows or numbers duplicated
10
What is a contextual tab?
A tab that textured
Tab displayed in tab row when object in workarea is selected
Way to change document
Tab that lets you move quickly to a point in text
11
In ppt what creates consistent look throughout ppt presentation
Themes
Fonts
Animations
Transitions
12
A row is identified in Excel by a
Number
Letter
13
What makes a visual impact on a slide
Lots of text
Large pictures
Graphics
Small pictures and words
14
What chart is best to use to show data such as a price over time?
Pie
Column
Bar
Line
15
To MOVE an object in a document you.....
copy and paste
cut and copy
copy and cut
cut and paste
16
When you copy & paste data in a spreadsheet to another data cell in spreadsheet what happens?
Original data is deleted & receiving cell data is moved down
Original data remains &receiving cell data is moved down
Original data is deleted & receiving cell data overwritten
Original data remains & receiving cell data overwritten
17
When you hide/unhide cells how do you access the command?
Click the insert key
right click on the selected cells
click the ctrl-delete keys
Click data tab
18
Which page orientation allows you to see more information vertically?
Landscape
Portrait
19
Which of these formulas uses relative cell references?
=50/4
=$a$4*$c$2
=$a$4*c2
=$a$4*3
20
Which control determines how an animation begins to play
Duration
Delay
Mover earlier
Start
21
What happens when you hide a row or column?
Information is deleted
Information is not visible
Formulas do not work
Information combines with other information
22
How can a website be opened in a ppt
Hyperlink to or embedding it
Action Button
Copying
Pasting
23
What tab on the ribbon would you select to create a Photo Album?
Animation
Design
Insert
Home
24
A page break does....
Eliminates a page
Adds a new page to the document
Creates a numbered list
begins the next line of text on a new page
25
Which number format would you want to apply to a cell showing the total expenses for the month?
Date
Percentage
Currency
Number
26
What symbol is used to designate an absolute cell reference?
$
%
=
*
27
In this formula what calculation is performed first? = A2-15*3+10/A4
15*3
A2-15
10/A4
3+10
28
A column is
horizontal
vertical
29
When putting a textbox on a shape how can you make shape more visible?
Put the shape over textbox
Change the textbox to tranparent
Decrease size of the textbox
30
A column in Excel is identified by a _____
Letter
Number
31
Using many animations and transitions makes a power point better.
False
True
32
When you use CTRL A you are....
Redoes an action
selecting all of the text
Saving
Cutting
33
If you wanted to add the contents of cells A2, B2, C2 into D2, how would you type it in cell?
=Average(a2:d2)
=A2+B2+C2+D2
=SUM
=A2+B2+C2
34
What short cut keys allow you to paste something you have cut or copied into a document?
Ctrl-P
Ctrl-C
Ctrl-V
Ctrl-A
35
In the paragraph dialog box to double space every line in paragraph you set it by clicking
Line spacing
Spacing before
Indention special
Indention left
36
How can you display formulas in a worksheet to see if they are correct?
Display footers
Show all
Show formulas in a print-out or the screen
Display headers
37
You should click at the center of a picture to resize it.
False
True
38
Animations change how an object moves on and off a slide
True
False
39
What is the correct format to calculate the total of column B of numbers in rows 1 to 5?
sum(b1:b5)
=sum(b1:b5)
=sum(b1,b5)
sum(b1,b5)
40
What happens when you merge cells in an Excel document?
Boarders are put around the cells
Cell contents are italicized
text is centered in cell
Cells are combined
41
What is a deliminator in a file of data?
Something that changes data
Something that separates data such as a comma
Something that reduces data
Something that add to data
42
Which tab access the print controls?
Insert
Home
Page Layout
File
43
Items that need to go in a specific order such as a recipe should be in a what kind of list?
Numbered
Connected
Bulleted
44
How do you change the layout of the slide in ppt
Click new in the slides group
Click insert
Click section in the slides group
Click Layout in the slides group
45
What is in the Name Box in Excel?
the cell name
the contents of the cell
the cell format
46
You want to enter a series of times down a column. What would be the best tool for the job?
Cut and Paste
Spelling Checker
Find and Replace
AutoFill
47
If you want a picture and words to appear on a slide at the same time you choose which option
On click
After Previous
With Previous
48
Which of the following files can be used to import data into Excel?
Audio file
Image file
Movie file
Text file
49
What is the ribbon on a Word screen?
The portion of the screen at the bottom where programs show
Only the tabs in Word
the top part of the screen where all commands are located
At top of screen where redo, save & other shortcuts are
50
Which is the correct order for mathematical calculations to be competed (order of operations)?
x^2, *, /, (), +, -
(), +, *, -, /, x^2
(), x^2, *, /, +, -
x^2, /, *, +, (), -
51
Which are font styles?
dailogboxes, views, edits
cursive, print, save
italics, underline, bold
numbers, bullets, underscore
52
A cell's address is made up of:
none of the answers
two letters
a letter(column) and a number(row)
two numbers
53
What is the 7x7 rule in presentations
The presentation should have less than 49 slides
Each slide has not ore than 7 bullets and 7 images
The presentation only has 7 slides with 7 images
Each slide should have no more than 7 lines w/7 words/line
54
A footer is at what part of the page?
bottom
top
center
left
55
In Excel, all formulas must begin with what symbol?
*
=
%
$
56
You should use many different font styles when creating a slide in PPT.
True
False
57
Animations change how a presentation moves from slide to slide.
True
False
