Excel Chapter 7 Review Questions Question Preview (ID: 29972)


Chapter 7 Questions. TEACHERS: click here for quick copy question ID numbers.

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 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

The location where the data will be used is the ____.
a) destination
b) source
c) data source
d) screenshot

The location of the data being referenced is the
a) source
b) destination
c) data source
d) screenshot

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 ____ is the worksheet that appears in the workbook window.
a) active worksheet
b) sheet tab
c) screenshot
d) source

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

You can only work with one workbook at a time.
a) False
b) True
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 insert a worksheet in a workbook as needed to accommodate your data.
a) True
b) False
c)
d)

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)

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.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links