Istm 210 excel - Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about Istm 210 excel? On this page you'll find 83 study documents about Istm 210 excel.
Page 4 out of 83 results
Sort by
-
ISTM 210 Exam 2- Excel Questions and Answers with complete
- Exam (elaborations) • 13 pages • 2024
- Available in package deal
-
- $7.99
- + learn more
Allows you to automatically populate cells in a worksheet - Answer-Fill Feature 
Allows you to complete a pattern within a range of cells - Answer-Series Feature 
Allows you to lock rows and columns when you navigate through a data table - Answer-Freeze Pain 
Feature 
Allows information on the table to be presented in an organized fashion - Answer-Sorting Feature 
Allows you to display only specific information on a data table - Answer-Filtering Feature 
cells automatically update when a formula...
-
ISTM 210 Exam 2- Excel Questions with 100% Correct Answers
- Exam (elaborations) • 5 pages • 2024
- Available in package deal
-
- $10.49
- + learn more
ISTM 210 Exam 2- Excel Questions with 
100% Correct Answers 
what do all formulas begin with 
= 
what does #### mean 
the cell needs to be widened in order to fit characters 
active cell 
has green, dashed lines around it 
what is the shortcut for viewing formulas 
ctrl ~ 
first step in creating an effective worksheet 
understand what is required 
workbook 
whole thing 
worksheet 
individual pages 
example of cell range 
A4:A6 
how to bring data into a worksheet 
data, get data 
how to hide a co...
-
ISTM 210 Exam 2- Excel Questions with 100% Correct Answers
- Exam (elaborations) • 11 pages • 2024
- Available in package deal
-
- $12.49
- + learn more
ISTM 210 Exam 2- Excel Questions with 
100% Correct Answers 
Fill Feature - answerAllows you to automatically populate cells in a worksheet 
Series Feature - answerAllows you to complete a pattern within a range of cells 
Freeze Pain Feature - answerAllows you to lock rows and columns when you navigate 
through a data table 
Sorting Feature - answerAllows information on the table to be presented in an organized 
fashion 
Filtering Feature - answerAllows you to display only specific information o...
-
ISTM 210 Exam 2- Excel Questions with 100% Correct Answers
- Exam (elaborations) • 5 pages • 2024
- Available in package deal
-
- $10.49
- + learn more
ISTM 210 Exam 2- Excel Questions with 
100% Correct Answers 
what do all formulas begin with 
= 
what does #### mean 
the cell needs to be widened in order to fit characters 
active cell 
has green, dashed lines around it 
what is the shortcut for viewing formulas 
ctrl ~ 
first step in creating an effective worksheet 
understand what is required 
workbook 
whole thing 
worksheet 
individual pages 
example of cell range 
A4:A6 
how to bring data into a worksheet 
data, get data 
how to hide a co...
-
ISTM 210 Exam 2 Excel (phinney) Questions with 100% Correct Answers
- Exam (elaborations) • 6 pages • 2024
- Available in package deal
-
- $11.49
- + learn more
ISTM 210 Exam 2 Excel (phinney) Questions 
with 100% Correct Answers 
Phinney's Fav formula - answerCONCATENATE 
CONCATENATE function - answerCONCATENATE (text1,[text2],...) - combines blocks 
of text 
SEARCH function - answerNOT case sensitive 
COUNT function - answerA function that determines how many cells in a range contain a 
number. 
Workbook - answerexcel file that stores all information, calculations, and analyses. 
Worksheet - answerA computerized spreadsheet in Excel. 
Cells - answers...
As you read this, a fellow student has made another $4.70
-
ISTM 210 Exam 2 Excel (phinney) Questions with 100% Correct Answers
- Exam (elaborations) • 6 pages • 2024
- Available in package deal
-
- $11.49
- + learn more
ISTM 210 Exam 2 Excel (phinney) Questions 
with 100% Correct Answers 
Phinney's Fav formula - answerCONCATENATE 
CONCATENATE function - answerCONCATENATE (text1,[text2],...) - combines blocks 
of text 
SEARCH function - answerNOT case sensitive 
COUNT function - answerA function that determines how many cells in a range contain a 
number. 
Workbook - answerexcel file that stores all information, calculations, and analyses. 
Worksheet - answerA computerized spreadsheet in Excel. 
Cells - answers...
-
ISTM 210 Exam 2- Excel Questions with 100% Correct Answers
- Exam (elaborations) • 5 pages • 2024
- Available in package deal
-
- $10.49
- + learn more
ISTM 210 Exam 2- Excel Questions with 
100% Correct Answers 
what do all formulas begin with 
= 
what does #### mean 
the cell needs to be widened in order to fit characters 
active cell 
has green, dashed lines around it 
what is the shortcut for viewing formulas 
ctrl ~ 
first step in creating an effective worksheet 
understand what is required 
workbook 
whole thing 
worksheet 
individual pages 
example of cell range 
A4:A6 
how to bring data into a worksheet 
data, get data 
how to hide a co...
-
ISTM 210 Exam 2 Excel (phinney) Questions with 100% Correct Answers
- Exam (elaborations) • 6 pages • 2024
- Available in package deal
-
- $10.49
- + learn more
ISTM 210 Exam 2 Excel (phinney) Questions 
with 100% Correct Answers 
Phinney's Fav formula - answerCONCATENATE 
CONCATENATE function - answerCONCATENATE (text1,[text2],...) - combines blocks 
of text 
SEARCH function - answerNOT case sensitive 
COUNT function - answerA function that determines how many cells in a range contain a 
number. 
Workbook - answerexcel file that stores all information, calculations, and analyses. 
Worksheet - answerA computerized spreadsheet in Excel. 
Cells - answers...
-
TAMU ISTM 210 Exam 2 Excel Exam 2024 Questions & Answers 100% Verified
- Exam (elaborations) • 3 pages • 2024
-
Available in package deal
-
- $9.49
- + learn more
TAMU ISTM 210 Exam 2 Excel Exam 2024 Questions & Answers 100% Verified 
 
 
Pie chart - ANSWERScompare parts of a whole 
 
line chart - ANSWERScompare an item over time, shows trends in data 
 
column charts - ANSWERScompare different (or same) categories over time 
 
Stacked column charts - ANSWERScolumn chart but with columns broken into subcategories 
 
Date formatted as general - ANSWERSdate(left) 
time (right) 
allows for math on dates, fraction of days 
 
today( - ANSWERSinsert current dat...
-
TAMU ISTM 210 Exam 2 Excel Questions with 100% Correct Answers
- Exam (elaborations) • 3 pages • 2024
- Available in package deal
-
- $10.49
- + learn more
TAMU ISTM 210 Exam 2 Excel Questions 
with 100% Correct Answers 
Pie chart - answercompare parts of a whole 
line chart - answercompare an item over time, shows trends in data 
column charts - answercompare different (or same) categories over time 
Stacked column charts - answercolumn chart but with columns broken into subcategories 
Date formatted as general - answerdate(left) 
time (right) 
allows for math on dates, fraction of days 
today( - answerinsert current date 
Now( - answerinsert curr...
How did he do that? By selling his study resources on Stuvia. Try it yourself! Discover all about earning on Stuvia