Excel - Online Assessment
Settings
- 1.The symbol for division is...
- A.
$
- B.
\
- C.
*
- 2.What is a pivot table?
- A.
A report
- B.
An advanced filter
- C.
A filter
- D.
Vlookup
- 3.An nested if statement only allows for one argument?
- A.
True
- B.
False
- 4.If the range lookup is false in a vlookup what does it mean?
- A.
The result will return an exact match
- B.
The result will return the nearest match
- C.
It will return a negative
- D.
None of the above
- 5.By default how many worksheets are in a workbook?
- A.
1
- B.
2
- C.
3
- D.
4
- 6.
- A.
1
- B.
2
- C.
3
- D.
4
- 7.A macro is a part of a conditional format?
- A.
True
- B.
False
- 8.A template is a worksheet which has all the necessary features you require?
- A.
True
- B.
False
- 9.What is a scenario?
- A.
Figures which switch between varying amounts
- B.
A conditional format
- C.
A macro
- D.
An IF statement
- 10.The sumif function has the...... range, criteria, sum_range?
- A.
True
- B.
False
- 11.A lookup table counts the columns in the Col_index_No and not the cell reference?
- A.
True
- B.
False
- 12.The feature that enables you to automatically complete a list of 12 months after you key one month is
- A.
Cell style
- B.
Fill handle or Autofill
- C.
Page layout
- D.
Find
- E.
Replace
- 13.
- A.
Merge and Center
- B.
Align
- C.
Freeze columns
- D.
Indent
- E.
Split
- 14.
- A.
Mixed reference
- B.
Absolute reference
- C.
Relative reference
- D.
Additional reference
- E.
Money reference
- 15.What type of operation is being preformed in the formula =A4*B5
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
- 16.Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
- 17.What term describes a model workbook used as the basis for other workbooks?
- A.
Form
- B.
Demonstration
- C.
Template
- D.
Cell styles
- E.
Page Layout
- 18.How can you start Edit mode to edit a formula?
- A.
Tools
- B.
Format
- C.
F4
- D.
F2 or double-click cell
- E.
Find and replace
- 19.Three types of data visualation are:
- A.
Tools, Columns, Styles
- B.
Data bars, Color scales, Icon sets
- C.
Cell styles, Bold, Italics
- D.
Home, Edit, Fill
- E.
Shapes, Arrows, Clip art
- 20.Name the function that adds cell values only if they meet your criteria.
- A.
Average()
- B.
Count()
- C.
Mean()
- D.
SumIF()
- E.
Round
- 21.What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
- 22.Which logical function shows the opposite of the condition?
- A.
NOT function
- B.
False function
- C.
Nper function
- D.
Sum function
- E.
PMT function
- 23.What is the term used to describe a function inside a function?
- A.
Conditional
- B.
Argument
- C.
Nested
- D.
Double
- E.
Hyperlink
- 24.What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
- 25.Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
Back to top