CADS 5850 Lab 1 Quiz Created By Siyuan

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Hsy_kenny

Hsy_kenny

Community Contributor

Quizzes Created: 1 | Total Attempts: 318

Questions: 10 | Attempts: 318 | Updated: Feb 20, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Cads 5850 Lab 1 Quiz Created By Siyuan - Quiz

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
Correct Answer
A. True

Explanation
Excel is like an electronic version of a paper ledger because it allows users to organize and manipulate data in rows and columns, similar to how a paper ledger is organized. The cells in Excel represent the intersection of rows and columns, just like the spaces in a table. Therefore, the statement is true.

Rate this question:
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
Correct Answer(s)
A. Label
B. Mathematical equations
C. Text sentence
D. Numerical number
E. Formula

Explanation
The types of data that may occur in an Excel cell include labels (text that is used to identify or describe data), mathematical equations (formulas that perform calculations), text sentences (complete sentences or phrases), numerical numbers (numeric values), and formulas (expressions that perform calculations using cell references and mathematical operators).

Rate this question:
3.

Formulas or functions must begin with ____________.
- A.
  
  $
- B.
  
  *
- C.
  
  =
- D.
  
  @
- E.
  
  !
- F.
  
  #
Correct Answer
C. =

Explanation
Formulas or functions in most programming languages, including Excel, must begin with the "=" sign. This is because the "=" sign is used to indicate that the following text is a formula or function that needs to be evaluated. Without the "=" sign, the text would be treated as a regular string or value, rather than a formula or function. Therefore, in order to properly use formulas or functions, it is necessary to begin them with the "=" sign.

Rate this question:
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
Correct Answer
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.

Correct Answer
8
eight

Explanation
The formula "=SUM (A1:A3) +$B$3" is asking for the sum of the values in cells A1, A2, and A3, and then adding the value in cell B3 to it. Since the values in cells A1, A2, and A3 are 2, 3, and 2 respectively, the sum of these values is 7. Therefore, the value of B5 should be 7 + the value in B3. The answer choices given are 8 and eight, either of which could be the value in B3.

Rate this question:

4
6.

__________allows text to span across multiple columns.
- A.
  
  Merge & Center
- B.
  
  Currency
- C.
  
  Wrap Text
- D.
  
  Bold
- E.
  
  Orientation
Correct Answer
A. Merge & Center

Explanation
Merge & Center allows text to span across multiple columns. This feature combines the selected cells into one cell and centers the text within it. This is commonly used when creating tables or organizing data in a spreadsheet, as it helps to visually group or highlight certain information. By merging cells and centering the text, the data becomes easier to read and understand.

Rate this question:
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
Correct Answer
B. SUM

Explanation
The SUM formula can add all the numeric values in a range of cells and place the result in a different cell. It ignores any non-numeric values in the range.

Rate this question:
8.

What type of cell reference is this:$A$1.
- A.
  
  Mixed
- B.
  
  Relative
- C.
  
  Absolute
Correct Answer
C. Absolute

Explanation
The cell reference $A$1 is an absolute cell reference. In Excel, an absolute cell reference is denoted by using the dollar sign ($) before the column letter and row number. This means that when the formula or reference is copied to other cells, the reference to $A$1 will always remain the same. It will not change based on the relative position of the formula or reference.

Rate this question:
9.

What are used to designate each ROW'S location ? (please input one word)

Correct Answer
Numbers
number

Explanation
The answer is "Numbers" and "number" because they are used to designate each row's location.

Rate this question:

4
10.

A B 1 3 5 2 4 6 If A5 = (A2*B1)/2, then A5= _______? (please input the number)

Correct Answer
10
ten

Explanation
The equation A5 = (A2*B1)/2 means that A5 is equal to the product of A2 and B1, divided by 2. Since the values given for A2 and B1 are not provided, we cannot determine the exact value of A5. Therefore, the answer could be any number or even a non-numeric value like "ten".

Rate this question:

4

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Feb 20, 2023

Quiz Edited by
ProProfs Editorial Team
Jan 10, 2014

Quiz Created by
Hsy_kenny

Cads 5850 Lab 1 Quiz Created By Siyuan

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”.

Please check the types of data may occur in excel "cell" (check all possible answers)

Formulas or functions must begin with ____________.

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 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.

__________allows text to span across multiple columns.

Which formula can add the all the numeric values in a range of cells, ignoring thos​e which are not numeric, and place the result in a different cell?

What type of cell reference is this:$A$1.

What are used to designate each ROW'S location ? (please input one word)

A B 1 3 5 2 4 6 If A5 = (A2*B1)/2, then A5= _______? (please input the number)

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?