Computer Apps Excel
The path to the Format Painter button is ____. (HOME tab | Painting group) (HOME tab | Number group) (HOME tab | Clipboard group) (HOME tab | Font group)
(HOME tab | Clipboard group)
Panes created using the vertical split bar scroll together horizontally. True False
False
All of the following are valid Excel arithmetic operators EXCEPT ____. > % ^ *
>
The ____________________ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.
Auto Fill Options
The Accounting number format assigns a floating dollar sign. True False
False
The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it. True False
False
When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery. True False
False
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns. True False
False
With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces. True False
False
You should press the SPACEBAR to clear a cell. True False
False
The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.
Fill series
One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.
Formula
When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899. DATETIME NOW CURRENT SYSDATE
NOW
Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell. True False
True
Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and True False
True
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. True False
True
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column. True False
True
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. True False
True
The most common error when entering a formula is to reference the wrong cell in the formula. True False
True
The opposite of merging cells is splitting a merged cell. True False
True
The path to the Logical button is (FORMULAS tab | Function Library group). True False
True
You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. True False
True
The arguments in an IF function are ____. value_if_false value_if_true value_if_true_false logical_test
alue_if_false value_if_true logical_test
You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation.
drag and drop
The person or persons requesting the worksheet should supply their requirements in a ____ document. test issues blank certified requirements
requirements
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. True False
False
Which of the following is an extension of the fill pattern Sunday, Tuesday? Saturday, Sunday, Monday Monday, Wednesday, Friday Wednesday, Thursday, Saturday Thursday, Saturday, Monday
Thursday, Saturday, Monday
The default font for a new workbook is ____________________ 11-point regular black.
Calibri
A(n) ____________________ conveys a visual representation of data.
Chart
When you decrease the row height to ____, the row is hidden. 2 1 0 3
0
Excel remembers the last ____ actions you have completed. 100 25 75 50
100
A cell reference with only one dollar sign before either the column or the row is called an absolute reference. True False
False
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. True False
False
Best fit means that the width of the column will be increased or decreased by a percentage you specify. True False
False
Clicking the Create Function box opens the Function Arguments dialog box. True False
False
Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees. True False
False
Excel includes four types of sparkline charts: line, column, win/loss, and stock. True False
False
Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window. True False
False
A character with a point size of 10 is about 10/72 of one inch in height. True False
True
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. gallery style scheme theme
theme
You use ____ to view an XPS file. Microsoft PowerView Adobe Reader Backstage View XPS Viewer
XPS Viewer
Which of the following calculations multiplies 23 by 0.01? =23 =24-.01 =23+.01 =23%
=23%
If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message. #DIV/0! #REF! #NULL! #N/A
#REF!
You can click the ____ button to undo an automatic correction. Paste Options AutoCorrect Options Trace Error Auto Fill Options
AutoCorrect Options
You can press the ____ keys to open the Format Cells dialog box. CTRL+1 CTRL+4 CTRL+2 CTRL+3
CTRL+1
Press ____ to select the entire worksheet. CTRL+A F1 ALT+A F4
CTRL+A
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. ALT+B TAB+B SHIFT+B CTRL+B
CTRL+B
Which of the following are formatting symbols? Dollar sign ($) Percent sign (%) Pound sign (#) Comma (,)
Dollar sign ($) Percent sign (%) Comma (,)
Which of the following keys moves the insertion point to the end of data in a cell? DELETE END HOME BACKSPACE
END
____ view allows you to create or modify a worksheet while viewing how it will look in printed format. Page Layout Full Screen Normal Page Break Preview
Page Layout
The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.
Relative reference
You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.
Sum
The AVERAGE function requires that the argument be included within parentheses following the function name. True False
True
The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. True False
True
The Sum button menu allows you to enter one of five often-used functions easily into a cell. True False
True
The range of entries that identifies the major groups for a clustered column chart are called the category names. True False
True
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group). True False
True
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. True False
True
You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box. True False
True
Charts can either be embedded in a worksheet or placed in a separate ____. dialog box worksheet chart sheet range
chart sheet
Using the mouse to move or copy cells is called ____. drag and copy drop and drag drag and paste drag and drop
drag and drop
The ____________________ is a small black square in the lower-right corner of the active cell or active range.
fill handle
Excel allows you to ____________________ the titles so that the titles remain on the screen no matter how far down or to the right you scroll.
freeze
Which of the following is a method of entering functions? keyboard, touch gesture, or pointer the Insert Function box in the formula bar the Sum menu the Name box area in the formula bar
keyboard, touch gesture, or pointer the Insert Function box in the formula bar the Sum menu the Name box area in the formula bar
Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.
line
Combining two or more selected cells into one cell is called ____ cells. spanning combining mixing merging
merging
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra. operations positioning placement selections
operations
Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.
planning
The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.
plus sign
Which of the following is not a valid format symbol? dollar sign ($) comma (,) percent sign (%) semi-colon (;)
semi-colon (;)
An Excel ____ allows data to be summarized and charted easily. presentation workflow document worksheet
worksheet
_____ refers to cells not wide enough to display the entire entry. ##### $ +++++ &&&&&
#####
