CGS 1060 FINAL EXAM STUDY GUIDE 4
QUESTIONS WITH COMPLETE
SOLUTIONS
, An Excel file is referred to as a: - ANSWERworkbook
When you start the Excel program, you can choose to start with a new blank workbook
or one of many pre-formatted workbooks called _______. - ANSWERtemplates
In Excel, a ____ is referenced by a column letter and row number such as C5. -
ANSWERcell
An Excel workbook can consist of multiple _______ or "pages" each referenced by a
tab at the bottom of the Excel program window. - ANSWERworksheets
The default name for an Excel file is _______. - ANSWERBook1
If you begin typing in Excel, the characters will appear in the cell of the worksheet
known as the ________ that has its border bolded with a green color. - ANSWERActive
cell
Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of
the worksheet whose cell reference is given by: - ANSWERA1
Press the ______ key to move the active cell one position to the right on the worksheet.
- ANSWERTab
This bar displays entries as they are made and edited in the Excel workbook window
and also shows the actual formula used to calculate the value shown in the worksheet
cell. - ANSWERFormula
If you wish to MOVE the contents of one cell to another cell, which command will you
use: Copy or Cut? - ANSWERCut
If you wish to DUPLICATE the contents of a range of cells to another portion of the
worksheet, which command will you use: Copy or Cut? - ANSWERCopy
A new Blank Workbook in Excel 2016 contains one worksheet named: -
ANSWERSheet1
Excel 2016 files have names that end with a default file extension of ____ . -
ANSWER.xlsx
To save a workbook in a format compatible with Excel 97-2003 versions, the file
extension should be: - ANSWER.xls
QUESTIONS WITH COMPLETE
SOLUTIONS
, An Excel file is referred to as a: - ANSWERworkbook
When you start the Excel program, you can choose to start with a new blank workbook
or one of many pre-formatted workbooks called _______. - ANSWERtemplates
In Excel, a ____ is referenced by a column letter and row number such as C5. -
ANSWERcell
An Excel workbook can consist of multiple _______ or "pages" each referenced by a
tab at the bottom of the Excel program window. - ANSWERworksheets
The default name for an Excel file is _______. - ANSWERBook1
If you begin typing in Excel, the characters will appear in the cell of the worksheet
known as the ________ that has its border bolded with a green color. - ANSWERActive
cell
Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of
the worksheet whose cell reference is given by: - ANSWERA1
Press the ______ key to move the active cell one position to the right on the worksheet.
- ANSWERTab
This bar displays entries as they are made and edited in the Excel workbook window
and also shows the actual formula used to calculate the value shown in the worksheet
cell. - ANSWERFormula
If you wish to MOVE the contents of one cell to another cell, which command will you
use: Copy or Cut? - ANSWERCut
If you wish to DUPLICATE the contents of a range of cells to another portion of the
worksheet, which command will you use: Copy or Cut? - ANSWERCopy
A new Blank Workbook in Excel 2016 contains one worksheet named: -
ANSWERSheet1
Excel 2016 files have names that end with a default file extension of ____ . -
ANSWER.xlsx
To save a workbook in a format compatible with Excel 97-2003 versions, the file
extension should be: - ANSWER.xls
