22 Questions | Total Attempts: 82

Settings

Welcome to your first Online Test, Grade 10A!The questions are multiple choice and short answer, but you will not be allowed to go to previous answers once you click submit. Please, type your answers in all caps, unless otherwise specified. Login below with your first initial and last name (e. G. ACarr)

Related Topics
• 1.
In a formula, G11 is –
• A.

A cell pointer

• B.

A condition

• C.

An absolute cell reference

• D.

A relative cell reference

• 2.
You are asked to sort the spreadsheet below from Z- A. After selecting the data, which steps would you choose to do this task? NAME DEPARTMENT POSITION James Taylor Accounting Clerk Kiki Paloris Public Relations Manager Thom Arnold Accounting Manager Rose Edith-Hall Canteen Manager Fred Winston Engineering Engineer Georgina Wilbur Engineering Apprentice
• A.

Click on Data, Sort, header row, column B, ascending, OK

• B.

Click on Sort, no header row, Department, descending, OK

• C.

Click on Data, Sort, header row, Department, descending, OK

• D.

Click on Sort, header row, column B, ascending, OK

• 3.
In the selection formula =IF(B4>C5, ‘C5 is smaller’, ‘B4 is smaller’) –
• A.

‘B4 is smaller’ is the action taken when the condition is false

• B.

‘B4>C5’ is the action taken when the condition is false

• C.

‘>C5’ is the condition

• D.

‘C5 is smaller’ is the action taken when the condition is false

• 4.
To extract the records of Managers from the table below, what two things, exactly,  would you type? NAME DEPARTMENT POSITION James Taylor Accounting Clerk Kiki Paloris Public Relations Manager Thom Arnold Accounting Manager Rose Edith-Hall Canteen Manager Fred Winston Engineering Engineer Georgina Wilbur Engineering Apprentice(separate your answers by comma and space e.g. milk, eggs
• 5.
Which describes absolute cell referencing?
• A.

Always reference the cell to the left of the active cell

• B.

Always references the cell to the right of the active cell

• C.

Never references the same cell

• D.

Always reference the same cell

• 6.
Which of the following is an improper sum function?
• A.

=sum(a5:d5, g5)

• B.

=sum(b3+b9)

• C.

=sum(g5,g6,g7,g8)

• D.

=sum(a12, a20:b20, b25)

• 7.
Dawn-Ann wants to use the freeze panes feature of MS Excel to help with an especially big spreadsheet file. To freeze panes means to keep all cells _____ and to the ______of the active cell while scrolling.(separate your answers by comma and space e.g. milk, eggs)
• 8.
Which function enters the date taken from the system clock/ the computer?
• A.

=NOW( )

• B.

=DATE( )

• C.

=TODAY( )

• D.

Any of the above

• 9.
Given this spreadsheet above of basketball players, what formula/ function would display the name of the tallest player in column C?
• 10.
What is a footnote?
• 11.
In this except from a word document, what has been done to the text?
• A.

The text has been split into equal width columns

• B.

A section of the text has been separated by font size

• C.

A section of the text has been split into unequal columns

• D.

The text has be separated by font size

• 12.
Column A contain prices of goods at KerrShan Pharmacy (such as 55.95, 170.95). A special cell, cell G1 has the current tax rate of 10%, but the word on the street is that it may change. What must be added to the formula that calculates the tax to ensure that it can be copied to other cells?
• A.

The average function

• B.

Absolute cell reference

• C.

The autofill symbol

• D.

Nothing at all

• 13.
I have used advanced filtering to look at values from this table related to friends who love purple or who are older than 13 years. FRIENDS FAVOURITE COLOUR AGE Renae D. Purple 13 Amelia A. Orange 17 Donnalee M. Purple 15 Shawntol C. Pink 12 Brianna R. Pink 14The answers I am getting are incorrect. What are the possible reasons for this?(i) the age equation reads "greater than 13"(ii) the criteria is in different rows(iii) I typed the criterion heading as "colour"(iv) the criteria headings are in bold
• A.

Ii and iii

• B.

I and ii

• C.

Iii and iv

• D.

I and iii

• 14.
In a spreadsheet, the function below is placed in a cell to check on the content of E6:=IF((E6/2)>2,1,0)What is printed when the value 5 is placed in E6?
• 15.
A program is a set of _________ used to tell the computer/ processor what to do.
• 16.
Given this list of programming languages, put it in order, from earliest to most recent generation: C++COBOLASSEMBLYJAVA
• A.

JAVA, ASSEMBLY, C++, COBOL

• B.

ASSEMBLY, COBOL, C++, JAVA

• C.

COBOL, ASSEMBLY, JAVA, C++

• D.

ASSEMBLY, COBOL, JAVA, C++

• 17.
Define the following:                   A) mnemonics                   B) source code
• 18.
Name one translation program.
• 19.
Give one advantage and 2 disadvantages of using a first generation programming language.
• 20.
The _________ code is the result of a translation process performed on the program written in a high-level programming language.
• 21.
What levels of programming languages are represented by L1, L2 and L3 below:a) L1: 10110  101100b) L2: Accept Num1c) L3: DIV 3,1
• 22.
Which are true of 4GLs (fourth generation programmng languages)?(i)   They run on many different platforms/ systems (machine independent)(ii)  They are the closest to natural language(iii) They are completely general purpose and could be used by novice and       professional programmers alike(iv) Take longer to execute than an assembly language program
• A.

Ii and iv

• B.

I and iii

• C.

I and iv

• D.

Ii and iii