NEW
Font size
WorksheetsFall Exam Review Questions Part 1
Total questions: 25
Worksheet time: 25mins
Worksheet titles and subtitles should be as wordy as possible.
True
False
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.
True
False
Excel can display characters in only three font colors: black, red, and blue.
True
False
You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).
True
False
To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).
True
False
You should press the SPACEBAR to clear a cell.
True
False
The arithmetic operator, ^, directs Excel to perform the division operation.
True
False
The range automatically selected by Excel is always correct.
True
False
When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.
True
False
When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.
True
False
The first step in creating an effective worksheet is to make sure you ____.
apply font formatting
understanding what is required
insert chart
enter the data
The range of cells receiving copied content is called the ____ area.
fill
range
location
paste
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Save
Format
clear
What effect does the Accounting Number Format have on the selected cells?
Converts alphabetic characters to numbers
Displays cell contents with two decimal places that align vertically
Performs tax calculations
Copies the numbers from one cell to another
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL + HOME
CTRL + END
HOME
END
How many chart types does Excel offer?
5
15
30
50
A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
exploded
outer
offset
rasterized
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Automatic
Hidden
Replacement
Standard
Excel remembers the last ____ actions you have completed.
25
50
75
100
A ____ is a prewritten formula that is built into Excel.
function
feature
task
calculation
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
placement
operations
positioning
selections
The ____ function displays the highest value in a range.
MIN
SUM
MAX
AVERAGE
The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
DIVSUM
AVERAGE
RANGEAVG
MAX
The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.
Comma Style format
Accounting number format
Percent style format
Currency style format
When you decrease the row height to ____, the row is hidden.
0
1
2
3
