WorksheetsICT08-Q1 General Quiz
Total questions: 151
Worksheet time: 1hrs 22mins
An Excel file format extension is
doc
xls
txt
mp3
The letters in Excel represent the...
Rows
Columns
Cells
Data
What is the name of this cell?
B5
B4
B6
B10
How are cells named?
By row (number) and column (letter)
By column (letter) and row (number)
By the contents of the cell
Names are randomly assigned
This is a tab on the Ribbon which opens the Backstage view, which contains a menu of basic commands such as New, Open, Save, Save As, and Print.
TITLE BAR
FILE TAB
GROUP
FORMULA BAR
Name the part of Microsoft Excel
formula bar
column
quick access toolbar
Name the part of Microsoft Excel
tab
ribbon
zoom
Name the part of Microsoft Excel
row
column
name box
Name the part of Microsoft Excel
zoom control
ruler
scroll bar
Identify this Person
Monkey D. Pluffy
Monkey F. Luffy
Monkey D. Puppy
Monkey D. Luffy
In SpongeBob SquarePants Show.
"My leg" who said this word?
Fred the Clown
Fred the Tuna
Fred the fish
Fred the leg
Bonus Question:
Identify the name of this ship
going merry
mary grace
monkey
Monkey D. Luffy
** WRITE THE LETTER OF THE CORRECT ANSWER**
What does PEMDAS stand for in mathematics?
a) People's Equation for Mathematical Definitions and Solutions
b) Parenthesis, Exponent, Multiplication, Division, Addition, Subtraction
c) Prime Exponents Make Division Awesome, Seriously
d) Parenthetical Expressions for Mathematical Descriptions
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
In Excel, which symbol is used to represent multiplication?
a) X
b) ^
c) *
d) /
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
When multiplication and division are combined in Excel, how is the formula evaluated?
a) Right to left
b) Left to right
c) Randomly
d) Top to bottom
(a)
** WRITE THE WORD OF THE CORRECT ANSWER**
4. Which of the following is not a step in the PEMDAS sequence for evaluating equations?
a) Parenthesis
b) Exponent
c) Subtraction
d) Addition
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
In Excel, what symbol is used for subtraction?
a) +
b) /
c) -
d) %
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
Which of the following is the correct sequence for evaluating equations in Excel?
a) Exponent, Parenthesis, Addition, Multiplication, Subtraction, Division
b) Parenthesis, Exponent, Multiplication, Division, Addition, Subtraction
c) Subtraction, Addition, Division, Multiplication, Parenthesis, Exponent
d) Multiplication, Addition, Parenthesis, Subtraction, Division, Exponent
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
What is the first step when working with equations in Excel?
a) Write the equation in plain text
b) Start with the equal sign (=)
c) Identify the highest exponent
d) Multiply all values together
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
In Excel, which symbol represents division?
a) -
b) /
c) +
d) *
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
When addition and subtraction are combined in Excel, how is the formula evaluated?
a) Right to left
b) Left to right
c) Bottom to top
d) Top to bottom
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
What is the Excel symbol for exponent?
a) ^
b) **
c) %
d) &
(a)
** WRITE THE WORD OF THE CORRECT ANSWER**
Which part of PEMDAS is evaluated first in Excel?
a) Addition
b) Exponentiation
c) Multiplication
d) Parentheses
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
In Excel, what is used to represent a group of values that need to be evaluated together?
a) Brackets [ ]
b) Curly braces { }
c) Parentheses ( )
d) Quotation marks " "
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
Which symbol in Excel represents addition?
a) *
b) -
c) +
d) /
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
When working with equations in Excel, what should the formula always start with?
a) A letter
b) A number
c) A percentage sign (%)
d) An equal sign (=)
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
In Excel, what symbol is used for multiplication?
a) /
b) -
c) *
d) +
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
How does Excel evaluate formulas involving multiplication and division?
a) Right to left
b) Left to right
c) Bottom to top
d) Top to bottom
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
What is the order of evaluation in the PEMDAS sequence for Excel equations?
a) Parenthesis, Exponent, Division, Multiplication, Addition, Subtraction
b) Parenthesis, Exponent, Multiplication, Division, Addition, Subtraction
c) Subtraction, Addition, Division, Multiplication, Parenthesis, Exponent
d) Multiplication, Addition, Parenthesis, Subtraction, Division, Exponent
(a)
** WRITE THE SYMBOL OF THE CORRECT ANSWER**
In Excel, what is the symbol for subtraction?
a) +
b) /
c) -
d) %
(a)
** WRITE THE WORD OF THE CORRECT ANSWER**
Which step of the PEMDAS sequence is performed last in Excel equations?
a) Parenthesis
b) Exponent
c) Subtraction
d) Multiplication
(a)
** WRITE THE LETTER OF THE CORRECT ANSWER**
What is the first step when evaluating equations in Excel, according to the provided content?
a) Identify the highest exponent
b) Write the equation in plain text
c) Start with the equal sign (=)
d) Multiply all values together
(a)
Identify this Character
Identify this Show
Jimmy Newtron
Captain Adventure
Adventure Time
Flapjack
An Excel file format extension is
doc
xls
txt
mp3
The letters in Excel represent the...
Rows
Columns
Cells
Data
What is the name of this cell?
B5
B4
B6
B10
How are cells named?
By row (number) and column (letter)
By column (letter) and row (number)
By the contents of the cell
Names are randomly assigned
This is a tab on the Ribbon which opens the Backstage view, which contains a menu of basic commands such as New, Open, Save, Save As, and Print.
TITLE BAR
FILE TAB
GROUP
FORMULA BAR
Name the part of Microsoft Excel
formula bar
column
quick access toolbar
Name the part of Microsoft Excel
tab
ribbon
zoom
Name the part of Microsoft Excel
row
column
name box
Name the part of Microsoft Excel
zoom control
ruler
scroll bar
Identify this show
Johnny Bravo
Flapjack
Jimmy Neutron
Fairly OddParents
Identify this Character
Howard Wolowitz
Sheldon Cooper
Leonard Hofstadter
George Cooper Jr.
An Excel file format extension is
doc
xls
txt
mp3
The letters in Excel represent the...
Rows
Columns
Cells
Data
What is the name of this cell?
B5
B4
B6
B10
How are cells named?
By row (number) and column (letter)
By column (letter) and row (number)
By the contents of the cell
Names are randomly assigned
This is a tab on the Ribbon which opens the Backstage view, which contains a menu of basic commands such as New, Open, Save, Save As, and Print.
TITLE BAR
FILE TAB
GROUP
FORMULA BAR
Name the part of Microsoft Excel
formula bar
column
quick access toolbar
Name the part of Microsoft Excel
tab
ribbon
zoom
Name the part of Microsoft Excel
row
column
name box
Name the part of Microsoft Excel
zoom control
ruler
scroll bar
Identify this Person
Monkey D. Pluffy
Monkey F. Luffy
Monkey D. Puppy
Monkey D. Luffy
In SpongeBob SquarePants Show.
"My leg" who said this word?
Fred the Clown
Fred the Tuna
Fred the fish
Fred the leg
Bonus Question:
Identify the name of this ship
going merry
mary grace
monkey
Monkey D. Luffy
*Type the word of the correct answer*
What Excel function calculates the sum of a range of numbers?
A) AVERAGE
B) MAX
C) SUM
D) MIN
(a)
*Type the word of the correct answer*
Which Excel function finds the largest value in a given range of numbers?
A) MIN
B) PRODUCT
C) SUM
D) MAX
(a)
*Type the word of the correct answer*
Which function counts the number of cells with numerical values in a range?
A) PRODUCT
B) COUNT
C) AVERAGE
D) ROUND
(a)
*Type the word of the correct answer*
Which Excel function computes the average of a range of numbers?
A) ROUND
B) MAX
C) COUNT
D) AVERAGE
(a)
*Type the letter of the correct answer*
What is the purpose of the ROUND function in Excel?
A) To find the maximum value in a range
B) To count the number of cells in a range
C) To calculate the product of numbers in a range
D) To round a number to a specified number of decimal places
(a)
*Type the word of the correct answer*
Which Excel function calculates the product of a range of numbers?
A) AVERAGE
B) MAX
C) SUM
D) PRODUCT'
(a)
*Type the word of the correct answer*
Which function in Excel gives you the smallest value in a range of numbers?
A) PRODUCT
B) ROUND
C) MIN
D) COUNT
(a)
*Type the word of the correct answer*
What is the result of the formula: =ROUND(3.14159, 2)?
A) 3.1
B) 3.15
C) 3.14
D) 3.2
(a)
*Type the letter of the correct answer*
How do you calculate the average of the numbers in cells A1 to A5 in Excel?
A) =AVERAGE(A1, A5)
B) =AVERAGE(A1:A5)
C) =SUM(A1:A5)
D) =MAX(A1:A5)
(a)
*Type the letter of the correct answer*
What is the correct way to find the sum of numbers in cells B1 to B10 in Excel?
A) =AVERAGE(B1:B10)
B) =PRODUCT(B1:B10)
C) =SUM(B1:B10)
D) =MAX(B1:B10)
(a)
*Type the word of the correct answer*
Which of the following Excel functions is used to round a number up to the nearest integer?
A) ROUNDUP
B) ROUNDDOWN
C) ROUND
D) CEILING
(a)
*Type the word of the correct answer*
What is the result of the formula: =PRODUCT(2, 3, 4, 5)?
A) 12
B) 120
C) 15
D) 2.34
(a)
*Type the letter of the correct answer*
What function in Excel counts the number of cells that contain values in a range?
A) AVERAGE
B) SUM
C) COUNTA
D) COUNT
(a)
*Type the letter of the correct answer*
In Excel, what is the purpose of the MAX function?
A) To find the maximum value in a range
B) To count the number of cells in a range
C) To calculate the product of numbers in a range
D) To round a number to a specified number of decimal places
(a)
*Type the word of the correct answer*
Which function should you use to find the minimum value in a range of cells in Excel?
A) MIN
B) AVERAGE
C) MAX
D) COUNT
(a)
*Type the letter of the correct answer*
In Excel, what does the acronym PEMDAS stand for?
A) Plain English Mathematical Description and Syntax
B) Parentheses, Exponents, Multiplication, Division, Addition, Subtraction
C) Powerful Excel Math and Data Analysis Software
D) Personalized Excel Method for Data Accumulation and Summation
(a)
*Type the word of the correct answer*
According to the order of operations (PEMDAS), which operation should be performed first?
A) Subtraction
B) Division
C) Multiplication
D) Addition
(a)
*Type the word of the correct answer*
In the formula "=5 + 3 * 2", what is the result according to the PEMDAS order of operations?
A) 16
B) 11
C) 13
D) 10
(a)
*Type the word of the correct answer*
According to PEMDAS, which operation should be performed last in the expression "4 + 2 × (5 - 1) ÷ 2"?
A) Multiplication
B) Subtraction
C) Division
D) Addition
(a)
Which cartoon is this?
Adventure time
Sanjay and craig
Sponge bob square pants
Miraculous ladybug
*Type the word of the correct answer*
What is the value of the expression "3 + 4 × 2 ÷ (1 - 5)" when evaluated using PEMDAS?
A) 6
B) -5
C) 8
D) 2
(a)
Who is this?
Adrien
Peppa
Marinette
Mr.Bean
This house belongs to whom?
Sponge bob Square pants
Squidward Tentacles
Patrick Star
Mr.Krabs
Identify the area within the box.
(a)
Name the part of Microsoft Excel
zoom control
ruler
scroll bar
Name the part of Microsoft Excel
ribbon
save
page view
Name the part of Microsoft Excel
row
column
name box
Name the part of Microsoft Excel
formula bar
scroll bar
worksheet
Name the part of Microsoft Excel
tab
ribbon
zoom
Name the part of Microsoft Excel
scroll bar
column
quick access toolbar
Name the part of Microsoft Excel
formula bar
column
quick access toolbar
Name the part of Microsoft Excel
FORMULA BAR
TAB
ROW
This is a vertical group of cells identified by letters.
CELL
ROW
COLUMN
STATUS BAR
This is a horizontal group of cells identified by numbers.
CELL
ROW
COLUMN
STATUS BAR
This is the intersection of a row and a column.
CELL
ZOOM SLIDER
QUICK ACCESS TOOLBAR
STATUS BAR
This is a tab at the bottom corner of the window which allows you to switch between worksheets. Sheet1 is the default name of the sheet tab and will continue with 2, 3, and above as you add more sheets.
CELL
ZOOM SLIDER
QUICK ACCESS TOOLBAR
SHEET TAB
This displays the commonly used commands and tools for easy access.
SCROLL BAR
ZOOM SLIDER
QUICK ACCESS TOOLBAR
SHEET TAB
This is a button, box, or menu that, when clicked, tells or action. the program to do a task.
SCROLL BAR
ZOOM SLIDER
FORMULA BAR
COMMAND
In Excel, a row is denoted by ________
Symbols
Letters
Numbers
Colors
This part consists of a set of tabs with commands that are used to perform tasks in Excel.
RIBBON
FILE TAB
SCROLL BAR
FORMULA BAR
This is a tab on the Ribbon which opens the Backstage view, which contains a menu of basic commands such as New, Open, Save, Save As, and Print.
TITLE BAR
FILE TAB
GROUP
FORMULA BAR
This is the bar at the top of the window that shows the name of the workbook and the program.
GROUP
TITLE BAR
CONTROL BUTTONS
NAME BOX
This is a collection of commands on a tab that perform similar actions.
TITLE BAR
SHEET TAB
GROUP
FORMULA BAR
What symbol comes first when using a function?
:
*
(
=
How are cells named?
By row (number) and column (letter)
By column (letter) and row (number)
By the contents of the cell
Names are randomly assigned
To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?
=SUM(C1-C5)
=SUM(C1,C5)
=SUM(C1:C5)
=SUM(C1*C5)
What is the name of this cell?
B5
B4
B6
B10
What would be a correct formula for Subtraction in excel?
B3*B4
B3+B4
=B3-B4
B3-B4
What is the cell in the worksheet in which you can type data?
Main cell
Open cell
Active cell
Absolute cell
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
An Excel file format extension is
doc
xls
txt
mp3
Identify the person in the image
Sundar Pichai
Elon Musk
Jeff Bezos
Mark Zuckerberg
