Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Exam Review 4
Test Description: Excel exam review 4
Instructions: Answer all questions to get your test result.
1) Angie is calculating her average sales for the past four months. If she uses =Average(b1:b4), this is an example of which type of entry?
A
values
B
formulas
C
labels
D
functions
2) Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
A
defined names
B
calculation
C
formula auditing
D
function library
3) What is a prewritten formula that is built into Microsoft Excel called?
A
utility
B
function
C
statement
D
procedure
4) Which of the following are valid Excel functions?
A
weekday, max, and close
B
average, max, num
C
max, min, and week
D
average, max and min
5) Trey would like to apply a rule to the data in a cell range a1:f20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
A
borders
B
format as table
C
cell style
D
conditional formatting
6) Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this proble?
A
special formatting
B
merge
C
subscript formatting
D
Autofit
7) What command do you use to apply a background color to cells in a worksheet?
A
drawing
B
fill color
C
highlight
D
borders and shading
8) Which quick-number style button formats numbers to display as currency in the worksheet?
A
accounting
B
percent
C
dollar
D
comma
9) Carl notices that the data in cell E4 reads #####. What command could Carl choose to correct this problem?
A
special formatting
B
autofit
C
wrap text
D
subscript formatting
10) Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
A
format as table
B
conditional formatting
C
cell style
D
fill color
11) On the home ribbon, what do you use to change the font size of characters in a cell?
A
font style drop-down list
B
font size drop-down list
C
font drop-down list
D
cell styles drop-down list
12) Which command do you use to reduce the margin between the border and the text in an indented cell?
A
column width
B
orientation
C
decrease indent
D
alignment
13) Which command on the home ribbon joins selected cells into one and centers that content into a larger single cell?
A
merge and center
B
wrap text
C
group cells
D
cell styles
14) Katheryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
orientation
B
wrap text
C
center
D
merge and center
15) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
borders
B
format as table
C
cell style
D
conditional formatting
16) Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet?
A
theme
B
template
C
layout
D
design
17) Which command on the home ribbon do you use to remove cells, rows, or columns from a worksheet or a table?
A
delete
B
format as table
C
format
D
remove
18) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
borders
B
edges
C
frames
D
margins
19) Which command on the home ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
A
sort and filter
B
form
C
Insert
D
format
20) Which command on the Page Layout ribbon enables a user to mark where a new page will begin on the printed copy?
A
background
B
effects
C
print area
D
breaks
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?