Cads 5850 Lab 1 Quiz Created By Siyuan
10 Questions
| Total Attempts: 122
Please take the quiz after you study the excel tutorial sheet.
Questions and Answers
- 1.True or false: Excel is like an electronic version of a paper ledger. If you are familiar with Word, a spreadsheet is similar to working with tables—it has rows and columns, and the space where these two intersect are called “cells”.
- A.
True
- B.
False
- 2.Please check the types of data may occur in excel "cell" (check all possible answers)
- A.
Label
- B.
Mathematical equations
- C.
Text sentence
- D.
Numerical number
- E.
Formula
- F.
None of above
- 3.Formulas or functions must begin with ____________.
- A.
$
- B.
*
- C.
=
- D.
@
- E.
!
- F.
#
- 4.A B C 1 2 2 2 = SUM (A2:A4, A6) 3 3 4 5 5 1 6 3 What is the value of B2?
- A.
9
- B.
10
- C.
12
- D.
15
- E.
13
- 5.A B 1 2 3 2 3 2 3 1 2 4 2 2 5 1 =SUM (A1:A3) +$B$3 Please type in the value of B5 according to the given formula.
- 6.__________allows text to span across multiple columns.
- A.
Merge & Center
- B.
Currency
- C.
Wrap Text
- D.
Bold
- E.
Orientation
- 7.Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- A.
Average
- B.
SUM
- C.
MEAN
- D.
COS
- E.
MAX
- 8.What type of cell reference is this:$A$1.
- A.
Mixed
- B.
Relative
- C.
Absolute
- 9.What are used to designate each ROW'S location ? (please input one word)
- 10.A B 1 3 5 2 4 6 If A5 = (A2*B1)/2, then A5= _______? (please input the number)
Back to top