Module 2 Flashcards
You can get the largest numerical value in a range of values by using what function?
Max
You can get the smallest numerical value in a range of values using what function?
Min
We retrieve information from table by searching a row for a match data
Hlookup
We retrieve information from table by searching a column for a match data
Vlookup
A function that adds a range of cells
Total
The name of the bar where information appears as you input data in excel
Formula bar
Excel refers to files as
Workbooks
The letters in excel represent the
Column
The numbers in excel represent the
Row
To alert excel that you are entering a formula and not text, type this preceding the formula
=
The cell in the worksheet in which you can type data
Active cell
An excel file format extension is
Xls
Text in excel is automatically aligned
Left
Numbers in excel are automatically aligned
Right
The ability to quickly add a formula, set of number, months or day of the week down a column or across a row
Autofill
The set of data that runs left to right in a spreadsheet
Row
The set of data that runs up and down in a spreadsheet
Column
The intersection of a row and column
Cell
The count column found on the grade count table, can be computed by this function
Countif