Advertisement Upgrade to remove ads

healthclaim

You can apply ____ formatting that appears only when the value in a cell meets conditions that you specify.
a. specified
b. narrow
c. customized
d. conditional

d. conditional

____ allows you to select cells for use in a formula by using the mouse.
a. point and click
b. click mode
c. Formula mode
d. Point mode

d. point mode

To verify that a formula contains the intended cell references, use Excel's
a. functions
b. Range Rinder
c. Reference Finder
d. Reference Checker

b. Range Finder

To override the order of operations, use ___
a. brackets
b. asterisks
c. quotes
d. parentheses

d. parentheses

A___ is made up of two values and a relational operator.
a. formula
b. condition
c. function
d. comman

b. condition

You can assign a ____ to a cell and Excel will calculate the results.
a. formula
b. reference
c. value
d. micro

a. formula

____ colors tend to reach towards your worksheet's reader.
a. cooler
b. darker
c. warmer
d. brighter

c. warmer

A____ is predefined set of colors, fonts, cell styles, and fill effects that can be applied to an entire workbook
a. theme
b. function
c. condition
d. definition

a. 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
a. 8.43
b. 12
c. 15
d. 64

a. 8.43

the ___ is the order in which arithmetic operators are calculated
a. order of values
b. order of operations
c. order of signs
d. order of calculations

b. order of operations

_____ colors tend to pull away from your worksheet's reader
a. cooler
b. darker
c. warmer
d. brighter

a. 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.
a. single-click
b. double-click
c. right-click
d. double-righ-click

b. double-click

Which of the following is a valid conditional formatting operator found in the New Formatting Rule dialog box?
a. inbetween
b. more
c. greater than
d. outside

a. inbetween

A(n) ____ is a prewritten formula that is built into Excel.
a. argument
b. array
c. worksheet
d. function

d. function

____ allows you to create or modify a worksheet while viewing how it will look in printed format
a. Normal View
b. Page Layout View
c. Print Preview
d. Review

b. Page Layout View

The ___ button lists formatting options following an insert of cells, rows, or columns
a. Insert Options
b. Format Options
c. Formatting
d. add cell

a. Insert Option

A dot on the screen that contains color is called a ____
a. font
b. pixel
c. character
d. point

b. pixel

A(n) ____ takes a value or values, performs an operation, and returns a result to the cell
a. operation
b. cell
c. function
d. argument

c. function

The default view for a worksheet is +____
a. Normal View
b. Standard View
c. Page View
d. Basic View

a. Normal View

A blank cell in Excel has a numerical value of ____.
a. zero
b. one
c. five
d. negative ones

a. zero

A saved workbook is referred to as a ___
a. book
b. workbook
c. project
d. file

d. 0.file

The range of cells receiving a copy is called _____ area
a. source
b. destionation
c. copy
d. reference

b. 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.
a. insert
b. overtype
c. right-align
d. push right

a. insert

the ___ is a blinking vertical line that indicates where the next type character will appear
a. lnsertion point
b. key tip
c. active cell
d. ribbon

a. Insertion point

____ Allow users to enter, calculate, manipulate, and analyze data
a. charts
b. lists
c. worksheets
d. databases

c. workseets

You view the portion of the worksheet displayed on the screen though an
a. Active window
b. worksheet window
c. cell
d. active cell menu

b. worksheet window

The default view in Excel is ____ view
a. Work
b. auto
c. normal
d. Roman

c. 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
a. Cell reference
b. Name box
c. Unit
d. Active cell

a. Cell refernce

The mouse pointer turns to a ____ whenever you move it to outside the worksheet
a. Hand
b. Block arrow
c. Double-headed arrow
d. Crosshair

b. Block arrow

___ cells involves creating a single cell by combinig two or more selected cells
a. formatting
b. merging
c. embedding
d. splitting

b. merging

Which of the following is not a valid entry into a cell that requires numbers?
a. +
b. E
c. #
d. $

c. #

A(n) ____chart is drawn on the same worksheet as its data.
a. 3D pie
b. embossed
c. embedded
d. local

c. embedded

The number of workseets that you can add to a workbooks is
a. 100
b. 256
c.1,067,456
d. limited by the amount of memory on the computer

d. limited by the amount of memory on the computer

