Istm 210 exam 2 excel - Study guides, Class notes & Summaries

Pie chart - compare parts of a whole line chart - compare an item over time, shows trends in data column charts - compare different (or same) categories over time Stacked column charts - column chart but with columns broken into subcategories Date formatted as general - date(left) time (right) allows for math on dates, fraction of days today( - insert current date Now( - insert current time Weekday( - day of the week weeknum( - week of the year month( - month of the year year( - what...

ISTM 210 Exam 2 Excel (phinney) Questions and Answers

ISTM 210 Exam 2 Excel (Phinney)

Phinney's Fav formula - Ans CONCATENATE CONCATENATE function - Ans CONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - Ans NOT case sensitive COUNT function - Ans A function that determines how many cells in a range contain a number. Workbook - Ans excel file that stores all information, calculations, and analyses. Worksheet - Ans A computerized spreadsheet in Excel.

Phinney's Fav formula - ANSWERSCONCATENATE CONCATENATE function - ANSWERSCONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - ANSWERSNOT case sensitive COUNT function - ANSWERSA function that determines how many cells in a range contain a number. Workbook - ANSWERSexcel file that stores all information, calculations, and analyses. Worksheet - ANSWERSA computerized spreadsheet in Excel. Cells - ANSWERSstore individual pieces of data/collections Cell Ad...

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 (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 (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...

Phinney's Fav formula - ANSWERSCONCATENATE CONCATENATE function - ANSWERSCONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - ANSWERSNOT case sensitive COUNT function - ANSWERSA function that determines how many cells in a range contain a number. Workbook - ANSWERSexcel file that stores all information, calculations, and analyses. Worksheet - ANSWERSA computerized spreadsheet in Excel. Cells - ANSWERSstore individual pieces of data/collections Cell Ad...

Phinney's Fav formula - CONCATENATE CONCATENATE function - CONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - NOT case sensitive COUNT function - A function that determines how many cells in a range contain a number. Workbook - excel file that stores all information, calculations, and analyses. Worksheet - A computerized spreadsheet in Excel. Cells - store individual pieces of data/collections Cell Address - The name of the cell is determined by the...