Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Chapter 7 Review Questions
Test Description: Chapter 7 Questions
Instructions: Answer all questions to get your test result.
1) Until worksheets are name, they are identified as Sheet1, Sheet2, and so on.
A
True
B
False
2) Hiding a worksheet permanently removes it from the workbook.
A
False
B
True
3) You can insert a worksheet in a workbook as needed to accommodate your data.
A
True
B
False
4) In addition to printing an active worksheet or selected areas of an active worksheet, you can also print an entire workbook, selected worksheets, or selected areas of a workbook.
A
True
B
False
5) You can only work with one workbook at a time.
A
False
B
True
6) You can use a ____ to incorporate data from other worksheets into the active worksheet.
A
active worksheet
B
sheet tab
C
data source
D
3-D reference
7) The ____ is the worksheet that appears in the workbook window.
A
active worksheet
B
source
C
screenshot
D
sheet tab
8) Each worksheet within the workbook is identified with a ____ that appears at the bottom of the workbook window.
A
sparklines
B
3-D reference
C
sheet tab
D
screenshot
9) The location of the data being referenced is the
A
screenshot
B
data source
C
destination
D
source
10) The location where the data will be used is the ____.
A
screenshot
B
data source
C
destination
D
source
11) Adds the values in A4 in the Sheet4, Sheet5, and Sheet6 worksheets.
A
Sheet5!A4
B
SUM(Sheet5!A4:A5)
C
Sheet4!A4+Sheet5!A5
D
SUM(Sheet4:SHeet6!A4)
12) Displays the value contained in A4 from the Sheet5 worksheet.
A
Sheet4!A5+Sheet5!A4
B
Sheet4!A4+Sheet5!A5
C
SUM(Sheet4:SHeet6!A4)
D
Sheet5!A4
13) Adds the values in A4 and A5 of the Sheet5 worksheet.
A
SUM(Sheet5!A4:A5)
B
Sheet4!A5+Sheet5!A4
C
Sheet4!A4+Sheet5!A5
D
Sheet4!A5+Sheet5!A4
14) Adds the values in A4 of the Sheet4 worksheet and A5 of the SHeet5 worksheet
A
Sheet5!A4
B
Sheet4!A5+Sheet5!A4
C
SUM(Sheet5!A4:A5)
D
Sheet4!A4+Sheet5!A5
15) Adds the values in A5 of the worksheet named Sheet4 and A4 of the Sheet5 worksheet.
A
Sheet4!A4+Sheet5!A5
B
SUM(Sheet5!A4:A5)
C
SUM(Sheet4:SHeet6!A4)
D
Sheet4!A5+Sheet5!A4
*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?