How can we help?

You can also find more resources in our Help Center.

89 terms

Excel

No A-B-C-D
STUDY
PLAY
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