Excel test 1-3

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

The _____ Auto Fill Option that fills the destination area using the format of the Source area no content is filled.

Fill Formatting Only

Which of the following Auto FillOptions menu options is the same as the Fill Series option?

Fill Months

The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

_____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Goal

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

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

IF

Which of the folowing keys toggles between Insert mode and Overtype mode?

INSERT

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.

True

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

True

Moving from left to right, the first calculation in the order of operations is negation (-)

True

Point mode allows vou to select cells for use in a formula by using your finger or the pointer

True

The AVERAGE function requires that the argument be included within parentheses following the function name

True

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

True

The Insert Options button lists formatting options.

True

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entery by 100, rounding the results to the nearest percent and adding a percent sign

True

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

True

The equal sign (=) precedes a formula

True

The path to the Logical button is (FORMULAS tab | Function Library group).

True

The range of entries that identifies the major groups for a clustered column chart are called the category names.

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

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.

True

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box

True

A date stamp shows the date a workbook, report. or other document was created or the time period it represents

Trur

The ____ button allows you to erase recent cell entries

Undo

An Excel _____ allows data to be summarized and charted easily.

Worksheet

You use _____ to view an XPs fle

XPS Viewer

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

True

Error messages begin with the ______ symbol.

#

____refers to cells not wide enough to display the entire entry.

####

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instrad displays the ____ error message

#REF!

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab | Styles group)

Which of the following is the path to the Zoom button?

(VIEW tab | Zoom group)

When you decrease the row height to __ the row is hidden.

0

Excel remembers the last___ actions you have completed.

100

When Excel follows the order of operations, the formula, 83+2 equals

26

Which of the following patterns extends the fill series to 525, 475, 425?

625, 575

Which comparison operator means "not equal to"?

<>

Which of the following formulas contains an absolute cell reference?

=$B$4

Which of the following calculations multiplies 23 by 0.017

=23%

All of the following are valid Excll arithmetic operators EXCEPT____

>

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.

Accounting number format

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.

Allignment

Cell references in a formula are called

Assumptions

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

The _____ area on the status bar includes six commands associated calculation on the right side of the menu. as well as the result of the

AutoCalculate

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

AutoCorrect

You can click the ______ button to undo an automatic correction

AutoCorrect Options

The ___ button allows you to choose whether you want to copy the values from the Source area to the destination area with formatting.

AutoFill option

Press ____ to select the entire worksheet.

CTRL+A

You can apply the Bold font style by pressing the _____ keyboard shortcut keys.

CTRL+B

To enter data in a cell, you must first select the_____

Cell

Charts can either be embedded in a worksheet or placed in a separate____

Chart sheet

You should press the SPACEBAR to clear a cell.

False

The Copy button copies the contents and format of the source area to the Office ______ a temporary storage area in the computer's memory.

Clipboard

You should use a ____ chart to compare values side by side, broken down by category

Clustered Column

To open the Format Cells dialog box with the Alignment sheet active, elick the Alignment Settings_____

Dialog Box Lancher

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

Clicking the ____ box completes an entry

Enter

In the context of copying a range of cells to nonadjacent location, an alternative to clucking the Paste button is to press the ____ key

Enter

Which of the following happens when you enter the formula G15 into a cell?

Excel assigns the value in cell G15 to the active cel

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

False

A thin red border indicates the acive cell.

False

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

False

Live preview is available on a touch screen

False

The range automatically selected by Excel is always correct.

False

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

False

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

Insert

The _______ function determines the lowest number in a range.

MIN

Combining two or more selected cells into one cell is called ____ cells

Merging

When assigned to a cell, the ______ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

The default view in Excel is called _____ view.

Normal

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.

O True

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Operations

If you enter 90 in the Degrees box in the _____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.

Orientation

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page layout

The range of cells receiving copied content is called the _____area.

Paste

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

Qtr2

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

RIGHT ARROW

You can use the_____ to check which cells are referenced in the formula assigned to the active cell.

Range Finder

A _____ reference is an adiusted cell reference in a copied and pasted formula

Relative

The adjusted cell references in a copied and pasted formula are called __ cell references.

Relative

_____ text often provides a strong visual appeal.

Rotated

A(n)_____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Sparkline

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Thursday, Saturday, Monday

The _____ button lists error-checking options following the assignment of an invalid formula to a cell.

Trace error

You can enter the correct references separated by a range in a function by typing the beginning and ending cell_____

colon

Using the mouse to move or copy cells is called_____

drag and drop

A pie chart with one or more slices offset is referred to as a(n) _____ pie chart.

exploded

You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

A_____ is a prewritten formula that is built into Excel.

function

Aln) ____ 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.

indirect

The person or persons requesting the worksheet should supply their requirements in a ____ document.

requirements

Excel automatically appends the_____ to complete the AVERAGE function when you click the Enter bax or press the ENTER key.

right parenthesis

Which of the following is not a vakd format symbol?

semi-colon ;

A company or department may standardize with a specific____ so that all of their documents have a similar appearance.

theme

The Increase Indent button indents the contents of a cell to the right by ____spaces each time you click it.

two

When working with a large worksheet, you can split the window into ______ panes.

two or four

The first step in creating an effective worksheet is to make sure you___

understand what is required


Kaugnay na mga set ng pag-aaral

Ch 15 - Physiological and Behavioral Responses of the Neonate

View Set

Chapter 51: Care of Patients with Musculoskeletal Trauma

View Set

Chapter 11- Measuring the Cost of Living

View Set

Chapter 37: Nursing Care of the Child With an Infectious or Communicable Disorder

View Set

Art History 225B Post-Impressionism & SYmbolism

View Set

Iggy Chapter 34: Care of Patients with Dysrhythmias

View Set