NEW
Font size
WorksheetsMS Excel 2013
Total questions: 13
Worksheet time: 10mins
Which function is used to add the values of several cells?
Average
Max
Min
Sum
When you type a formula, you always start by typing the __________ sign.
/
^
=
+
If a column displays #####, it means
The column is not wide enough.
Division by zero
The column has text value instead of a numeric value.
Wrong cell reference
Which symbol is used for absolute referencing?
%
$
&
*
Which one is not a type of cell referencing?
Relative
Absolute
Mixed
General
Which function is used to count the number of numeric values in a range?
CountNumbers( )
COUNT( )
SUM( )
TOTAL( )
A reference where a formula refers to its own value
mixed reference
absolute reference
circular reference
The AutoSum button is present in the _________ group on the HOME tab.
Styles
Editing
Font
Alignment
The _________ function finds the average of a set of values in a column or row.
Max
Min
Sum
Average
The _________ character is used for the concatenation of strings.
ampersand (&)
asterisk (*)
dollar ($)
percent (%)
the intersection of a row and column
row
column
cell
sheet
located just above the column headings; shows the contents of the selected cell
bar
name box
formula
formula bar
predefined formulas available in Excel to perform calculations
formula
function
cell
equal sign
