Excel Chapter 7 Review Questions Question Preview (ID: 29972)
Chapter 7 Questions.
TEACHERS: click here for quick copy question ID numbers.
Until worksheets are name, they are identified as Sheet1, Sheet2, and so on.
a) True
b) False
c)
d)
Hiding a worksheet permanently removes it from the workbook.
a) False
b) True
c)
d)
You can insert a worksheet in a workbook as needed to accommodate your data.
a) True
b) False
c)
d)
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
c)
d)
You can only work with one workbook at a time.
a) False
b) True
c)
d)
You can use a ____ to incorporate data from other worksheets into the active worksheet.
a) 3-D reference
b) data source
c) sheet tab
d) active worksheet
The ____ is the worksheet that appears in the workbook window.
a) active worksheet
b) sheet tab
c) screenshot
d) source
Each worksheet within the workbook is identified with a ____ that appears at the bottom of the workbook window.
a) sheet tab
b) screenshot
c) 3-D reference
d) sparklines
The location of the data being referenced is the
a) source
b) destination
c) data source
d) screenshot
The location where the data will be used is the ____.
a) destination
b) source
c) data source
d) screenshot
Adds the values in A4 in the Sheet4, Sheet5, and Sheet6 worksheets.
a) Sheet5!A4
b) Sheet4!A4+Sheet5!A5
c) SUM(Sheet4:SHeet6!A4)
d) SUM(Sheet5!A4:A5)
Displays the value contained in A4 from the Sheet5 worksheet.
a) Sheet5!A4
b) SUM(Sheet4:SHeet6!A4)
c) Sheet4!A4+Sheet5!A5
d) Sheet4!A5+Sheet5!A4
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
Adds the values in A4 of the Sheet4 worksheet and A5 of the SHeet5 worksheet
a) Sheet4!A4+Sheet5!A5
b) Sheet4!A5+Sheet5!A4
c) SUM(Sheet5!A4:A5)
d) Sheet5!A4
Adds the values in A5 of the worksheet named Sheet4 and A4 of the Sheet5 worksheet.
a) Sheet4!A5+Sheet5!A4
b) SUM(Sheet5!A4:A5)
c) SUM(Sheet4:SHeet6!A4)
d) Sheet4!A4+Sheet5!A5
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 29972 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 29972 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register