Each worksheet in a workbook has ____ rows
a. 100
b. 32,767
c. 65,536
d.1,045,567

d.1,045,567

You press the ___ key on the keyboard to display a Key Tip badge.
a. ESC
b. CTRL
c. ALT
d. Home

c. ALT

The ___ feature of Excel works behind the scenes, correcting common mistakes
a. AutoCorrect
b. Spelling
c. Help
d. Ribbon

a. AutoCorrect

To enter a number as text, start the entry with a(n)
a. asterisk
b. hyphen
c. semicolon
d. apostrophe

d. apostrophe

To emphasize certain entries and make the workseet easier to read and understand you ___ the worksheet
a. format
b. edit
c. print
d. proofread

a. format

Holding down the ____ key while you drag a chart snaps the edge of the chart area to the workseet gridlines
a. ALT
b. Home
c. Insert
d. CTRL

a. ALT

The ___ command in th Auto Calculate area displays the number of non black cells in the selected range
a. Count
b. Blank
c. Zero
d. fill

a. 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 _______.
A: cross hair
B: hand
C: paintbrush
D: double-headed arrow

C: paintbrush

An alternative to clicking the Paste button is to _______.
A: click the Drop button
B: click the Move butto0n
C: press the Enter key
D: press the down arrow

C: press the Enter key

A pie chart with one or more slices offset from the main portion is called a(n) _____ pie chart.
A: exploded
B: detached
C: separated
D: highlighted

A: exploded

The ______ on the status bar can be used to change the size of entries to make them more readable.
A: Fit in cell button
B: Zoom slider
C: View tab
D: Fit in screen button

B: Zoom slider

The worksheet entries that determine the size of the slices in a pie chart are called the________.
A: data series
B: pie data
C: data collection
D: chart data

A: 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: Spacebar
B: F4
C: CTRL
D: Shift

C: CTRL

A cell reference with only one dollar sign before either the column or the row is called a(n)_______.
A: mixed cell reference
B: relative cell reference
C: absolute cell reference
D: incomplete cell reference

A: 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: 10 degree
B: 45 degree
C: 90 degree
D: 180 degree

C: 90 degree

A____ function is one in which the action taken for the true or false case includes yet another IF function.
A: Hidden IF
B: Complex IF
C: Nested IF
D: Double IF

C: Nested IF

To specify an absolute reference in a formula, enter a(n) _____before a column letter or a row number.
A: percent sign
B: apostrophe
C: dollar sign
D: title

C: dollar sign

To display the original worksheet after answering a what-if question, click the ___button for each value you changed.
A: Copy
B: Save
C: Restore
D: Undo

A: Copy

Use the ___ function to enter the system date into a cell in the worksheet.
A: IF
B: Now
C: GMT
D: Date

B: Now

When creating panes in a worksheet, the bar going up and down the middle of the window is called the ___.
A: horizontal split bar
B: vertical split
C: scroll bar
D: vertical ruler

A: horizontal split bar

Which of the following is not considered a format symbol?
A: $(dollar sign)
B: , (comma)
C: +(plus sign)
D: %(percent sign)

C: +(plus sign)

You can emphasize a slice of a pie chart by___ it from the rest of the slices so it stands out.
A: offsetting
B: impacting
C: embedding
D: charting

A: offsetting

The____ command removes selected cells from the worksheet and shifts the remaining rows up or shifts the remaining columns to the left.
A: Columns
B: Delete
C: Rows
D: Cells

B: Delete

Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____.
A: Chart Painter dialog box
B: Pie Chart Control box
C: Control tab
D: Format Chart Area dialog box

D: Format Chart Area dialog box

Using the mouse to move or copy cells is called ____.
A: mouse copy
B: move and drop
C: drag and drop
D: mousing

C: 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.
A: Formatter
B: Format Painter
C: Copy
D: Layout

B: 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.
A: Move
B: Complete
C: Execute
D: Paste

D: Paste

When a formatted number does not fit within a ceU, it displays
a. #####
b. #DlV/O
c. #DIV@
d. None of these

a. #####

Data can be arranged in ascending or descending order by using
a. Sort command from Table menu b. Sort command from Data menu
c.Sort command from Tools menu
d.None of these

b. Sort command from Data menu

