IBA study guide

66 terms by kkbossy 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

____ are a collection of worksheets

workbooks

saving the workbook frequently is important for the following reason:

if you lose power, the worksheet could be lost

while excel is saving your file, it brieflyu displays a message on the status bar indicating

the amount of the file saved

combining two or more cells together is called __ cells

merging

which keyboard key moves the insertion point to the beginning of data in a cell

home

the ___ tab is the primary tab of the ribbon

home

how do you activate range finder to verify a formula in a cell

double-click in the cell

click ___ in the conditional formatting gallerty to display the new formatting rule dialog box

new rule

if you want to increase or decrease column width significantly, you can right click a column heading and then use the ___ command on the shortcut menu to change the column's width

column width

if a single cell is selected so that the formula bar is not active and then the spell checker is started, Excel checks____

the remainder of the worksheet, including notes and embedded charts

the____ button, in the accompanying figure, allows you to view the page in larger or smaller sizes in the preview window

zoom

what is the first step in renaming the worksheet?

double-click the workseet tab

when you set up a worksheet, you should use cell references in formulas whenever possible, rather than ___ values

constant

the allignment tab allows you to position data by__

indenting, rotating, aligning at the top, bottom or center, centering, left-aligning, or right clicking (all of the above)

the color bar at the bottom of the fill color and font color buttons on the home tab on the ribbon changes to the ___ color

most recently selected

when you change a value on which a chart is depending, excel____

immediately redraws the chart based on the new value

excel rotates the chart 10 degrees in a ___ direction each time you click the increase X rotation button

clockwise

when choosing words for PowerPoint slides, ____

use the less is more principle

what is initially transparent, disappears if not used, but is bright in appearance when the mouse is moved over it?

the mini toolbar

a ___ is available in PowerPoint to ad special words such as proper names, cities and acronyms to a presentation, so that they will not be marked as spelling errors

custom dictionary

what are the tow boxes on the slide known as

placeholders

the slide layouts are apart of the___

layout gallery

elements such as lines, arrows, callouts, and banners that can be added to a slided are known as

shapes

where is the close button located to close PowerPoint?

on the right side of the title bar

the ___ is a central location for managing and sharing documents

office button

to enter a blank line into a document, press the __ key without typing any text on the line

ENTER

the __, or typeface, defines the appearance and shape of letters, numbers, and special characters

font

on most computers, the default font size in word is

11

when using the MLA style, position explanatory notes either at the ____

bottom of the page as footnotes or at the end of the paper as endnotes

the shortcut keys used to center a paragraph are__

CTRL+E

the rule is to press the SPACE BAR ___time(s) after periods, colons, and other punctuation marks

one

in a business letter, the ___ if present, begins two lines below the last line of the inside address

salutation

mode indicators such as enter and ready appear on the status bar and specify the current mode of excel

mode indicators such as enter and ready appear on the status bar and specify the current mode of excel

FALSE FALSE FALSE

excel can only display three font colors: black red and blue

with conditional formatting, if the value of the cell changes and no longer meets the specified condition, excel suppresses the conditional formatting

with conditional formatting, if the value of the cell changes and no longer meets the specified condition, excel suppresses the conditional formatting

excel does not display #REF! in a cell to indicate the cell is a cross reference

excel does not display #REF! in a cell to indicate the cell is a cross reference

FALSE FALSE FALSE

according the the MLA style, on each page of the research paper, precede the page number by the title of the paper

appears automatically based on tasks you perform such as selecting text

mini toolbar

contains a list of commands

menu

appears when you right click an object

shortcut menu

a central location for managing and sharing workbooks

microsoft office button

makes it easier to see and identify each cell in the worksheet

gridline

a set of choices, often graphical, arranged in a grid or in a list

gallery

press the ALT key to display this keyboard code icon for certain commands

Key Tip Badge

provides easy access to frequently used commands; located by default above the ribbon

quick access toolbar

provides easy, central access to the tasks you perform while creating a worksheet

ribbon

presents info about the worksheet, the function of the button to which the mouse pointer is pointing, or the mode of excel

status bar

returns a number that corresponds to the system date and time beginning with December 31, 1899

NOW function

fills a destination area using the format of the source area. no content is copied unless fill is series

fill formatting only

determines the value of a cell on which the formula depends

goal seeking

scrutinizes the impact of changing values in cells hat are referenced by a formula in another cell

what-if analysis

shows the relationship or proportion of parts to a whole

pie chart

indicates a cell is using a name excel does not recognize

#NAME?

copies the contents and format of the source area

keep source formatting

assigns a value of a cell based on a logical test

IF function

keeps a cell reference constant when copying a formula or function

absolute cell referencing

PowerPoint shape selection

a banner

an available character

a type of transition

uncover right

how the mouse pointer looks after selecting the format painter button

paint brush

a serif font choice

cambria

a sans serif font choice

calibri

sizing handles appear like this

small squares and circles

a PowerPoint 2007 layout

title slide

a graphics file type

.gif

man i am so sleepy it makes no sense! but too bad bruhh! cause i have to study for exams tomorrow!!! OMG! AHHHHHHH!!!

...

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set