Quiz 3 SEC A
.
- 1.What is the intersection of a column and a row on a worksheet called ?
- A.
Column
- B.
Value
- C.
Address
- D.
Cell
- 2.Which of these data types is not in MS.excel?
- A.
Number
- B.
Currency
- C.
Label
- D.
Date/Time
- 3.In MS Excel, which menu does have Sort option
- A.
Edit
- B.
Format
- C.
Tool
- D.
Data
- 4.Which of these charts does not exist in MS Excel?
- A.
Scatter
- B.
Line
- C.
Doughnut
- D.
Graph
- 5.Which sign display when Formula Error in MS Excel
- A.
$
- B.
*
- C.
\
- D.
#
- 6.Functions in MS Excel must begin with ___
- A.
An () sign
- B.
An Equal Sign
- C.
A Plus Sign
- D.
A > Sign
- 7.What type of chart is useful for showing trends or changes over time ?.
- A.
Pie Chart
- B.
Column Chart
- C.
Line Chart
- D.
Dot Graph
- 8.The process of arrenging the items of a column in some sequence or order is known as :
- A.
Arranging
- B.
Autofill
- C.
Sorting
- D.
Filtering
- 9.The ____ feature of MS Excel quickly completes a series of data
- A.
Auto Complete
- B.
Auto Fill
- C.
Fill Handle
- D.
Sorting
- 10.What type of chart is useful for comparing parts of a whole ?
- A.
Pie Chart
- B.
Column Chart
- C.
Line Chart
- D.
Dot Graph
- 11.How many sheets are there, by default, when we create a new Excel file ?
- A.
1
- B.
3
- C.
5
- D.
10
- 12.In Excel, which one denoted a range from B1 through E5.
- A.
B1 - E5
- B.
B1:E5
- C.
B1 to E5
- D.
B1$E5
- 13.What type of chart will you use to compare performance of sales of two products ?
- A.
Column Chart
- B.
Line Chart
- C.
Pie Chart
- D.
Both A and B
- 14.A features that displays only the data in column (s) according to specified criteria
- A.
Formula
- B.
Sorting
- C.
Filtering
- D.
Pivot
- 15.On an excel sheet the active cell in indicated by ?
- A.
A dotted border
- B.
A dark wide border
- C.
A blinking border
- D.
By italic text
- 16.In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
- A.
A. You can automatically apply formatting to a data series
- B.
B. You can change the position of a data marker and that automatically changes the data point value in the worksheet
- C.
C. You can change a data point value and automatically that is drawn in the chart
- D.
D. Both (b) & (c)
- 17.The default style for new data keyed in a new workbook is ?
- A.
Comma
- B.
Normal
- C.
Currency
- D.
Percent
- 18.In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
- A.
Workday
- B.
Date
- C.
Networkday
- D.
Weekday
- 19.In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu
- A.
Edit
- B.
Format
- C.
Tools
- D.
All of the above
- 20.In MS-Excel 3-D reference in a formula
- A.
Cannot be modified
- B.
Only appears on summary worksheets
- C.
Spans worksheets
Questions: 14 | Attempts: 10552 | Last updated: Mar 22, 2022
-
Sample Question_______, ________ and _______are what you see when you open Excel
Questions: 20 | Attempts: 3065 | Last updated: Mar 20, 2022
-
Sample QuestionA fast way to add up this column of numbers is to click in the cell below the numbers and then:
Questions: 40 | Attempts: 1241 | Last updated: Aug 1, 2022
-
Sample QuestionWhat is the keyboard shortcut command to move the mouse pointer to cell A1?
Back to top