Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel Pt. 1
Test Description: This is a review over our Microsoft Excel unit.
Instructions: Answer all questions to get your test result.
1) 1. What function would you use to find the highest number?
A
=sum()
B
=add()
C
=max()
D
=min()
2) 2. What function would you use to add up numbers?
A
=max()
B
=min()
C
=add()
D
=sum()
3) 3. In a spreadsheet, deleting and clearing are the same thing. T or F
A
True
B
False
4) 4. What function would you use to find the lowest number?
A
=min()
B
=add()
C
=sum()
D
=max()
5) 5. A function is
A
a hidden feature of Excel
B
another word for event
C
a layer of formatting
D
a pre-defined formula that is already written for you in Excel
6) 6. If you always want to see certain rows or columns as you work on a spreadsheet, you can
A
make them smaller
B
thaw them
C
freeze them
D
make them bigger
7) 7. To display formulas in a spreadsheet, press
A
Ctrl + ` (grave accent)
B
F12
C
Ctrl + S
D
Ctrl + V
8) 8. A row goes ____ and is identified by numbers.
A
nowhere
B
down
C
up
D
across
9) 9. A column goes down and is identified with ____.
A
numbers
B
symbols
C
diagonal
D
letters
10) 10. A spreadsheet can be used for
A
posters
B
presentations
C
calculations
D
book reports
11) 11. All formulas begin with a
A
+
B
-
C
/
D
=
12) 12. A cell is a
A
group of rows and columns
B
line where the column intersects a row
C
box created when the column intersects a row
D
section at the top of the document
13) 13. What are the benefits of a function?
A
Other
B
slows down calculations
C
speed up calculations
D
makes mistakes
14) A formula is written in the ______.
A
tool tip
B
page layout tab
C
column header
D
formula bar
15) 15. What formula would you use to average?
A
=MIN(C10:F10)
B
=AVERAGE(C10:F10)
C
=SUM(C10:F10)
D
=MAX(C10:F10)
16) 16. Which formula would you use to multiply?
A
=sum(d12:g15)
B
=D13*E13
C
=average(d12:g15)
D
=MAX(D13:D43)
17) 17. The ribbon is located
A
at the bottom of the screen
B
at the top of the screen
C
on the left
D
on the right
18) 18. What is a spreadsheet?
A
lists of data that can be easily accessed
B
a file that uses data for calculations
C
a thingy on the computer that does slide shows
D
a query
19) 19. Under what tab do you set the print area?
A
Formulas
B
Home
C
Page layout
D
Insert
20) 20. Where do you set grid lines for printing?
A
Insert
B
margins
C
Home
D
page layout
*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?