Computer Apps Excel

Ace your homework & exams now with Quizwiz!

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.​ ​##### ​$ ​+++++ ​&&&&&

​#####


Related study sets

Chapter 11 - The Diversity of Prokaryotic Organisms

View Set

Congenital and genetic disorders

View Set

Chapter 10: Taxation of Life Insurance and Annuities - Premiums and Proceeds

View Set

Effects of Recreational Drugs Exam 4 | Textbook Portion

View Set

PrepU Chapter 45 Nursing Care of the Child With an Alteration in Tissue Integrity/Integumentary Disorder

View Set