We have sent an email with your new password.


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

Removing ad is a premium feature

Upgrade and get a lot more done!