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
=add()
B
=sum()
C
=min()
D
=max()
2) 2. What function would you use to add up numbers?
A
=add()
B
=sum()
C
=min()
D
=max()
3) 3. In a spreadsheet, deleting and clearing are the same thing. T or F
A
False
B
True
4) 4. What function would you use to find the lowest number?
A
=sum()
B
=min()
C
=max()
D
=add()
5) 5. A function is
A
a hidden feature of Excel
B
a pre-defined formula that is already written for you in Excel
C
a layer of formatting
D
another word for event
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 + V
B
F12
C
Ctrl + S
D
Ctrl + ` (grave accent)
8) 8. A row goes ____ and is identified by numbers.
A
down
B
nowhere
C
across
D
up
9) 9. A column goes down and is identified with ____.
A
diagonal
B
numbers
C
symbols
D
letters
10) 10. A spreadsheet can be used for
A
posters
B
calculations
C
presentations
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
box created when the column intersects a row
C
section at the top of the document
D
line where the column intersects a row
13) 13. What are the benefits of a function?
A
Other
B
speed up calculations
C
makes mistakes
D
slows down calculations
14) A formula is written in the ______.
A
page layout tab
B
tool tip
C
column header
D
formula bar
15) 15. What formula would you use to average?
A
=MAX(C10:F10)
B
=SUM(C10:F10)
C
=AVERAGE(C10:F10)
D
=MIN(C10:F10)
16) 16. Which formula would you use to multiply?
A
=MAX(D13:D43)
B
=sum(d12:g15)
C
=average(d12:g15)
D
=D13*E13
17) 17. The ribbon is located
A
on the left
B
on the right
C
at the top of the screen
D
at the bottom of the screen
18) 18. What is a spreadsheet?
A
a file that uses data for calculations
B
lists of data that can be easily accessed
C
a query
D
a thingy on the computer that does slide shows
19) 19. Under what tab do you set the print area?
A
Insert
B
Home
C
Formulas
D
Page layout
20) 20. Where do you set grid lines for printing?
A
margins
B
page layout
C
Home
D
Insert
*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?