WorksheetsExcel Module 2 Practice Concepts
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
Currency is an example of a number format.
a)
True
b)
False
2.
You can apply date formats to cells by using the Date category in the Format Cells dialog box.
a)
True
b)
False
3.
To change the background color of a cell, you use the Background color button.
a)
True
b)
False
4.
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.
a)
True
b)
False
5.
To accept a suggested spelling for that instance only, which of the following would you select?
a)
Change
b)
Change All
c)
Ignore Once
d)
Add to Dictionary
6.
Clicking the Accounting style in the Number Format arrow applies _____ decimal places by default.
a)
one
b)
two
c)
three
d)
four
7.
To format a range so that all values greater than $500 appear in red, which of the following can you use?
a)
conditional formatting
b)
cell formatting
c)
cell styles
d)
Quick Access toolbar
8.
The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?
a)
Change All
b)
Change
c)
Ignore once
d)
Ignore all
9.
The Comma Style format adds a comma and a dollar sign to a cell value.
a)
True
b)
False
10.
To change the color of cell content, you use the ________ color list arrow.
a)
cell
b)
text
c)
pattern
d)
font
11.
The default worksheet text is _____-point Calibri.
a)
10
b)
11
c)
12
d)
14
12.
When you underline cell content, you are using _____.
a)
a font style
b)
an orientation setting
c)
an indent setting
d)
a centering style
13.
The _____ number format adds dollar signs and two decimal places to numeric data.
a)
Data
b)
Accounting
c)
Percentage
d)
General
14.
To combine multiple cells into one combined cell, which of the following do you use?
a)
Column Width command
b)
Center button
c)
Merge and Center button
d)
Increase Indent button
15.
When you change cell contents to italics, you are changing the cell's alignment.
a)
True
b)
False
16.
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.
a)
True
b)
False
17.
When you select a cell range, the cells must be adjacent to each other.
a)
True
b)
False
18.
To copy a cell's formatting to another cell, which of the following can you use?
a)
Format Cells dialog box
b)
Format Printer
c)
Quick Analysis Tool
d)
Format as Table
19.
To rename a worksheet, you change the text on the _____.
a)
sheet columns
b)
sheet rows
c)
sheet header
d)
sheet tab
20.
To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.
a)
CTRL
b)
ALT
c)
SHIFT
d)
ESC
100 %
