1896. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
✅ The correct answer is option D.
1899. To create a formula, you can use:
A. Values but not cell references
B. Cell references but not values
C. Values or cell references although not both at the same time
D. Value and cell references
✅ The correct answer is option D.
1902. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
✅ The correct answer is option B.
1904. When you want to insert a blank embedded excel object in a word document you can
A. Click the object command on the insert menu
B. Click the office links button on the standard toolbar
C. Click the create worksheet button on the formatting toolbar
D. Click the import excel command on the file menu
✅ The correct answer is option A.
1907. What symbol is used before a number to make it a label?
A. ” ( quote )
B. = ( equal )
C. _ ( underscore )
D. ‘ ( apostrophe )
✅ The correct answer is option D.
1910. Excel probably considers the cell entry January 1, 2020 to be a
A. Label
B. Value
C. Formula
D. Text string
✅ The correct answer is option B.
1913. How many characters can be typed in a single cell in Excel?
A. 256
B. 1024
C. 32767
D. 65535
✅ The correct answer is option C.
1916. Which of the following formulas will Excel not be able to calculate?
A. =SUM(Sales)-A3
B. =SUM(A1:A5)*.5
C. =SUM(A1:A5)/(10-10)
D. =SUM(A1:A5)-10
✅ The correct answer is option A.
1919. You can edit a cell by
A. Clicking the formula button
B. Double clicking the cell to edit it in-place
C. Selecting Edit > Edit Cell from the menu
D. None of above
✅ The correct answer is option B.
1876. The ________ is a short horizontal line indicating the conclusion of a document.
A. Insertion point
B. End mark
C. Status indicator
D. Scroll box
✅ The correct answer is option B.