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


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!