Foundations of Tech semester test

a. #####

If a column is not wide enough, ... is displayed?

a. illustrations

The picture button appears in the ... group of the Insert tab.

True

A watermark will print behind worksheet data.

True

A workbook can be password protected.

False

A worksheet background will print behind a worksheet data.

a. property

A(n) ... control contains the document property information you entered in the Document information Panel, or if you did not assign a document property, placeholder text.

True

A(n) nested table is a table within a table.

b. chart

A(n) object is best used to illustrate a trend, pattern, or relationship in numerical data.

b. Header

A(n)... row is the first row of a table that contains the column headings.

a. Themes

To apply a theme to a document, you use the Themes command in the ... group on the design tab.

c. Create a table in the document, and then insert text and graphics in the table cells

To be able to position text and graphics precisely on a document you plan to save as a web page, it is best to...

d. [Shift]

To draw a circle, you can click the Oval in the Shapes menu, then press... while you drag with the pointer.

b. Modify building block

To edit the properties of a building block, you use the... dialog box.

True

The proper text function capitalizes the first letter of a string of data.

b. Data

To repeat the header row on every page of a table that spans multiple pages, you can click the Repeat Header Rows button in the... group on the Table Tools Layout tab.

d. Reset to Theme from Template

To restore a document to the default theme for the template on which the document is based, click the themes button, and then click...

c. Final paragraph mark

To store paragraph formatting with a building block, you should make sure to select the ... when you select the text.

a. Table

To turn gridlines off or on, in a selected table, you should click the view gridlines button in the... group on the table tools layout tab.

True

When you drag a cropping handle on a drawing canvas, the graphic is not resized, but rather just trimmed.

True

You must type underscores instead of spaces between words when you assign a name to a cell or range.

a. quick parts

You save an item as a building block using the... command.

True

As you move the pointer over a style in the Quick Styles Gallery, preview of that style is applied to the selected text.

False

In a table, you can sort the rows only by the information contained in it one column.

True

The AND function returns a value of TRUE if every logical text in the formula is true.

True

The Arrow Keys can be used to nudge a graphic in small increments.

b. zoom

The Page Width Button is located in the ... group of the View tab.

True

When you merge cells, Word converts the text in each cell into one paragraph in the merged cell.

True

When you only want to use part of a picture, you can Crop it to trim the parts you don't want to use.

True

When you select a row, you must also select the end of row mark for the row to be selected

a. Split

When you... a cell, you divide an existing cell into multiple cells.

a. Insert Picture

Which dialog box is used to insert graphics in a document?

a. #NUM!

Which error code will display if a number is used invalidly in a cell?

a. =Average(A1*A3)

Which of the following is NOT a valid formula for averaging the values in cells A1, A2, and A3?

a. Amount

Which of the following is NOT part of the PMT Function?

c. tmp

Which of the following is not a valid file extension for a bitmap graphic?

c. Substitute

Which text function replaces text in a string?

False

The lines that divide the columns and rows in a table are called cells

True

Data can be consolidated from different worksheets.

False

Once you create a chart, you cannot change the chart type.

b. [Up Arrow]

Use...to move a graphic.

True

A Cell is the box formed by the intersection of a column and row in a table.

True

A Chart is a great way to represent numerical data.

d. Triple-clicking

... a word selects the entire paragraph, including the paragraph mark.

True

A delimiter is a data separator.

True

A grid of columns and rows of cells is called a table.

True

A logical function contains 3 parts: a condition, action if TRUE, action if FALSE.

True

After clicking the Crop button, cropping handles with solid black lines appear on all four sides and corner of the graphic.

False

Borders are blue dotted lines that show the boundaries of cells, but do not print.

False

Cells in the data entry area are generally locked.

True

Changing the theme applied to a document is a quick way to set the tone of a document and give it a polished and cohesive appearance, particularly if the text and any tables, charts, shapes, SmartArt objects, or text boxes in the document are formatted with styles.

a. blank page

Click the... button in the Pages group to insert a blank page at the location of the insertion point.

True

Sidebars are inserted on the left side of an even-numbered page.

b. John Smith

Determine the calculated result of the formula = Proper(john smith)

d. A corner

Dragging ... sizing handle resizes the photo proportionally so that its width and height are reduced or enlarged by the same percentage.

True

Each Quick Style set includes styles for a title, subtitle, headings, body text, lists, quotes, and other text elements.

False

Excel allows you to split the worksheet area into horizontal panes only.

True

Excel uses a comma to separate multiple arguments in all functions.

c. Blue

Gridlines are... dotted lines that show the boundaries of cells, but do not print.

True

If a number is divided by zero the error value #DIV/0! will display in the cell.

True

If a value in a formula is not available the error value #NA will display in the cell.

True

If there are invalid cell references in a formula the error value #REF! will display in the cell.

c. Distribute rows

If you want to quickly make all the rows in a table the same height, which command should you use?

b. The seventh column

In the cell reference G6, what does "G" represent?

False

It is a good idea to not name categories for building blocks so you can't find them.

False

Manual page breaks adjust automatically when you insert data into a worksheet.

True

One way to create a text box is to draw one around existing text.

True

Pressing [Tab] at the end of a table row moves the insertion point to the first cell in the next row.

True

Pressing [Tab] at the end of the last cell in a table creates a new blank row at the bottom of the table.

True

Symbols, such as less than (<), greater than (>), and equal to (=), are all examples of comparison operators.

False

The # (number symbol) is an external reference indicator.

True

The Split Table command allows you to split a table into two tables.

a. design

The Themes Colors button appears in the Document Formatting group of the ... tab.

True

The building block organizer includes a complete list of built-in customized building blocks from every gallery.

c. D3

The cell in the third row of the fourth column is cell

True

The cell lock option does not take effect until the protection feature is activated.

False

The concatenate function breaks a text string into separate strings.

True

The document inspector feature finds hidden data in a worksheet.

b. Chart

Use the ... button on the insert tab to create a chart.

d. The table is selected

What happens when you click a table move handle?

b. The column automatically resizes to fit the text

What happens when you double-click a border between two columns in a table?

c. A table inserted within the cell of another table

What is a "nested table"?

c. green

When a graphic is selected, a ... rotate handle appears.

a. White

When a graphic is selected,... circles and squares, called sizing handles, appear on the sides and corners of the graphic.

b. Sorted

When the rows in a table are organized in alphabetical or sequential order, the table is...

c. Building block

When you design a piece of content that you want to use again in other documents, you can save it as a... in one of the Word galleries.

True

When you double click a photo the picture tools format tab is activated and the picture changed into a floating graphic.

c. convert text to columns

Which Excel feature is used to break a data field into separate columns?

b. Insert Table Command on the Table Command the tables group

Which command is used to create a table?

d. #NA

Which error code will display if a value in a formula is not available?

False

You can assign names to cells and ranges, but you cannot use these names in formulas.

b. panel

You can assign or update a document property by typing directly in a property control or by typing in the Document Information...

True

You can build a logical formula using an IF function.

d. changing the text wrapping style of In Line with Text

You can change a floating graphic to an inline graphic by...

[Shift][Delete]

You can delete a row or column by selecting it and pressing...

b. Adjustment Handle

You can drag a(n)... to modify the shapes, but not the size, of a shape.

b. [Ctrl][N]

You can press... to open a new blank document.

b. Arrow

You can use the ... keys to move the insertion point from cell to cell.

False

You cannot insert more than one row at a time.