Com s 113 - Study guides, Class notes & Summaries

COM S 113 Exam 1 Question and answers 100% correct 2023Worksheet - correct answer A spreadsheet that contains formulas, functions, values, text, and visual aids Workbook - correct answer A file containing related worksheets Input Area - correct answer a range of cells containing values for variables used in formulas Output area - correct answer a range of cells containing results based on manipulating the variables Name box - correct answer identifies the address of the c...

com s 113 Questions with complete solution 2023

COM S 113 Questions with complete solution 2023Clustered column chart - correct answer Chart that groups columns side by side to compare data points among categories. Sparkline - correct answer Miniature chart contained in a single cell. Line chart - correct answer Chart type that shows trends over time in which the value axis indicates quantities and the horizontal axis indicates time. Chart title - correct answer Label that describes the entire chart. Axis title - correct ...

Com S 113 Exam 1 Question and answers 100% correct 2023Chapter 1 - correct answer Introduction to Excel Spreadsheet - correct answer an electronic file of columns and rows that is used to:organize related data and perform calculations Worksheet - correct answer single spreadsheet Workbook - correct answer file containing multiple related worksheets Columns - correct answer letters Rows - correct answer numbers Excel supports 4 types of data - correct answer...

Com S 113 Exam 1 Questions with complete solution 2023

COM S 113 Exam II Questions with complete solution 2023Subtotal Data - correct answer - Excel can automatically insert subtotal rows for each category in a sorted range of data - you must enter "at each change" (where to place the subtotal rows), "use function" (what type of subtotal), and "add subtotal to" (which columns to calculate subtotals for) PivotTable - correct answer - data can be rearranged - details can be expanded or collapsed - data can be organized and grouped di...

COM S 113 Exam 1 Question and answers correctly solved 2023Which of the following is not true about the VLOOKUP function? - correct answer The lookup table must be in descending order. Which of the following is not a valid lookup function? - correct answer LLOOKUP Functions can be selected by using the ............... - correct answer Insert Function dialog box Where does Excel automatically display statistics like count, average, and sum when a range of values is selected? - c...

COM S 113 Exam II Question and answers 100% correct 2023Subtotal Data - correct answer - Excel can automatically insert subtotal rows for each category in a sorted range of data - you must enter "at each change" (where to place the subtotal rows), "use function" (what type of subtotal), and "add subtotal to" (which columns to calculate subtotals for) PivotTable - correct answer - data can be rearranged - details can be expanded or collapsed - data can be organized and grouped d...

Com S 113 Questions with complete solution 2023

COM S 113 Exam 1 Question and answers 2023 verified to pass A Formula does not begin with (=) sign - correct answer false If a cell contains the formula =B7-F8 then what is/are possible data type(s) in Cell B7? - correct answer Value (number) Formula that contain number Date The value of =5^2+1-2 is - correct answer 24 A cluster column chart can be used for. - correct answer Multiple data series The correct structure for IF function is - correct answer = IF (logical test...