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
functions
B
labels
C
values
D
formulas
2) Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
A
function library
B
calculation
C
defined names
D
formula auditing
3) What is a prewritten formula that is built into Microsoft Excel called?
A
utility
B
procedure
C
statement
D
function
4) Which of the following are valid Excel functions?
A
average, max, num
B
max, min, and week
C
weekday, max, and close
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
conditional formatting
B
format as table
C
cell style
D
borders
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
Autofit
C
merge
D
subscript formatting
7) What command do you use to apply a background color to cells in a worksheet?
A
borders and shading
B
highlight
C
fill color
D
drawing
8) Which quick-number style button formats numbers to display as currency in the worksheet?
A
comma
B
percent
C
dollar
D
accounting
9) Carl notices that the data in cell E4 reads #####. What command could Carl choose to correct this problem?
A
wrap text
B
autofit
C
special formatting
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 size drop-down list
B
cell styles drop-down list
C
font style drop-down list
D
font drop-down list
12) Which command do you use to reduce the margin between the border and the text in an indented cell?
A
orientation
B
decrease indent
C
alignment
D
column width
13) Which command on the home ribbon joins selected cells into one and centers that content into a larger single cell?
A
wrap text
B
cell styles
C
merge and center
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
center
B
wrap text
C
merge and center
D
orientation
15) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
cell style
B
format as table
C
conditional formatting
D
borders
16) Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet?
A
layout
B
theme
C
template
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
format
B
remove
C
delete
D
format as table
18) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
margins
B
edges
C
borders
D
frames
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
Insert
B
sort and filter
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
breaks
C
effects
D
print area
*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?