CGS 2518 EXCEL EXAM QUESTIONS AND ANSWERS

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