NEW
Font size
WorksheetsTech lLife Quiz
Total questions: 80
Worksheet time: 53mins
It is known as the spreadsheet application.
MS Word
MS Excel
MS PowerPoint
MS Publisher
It is on-screen spreadsheet that contains various cell in columns and rows.
MS Excel
MS Word
Worksheet
Workbook
It contain one or more worksheet which are automatically named in the sheet tabs as sheet 1, sheet 2, and so on.
cell
workbook
worksheet
Excel
MS Excel is widely used for ______, financial application, statistics and engineering calculations.
accounting
word processing
photo editing
video editing
_______ is a rectangular area where a column and row intersect.
cell
column
row
sheet tab
It shows the reference of the active cell.
cell
rows
name box
formula bar
It select the content of the entire worksheet.
name box
formula bar
sheet tab
select all button
It refers to the colored row of letters which is used to identify each column.
select all button
name box
column header
row header
This refers to the column of numbers at the left side of the worksheet.
column header
row header
scroll bar
sheet tab
The process of keeping or storing a workbook into the computer.
encoding
saving
surfing
editing
9. Microsoft Excel is categorized as a ________________ software.
Database
Presentation
Spreadsheet
Word Processing
6. What does every formula in MS EXCEL start with?
+
=
-
*
Pada gambar tersebut, sel yang aktif berada pada kolom ?
9
D
D8
8
You can use the auto-sum key to subtract numbers.
True
False
Excel would be the ideal program to type a book report?
False
True
What MAX function do.?
It gives you the Maximum number of the selected range
It gives you the maximum number column name
It separates the maximum numbers from the selected range
It gives you the minimum value of the selected range
To calculate the percentage of the total marks obtained by Aarush, which formula should we apply?
Percentage
Average
Averagable
IF
To calculate the total marks obtained by Neha, Arjun, and Sanya in the selected range, which formula should we apply?
Total
Add the marks of each student one by one using +
Calculate the average
Sum
In a worksheet, the vertical spaces with the headings A, B, C and so on
Cell
Column
Row
Data
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
Column
Label
Row
Cell Address
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
In Excel, the name of the bar where information appears as you input data in called ?
File Bar
Help Bar
Formula Bar
Window Bar
Microsoft Excel is categorize as ?
Word Processing Software
Database Software
Spreadsheet Software
Presentation Software
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
John is working on a spreadsheet in Excel and he needs to find the smallest number in a range of cells. Which formula should he use?
Sum
Average
Min
Max
John is working on a financial report in Excel and needs to calculate the product of two numbers. How should he do this?
He should use the asterisk sign in the formula
He should use the plus sign in the formula
He should use the minus sign in the formula
He should use the division sign in the formula
John is trying to calculate the total sales of his store in Excel. What should he start with to do formulas in Excel?
Start with the equal sign
Start with the plus sign
Start with the minus sign
Start with the multiplication sign
The ______________ formula returns a mathematical mean of a given cell range.
AVERAGE
MEDIAN
SUM
MIN
What is used to indicate that each formula is used for a specific set of cells?
Worksheet Tab
Cell Range
Sum Formula
Active Tab
If MAX finds the largest number and MIN finds the smallest number, what does MEDIAN find?
Average of all the numbers in the range
Total Number of Cells
The number that falls in the middle
All the numbers added together
Finding and fixing problems in an algorithm or program.
sequencing
debugging
programing
overlaying
The position of an object on a grid is represented by __ and __ coordinates.
x and y
w and h
x and w
h and y
Part of a program that does not work correctly.
error
ellipse
bug
overlay
What is decomposition?
Simplifying a problem by ignoring details
Converting instructions into code
Breaking a problem into smaller parts
Turning household waste into compost
What word is used to refer to a labelled place in the computer's memory where data can be stored?
Variable
Value
Algorithm
RAM
What is iteration
Simplfying a problem
Turning instructions into code
Repeating some code
Storing data in memory
Primary instructions that tells the computer what action to perform (e.g. run, jump, walk)
Loop
Command
Sequence
Algorithm
Instead of traditional, text-based programming, this type of coding involves dragging "blocks" of instructions.
Algorithm
Computer Science
Command
Block Style Coding
The step-by-step order in which instructions should occur.
Loop
Sequence
Command
Parameter
how we can make the game work
Move forward
click RUN
I don't know
Nothing
how we can move one step forward
Debugging means Fix The Problem
True
False
Solve this puzzle
What is wrong with the code to get Scrat to the acorn?
The first "move forward" is not needed.
The first "turn right" should be a "turn left"
The second "move forward" is extra
The last "turn right" should be a "turn left"
The action of doing something over and over again.
Looping
Bugging
Programming
What does this code do?
Moves forward 1 time
Moves forward forever
Moves forward 5 times
Moves left
Which of the code below will complete this puzzle?
The language that programmers create and use to tell a computer what to do
Code
Command
Run Program
BINARY
Coding can be used to
Program robots
Create websites, games & apps
Tell computers what to do
All of the above
A block is
an instruction in a coding program that can be joined to other blocks to build code
visual elements on a screen that are not text, such as pictures, icons and symbols
something a computer program can react to, such as a key being pressed or mouse being clicked
place to store data that can change in a program
A traditional desktop computer's display (such as the one on your teacher's desk) can be an example of _______________.
an input
an output
either an input or an output
neither an input nor an output
The earliest computers were designed to ______________.
manipulate numbers
play games
process text
control robots
A computer's memory is used to _____________ information.
input
output
store
process
When information is manipulated or changed by the computer, it is being ______________.
input
output
processed
stored
a machine that can run a program, including computers, tablets, servers, routers, and smart sensors
Computing System
Computing Device
Computing Network
Router
Microsoft Word and Google Docs are examples of what?
Word Processors
Databases
Spreadsheets
Presentations
If you make a mistake, what do you do?
Restart writing the document
Delete everything
Undo
I don't know
A horizontal line that is placed beneath characters is called what?
Bold
Italics
Underline
Subscript
You cannot change the color of words in Microsoft word?
True
False
Probably
I don't know
A formatting option that makes selected words print darker than normal.
Italics
Bold
Underline
Subscript
Left, Center, Right,and Justify are options for which tool located on the toolbar or ribbon?
Zoom
Line Spacing
Text Alignment
Bulleted Lists
A template in a word processor provides access to:
The program coding used to operate your word processor.
A page design layout into which you can place your content.
A presentation of pre-defined slides.
The complete list of shortcuts used by your word processor.
Which tab in the Ribbon contains the options for formatting text, such as font size and color?
Home
Insert
Review
Layout
Hey there! Can you help me out with this fun question?
What does the 'Ctrl + P' keyboard shortcut do in Microsoft Word?
It pastes the copied text
It prints the document
It opens a new document
It saves the document
What is the function of this button?
Sort
Copy
Paste
Save
Shortcut key for 'Find and Replace'.
CTRL + F
CTRL + R
CTRL + H
CTRL + C
Space between the lines of the text -
Column spacing
Line spacing
Paragraph spacing
