Cads 5850 Lab 1 Quiz Created By Siyuan
10 Questions
| Total Attempts: 129
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)
This is a test on drafting techniques and the Solidworks Program.
Questions: 34 | Attempts: 4966 | Last updated: Dec 31, 2012
-
Sample QuestionTo begin drawing a new object in Solidworks you must go through the following sequence.
Below is a CAD Functions Trivia Quiz. This tool is used by designers to make quality designs and document a database for manufacturing the designs. Do you know how to use this tool effectively, or do you need a refresher? Take up...
Questions: 15 | Attempts: 3392 | Last updated: Oct 3, 2019
-
Sample QuestionWHAT DOES THIS TOOL ALLOW YOU TO DO ?
Have you ever heard of computer-aided design? The computer-aided design uses computers to assist in creating, altering, examinations, or optimizing design. CAD software is used to elevate the designer's productivity,...
Questions: 8 | Attempts: 3356 | Last updated: Mar 17, 2021
-
Sample QuestionCAD stands for?
Back to top