3. Red triangle at the top right corner of a cell indicates
a.. There is an error in the cell
b. There is a comment associated with the cell
c.The font color of the text in cell is red
d.The cell can't accept formula

b. There is a comment associated with the cell

How many sheets are there in Excel Workbook by default?
a.2
b. 3
c.4
d. 5

b. 3

To move to the previous worksheet press
a. Ctrl+PgUp
b.Ctrl+PgDn
c.Shift+Tab
d.Ctrl+Tab

a. Ctrl+PgUp

The accounting style shows negative numbers in
a.Bold
b.Brackets
c. Paranthesis
d. Quotes

c. 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
a. freezing
b.locking
c.selecting
d.fixing

a. freezing

When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created
a. sections
b. panes
c.views
d.subsheets

b. panes

To keep specific rows and columns from scrolling off the screen you first must position the cell pointer
a.to the right oftbe column you want to remain on the screen
b.below the row you want to remain on the screen
c. on the row you want to remain on the screen
d. both below and right of the row and column you want to remain on the screen

d. 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?
a. zip codes (ascending), then last name (ascending), then first name (ascending)
b.last name (ascending), then first name(ascending), then last name (ascending)
c.zip codes (descending), then last name(ascending), then first name(ascending)
d.last name (descending), then first name (descending), then last name (descending)

a. 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?
a.Auto Filter
b.Update Filter
c. Advantage Filter
d. Advanced Criteria Filter

d. Advanced Criteria Filter

A quick way to return to a specific area of a worksheet is to type in the __
a. Name box
b. Formula bar
c.Zoom box
d.None of these

a. Name box

Which keyboard shortcut opens the Go To dialog box?
a. Ctrl + B
b. Ctrl + Shift + B
c. F2
d. F5

d. F5

If you wanted to sort an employee file 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?

a)zip codes (ascending), then last name (ascending), then first name (ascending)
b. last name (ascending), then first name(ascending), then last name (ascending)
c.zip codes (descending), then last name(ascending), then first name(ascending)
d.last name (descending), then first name (descending), then last name (descending)

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

What chart object is a horizontal/vertical line extending across the plot area aiding reading values
a. catogory axis
b. data marker
c. data point
d. grid line

d. grid line

Two common wildcard characters that Excel recognizes are
a. and/
b. <and>
c. *and ?
d. +and-

c. *and ?

The format Cell Number can has an option to show negative numbers in
a. green
b. blue
c. red
d. quotes

c. red

To access the Go To dialog box in Excel you can press?
a. Ctrl+G
b. Ctrl+H
c. Ctrl+O
d. Ctrl+A

a. Ctrl+G

To centre workseet titles across a range of celll, you must ____
a. Used merge and center button to center the text across multiple cells
b. wident the columns
c. checks whether text is the same in one cell as in the next
d. all of these choices

a. 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
a. #REF!
b. #Name?
C. #Value
D. #N/A

b. #Name?

What is a circula reference?
a. Geometric modeling tool
b. a cell that points to a drawing object
c. a formual that either directly or indirectly depends on itself
d. always erroneous

c. 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. view
b. insert
c. format
d. tools

D. Tools

A cell's unique address is calla
a. cell address
b. name box
c. cell heading
d. active cell

a. cell address

What is the keyboard shortcut for creating a chart from the selected cells
a. F1
b. F5
c. F7
d. F11

d. F11

A function inside another function is called a ____ function
a. Nested
b. Round
c. Complex
d. Compound

a. Nested

A value used in a formula that does not change is called
a. constant
b. function
c. cell range
d. cell address

a. constant

To select several cells or ranges that are not touching each other, you would ____ wile selecting
a. Hold down the control button
b. hold down the shift key
c. hold down the control key
d. hold downt eh control and shift key

a. Hold down the control button

to move the previous worksheet press
a. Alt+PgUp
b. Ctrl + PgUp
c.Ctrl + PgDn
d. Alt + PgDown

b. Ctrl + PgUp

YOu want to track the progress of the opening and closing price of a stock. Which type of chart should you use?
a. Pie Chart
b. Bubble
c. Stacked Colum
d. High Low Close Open

d. High Low Close Open

How many arguments does an AND function allow you to enter
a. 16
b. 30
c. 255
d. 64

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