NEW
Font size
Worksheetsms excel 2010
Total questions: 50
Worksheet time: 25mins
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.
A) AutoSum
B) Custom Fill
C)Fill Handle
D)Ctrl+C
What text formula joins the text from two or more cells?
concatenate
proper
left
e=mc2
Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.
format cell
conditional formatting
fill color
magic cell
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
Which operator is used to multiply in Excel?
+
x
/
*
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
To edit a formula you
A. Double-click the cell
B. Click in the formula bar
C. Press Esc
D. Both A & B
Answer =2+3*3-2
9
10
11
12
Answer =3+5*(6-2)
23
32
31
64
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
$
&
#
The key at the side of the chart is called
a decoder
a what is where
a legend
the axis
BAR
LINE
STOCK
COMBO
BAR CLUSTER
COMBO
STOCK
RADAR
XY SCATTER
COMBO
STOCK
RADAR
LINE
CIRCLE
PIE
COMBO
BAR
LINE
STOCK
BAR CLUSTER
Area
Stock
Sunburst
Radar
Identify this chart.
Column
Bar
Line
Pie
This part of the chart is usually vertical and contains data.
Y axis
X axis
Legend
Chart title
The call references contain values to be used for calculation passed to the function are called
Arguments
Operators
Product
Autosum
To get the total of adjacent cells which key combination is used.
Alt + =
Shift + =
Ctrl + =
Space + =
This function returns the remainder after a number is divided by the divisor
POWER( )
AVERAGE( )
MOD( )
INT( )
Which of the given cell reference can be included in relative reference?
$D6
B3
A$3
B$3
Microsoft Excel follows the __________ rule to evaluate the mathematical expression.
BODMAS
BIDMAS
BEDMAS
DMAS
Which function will display the current date in the selected cell?
DATE( )
DAY( )
CURRENT DATE( )
TODAY( )
To use the Sheet reference, which address is appropriate out of the following options.
A4 ! Sheet1
Sheet1 ! A4
Sheet1 $ A4
A4 # Sheet1
What is the meaning of this error in Excel?
Text in the formula is not recognized
Trying to divide by 0
A space was used in formulas that reference multiple ranges; a comma separates range references
Referencing in =$B3+B$4 formula is
Absolute
Relative
Mixed
Proper
To arrange data in ascending order of age we will
Filter it
Sort it
Apply Conditional Formatting
Rearrange data manually
To display only those records where temperature is below 0 degree you will
Manually extract the data
Sort the data
Filter the data
Use Goto option
To colour those cells blue where temperature is above 50 degree you will
Apply filtering
Use fill colour option
Shade Cells
Use Conditional Formatting
The various elements of a chart are
data label, chart title, legend
data legend, chart title, label
chart legend. chart label, chart title
none of the above
To change chart layout, style, type of inserted chart you need to go to
Format Tab
Insert Tab
Design Tab
View Tab
A) =Count("String")
B) =Len("String")
Both will give the same output
Both will give an error
A) is correct B) is wrong
A) is wrong B) is correct
To see the result of the applied formula, press _________ key.
Shift
Ctrl
Enter
