BOS State Test

In Excel, if $1234.5 is typed in the formula bar, what displays in the cell?

$1,234.50

Which of the following cell references would remain the same when copied?

$B$16

Which cell reference below correctly expresses an absolute cell reference in an Excel formula?

$B$2

Refer to the Excel window labels below. Besides the active cell, where else does text display as you type?

B - formula bar

What is the smallest font size that should be used in a PowerPoint presentation?

24 point

In Excel ... Cell B4 contains value 100 Cell D5 contains value 90 Cell E7 contains function =IF(B4>D5, 80, 70) What value will display in E7?

80

Which of the expressions below show the correct form of a function in Excel?

=SUM(A1:J1)

In Excel, if the active cell is K26 and the Home key is pressed, which cell becomes the active cell?

A26

In Excel, commonly used functions like SUM, AVERAGE, MAX, and MIN can be quickly found using which drop-down menu?

AutoSum

In Excel, what are the vertical group of cells called that are labeled with letters across the top of the sheet?

Column

What is the term used to describe a setting in software that is predetermined? For example, when you open a Word document, 1-inch margins are predetermined.

Default

If a formula in Excel references cells that gets deleted, Excel will not adjust the cell references; the formula will need to be rewritten.

False

In Excel, to assign a dollar sign that is to the left of the first number in the value rather than a dollar sign that is at the left of the cell, choose the Accounting format in the Number text box.

False

In Access, what are columns called?

Fields

In Access, what provides a convenient way for users to enter data into their tables?

Forms

What type of cell alignment was applied to the column headings in the first row of the worksheet below?

Horizontal Center / Vertical Bottom

Which Excel function returns one of two values based on a logical test?

IF

What is the function used to find a specific value from a table based on a cell's value?

LOOKUP

What function is used to find the largest value in a range of cells?

MAX

What function is used to find the smallest value in a range of cells?

MIN

In Excel, what function enters a date and time that automatically updates?

NOW

In Access, what allows the user to extract useful information from the tables?

Queries

What is the term used to describe an adjacent group of cells in a worksheet? For example: H4:H10.

Range

In Access, what are rows called?

Records

In Access, what provides an easy-to-read printable summary of your data?

Reports

In Excel, what are the horizontal group of cells called that are labeled by number down the left side of the sheet?

Row

The table below was sorted. Which column in the table controlled the sort?

Score

In Excel, which feature below would be best to use if you wanted to view opposite Columns in a worksheet?

Split Panes

In Access, what forms the backbone of the database?

Tables

Access databases are called 'relational' because they work by creating relationships between multiple data tables.

True

Each table in Access has one field that is designated as the primary key field.

True

In Access, each record relates to a unique person, object, or event.

True

In Access, fields determine what kind of information is kept about each record.

True

In Access, the purpose of the field that is designated as a primary key is to give each record a unique identifier.

True

In Excel, using the Delete key will clear data from cells, but the cells remain in the worksheet.

True

Which of the following is a correct design principle when creating a presentation? Choose all that apply.

Use at least a 24 point font, Use animation and slide transitions sparingly, Use complementary colors, Be brief and keep to the point, and Adhere to copyright laws

What is the feature in Word that converts text to a graphic?

WordArt

a, b, c, d, e, f, g, h, i, j, k, l, m, n

a = move image b = rotate image c = resize a column or row d = select a range of cells e = merge and center cells f = increase decimal g = insert function h = paste i = format painter j = decrease indent k = accounting number format l = sum function/AutoSum m = fill color n = font color

a, b, c, d

a = name box b = insert function c = active cell d = sheet tabs

What type of sort was used to sort the Score column in the table below?

ascending

What feature is used so the slide show will advance at a predetermined rate?

automatic timing

In Word, what is inserted to end a paragraph in one column and start a new paragraph at the top of the next column?

column break

In Excel, what is the feature called that applies formatting when the cell content meets certain criteria?

conditional formatting

In Word, what command is used to insert a section break and start the new section on the same page?

continuous break

In Excel, what is the name of the feature that allows the user to copy formulas as well as create a series of numbers, dates, or month names in a range of cells? It is the green square in the bottom right-hand corner of the active cell.

fill handle

What feature is used to temporarily hide information that does not meet a specific criteria?

filter

What feature is used to quickly apply existing formatting to multiple pieces of texts or shapes.

format painter

In an Excel worksheet, what feature is used to allow rows and/or columns to display even while scrolling to the right or down?

freeze panes

In PowerPoint what button can be created to allow a user to perform tasks like going to a specific slide?

go forward button

In PowerPoint, what is used to link to other places including other slides, a file, or web sites?

hyperlink

Which document(s) listed below would most commonly be formatted using columns? Choose all that apply.

magazines and newspapers

In Excel, when the grid lines are removed between two or more cells, what is this called?

merged

In an Excel worksheet, what is used that makes formulas easier to understand and maintain?

named ranges

What feature is used in PowerPoint to add information to a presentation that the audience won't see?

notes pane

In Word, which type of break is used to end the current page and move to the next page?

page break

In PowerPoint, what is used in a slide layout that arranges text or content in various configurations?

placeholders

Endnotes are placed at the end of the document and footnotes are placed at the bottom of the page, so what is the only real difference between them?

placement

What is the name of the view option that allows you to see the document as it will be printed including headers, footers, and page numbers?

print preview

What needs to be selected to designate which row/column will print on every page of an Excel worksheet?

print title

Which page layout option enables an Excel worksheet to be printed on a certain number of pages?

scaling

What feature is used in PowerPoint to control styles, design/themes, objects, text, etc. that appears on all slides of the same type.

slide master

What button is used to view a PowerPoint presentation in full screen?

slide show

What button is used to view multiple slides on a page in PowerPoint?

slide sorter

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

sorted data

In Word, which text wrapping option was used to achieve this result around this graphic?

square

What appears horizontally at the bottom of an open Windows application and displays information about the current state of the document?

status bar

What is a saved collection of formatting characteristics that can be applied to items within a document?

style

In Word, what feature is used to align text at the same place on each line?

tabs

In Word, which text wrapping option was used to achieve this result around this graphic?

tight

What is lightly shaded words or pictures that prints behind text called?

watermark

In Excel, what is the name of the feature used to create the two-line heading as pictured below?

wrap text