CTS-130 – Spreadsheets Questions With Complete Solutions

How are chart sheets different from worksheets? correct answer: Worksheets contain a grid of cells in which text and formulas can be entered and can also contain graphical objects. Chart sheets contains charts and graphic objects but do not contain grids in which text and formulas can be entered. What is the cell reference for the cell located in the third Column and fourth row of a worksheet? correct answer: C4 What is the range reference for the block of cells D3 through E10? correct answer: D3:E10 What is the range reference for cells A1 through C5 and cells A8 through C12? correct answer: A1:C5, A8:C12 How is text aligned within a worksheet cell by default? correct answer: Text is left-aligned in a cell by default. How would the number 00514 appear in a cell? correct answer: 514 Cell B2 contains the entry May 3, 2021. Why doesn't Excel consider this a text entry? correct answer: Dates and times are stored as numbers not as text. How do you autofit a column to match its longest cell entry? correct answer: Double-click the right border of the column heading or click the Format button in the Cells group on the Home tab and click AutoFit Column Width. What is the formula to add values in cells A1, B1, and C1? What function will achieve the same result? correct answer: =A1+B1+C1 =SUM(A1:C1) What is the formula to count the number of numeric values in the range A1:A30? correct answer: =COUNT(A1:A30)