TAMU ISTM 210 Exam 2 Excel ||Verified Exam!!|| Most
Recent Exam Actual Complete Real Exam Questions
With Correct Answers (Verified Answers) Already
Graded A+ | Newest Exam!!!
What is the first cell in a column called? - Answer-primary
Key field
What is an ideal example of a primary field? - Answer-ID
number because each individual or item has a unique ID
number.
How do you insert a table into excel? (two options) -
Answer-Option 1: insert data à go to INSERT top tab à
select TABLE
Option 2: go to INSERT tab à select TABLE à input cell
from data
In what format are cells in excel written? - Answer-
$COLUMN$ROW
,2|Page
What can sort do in excel? - Answer-Changes the order of
information for a specific field. For example, alphabetically,
highest to lowest, or color
Does sort, filter and search, apply to records, fields, or
both? - Answer-applies to columns (fields) only
How do you do a search within a field? - Answer-Select
the arrow down next to the field name à type in keywords
in search field
What needs to be turned on so search can work? -
Answer-the filter
What does the filter option allow you to do in excel? -
Answer-Remove or include specific results based upon
the criteria that was selected.
What does text filters do? - Answer-filter by:
contains,
does not contain,
begins with,
,3|Page
ends with, and
customize filters.
What does conditional formatting do in excel? - Answer-
Highlight cell with specific rules such as greater than,
between, less than, above/ under percentage. It also adds
colored bars, scales, and icon sets to differentiate levels
between data
What does format as table do? - Answer-Customize colors
of rows and columns for easier understanding
What does cell styles do? - Answer-Customize each cell
individually by color, headings style, data/models, as well
as number format
What does format do? - Answer-Customize cells
individually. Such as height, width, rename sheet
In a database a row is called a - Answer-record
In a data base a column is called a - Answer-field
, 4|Page
By putting all the information in the same row, what is
being created? - Answer-Creating a relationship between
each cell in a row
How do you lock a cell? - Answer-Under the cells category
--> format
How do you protect a sheet? - Answer-Under the cells
category --> format
How do you change number format in a cell? - Answer-
Under the styles category select CELL STYLES
How do you hide/unhide cells? - Answer-Under the cells
category --> FORMAT
How do you rename sheet? - Answer-Under the cells
category --> FORMAT
How do you change the outline of each cell / tab color? -
Answer-Under the cells category --> FORMAT--> select
TAB COLOR