Success Academy Microsoft Excel Quiz
The following is a short Quiz over Excel
- 1.The advantage of using a spreadsheet is
- A.
Calculations can be done automatically
- B.
Changing data automatically updates calculations (as long as Excel is not set to calculate manually)
- C.
More flexibility than word tables
- D.
All of the above
- 2.The intersection of a row and a column is called
- A.
Data
- B.
A field
- C.
A cell
- D.
An equation
- 3.When you are typing an equation into a cell the first thing that must be entered is
- A.
The first cell referenced
- B.
Parenthesis
- C.
Quotation marks
- D.
An equal sign
- 4.Labels are used in a spreadsheet to
- A.
Tell the computer what we are doing
- B.
Help us identify the information
- C.
Do the calculations
- D.
Set up the equations
- 5.The cell labeled F5 refers to
- A.
Row F column 5
- B.
Functions available in cells
- C.
Column F row 5
- D.
Function key F4
- 6.There are three types of data found in a spreadsheet
- A.
Data, words, numbers
- B.
Equations, data, numbers
- C.
Numbers, formulas, labels
- D.
Words, numbers, labels
- 7.
- A.
C2+C3
- B.
D3+C4
- C.
D3+C3
- D.
None of the above
- 8.
- A.
=$c$3*e3
- B.
=c3*e3
- C.
=$c$3*d3
- D.
24
- 9.A constant is another name for this type of data
- A.
Number
- B.
Equation
- C.
Formula
- D.
Description
- 10.What are columns in Excel ordinarily labeled with?
- A.
Numbers
- B.
Functions
- C.
Formulas
- D.
Alphabet letters
- 11.What are rows in Excel ordinarily labeled with?
- A.
Letters of the Alphabet
- B.
Numbers
- C.
Functions
- D.
Formulas
- 12.Which keyboard shortcut will always take you immediately to the top left corner of your worksheet, no matter where your cell pointer happens to be located?
- A.
Alt + Page Up
- B.
Ctrl + HOME
- C.
HOME
- D.
Shift + Tab
Related Topics
Recent Quizzes
Back to top