Excel

Created by swirlszz 

Upgrade to
remove ads

No A-B-C-D

You can apply ____ formatting that appears only when the value in a cell meets conditions that you specify.

conditional

____ allows you to select cells for use in a formula by using the mouse.

point mode

To verify that a formula contains the intended cell references, use Excel's

Range Finder

To override the order of operations, use ___

parentheses

A___ is made up of two values and a relational operator.

condition

You can assign a ____ to a cell and Excel will calculate the results.

formula

____ colors tend to reach towards your worksheet's reader.

warmer

A____ is predefined set of colors, fonts, cell styles, and fill effects that can be applied to an entire workbook

theme

When Excel starts and the blank workbook displays on the screen, all of the columns have a default width of ____ characters in 11-point Calibri font

8.43

the ___ is the order in which arithmetic operators are calculated

order of operations

_____ colors tend to pull away from your worksheet's reader

cooler

To check the spelling of text in a single cell, ____ the cell to make the formula bar active and then click the Spelling button on the Review tab.

double-click

Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?

inbetween

A(n) ____ is a prewritten formula that is built into Excel.

function

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

Page Layout View

The ___ button lists formatting options following an insert of cells, rows, or columns

Insert Option

A dot on the screen that contains color is called a ____

pixel

A(n) ____ takes a value or values, performs an operation, and returns a result to the cell

function

The default view for a worksheet is +____

Normal View

A blank cell in Excel has a numerical value of ____.

zero

A saved workbook is referred to as a ___

file

The range of cells receiving a copy is called _____ area

destination

In ___ mode, as you type a character, excel inserts the character and moves all characters to the right of the typed character one position to the right.

insert

the ___ is a blinking vertical line that indicates where the next type character will appear

Insertion point

____ Allow users to enter, calculate, manipulate, and analyze data

workseets

You view the portion of the worksheet displayed on the screen though an

worksheet window

The default view in Excel is ____ view

normal

A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row

Cell refernce

The mouse pointer turns to a ____ whenever you move it to outside the worksheet

Block arrow

___ cells involves creating a single cell by combinig two or more selected cells

merging

Which of the following is not a valid entry into a cell that requires numbers?

#

A(n) ____chart is drawn on the same worksheet as its data.

embedded

The number of workseets that you can add to a workbooks is

limited by the amount of memory on the computer

Each worksheet in a workbook has ____ rows

1,045,567

You press the ___ key on the keyboard to display a Key Tip badge.

ALT

The ___ feature of Excel works behind the scenes, correcting common mistakes

AutoCorrect

To enter a number as text, start the entry with a(n)

apostrophe

To emphasize certain entries and make the workseet easier to read and understand you ___ the worksheet

format

Holding down the ____ key while you drag a chart snaps the edge of the chart area to the workseet gridlines

ALT

The ___ command in th Auto Calculate area displays the number of non black cells in the selected range

Count

When you click the Format Painter button and move the mouse pointer onto the worksheet, the mouse pointer changes to a block plus sign with a _______.

paintbrush

An alternative to clicking the Paste button is to _______.

press the Enter key

A pie chart with one or more slices offset from the main portion is called a(n) _____ pie chart.

exploded

The ______ on the status bar can be used to change the size of entries to make them more readable.

Zoom slider

The worksheet entries that determine the size of the slices in a pie chart are called the________.

data series

To copy a word, such as Monday, which Excel might interpret as the start of a series, hold down the _______key while you drag the fill handle to a destination area.

CTRL

A cell reference with only one dollar sign before either the column or the row is called a(n)_______.

mixed cell reference

Text in a cell can be rotated counterclockwise by entering a number between 1 degree and ___
In the Alignment sheet in the Format Cells dialog box.

90 degree

A____ function is one in which the action taken for the true or false case includes yet another IF function.

Nested IF

To specify an absolute reference in a formula, enter a(n) _____before a column letter or a row number.

dollar sign

To display the original worksheet after answering a what-if question, click the ___button for each value you changed.

Copy

Use the ___ function to enter the system date into a cell in the worksheet.

Now

When creating panes in a worksheet, the bar going up and down the middle of the window is called the ___.

horizontal split bar

Which of the following is not considered a format symbol?

+(plus sign)

You can emphasize a slice of a pie chart by___ it from the rest of the slices so it stands out.

offsetting

The____ command removes selected cells from the worksheet and shifts the remaining rows up or shifts the remaining columns to the left.

Delete

Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____.

Format Chart Area dialog box

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

drag and drop

Using the ___ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or range of cells.

Format Painter

When you cut cells using the Cut button, Excel copies the cells to the Office Clipboard, but does not remove the cells until you paste the cells in the destination area by clicking the ___button.

Paste

When a formatted number does not fit within a ceU, it displays

#####

Data can be arranged in ascending or descending order by using

Sort command from Data menu

3. Red triangle at the top right corner of a cell indicates

There is a comment associated with the cell

How many sheets are there in Excel Workbook by default?

3

To move to the previous worksheet press

Ctrl+PgUp

The accounting style shows negative numbers in

Paranthesis

The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called

freezing

When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created

panes

To keep specific rows and columns from scrolling off the screen you first must position the cell pointer

both below and right of the row and column you want to remain on the screen

. If you wanted to sort an employee me so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?

zip codes (ascending), then last name (ascending), then first name (ascending)

. If you require more than two conditions or if you want to analyze a list using Excel 2003's database functions, you must define which filter?

Advanced Criteria Filter

A quick way to return to a specific area of a worksheet is to type in the __

Name box

Which keyboard shortcut opens the Go To dialog box?

F5

What chart object is a horizontal/vertical line extending across the plot area aiding reading values

grid line

Two common wildcard characters that Excel recognizes are

*and ?

The format Cell Number can has an option to show negative numbers in

red

To access the Go To dialog box in Excel you can press?

Ctrl+G

To centre workseet titles across a range of celll, you must ____

Used merge and center button to center the text across multiple cells

What error code does excel dispaly if a range name is miss-typed or deleted

#Name?

What is a circula reference?

A formula that either directly or indirectly depends on itself

To protect a worksheet, you can choose Protection and the Protect Sheet form the .... menu

Tools

A cell's unique address is calla

cell address

What is the keyboard shortcut for creating a chart from the selected cells

F11

A function inside another function is called a ____ function

Nested

A value used in a formula that does not change is called

constant

To select several cells or ranges that are not touching each other, you would ____ wile selecting

Hold down the control button

to move the previous worksheet press

Ctrl + PgUp

YOu want to track the progress of the opening and closing price of a stock. Which type of chart should you use?

High Low Close Open

How many arguments does an AND function allow you to enter

30

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set