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