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

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.