Test 3

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

The characters that Excel displays on the screen are a specific ____. A. font B. style C. size D. color

A. Font

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. A. True B. False

A. True

Cooler colors tend to pull away from the reader. A. True B. False

A. True

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. A. left parenthesis B. right bracket C. right parenthesis D. left bracket

A. left parenthesis

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. A .exploded B. outer C. offset D. rasterized

A .exploded

A ____ is information that exists on a physical medium such as paper. A. hard copy B. column C. validation D. printout

A. Hard copy

By default, text is ____ in a cell. A. left-aligned B. centered C. justified D. right-aligned

A. Left-aligned

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure A. range B. bunch C. nearby cell D. neighbor

A. Range

A character with a point size of 10 is about 10/72 of one inch in height. A. True B. False

A. True

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. A. True B. False

A. True

A thin red border indicates the active cell. A. True B. False

A. True

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell. A. True B. False

A. True

Clicking the Create Function box opens the Function Arguments dialog box. A. True B. False

A. True

Excel can display characters in only three font colors: black, red, and blue. A. True B. False

A. True

Excel has more than 400 functions that perform just about every type of calculation you can imagine. A. True B. False

A. True

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. A. True B. False

A. True

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

A. check the spelling of words in a selected range

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

A. footer

A ____ is a prewritten formula that is built into Excel. A. function B. feature C. task D. calculation

A. function

A ____ is text and graphics that print at the top of each page. A. header B. topper C. margin D. crown

A. header

An Excel ____ allows data to be summarized and charted easily. A. worksheet B. workflow C. document D. presentation

A. worksheet

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

Formula

A(n) ____________________ is a dot on the screen that contains a color.

Pixel

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

Planning

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

Circular reference

A(n) ____________________ conveys a visual representation of data.

Chart

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the accompanying figure

Active Cell

Which of the following actions are provided by the Paste Options button? A. Pastes synonyms or acronyms B. Copy just formulas

B. Copy just formulas

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names. A. True B. False

B. False

A single point is about 1/32 of one inch in height. A. True B. False

B. False

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. A. True B. False

B. False

Best fit means that the width of the column will be increased or decreased by a percentage you specify. A. True B. False

B. False

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 that contain numeric data. A. True B. False

B. False

Live preview is available on a touch screen. A. True B. False

B. False

Clicking the ____ opens the Insert Function dialog box. A. Insert Function box in the formula bar B. Function dialog box launcher (HOME tab | Calculations group) C. Function button (HOME tab | Function group) D. Functions & Formulas button on the status bar

B. Function dialog box launcher (HOME tab | Calculations group)

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____. A. press ALT+F4 B. press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu

B. press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu

A ____ reference is an adjusted cell reference in a copied and pasted formula. A. revised B. relative C. recycled D. retained

B. relative

Clicking the ____ box completes an entry. A. Cancel B. Formula C. Enter D. Tab

C. Enter

Point mode allows you to ____, as shown in the accompanying figure. A. select cells for use in a formula using the keyboard B. select a function from the Sum button list C. select cells for use in a formula using the mouse pointer D. edit cell contents directly in the cell

C. select cells for use in a formula using the mouse pointer

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. A. scheme B. gallery C. theme D. style

C. theme

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

D. >

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. A. contiguous B. indexed C. direct D. indirect

D. indirect

Typing =av in a cell displays the ____________________, as shown in the accompanying figure.

formula auto complete


Ensembles d'études connexes

Nutrition Exam 2 Lipids and Cardiovascular Disease

View Set

Lilley Chapter 10: Analgesic Drugs

View Set

Tim's Honors Ethics Final Questions Test 1&2

View Set

Chapter 18: Deficits, Surpluses, and the Public Debt

View Set

23SP BUSN 110 - Introduction to Business - Week Two: Quiz 1

View Set

CompTIA A+ 220-1002: Microsoft Command Line Tools

View Set

prepu assessment of neuro function

View Set

17.2 Exchange Rates in the Long Run

View Set

WTW Telemarketing Compliance and Do not call policies

View Set