Multiple choice Microsoft Excel questions. please answer all of them!
answers the question or completes the statement. - Which of the following is an absolute cell address? (A) SA$6 (B) A6 (C) %A6 (D) A*6* How is a new row added to an existing spreadsheet in Microsoft Excel? (A) Select the column next to the cell where the new row should be added, left-click, and select Insert.. (B) Drag a blank row from the ribbon and drop it between the rows where it should be added. (C) Select the row below where the new row should be added, right-click, and Home>Cells> Insert Cells>Insert Sheet Rows. (D) Individual cells can be inserted, but not entire rows or columns. Which type of file is used to share spreadsheet data from one application with other software? (A) ITC (B) CSV (C) CDF (D) ECF Searching and finding a subset of the database describes which of the following? (A) query (B) sort (C) form (D) report master Which keys should be pressed to quickly move the active cell to cell Al of the spreadsheet in MS Excel? (A) Tab] Home] (B) [Shift) [Home] (C) [Ctrl] [Home] continued (D) [Alt] [Home] M UHU U Umputer Lalli 3 How can the width of a column be automatically adjusted to fit the cell with the most information in the column? (A) place the cursor on the edge of the relevant alphabetic column header and then double-click (B) place the cursor on the right edge of the cell with most data and then double-click! (C) highlight the relevant column and then click Adjust Width on the Data tab (D) column width cannot be automatically adjusted Which of the following Microsoft Excel functions would be used to count the number of sales for S100 in a range that included all sales made during a given month? (A) COUNTBLANK (B) AVERAGE (C) PMT (D) COUNTIF Which types of charts are best for showing gradual trends over months or years? (A) pie charts and scatter charts (B) bar charts and clustered-column charts (C) line charts and bar charts (D) pie charts and line charts Read each sentence and fill in the blank with a vocabulary word from the word bank that best completes each sentence. 9. A(n) is a group or block of cells in a worksheet. (range, principal, sheet) 10.If cells A1, A2, A3, and A4 are being used for a formula, the cell range can be entered as (A1:A4, Al-A4, A1//A4) 11. To find the highest value in the cell range C6, C7, C8, C9, and C10, enter the formula _into a cell in Microsoft Excel. (=SUM(C6:C10), =MAX (C6:C10). "AVG (C6:C10)) 12.A(n). database is a collection of tables that have been joined. (relational, primary key, criteria) 13. In a non-formatted/standard template, if the number 25 is converted to text format, the alignment becomes _ (right, left, center) 14. When tables are joined, primary keys from other tables become (secondary, foreign, restricted) 15. The view in Microsoft Access is used by developers to create fields. (design, calculate, export) supply the data or information that a function needs for its calculations. (Styles, Graphical interfaces, Arguments) 16
