business office specialist state test

the default is the setting that is predetermined in software

true

an adjacent group of cells or H4:H10 is called a range

true

word art concerts text to a graphic

true

a group of vertical cells in a table is called a row

false

a group of horizontal cells in a table is called a row

true

split panes would be better than freeze panes to view opposing ends of a spreadsheet?

true

formatting is applied when a cell meets a certain criteria

conditional formatting

the __________ at the bottom of a program window shoes information about the open file or task being performed

status bar

which type of text wrapping was use to achieve this result (close to picture)

tight wrap

what type of text wrap was used to achieve this affect? (square look around pic)

square wrap

the ___________ provides access to commonly used commands

quick access toolbar

which option correctly expressed a cell as an absolute cell reference?

$B$2

in spreadsheets, what option would be used to break words/labels between lines?

wrap text

this type of view allows you to see the page as it will be printed including headers/footers, and page numbers?

print preview

columns are commonly used in

newspapers and magazines

in excel besides the active cell where does text display as you type?

formula bar

a complete set of information for an individual

data record

a category of information in a data source file

data field

all the data records create a __________

data source file

a ________________ is a saved collection of formatting characteristics and that can be applied to items within a document

look

a cell is _________________ with another cell when the boundaries are removed between the two cells

merged

endnotes are placed at the end of the document and footnotes are placed at the bottom of the page. the only real difference between them is

the placement

______________ should be used to align text at the same place from row-to-row to line-to-line

tabs

selecting __________________ designates which row/column will print on every page of an excel worksheet

print title

what keys would be pressed to display a worksheet in formula view?

ctrl + '

use this function for the smallest value in a range of cells

min

use this function for the largest value in a range of cells

max

returns one of two values based on a logical test

IF statement

finds a specific value in a table based on a cell's value

lookup

which page layout option enables an excel worksheet to be printed on a certain number of pabee

scaling

what must a data range have before subtotals can be inserted?

sorted data

a ________________ temporarily hides information that does not meet a specific criteria

filter

in powerpoint what button can be created to allow a user to perform tasks like going to a specific slide

action button

the smallest font size to use in a presentation

24

what button is used to view the presentation in full screen

slideshow

what button is used to view multiple slides on a page

slide sorter

the __________________ is used to control styles, designs/themes, objects, text, etc. that appears on all sides of the same type

slide sorter

by setting ___________ the slide show will advance at a predetermined rate

automatic timing

the ________________ can be used to add information to a presentation that the audience won't wee

notes pane

links you to other places including slides, file, or websites?

hyperlink

the slide layout includes ____________ that arrange text or content in various configurations

placeholders

use this to quickly apply the same text formatting and other formatting to multiple pieces of texts or shapes

format painter

a ______________ is a grayed word or picture behind the gext

watermark

in an excel worksheet, this will allow you to scroll down or to the right and still see the rows and column you want wherever you are in the worksheet

freeze panes

in an spreadsheet worksheet, using these will make your formulas much easier to understand and maintain

named ranges

in word insert this to end a paragraph in one column and start a new paragraph at the top of the next column

column break

N-word do this command to insert a section break and start the new section on the same page

continuous break

which type of break is used to end the current page and move to the next page

Page break

graphics or text that can be printed on the top or bottom of page are known as

headers and footers

in a hanging indent all but the _____________ line moves to the ____________

first, right

when selecting shading or fill for a cell which of the following is true

dark text should be on a light background and light text should be on a dark background

what correct design principles should be used when creating a presentation

be brief and keep to the point, use at least a 24 point font, use complementary colors, adhere to copyright laws, and use animation and slide transitions sparingly

Why is entering the max function better than simply scanning the range and keying the last value

Excel re-calculate the highest value each time you enter a new value in the range

when the percent style button on the home tab/numbers group is clicked what happens to the value in the cell

100 is multiplied by the continent of the cell and is rounded to the nearest percent

to save the worksheet to a different location or with a different name he was which option in the file menu

save as

Primary key

allows you to create a relationship between two tables. It is a field in a database that uniquely identifies each row. Example your student ID number

Field

A column in a database table. It contains information about a particular item stored in a table

Data record

information in a database table. Example all of your personal information in the school district database. You are a record.

Data source

Data source also called a data file is simply a collection of records that store data

Which part comes first in the IF function

value if true