Ultimate MS Excel Quiz Questions! Trivia
(18).jpg "Ultimate MS Excel Quiz Questions! Trivia - Quiz")
Excel Quiz
- 1.
A function must always start with
- A.
=sumif
- B.
=sum
- C.
=
- D.
=sumif(
Correct Answer
C. = -
- 2.
Common Functions that we use most often are
- A.
=Sum
- B.
=Average
- C.
=Min
- D.
=Max
- E.
All of the above
Correct Answer
E. All of the above -
- 3.
Excel aloows you to create ____________________________ that refer to column and row labels in place of the cell reference or range.
- A.
Comments
- B.
Natural Language Formulas
- C.
Arguments
- D.
Functions
Correct Answer
B. Natural Language Formulas -
- 4.
A ________triangle appears in the upper-right corner of any cell with an attached __________________.
- A.
Green triangle, note
- B.
Red triangle, comment
- C.
Green triangle, comment
- D.
Red triangle, note
Correct Answer
B. Red triangle, comment -
- 5.
A block of cells in an Excel worksheet.
- A.
Area
- B.
Range
- C.
Cell
- D.
Active cell
Correct Answer
B. Range -
- 6.
A range of cells can be __________________or ____________________.
- A.
Connected, nonconnected
- B.
Adjancent,non adjancent
- C.
Contiguous, noncontiguous
Correct Answer
C. Contiguous, noncontiguous -
- 7.
Worksheets that are selected as a unit; any action performed on this unit will affect all the worksheets in the group.
- A.
Active
- B.
Grouping
- C.
Attached
Correct Answer
B. Grouping -
- 8.
A Range name may use up to ________ characters.
- A.
355
- B.
155
- C.
255
- D.
555
Correct Answer
C. 255 -
- 9.
The format for an IF statement is:
- A.
=SUM(condition,x,y)
- B.
=IF(condition,x,y)
- C.
=(condition,x,y)
Correct Answer
B. =IF(condition,x,y) -
- 10.
Correct format for a SUMIF statement is
- A.
=SUMIF(range, critera,sum_range)
- B.
=SUMIF(range,sum_range,critera)
- C.
=SUMIF(sum_range,critera,range)
Correct Answer
A. =SUMIF(range, critera,sum_range) -
- 11.
A graphic that allows you to compare and contrast data in a visual format.
- A.
Plot
- B.
Legend
- C.
Chart
Correct Answer
C. Chart -
- 12.
A chart placed as an object within a worksheet.
- A.
Chart sheets
- B.
Embedded chart
- C.
Categories
Correct Answer
B. Embedded chart -
- 13.
All charts use axes except
- A.
Bar
- B.
Line
- C.
Plot
- D.
Pie
Correct Answer
D. Pie -
- 14.
A chart actually has two backgrounds: the larger _______ _______ and the smaller ______ ______ which can be formmatted.
- A.
Tick mark, background
- B.
Chart area, plot area
- C.
Data axis, value axis
Correct Answer
B. Chart area, plot area -
- 15.
A chart that occupies its own worksheet.
- A.
Embedded chart
- B.
Chart sheet
- C.
Stand alone chart
Correct Answer
B. Chart sheet -
- 16.
A key that identifies each of the data series in a chart.
- A.
Key
- B.
Map
- C.
Legend
Correct Answer
C. Legend -
- 17.
Name the three parts that are typically found in a chart.
- A.
Data series, Series labels and Catefory labels
- B.
Name box, value labels, name labels
- C.
X axis, y axis, z axis
Correct Answer
A. Data series, Series labels and Catefory labels -
- 18.
Name two of the several ways to enhance a Chart Background.
- A.
Delete table
- B.
I D K
- C.
Ask my buddy
Correct Answer(s)
A. Delete table
B. I D K
C. Ask my buddy -
- 19.
A ______________ends the argument.
- A.
Quotation mark
- B.
Closed parenthesis
- C.
Comma
- D.
Period
Correct Answer
B. Closed parenthesis -
- 20.
Name three rules for naming ranges.
- A.
Spaces are allowed, can start with a range name, Y2008
- B.
Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes
- C.
Must make sense, can start with a number, spaces are allowed
Correct Answer
B. Spaces are not allowed, do not start with range names, may include letters, numbers, underscores,blackslashes -
- 21.
To display a comment in a worksheet
- A.
Roll mouse over red triangle
- B.
Open comment cell
- C.
Must highlight cell
Correct Answer
A. Roll mouse over red triangle -
- 22.
When you use "Natural Language" in a formula the name must be spelled exactly as the oolumn or row label.
- A.
NO
- B.
YES
Correct Answer
B. YES -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 17, 2022Quiz Edited by
ProProfs Editorial Team -
Jun 02, 2015Quiz Created by
Ersengultepe
Back to top