Computer Concepts Week 4

A date stamp shows the date a workbook, report, or other document was created or the time period it represents. (T/F)

true

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area. (T/F)

true

The equal sign (=) precedes a formula. (T/F)

true

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear. (T/F)

true

Which function in Excel would be used to average the values in cells A1 through A10? =(A1:A10) =AVERAGE(A1:10) =AVERAGE(A1:A10) =AVG(A1-A10)

=AVERAGE(A1:10)

The formula in Excel to add the contents of cell B10 to the contents of cell C10 is B10 + C10 B10*C10 =B10+ C10 =(B10*C10)

=B10+ C10

To find the lowest value in a range from B10 through B20, use the following function: =MINIMUM(B10-B20) MIN(B10:B20) =MIN(B10:B20) =(B10-B20)

=MIN(B10:B20)

All of the following are valid Excel arithmetic operators EXCEPT ____. ^ * % >

>

Which of the following Option buttons gives options for filling cells following a fill operation? Auto Fill Options AutoCorrect Options Insert Options Paste Options

Auto Fill Options

The range automatically selected by Excel is always correct. (T/F)

False

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery. (T/F)

False

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell. Goal Formula Option Function

Goal

When an item is underlined or in a different color and you position your mouse pointer over the item and click, you are taken to a website. This item is called a Hyperlink URL Search phrase Mouse address

Hyperlink

The ____ function is useful when you want to assign a value to a cell based on a logical test. IF NOW AND OR

IF

The ____ Option button lists formatting options following an insertion of cells, rows, or columns. AutoCorrect Insert Auto Fill Paste

Insert

What type of software tool allows you to open and view a Web page? Look Up Help Hyperlink Internet Explorer/Edge

Internet Explorer/Edge

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. SYSDATE NOW DATETIME CURRENT

NOW

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? Quarter 1 Qtr1 Qtr2 Quarter4

Qtr2

Cooler colors tend to pull away from the reader. (T/F)

True

The most common error when entering a formula is to reference the wrong cell in the formula. (T/F)

True

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. (T/F)

True

Cell references in a formula are called ____. assumptions comments numbers content

assumptions

Panes created using the vertical split bar scroll together horizontally. (T/F)

false

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns. (T/F)

false

You cannot format an entire column at once. (T/F)

false

Which method will allow you to open an application? Click Start button, move to All Programs, point to application and click on application name to open the application. Right-click on desktop and select Properties Point to Start button, click on Run Right-click on Start button, right-click on application to launch

Click Start button, move to All Programs, point to application and click on application name to open the application.

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer's memory. Ribbon Clipboard Folder File

Clipboard

A cell reference with only one dollar sign before either the column or the row is called an absolute reference. (T/F)

False

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. (T/F)

true

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. contiguous indexed direct indirect

indirect

Which comparison operator means "not equal to"? <= > < <>

<>

Which of the following calculations multiplies 23 by 0.01? =23% =23 =23+.01 =24-.01

=23%

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. Comma style format Accounting number format Percent style format Currency style format

Accounting number format

You use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.​ ​ Alignment ​ Left and Right ​Center ​Position

Alignment

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key. ENTER ALT CTRL SHIFT

ENTER

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics? Identification of how to format various elements of the worksheet Avoiding the temptation to use flashy or confusing visual elements within the worksheet

Identification of how to format various elements of the worksheet

The default view in Excel is called ____ view. Normal Standard Basic Values

Normal

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula. (T/F)

True

While holding down the ALT key, you can select nonadjacent ranges and cells. (T/F)

True

Charts can either be embedded in a worksheet or placed in a separate ____. worksheet dialog box chart sheet range

chart sheet

Using the Excel spell checker, you can ____. check the spelling of words in a selected range add words to the dictionary

check the spelling of words in a selected range add words to the dictionary

A ____ is text and graphics that print at the bottom of every page. footer toe margin stopper

footer

Which of the following is a method of entering functions? keyboard, touch gesture, or pointer the Sum menu the Insert Function box in the formula bar the Name box area in the formula bar

keyboard, touch gesture, or pointer the Sum menu the Insert Function box in the formula bar the Name box area in the formula bar

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. included other nested duplicate

nested

Which of the following is a correct address that will allow you access a commercial website? www.mysite.com www-mysite mysite.edu www.mysite-com

www.mysite.com

Which of the following patterns extends the fill series to 525, 475, 425?​ ​ 650, 600 ​625, 575 ​560, 580 ​500, 475

​625, 575

To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____.​ ​ button ​check box ​ option button ​Dialog Box Launcher

​Dialog Box Launcher