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
labels
B
values
C
formulas
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
function
B
statement
C
procedure
D
utility
4) Which of the following are valid Excel functions?
A
weekday, max, and close
B
average, max and min
C
average, max, num
D
max, min, and week
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
conditional formatting
C
cell style
D
format as table
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
Autofit
D
subscript formatting
7) What command do you use to apply a background color to cells in a worksheet?
A
drawing
B
highlight
C
borders and shading
D
fill color
8) Which quick-number style button formats numbers to display as currency in the worksheet?
A
percent
B
comma
C
accounting
D
dollar
9) Carl notices that the data in cell E4 reads #####. What command could Carl choose to correct this problem?
A
subscript formatting
B
wrap text
C
special formatting
D
autofit
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
cell style
B
conditional formatting
C
format as table
D
fill color
11) On the home ribbon, what do you use to change the font size of characters in a cell?
A
font size drop-down list
B
font drop-down list
C
font style 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
alignment
C
decrease indent
D
orientation
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
cell styles
C
wrap text
D
group cells
14) Katheryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
A
merge and center
B
wrap text
C
orientation
D
center
15) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
borders
B
conditional formatting
C
cell style
D
format as table
16) Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet?
A
theme
B
design
C
layout
D
template
17) Which command on the home ribbon do you use to remove cells, rows, or columns from a worksheet or a table?
A
remove
B
format as table
C
delete
D
format
18) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
frames
B
edges
C
margins
D
borders
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
Insert
C
form
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
print area
C
effects
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?