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(
- 2.Common Functions that we use most often are
- A.
=Sum
- B.
=Average
- C.
=Min
- D.
=Max
- 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
- 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
- 5.A block of cells in an Excel worksheet.
- A.
Area
- B.
Range
- C.
Cell
- D.
Active cell
- 6.A range of cells can be __________________or ____________________.
- A.
Connected, nonconnected
- B.
Adjancent,non adjancent
- 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
- 8.A Range name may use up to ________ characters.
- A.
355
- B.
155
- C.
255
- D.
555
- 9.The format for an IF statement is:
- A.
=SUM(condition,x,y)
- B.
=IF(condition,x,y)
- C.
=(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)
- 11.A graphic that allows you to compare and contrast data in a visual format.
- A.
Plot
- B.
Legend
- C.
Chart
- 12.A chart placed as an object within a worksheet.
- A.
Chart sheets
- B.
Embedded chart
- C.
Categories
- 13.All charts use axes except
- A.
Bar
- B.
Line
- C.
Plot
- 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
- 15.A chart that occupies its own worksheet.
- A.
Embedded chart
- B.
Chart sheet
- C.
Stand alone chart
- 16.A key that identifies each of the data series in a chart.
- A.
Key
- B.
Map
- 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
- 18.Name two of the several ways to enhance a Chart Background.
- 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
- 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
- 21.To display a comment in a worksheet
- A.
Roll mouse over red triangle
- B.
Open comment cell
- C.
Must highlight cell
- 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
Questions: 14 | Attempts: 10205 | Last updated: Mar 22, 2022
-
Sample Question_______, ________ and _______are what you see when you open Excel
Questions: 20 | Attempts: 3027 | Last updated: Mar 20, 2022
-
Sample QuestionA fast way to add up this column of numbers is to click in the cell below the numbers and then:
Questions: 40 | Attempts: 1022 | Last updated: Mar 22, 2022
-
Sample QuestionWhat is the keyboard shortcut command to move the mouse pointer to cell A1?
Back to top