.png){kind=logo}
PDF Download
FREE COMPUTERS AND STUDY GAMES ABOUT EXCEL
VOCABULARY EXAM QUESTIONS
Qs and Ans Expert- Explanation
This Exam contains:
-Guarantee passing score -22 Questions and Answers -format set of multiple-choice -Expert- Explanation
Question 1: Headings
Answer:
the shaded area at the top of a data pane that has the field name
Question 2: Gridlines
Answer:
intersecting lines used to align objects
Question 3: Name Box
Answer:
box at the left end that identifies the selected cell
Question 4: Workbook
Answer:
Spreadsheet program file that has worksheets that you can enter and calculate data
Question 5: Columns
Answer:
a list of cells going up and down
Question 6: Spreadsheet
Answer:
Primary document in Excel that has cells in columns and rows
Question 7: Formula Bar
Answer:
bar at the top of the excel window that you use to enter or edit values or formulas in the cells or charts
Question 8: Workbook Window
Answer:
an open group of spreadsheets
Question 9: Cell
Answer:
a box formed by the intersection of a row and a column
Question 10: Active Cell
Answer:
the selected cell in which data is entered why you begin typing
Question 11: Relative Reference
Answer:
the address of a cell based on the relative position of the cell that contains the formula and the cell referred to
Question 12: Range
Answer:
two or more cells on a sheet
Question 13: Workspace
Answer:
a file that saves display information about open windows
Question 14: Worksheet
Answer:
primary document in Excel that has cells in columns and rows
Question 15: Enter Data
Answer:
data that is typed into a cell
Question 16: Cell Reference
Answer:
set of coordinates that a cell occupies on a spreadsheet
Question 17: Formula
Answer:
a sequence of values, cell references, names, functions, or operators in a cell that together produce a new value
Question 18: Rows
Answer:
a list of cells going left to right
Question 19: Active Worksheet
Answer:
the sheet that is currently open and the name of the tab should be bold
Question 20: Sheet Tab
Answer:
the current worksheet being displayed
Question 21: Mixed Reference
Answer:
combination of an absolute reference and a relative reference
Question 22: Absolute Reference
Answer:
cell address that contains a dollar sign in the row of column coordinate or both
.png)