Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account

No A-B-C-D

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


____ 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 ___


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


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


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


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


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


the ___ is the order in which arithmetic operators are calculated

order of operations

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


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.


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


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


____ 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 ____


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


The default view for a worksheet is +____

Normal View

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


A saved workbook is referred to as a ___


The range of cells receiving a copy is called _____ area


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.


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


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

worksheet window

The default view in Excel is ____ view


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


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.


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


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


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


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


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


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


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


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


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.


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.


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.


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


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.


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


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.


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?


To move to the previous worksheet press


The accounting style shows negative numbers in


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


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


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?


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


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


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


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


A cell's unique address is calla

cell address

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


A function inside another function is called a ____ function


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


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


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 and try again


Reload the page to try again!


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

Voice Recording