NEW
Font size
WorksheetsExcel Module 1 Test Review
Total questions: 24
Worksheet time: 12mins
By default, text is _____ in a cell.
left-aligned
centered
justified
right-aligned
In Excel, a number can contain the characters _____.
0123456789
+ - ( ) , /
. $ % E e
all of the above
Which cell style is used (applied) to display a single line above a cell and a double-ruled line below a cell?
Total
Heading 3
Accent
Title
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 of one cell to another
What effect does the Comma Style format have on the selected cells?
Converts decimals to commas within a cell
Converts decimals to commas within merged cells
Displays cell contents with two decimal places and commas as thousands separators
Allows for substitution of selected characters
By default, numbers are ________ in a cell.
left-aligned
centered
justified
right-aligned
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
Which of the following keys toggles between Insert mode and Overtype mode?
INSERT
ENTER
TAB
ALT
The _____ is the small black plus-sign (cross-hair) (+) located in the lower-right corner of the heavy border around the active cell.
selection handle
sizing handle
fill handle
copy handle
In Excel, the white block plus sign is used to do what?
Copy a cell
Format a cell
Move a chart
Select/highlight a cell
In Excel, the four-pronged arrow is used to do what?
Copy a cell
Format a cell
Move a cell
Select/highlight a cell
Excel automatically will add numbers in a specific range by using the ____________.
AVG function
SUM function
TOTAL function
formula bar
When printing Excel spreadsheets and charts, you should always set the orientation to __________.
portrait
landscape
A _____ is a series of two or more adjacent cells in a column or row, for example A1:C5.
range
function
nearby cell
formula
Size of font is measured in points. One point is equal to 1/72”.
True
False
The data series is range of cells used in determining the size of slices in a pie chart.
True
False
An embedded chart and chart sheet are the same thing.
True
False
In Excel, any set of characters containing a letter, hyphen, or space, is considered text.
True
False
A function is a pre-defined formula in Excel.
True
False
##### displayed in a cell means something in a formula has been keyed or used incorrectly.
True
False
Starting any cell entry with the equals sign (=) tells Excel to calculate something.
True
False
________ completes an entry in a cell.
The enter key
Using the arrow keys
Using the tab key
All of the above.
AutoCorrect makes which type of correction for you?
Capitalize the first letter for names of days
Corrects two initial uppercase letters by changing the second letter to lowercase
Replaces commonly misspelled words with the correct spelling
All of the above.
