We have sent an email with your new password.

Close this window

Cgs1060

38 Questions  I  By [email protected]
CGS1060

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Goal Seek is an example of a
2.  Number values are often called labels
A.
B.
3.  A ______is formatted as a pattern of uniformly spaced horizontal rows and vertical columns
4.  An Excel worksheet is made up of one or more workbooks.
A.
B.
5.  The____allows the user to enter or edit he value or formula contained in the active cell.
6.  Excel does not have a spell checker
A.
B.
7.  Changing a value in a cell to see what effect it has on values in other cells that are calculated using the value is said to be doing
8.  An image that appears to have length, depth and width is said to be
9.  When the user changes a value in a cell, Excel automatically recalculates. 
A.
B.
10.  You would ____ a table if you wanted to display only data that matched specific criteria. 
11.  Values are compared using a ___ operator
12.  The _____ function counts the number of cells within a range that meets a certain criteria.
13.  The ____is outlined in black and is ready to accept data. 
14.  A pie chart should be limited to no more than seven categories
A.
B.
15.  The ___ function adds all of the numbers in a range of cells
16.  On a line chart, the y-axis is known as 
17.  An excel document is called a
18.  To ___ a table means to arrange all of the data in a specific order. 
19.  The values that an Excel function uses to perform operations are called
20.  .A menu that is context sensitive displays options related to the current task. 
A.
B.
21.  Two or more cells that Excel treats as a single unit is called a
22.  Arithmetic operators are used to perform basic mathematical operations in Excel. 
A.
B.
23.  If a value is changed in in a cell, Excel recalculates all formulas that reference that cell.
A.
B.
24.  A predefined formula is called a
25.  On a line chart, the x-axis is known as the 
26.  The spacing between the tick marks is determined by the 
27.  An excel formula begins with which symbol?
28.  Anything a user types into a cell is known as a
29.  You can select an element of a chart to format by using the chart’s element box. 
A.
B.
30.  If you want to chart trends over time use a
31.  Cell contents are either values or formulas
A.
B.
32.  A gallery of text styles that can be used to apply decorative effects to text is called a 
33.  A ___ _______ shows the relationship of each part of the data to the whole.
34.  The small black square in the lower right corner of a selected cell is called a
35.  By including worksheets in a _____ you can enter or edit data on them simultaneously. 
36.  Each pie slice displayed on a pie chart is an example of a
37.  The Excel operator for greater than or equal to is said to be 
38.  Excel’s ____ function retreats the date and time from the computer’s calendar and clock.
Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!