True/False Questions Cell entries in spreadsheets can be formatted similarly to formatting in word processors. 2) Spreadsheets can only sort in ascending order. 3) A group of cells is called a range. 4) Column widths in a spreadsheet must be set manually 5) All cells of a spreadsheet are always visible. 6) A formula in a cell always starts with an equal sign. 7) Data can be copied from one cell to another, but formulas cannot. 8) Functions and column letters in a spreadsheet are not case sensitive. 9) Spreadsheets can only display time as military time 10) You cannot mix absolute and relative references in the same cell reference. 1) What is the most common application of a spreadsheet? A) as a joumal B) to process text data C) to process numerical data D) as a drawing application 2) The basic unit of a spreadsheet is a A) box B) cube C) cell D) grid 3) Spreadsheets: A) can only be sorted by column A B) can be sorted by any column provided the column is named C) are sorted by rows then columns D) can be sorted by any column 4) A range of cells can include: A) cells from more than one row B) cells from more than one column C) the entire spreadsheet D) all of the above 5) Suppose cell B4 has an entry. If the data in cell A4 is too wide to fit in the cell, it A) is truncated B) is abbreviated C) is hyphenated D) cannot be entered into a cell 6) The main purpose ofh spreadsheet is to: A) display numerical results B) process numerical data C) organize factual data D) graphically present data 7) In Microsoft Excel, all of the contents of the spreadsheet's cells, including the formulas, can be displayed by using the keyboard shortcut: A) CtrltAlt+Tab B) Ctrl+FI C) Ctrl+ Note: grave accent () is on the same key with tilde ) C) organize factual datal D) graphically present data 7) In Microsoft Excel, all of the contents of the spreadsheet's cells, including the formulas, can be displayed by using the keyboard shortcut: A) Ctrl+Alt+Tab B) Ctrl+FI C) Ctrl+ Note: grave accent () is on the same key with tilde) D) Ctrl C 8) Which of the following is used for computing common summary applications in a spreadsheet? A) formulas B) functions C) tables D) formatting 9) A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a(n): A) date copy B) auto-increment C) conditional fill D) series fill 10) An example of conditional formatting is: A) applying a font color, e.g, green, to values over 500 B) applying currency format to cells that refer to money values C) applying italics to one column and bold to another column D) formatting a spreadsheet with alternate colors for each row Short Answer Questions 1) Spreadsheet columns are labeled with 2) The rows of a spreadsheet are designated with 3) The at the beginning ofa cell entry determines whether a spreadsheet cell contains a formula or data. 3. (25pts) Using spreadsheet in Moodle - Basics of Spreadsheets HW 1xlsx, containing 2 sheets: Abs vs Rel reference' and Sort and Filter Show your work by incorporating 647 Words English labeled wiH D Spreadsheet columns are 2) The rows of a spreadsheet are designated with 3) The a formula or data at the beginning of a cell entry determines whether a spreadsheet cell contains 3 (25pts) Using spreadsheet in Moodle-Basics of Spreadsheets HW 1xlsx, containing 2 sheets: Abs vs Rel reference' and Sort and Filter'. Show your work by incorporating screenshots into HW1 document. a. Ellout Abs vs Rel reference' sheet using formulas. Use power of spreadsheets- No manual calculations. Hint: Use Abs and Rel reference Using Sort and Filter sheet i. Sort by Last Name ii. Sort by Date iii. Sort by Product iv. Sort by Qy v. Sort by Total vi. Filter by Last Name vii. Filter by Product vii Filter by Date