Have an account?
Skip to Content
Build your own quiz
Suggestions for you
35 questions
Show Answers
See Preview
- 1. Multiple Choice
Absolute cell reference
is group of selected cells which are highlighted
is reference which is automatically fills other cells
does not change when the formula is copied or moved to a new location
- 2. Multiple Choice
You can use this feature to fill in a series of numbers and dates.
AutoCorrect
AutoFill
AutoComplete
AutoFix
- 3. Multiple Choice
With the __________________ feature, Excel
compares the first few characters
you enter in a cell to existing entries
in the same column and proposes
the existing entry. You can press
Enter to accept the proposed entry.
AutoFill
AutoComplete
AutoCorrect
AutoFix
- 4. Multiple Choice
This feature in
Excel corrects common
mistakes as you enter data.
AutoFix
AutoCorrect
AutoComplete
AutoFill
- 5. Multiple Choice
The ______________ feature
enables you to repeat the
same data in a column or
row.
AutoFix
AutoComplete
AutoCorrect
AutoFill
- 6. Multiple Choice
a value, a cell reference, a
range, or text that acts as an
operand in a function formula
and it is enclosed in
parentheses after the function
name.
argument
criteria
reference
function
- 7. Multiple Choice
the intersection of a single
row and a single column
range
reference
cell
argument
- 8. Multiple Choice
cell reference
is the column letter followed by the row number
the intersection of a single row and a single column
graphical representation of your worksheet data
function tallies the number of occurrences of numerical data
- 9. Multiple Choice
to select an entire column, click the
CTRL+A
ALT+A
column heading
the first cell of column twice
- 10. Multiple Choice
When you _______ data, the
data that does not meet
the criteria is hidden, and
only the data that meets
the criteria is shown.
hide column
hide row
filter
edit
- 11. Multiple Choice
The equation used to calculate values in a cell using operators.
function
formula
argument
- 12. Multiple Choice
Items on either side of an operator in a formula. In Excel, __________s can be values, cell references, names, labels, and functions.
operand
function
formula
operator
- 13. Multiple Choice
When you select a group
of cells, the group is called
a _________
reference
highlight
range
sheet
- 14. Multiple Choice
worksheet is always stored
in a _______________ that
contains one or more
worksheets.
workpage
workpaper
workbook
workpool
- 15. Multiple Choice
Rounds a number down to the nearest integer that is less than or equal to it.
ROUND
INT
MODE
FULL
- 16. Multiple Choice
Which one is correct formula for IF function?
=IF(value if true, value if false)
=IF(logical expression, value if false, value if true)
=IF(logical expression, value if true, value if false)
=IF(reference, value if true, value if false)
- 17. Multiple Choice
=__________(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match).
HLOOKUP
VLOOKUP
COUNITF
SEARCHIF
- 18. Multiple Choice
Which are correct formulas for nested ifs with 3 criteria?
=IF(logical expression, value if true, IF(logical expression, value if true, value if false))
=IF(logical expression, value if true, IF(logical expression, value if true, IF(logical expression, value if true, value if false))
=IF(logical expression, value if true, IF(logical expression, value if true, IF(logical expression, value if true))
=IF(logical expression, value if true, IF(logical expression, value if false)
- 19. Multiple Choice
Which are types of test data?
extreme data
ordinary data
normal data
error data
abnormal data
- 20. Multiple Choice
Extreme data is
Are normal data, lowest possible values
Are abnormal data, lowest and highest possible values
Are normal data, lowest and highest possible values
Are normal data, highest possible values
- 21. Multiple Choice
System was designed to
accept and process marks and grades
in percentages. Which are abnormal data for this system?
0,100,43
-1,102,210
93,12,48
21,2,99
- 22. Multiple Choice
There are two types of references:
1._____________ : (B2:B6), C4
2.Absolute : $A$2, ($B$2:$B$6),
Changing
Fluctuate
Relative
Linked
- 23. Multiple Choice
Which button is used to bring INSERT FUNCTION window?
1
2
3
4
- 24. Multiple Choice
We use ______________ to find how many numbers are in a range?
COUNTA
COUNTIF
COUNTING
COUNT
- 25. Multiple Choice
______________ function is used to find the nearest whole number to a numeric value
INT
ROUND
WHOLE
NEAREST
- 26. Multiple Choice
Which function is used to add up values of cats from the given price list?
=SUMIF(B2,D7:D14)
=SUM(D7:D14)
=SUMIF(D7:D14,C2,B7:B14)
=SUMIF(B7:B14,B2,D7:D14)
- 27. Multiple Choice
If we want to use AutoFill feature to calculate value of Dogs and Goats what function we should use in cell D2?
=SUMIF($B$7:$B$14,$B$2,$D$7:$D$14)
=SUMIF($B$7:$B$14,B2,$D$7:$D$14)
=SUMIF(B7:B14,B2,D7:D14)
=SUMIF($D$7:$D$14,D2,$B$7:$B$14)
- 28. Multiple Choice
If the mark is more than 50, the student passes. Which function we should use in D3? (We will use AutoFill for others)
=IF($B$3>50,"YES","NO")
=IF($C$3>50,"YES","NO")
=IF(C3>50,"YES","NO")
=IF(B3>50,YES,NO)
- 29. Multiple Choice
Which wildcard filter combination is used?
*ons
~ons~
*ons*
?ons?
- 30. Multiple Choice
Which wildcard filter combination is used?
*on*
?on?
?on???
*on
- 31. Multiple Choice
Which are simple mathematical operators used in a spreadsheet.
Operator: / Name: Division
Operator: * Name: Multiplication
Operator: + Name: Addition
Operator: - Name: Subtraction
Operator: ^ Name: Indices/Powers
ALL
- 32. Multiple Choice
We create a _________________ and use it. These are reasons why we would create and use them:
Using a spreadsheet model/you change spreadsheet data
to explore different possible answers.
they are often financial, mathematic or scientific.
This is sometimes called ‘what if’ modelling/scenario.
It allows you to change variables and get answers without doing the real thing.
Mathematical model
Excel sheet
Data System
Data Model
- 33. Multiple Choice
The contents of cells A1 and A2 are multiplied together in A3. Explain why cell A3 shows this answer.
Format of cell is designed to show the number as in the picture
Formulae in A3 is wrong
A1 and A2 numbers are electronic passwords
The contents of A3 are too large to fit into the cell/column width.
- 34. Multiple Choice
The contents of spreadsheet cell can be:
label
program
formula
number
script
- 35. Multiple Choice
A range/array of cells given a pre-defined name ...
... which is short and meaningful
... which is understood by the spreadsheet to refer to those cells.
It is easier to remember and use this name (e.g. VAT) than the cell references (e.g. $F$14:$G$16).
named cells
active range
named ranges
named reference
- Answer choicesTagsAnswer choicesTags