True of False... Freezing worksheet titles is a useful technique for viewing large worksheets that extend beyond the window.
What is True
100
True of False ...The NOW function is a date and time function.
What is TRUE
100
Double Jeopardy
Modified True of False
Exploding worksheet titles is a useful technique for viewing large worksheets that extend beyond the window.
What is False, Freezing
100
What decision is suggested to make when you plan a workbook?
What is determining the functions and formulas needed
100
With a good understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to ________.
What is use Excel to create the worksheet.
200
A (n) ________IF function is one in which the action to be taken for the turn or false case includes yet another IF function.
What is nested.
200
The ______function is useful when you want to assign a value to a cell based on a logical test.
What is IF.
200
A formula using the _____cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.
What is relative
200
Double Jeopardy
Modified True or False
Splitting the Excel window into TWO panes allows you to view all four corners of the worksheet easily.
What is False and Four
200
When assigned to a cell, the _______function returns a number that corresponds to the system date and time beginning with December 31, 1899.
What is NOW.
300
Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ________________________.
What is What-If Analysis
300
When you ______________a worksheet, Excel is able to display more columns and rows.
What is Shrink.
300
Which comparison operator means "not equal to"?
a. <= b. > c. < d. <>
What is D <>
300
A Pie Chart with one or more slices offset is called s(n) ___.
What is exploded Pie Chart.
300
You can magnify or shrink the appearance of a worksheet or chart by using the __________button on the View tab on the Ribbon.
What is Zoom.
400
The ____________ is ideal for returning the worksheet to its original state after you have changed the values in a worksheet to answer a what-if question.
What is Undo button.
400
The ______________ ______________ is a special place in the computer's memory that allows you to collect text and graphic items from an Office document and then paste them into any Office document.
What is Office Clipboard.
400
Before creating a worksheet, you should have a good understanding of the ______________document.
What is requirements.
400
When you first enter text, its angle is ______degrees, and it reads from left to right in a cell.
What is zero.
400
The ________function is useful when you want to assign a value to a cell based on a logical test.
What is IF
500
The dollar sign (4), comma (,) and percent sign (%) are called _______ symbols.
What is format.
500
Viewing the ___________ version of the worksheet allows you to check the formulas assigned to the range.
What is formula
500
In accounting, _______________numbers often are shown with parentheses surrounding the value.
What is negative.
500
Using the ___________ ____________ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or a range of cells.
What is format painter.
500
Use a)n) ____ chart to show the relationship or proportion of parts to a whole.