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