Exam 1 Study Guide cgs 2518 FSU
2025 updated questions and answers
In Microsoft Excel, the file you create and edit is called: a. a form b. a ledger c. a tabled. a
workbook e. a record - correct answer ✔✔workbook
By default, Excel 2019 files are saved with this extension. A. .xlsb. .xlsxc. .csvd. .xbke. .ods -
correct answer ✔✔b. .xlsx
Text in a worksheet that displays a name, a main title, row or column titles, and similar
descriptive information is called:a. a caption. a tagc. a labeld. a titlee. an annotation - correct
answer ✔✔label
When you click on a cell to activate it, the cell address appears in the:a. formula windowb.
name boxc. task bard. dropdown menue. comment bubble - correct answer ✔✔name box
When you want to delete characters in a cell to the left of the insertion point press - correct
answer ✔✔backspace
7. A rectangular group of cells in Excel is called a(n): - correct answer ✔✔range
9. To quickly select all the cells in a worksheet: - correct answer ✔✔Press Ctrl+A
10. After you select and cut cells, the cells are temporarily placed: - correct answer ✔✔a. On
the Clipboard
11. In an Excel worksheet dates and times are: - correct answer ✔✔c. Values (e.g. 43565.125)
, 12. When you want column and row headings displayed whether you are at the top, bottom,
left, or right of the spreadsheet, select: - correct answer ✔✔b. Freeze Panes
13. Use this button to combine two or more cells into one cell and center the text over a group
of columns. - correct answer ✔✔d. Merge and Center
1. This Excel feature allows users to use common arithmetic operations to perform a calculation:
- correct answer ✔✔a. Formulas
2. This symbol alerts Excel that you are entering a formula and not text: - correct answer ✔✔=
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect
order of arguments, or an incorrect cell reference, it returns: - correct answer ✔✔c. An error
message that begins with a number sign (#)
The Excel tool button that allows you to step through each part of a formula is called: - correct
answer ✔✔d. Evaluate Formula
When you are creating formulas using a cell location, the default cell reference is: - correct
answer ✔✔Relative
This type of cell reference does not change when copied and remains in a fixed position during
operations: - correct answer ✔✔Absolute
A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell
reference, adding the dollar sign ($) in front of the column and row addresses, is: - correct
answer ✔✔e. F4
2025 updated questions and answers
In Microsoft Excel, the file you create and edit is called: a. a form b. a ledger c. a tabled. a
workbook e. a record - correct answer ✔✔workbook
By default, Excel 2019 files are saved with this extension. A. .xlsb. .xlsxc. .csvd. .xbke. .ods -
correct answer ✔✔b. .xlsx
Text in a worksheet that displays a name, a main title, row or column titles, and similar
descriptive information is called:a. a caption. a tagc. a labeld. a titlee. an annotation - correct
answer ✔✔label
When you click on a cell to activate it, the cell address appears in the:a. formula windowb.
name boxc. task bard. dropdown menue. comment bubble - correct answer ✔✔name box
When you want to delete characters in a cell to the left of the insertion point press - correct
answer ✔✔backspace
7. A rectangular group of cells in Excel is called a(n): - correct answer ✔✔range
9. To quickly select all the cells in a worksheet: - correct answer ✔✔Press Ctrl+A
10. After you select and cut cells, the cells are temporarily placed: - correct answer ✔✔a. On
the Clipboard
11. In an Excel worksheet dates and times are: - correct answer ✔✔c. Values (e.g. 43565.125)
, 12. When you want column and row headings displayed whether you are at the top, bottom,
left, or right of the spreadsheet, select: - correct answer ✔✔b. Freeze Panes
13. Use this button to combine two or more cells into one cell and center the text over a group
of columns. - correct answer ✔✔d. Merge and Center
1. This Excel feature allows users to use common arithmetic operations to perform a calculation:
- correct answer ✔✔a. Formulas
2. This symbol alerts Excel that you are entering a formula and not text: - correct answer ✔✔=
When a formula contains a typographical error, unnecessary or missing punctuation, incorrect
order of arguments, or an incorrect cell reference, it returns: - correct answer ✔✔c. An error
message that begins with a number sign (#)
The Excel tool button that allows you to step through each part of a formula is called: - correct
answer ✔✔d. Evaluate Formula
When you are creating formulas using a cell location, the default cell reference is: - correct
answer ✔✔Relative
This type of cell reference does not change when copied and remains in a fixed position during
operations: - correct answer ✔✔Absolute
A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell
reference, adding the dollar sign ($) in front of the column and row addresses, is: - correct
answer ✔✔e. F4
