CGS 2518 EXCEL EXAM QUESTIONS
AND ANSWERS
When you want column and row headings displayed whether you are at the top, bottom,
left, or right of the spreadsheet, select:
a. A filter
b. Freeze Panes
c. Split Window
d. Zoom to selection
e. Splitter bar - Answer-freeze panes
Use this button to combine two or more cells into one cell and center the text over a
group of columns.
a. Combine Elements
b. Format Title Cells
c. Group and Merge
d. Merge and Center
e. Increase Indent - Answer-merge and center
In Microsoft Excel, the file you create and edit is called a:
a. form
b. ledger
c. table
d. workbook
e. record - Answer-workbook
By default, Excel 2019 files are saved with this extension
a. .xls
b. .xlsx
c. .csv
d. .xbk
e. .ods - Answer-.xlsx
When you click on a cell to activate it, the cell address appears in the:
a. formula window
b. name box
c. task bar
d. dropdown menu
e. comment bubble - Answer-name box
When you want to delete characters in a cell to the left of the insertion point press:
a. Delete
b. Enter
c. Edit
d. Backspace
AND ANSWERS
When you want column and row headings displayed whether you are at the top, bottom,
left, or right of the spreadsheet, select:
a. A filter
b. Freeze Panes
c. Split Window
d. Zoom to selection
e. Splitter bar - Answer-freeze panes
Use this button to combine two or more cells into one cell and center the text over a
group of columns.
a. Combine Elements
b. Format Title Cells
c. Group and Merge
d. Merge and Center
e. Increase Indent - Answer-merge and center
In Microsoft Excel, the file you create and edit is called a:
a. form
b. ledger
c. table
d. workbook
e. record - Answer-workbook
By default, Excel 2019 files are saved with this extension
a. .xls
b. .xlsx
c. .csv
d. .xbk
e. .ods - Answer-.xlsx
When you click on a cell to activate it, the cell address appears in the:
a. formula window
b. name box
c. task bar
d. dropdown menu
e. comment bubble - Answer-name box
When you want to delete characters in a cell to the left of the insertion point press:
a. Delete
b. Enter
c. Edit
d. Backspace