# End Of Term Assessment

23 Questions | Total Attempts: 76  Settings Create your own Quiz • 1.
How does an Excel spreadsheet know that =10/12 is a formula and not the date October 12?
• A.

The equal sign (=) signals it.

• B.

The division (/) sign signals it.

• C.

Dates cannot be shown that way.

• D.

It would not know.

• 2.
It is best to write formulas using cell references so that a spreadsheet
• A.

Has no hidden information.

• B.

Has all correct values.

• C.

Can be updated easily.

• D.

Can be more easily graphed.

• 3.
When working with statistics, a spreadsheet application is often preferred to electronic calculators because
• A.

It allows the user to create graphs to represent data

• B.

Formulas used in a spreadsheet are re-usable which makes spreadshets very efficient

• C.

One's work can be saved for future use and even future editing

• D.

All of the above are true

• 4.
What would B5 represent?
• A.

Active Cell

• B.

Cell Reference

• C.

Formula

• 5.
Which symbol does every formula start with?
• A.

+

• B.

/

• C.

=

• 6.
Which symbol is used to divide to values?
• A.

-

• B.

/

• C.

=

• 7.
What formula would you use to add A1 and A2 together?
• 8.
What would a formula look like?
• A.

2.38+3.588.25

• B.

(C12:B12)

• C.

=3.65+ (3.65*0.03)

• D.

*A9+B9+C9=

• 9.
What icon appears when you are about to Auto Fill
• A.

Black plus sign

• B.

White plus sign

• C.

Question mark

• D.

Hand

• 10.
What is the main function of any variable ?
• A.

To add numbers together

• B.

To keep track of data in the memory of the computer

• 11.
Booleans are _______.
• A.

True or False

• B.

Single characters

• 12.
It is the process of removing errors found in the program.
• A.

Editing

• B.

Compiling

• C.

Debugging

• D.

Running

• 13.
Which of the following is the data type used for a single character?
• A.

Byte

• B.

Char

• C.

Long

• D.

Short

• 14.
What is an algorithm?
• A.

A set of steps in order approach to solve a problem

• B.

Written in english or code

• C.

Rules of the language

• 15.
It is the rules of a programming language.
• A.

Format

• B.

Logic

• C.

Object

• D.

Syntax

• 16.
Which of the following is an invalid variable declaration in Java?
• A.

Int NumberOfStudents = 250;

• B.

Double Salary =0.0;

• C.

String NAME =

• D.

Char CivilStatus =

• 17.
Which is an example of an appropriate field name?
• A.

Patent's fist name and bithdate

• B.

Name/Last

• C.

Patient's fist name and ID

• D.

First name

• 18.
In Computer Science, what is Java?
• A.

A type of coffee

• B.

A type of programming language

• C.

An island

• 19.
Which of the following are examples of data types?
• A.

Byte

• B.

Boolean

• C.

Parse

• D.

Int

• 20.
A comment in programming is when you document your code explaining what is happening in each line of code.
• A.

True

• B.

False

• 21.
What is the purpose of the COUNTIF function?
• A.

It counts the numbers entered in a cell

• B.

It counts if a cell has been selected

• C.

It counts how many times a declared value is true

• 22.
The purpose of the use of buttons on a homepage is to
• 23.
What is the name of the formatting used in cells that informs you of the answer being right and wrong in this worksheet?
• A.

Formatting

• B.

Colour Format

• C.

Conditions

• D.

Conditional Formatting

Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.