BIM 1 Exam

Formulas can include standard arithmetic operators, including ____

+,-,*,/

What are the two ways of designating negative numbers in cells?

- and ()

You can use the [tab] key to add a new row to the bottom of a table

True

The ____ option forces text to wrap within a cell

Wrap Text

Which key do you use to change a chart size proportionally

[shift]

Insert a ____ to make navigating in long Word documents easier.

a bookmark

Inserting the date as ____ causes it to show today's date whenever the document is open..

a field

Clicking the Help button leads you to _____

a search box for typing in terms

When inserting rows into a worksheet, inserted rows always appear ____

above the selected rows

The cell references in the formula =$A$3-$B$3 are ____

absolute

After you start Excel, you can begin entering data immediately. You can enter data into the ____ cell

active

The AutoCorrect dialog box allows you to ____

add entries to the AutoCorrect table, delete entries from the table, and set other AutoCorrect option

what is true about the Insert Function dialog box.

allows you to locate a function by typing a description, locate a function by searching categories and access to Excel's built-in functions

The AutoFill options button ____

appears after you fill cells in a worksheet

When you close a document and then reopen it, Word remembers your last editing point and presents a pop-up ____ offering to let you pick up where you left off

bookmark

The chart tools displayed on the Ribbion when a chart is selected allow you to make changes to ____

design, layout, and formatting

to set row heights using AutoFit, select the desired rows and then ____

double-click between any two selected headings

What is not a type of paragraph alignment

double-spaced

What is NOT a spreadsheet task

writing a scholarly paper

What Excel feature can you use to quickly preview and select different chart elements, styles, and filters?

Chart formatting buttons

The number 6,467.99 uses what number format?

Comma with 2 decimal places

Documents created using a previous version of Word are opened in _____

Compatibility Mode

Changing the view in Excel also changes how the worksheet will print

False

Excel's Replace command can replace numbers and text but not formats

False

Several workbooks make up a worksheet

False

To copy a worksheet, select the desired sheet and hold down the [shift] key while dragging its tab

False

The ____ button lets you offset entries from the edges of cells

Increase indent

what is true about merged cells

Merged cells behave as one large cell

What type of chart would not have a category axis and a value axis

Pie chart

Frequently used commands appear where

Quick Access toolbar

To help make data fully visible, you can ____

Set a precise column width and/or row height, use AutoFit on column width and/or row height, and manually adjust column width and/or row height

Why might you use the Convert command on the File menu

To upgrade a Word 2010 document with Word 2013 features

A point is a typographic unit of measure; 72 points= 1 in

True

AutoCorrect entries created in Excel are not shared by all programs in the Microsoft Office Suite

True

Excel's Find command can perform searches for a particular word, number, cell reference, formula, or format

True

It is possible to insert multiple rows at once into a table

True

Line charts are most useful for comparing trends over time

True

The print command and the ability to preview your document are available in Backstage view

True

The term spreadsheet and worksheet can be used interchangeably

True

Unlike text, when you enter numbers into a cell and they exceed the width of the cell, the numbers don't spill over into the empty cell to its right

True

When creating a chart, you have the option of either embedding it in the current worksheet where the data is, or placing it on a separate sheet

True

The number of worksheets you can insert into a workbook is limited by the ____

computers memory

What does AutoFill allow you to do?

copy formulas to adjacent cells

What is in-cell editing?

editing the contents of a cell directly in a cell

When you want to draw attention to one particular "slice" of pie chart, you can ____ it

explode

AutoFormat can also be set to create an automatic billeted list when you start a line with an ampersand and followed by a space or tab

false

Click the Format painter once to copy formats to multiple locations

false

Screen resolution and word window sizing have no effect on the arrangement of ribbon buttons

false

The [delete] key removes characters to the left of the insertion point

false

Formatting a worksheet can mean changing the ____

font size

You can modify formulas ____

in either the Formula bar or the cell

To make a spreadsheet active, you select it. You can tell a cell is active because ____

it has a green, bold border

In an Excel chart, the box containing a text description for each data series is the ____

legend

Indenting text offsets text from the ____

margins

When sizing an embedded chart, you ____

must select the chart first

The spelling Checker flags errors in your document with wavy ____ lines; the grammar checker uses ____ wavy lines

red : blue

A range ____ specifies the cells included within a range

reference

A worksheet comprises a grid structure of cells; each cell is identified by a ____, which refers to the row number and the column letter

reference

If you copy the formula in cell C3 that reads =A3-B3 into cell C4 and the formula changes to =A4-B4, then the cell references are ____

relative

One of the most useful functions of Excel's Clear command is ____

removing numeric formats

AutoComplete is useful when you want to ____

repeat the same entry more than once in a column

You can format, hide, and unhid columns and rows by first ____ the desired columns or rows

selecting

To insert or delete only cells, not entire rows or columns, you must tell Excel how to ____ the surrounding cells

shift

In the block style business letter, all elements are ____, except for double spacing between paragraphs

single spaced and left aligned

The ____ can be customized to display a variety of functions including Average, Count, Numerical Count, Minimum, Maximum, and Sum

status bar

A formula is simply a math problem done in Excel; the most common type of calculation is ____

summing a column or a row of numbers

The Merge Across command is used to merge ____

the contents of multiple rows simultaneously

Pie charts are useful for comparing ____

the parts of a whole

Why is it important to save your documents frequently?

to prevent power outrages and accidents resulting in lost data

When might you need to display the actual formulas in a cell

to print formulas

Vertical alignment positions cell contents between the ____ of the cell.

top and bottom

Where can you insert a page number?

top-right corner, bottom-left corner, and bottom-right corner of a document

AutoComplete is useful when you want the same entry repeated more than once in a column

true

AutoFill is useful when you want the same entry repeated more than once in a column

true

Clicking the arrow on the Undo button displays a list of actions that can be undone

true

Custom pictures can be used as bullets

true

Drag and drop is most efficient when moving or copying cells a short distance within the same worksheet

true

Excel charts are automatically updated when the worksheet data changes

true

Excel's IF function displays a value or message based on a logical test you design

true

Formatting does not affect the data itself; it only changes how the data looks

true

If you retype an entry in a cell, the new entry will replace whatever is contained in the cell

true

In excel, text is aligned by default on the left and numbers are aligned by default on the right

true

Once a bookmark is set up, you can easily navigate to it by choosing the desired bookmark name from the Bookmark dialog box or the Go To tab in the Find and Replace dialog box

true

The AutoSum button automatically sums a column or row of numbers.

true

The Fill color button lets you fill the background of selected cells with color

true

The Insert Function dialog box allows you to locate a function by typing a description or searching by category

true

The block style is the most common business-letter style

true

When selecting chart data, you typically will not include both individual category data and totals because the individual data would appear distorted

true

When you insert text in Word, existing text moves to the right as you type

true

When you type a formula into a cell, it is recommended that you begin the formula with an equal sign

true

You can create a hyperlink in Word that opens a file in Excel

true

You can modify any chart object after the chart has been created

true

You can organize a workbook by inserting, deleting, and rearranging worksheets

true

You can put borders around paragraphs, selected areas of text, and even entire pages

true

If you want all the contents in a cell to display, you can ____

use Wrap text, change the cell width, use Shrink to Fit

Page Layout view allows you to see how your spreadsheet will appear ____

when you print it

Microsoft Word is a _____

word-processing program

You can organize a workbook by inserting, deleting, and rearranging ____

worksheets

____ is a cell reference and ____ is a range reference

D5 / E6:E14