We have sent an email with your new password.


Cgs1060

38 Questions  I  By [email protected]
Online Test Quizzes & Trivia

   or Create Online Test
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz