Excel

Using the mouse to move or copy cells is called ____.

drag and drop

The default view in Excel is called ____ view.

normal

pressing the ____ key to complete an entry activates the adjacent cell to the right

right arrow

Which of the following is not a formatting symbols

Pound sign

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

Trace Error

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

formula

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

if

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

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

How many chart types does excel offer

15

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

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

False

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 Fill Options menu options is the same as the Fill Series option?

Fill Months

The ____ function displays the highest value in a range.

Max

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Print Selection

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

True

the ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formating

auto fill options

the ____ area on the status bar include six commands as well as the result of the associated calculation on the right side of the menu

autocalculate

the ___ feature works behind the scenes, fixing common typing or spelling mistake when you complete a text entry

autocorrect

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

average

A pie chart with one or more slices offset is referred to as an ___ pie chart

exploded

The path to the Format Painter button is ____.

(HOME tab | Clipboard group)

Excel remembers the last ____ actions you have completed.

100

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

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

False

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

Range Finder

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

Sparkline

The equal sign (=) precedes a formula.

True

to enter data in a cell, you must first select the

cell

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.

indirect

The first step in creating an effective worksheet is to make sure you ____.

understand what is required

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

worksheet

write steps to Sum a column of numbers

select cell home tab editing autosum enter

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

Thursday, Saturday, Monday

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

to erase an entire entry in a cell and then reenter the data from the beginning, press the _____ key

ESC

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

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

Excel assigns the value in cell G15 to the active cell

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

False

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

False

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

True

you use ____ to view an XPS file

XPS viewer

A ____ is text and graphics that print at the top of each page.

header

which of the following is the ribbon path to the cell style button

home tab styles group

Which of the following is not a valid formula? =3^4 =H3/H11 22-F15 =11+9

22-F15

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

Which of the following is not a valid format symbol? , $ % ;

;

Which comparison operator means "not equal to"?

<>

Write absolute formula for addition of : B1 , C1 , D1 and E1

=$B$1+$C$1+$D$1+$E$1

Which of the following formulas contains an absolute cell reference?

=$B$4

Which of the following calculations multiplies 23 by 0.01?

=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.

#REF!

You can click the ____ button to undo an automatic correction.

AutoCorrect Options

press ____ to select the entire worksheet

CRTL+A

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

CRTL+B

pressing the ___ keyboard shortcut key select cell A1

CRTL+HOME

You can press the ____ keys to open the Format Cells dialog box.

CTRL+1

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

Insert

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

Operations

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

Page Layout

Write steps to rotate Text in Cell.

Select cell go to home tab and go to alignment click on drop down menu and click on "ab with an arrow increasing" click on drop down menu and select format you want

Write steps to apply Accounting Number Format.

Select cells that need to be formatted go to home tab, click on number group click on dropdown menu and find accounting option

Write steps to apply Conditional Formating.

Select cells you want to format go to home tab, go to styles group click on conditional formatting and drop down menu will appear click on specific format

Write steps to change Row height.

Select row you want to change height of go to home tab, go to cells group, click on drop down menu select format drop down menu select row height add specific height and click ok

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

True

Charts can either be embedded in a worksheet or placed in a separate ____.

chart sheet

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

circular

write steps to change a cell style

click on cell home tab styles group cell styles change cells

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

colon

The range of cells receiving the content of copied cells is called the ____

destination area

what effects does the accounting number format have on the selected cells

displays cell content with two decimal places that align vertically

what effects does the comma style format have on the selected cells

displays cells content with two decimals places and commas as thousands separators

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

Write steps to create a series of Month Names

key in the name of January in the first cell hover the mouse over the bottom right corner of the cell until you see a "+" press on the + and drag to the right until you are done with naming the months

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

merging

The ____ function determines the lowest number in a range.

min

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

nested

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 range of cells receiving copied content is called the ____ area.

paste

A ____ reference is an adjusted cell reference in a copied and pasted formula

relative

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

relative

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

right parenthesis

write steps to add a 3D pie chart

select all data insert tab chart group circle image button drop down menu 3D chart

Write steps to Split a window into Panes in Excel 2016.

select area you want to split go to view tab and go to window group go to image that is a square with blue header and red line in the middle click on it and worksheet will split

Write steps to add a Sparkline Chart to the worksheet.

select cell you want chart to appear go to insert tab and then go to spark lines group click on drop down menu and select either lines, column, or win/loss select cells you want to include and the cell you want to put the chart in press ok

write steps to change the sheet tab name

sheet tab on bottom of worksheet double click rename