Create an account
You can apply ____ formatting that appears only when the value in a cell meets conditions that you specify.
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
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?
____ 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
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
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
The number of workseets that you can add to a workbooks is
limited by the amount of memory on the computer
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 _______.
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.
The worksheet entries that determine the size of the slices in a pie chart are called the________.
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.
A____ function is one in which the action taken for the true or false case includes yet another IF function.
To specify an absolute reference in a formula, enter a(n) _____before a column letter or a row number.
To display the original worksheet after answering a what-if question, click the ___button for each value you changed.
When creating panes in a worksheet, the bar going up and down the middle of the window is called the ___.
horizontal split bar
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 ___ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or range of cells.
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.
3. Red triangle at the top right corner of a cell indicates
There is a comment associated with the cell
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
What chart object is a horizontal/vertical line extending across the plot area aiding reading values
To centre workseet titles across a range of celll, you must ____
Used merge and center button to center the text across multiple cells
To select several cells or ranges that are not touching each other, you would ____ wile selecting
Hold down the control button
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
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!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