- Information
- AI Chat
CS112 Test 3 - 2022 - GREAT PRACTISE
GREAT PRACTISE
Course
Computer Science (ComSci1)
76 Documents
Students shared 76 documents in this course
University
Rhodes University
Academic year: 2024/2025
Uploaded by:
0followers
3Uploads
0upvotes
Recommended for you
Preview text
DEPARTMENT OF COMPUTER SCIENCE
TEST 3 – 1 SEPTEMBER 2022
COMPUTER SCIENCE CS
INTERNAL EXAMINER: Dr Zelalem Shibeshi
MARKS: 20
DURATION: 45 minutes
STUDENT NUMBER: _____________________________
_____________________________________________________________________
GENERAL INSTRUCTIONS TO CANDIDATES
1. This paper consists of 9 pages
2. Please ensure that you have a complete paper.
3. Please complete your student number and fill in the bubbles for your student number
on the MCQ sheet at the back of the paper.
4. You may tear the MCQ sheet off.
_____________________________________________________________________
MULTIPLE CHOICE ASSESSMENT [20 Marks]
1. Which of the following operator is used as an exponent operator in Excel?
a) exp
b) **
c) ^
d) /
2. What will be the result of the formula =6+3*5-5?
a) 40
b) 16
c) 6
d) 45
e) an error
3. We have seen that we can control how numbers are displayed, which means what is displayed
may not be what actually is stored in Excel. In the following diagram, what is actually stored in
cell A1?
a) 12001
b) 12000.
c) 12000.
d) None of the options are true
9. Assume 100000 and 120000 are stored in cells A10 and B10 respectively. What will happen if we
enter the following formula in cell C11?
=IF(A10>B10;”Branch 1;,”Branch 2”)
a) #ERROR will be displayed in C
b) The word “Branch 1” will be displayed in C
c) The word “Branch 2” will be displayed in C
d) The formula itself will be displayed in C
e) None of the above is true
10. Assume the cell E4 contains the formula: =D1+D2. What will the formula look like if it is copied
and pasted into cell F5?
a) =D2+D
b) =$D1+$D
c) =E2+E
d) =E6+E
e) #REF
11. "VIP" is an example of a ____ in Excel.
a) cell reference
b) column heading
c) file owner
d) row heading
12. In the following table, Sales Tax for each item (in column D) is calculated by multiplying quantity
sold, price and sales tax rate (which is given in B7). What formula should be entered in D2 that
can later be copied to the below cells (D3 and D4).
a) =(B3C3)$B$
b) =(B3*C3)*B$
c) =(B3C3)$B
d) A and B are correct
e) A and C are correct
13. Which of the following is an absolute cell reference?
a) BC
b) #BC
c) B$C
d) $BC$
14. Which of the formulas below are valid?
a) =2A+6B
b) =F1+F2+F3/
c) =X2**2Z
d) H4-
15. What feature of Excel can we use to quickly apply the formatting shown in this image below?
a) Data scenario formatting
b) PivotTables
c) What-if analysis
d) Conditional formatting
19. The words "Bears", “Dolphins ”and “Whales” in the image below are called the chart’s ______:
a) Title
b) key
c) labels
d) legend
20. Why do we use plots like the following? Choose the most appropriate answer.
a) To see the maximum value of a variable
b) To see the minimum value of a variable
c) To see how two variables relate to each other
d) To see the percentage of growth of a variable
This page intentionally left blank
Was this document helpful?
CS112 Test 3 - 2022 - GREAT PRACTISE
Course: Computer Science (ComSci1)
76 Documents
Students shared 76 documents in this course
University: Rhodes University
Was this document helpful?
DEPARTMENT OF COMPUTER SCIENCE
TEST 3 – 1 SEPTEMBER 2022
COMPUTER SCIENCE CS112
INTERNAL EXAMINER: Dr Zelalem Shibeshi
MARKS: 20
DURATION: 45 minutes
STUDENT NUMBER: _____________________________
_____________________________________________________________________
GENERAL INSTRUCTIONS TO CANDIDATES
1. This paper consists of 9 pages
2. Please ensure that you have a complete paper.
3. Please complete your student number and fill in the bubbles for your student number
on the MCQ sheet at the back of the paper.
4. You may tear the MCQ sheet off.
_____________________________________________________________________
Discover more from:
- Discover more from:
More from:samkelisiwe ngubane
