Microsoft Excel Exam Questions and
Answers 100% Solved
Formula Bar - ✔✔Appears directly below the toolbar in the worksheet;
displays a formula when the cell of a worksheet contains a calculated
value.
Status Bar - ✔✔displays information about the current document
Name Box - ✔✔displays the active cell address
Workbook - ✔✔an excel file with one or more worksheets
Worksheet - ✔✔the workspace made up of columns and rows where you
enter data to create an electronic spreadsheet
Cell - ✔✔The intersection of a row and a column
Fill Color - ✔✔the background of the cell
Text Color - ✔✔color that the text appears in in a cell
Border - ✔✔a line that indicates a boundary of a cell or range
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Column - ✔✔appears vertically in a worksheet and is identified by letters
at the top of the worksheet window
Column Heading - ✔✔a column letter above the grid that identifies each
column
Row - ✔✔appears horizontally in a worksheet and is identified by
numbers on the left side of the worksheet window
Row Heading - ✔✔a number at the far-left side of a row that can be
clicked to select the entire row of cells
Cell Label - ✔✔ability to use name box to name a range of cells/cell
Cell Value - ✔✔what is typed into a cell-contained with in
Cell Format - ✔✔Allows someone to change a cell's appearance;
alignment, font, border, patterns, etc. as well as its numerical type; number,
text, currency, percentage, etc.
Merge Cells - ✔✔Takes two or more cells and combines them into one.
Insert Row/Column - ✔✔Placing a new, blank row or column in the
spreadsheet.
Cell Alignment - ✔✔the position in which text is placed within a cell
Series - ✔✔a predictable list of sequential numbers, dates, times, or text