Font size
WorksheetsExcel and Google Workspace Multiple Choice Questions
Total questions: 62
Worksheet time: 34mins
In Excel, which function is used to calculate the average of a range of cells?
SUM
MAX
MIN
AVERAGE
What does the formula "=COUNTIF(A1:A10,">50")" in Excel do?
Counts the number of cells in range A1:A10 that are greater than 50.
Calculates the sum of cells in range A1:A10 that are greater than 50.
Returns the average value of cells in range A1:A10 that are greater than 50.
Checks if all cells in range A1:A10 are greater than 50.
Which Excel feature is used to visually represent data using bars, columns, lines, or other graphical elements?
PivotTable
Filter
Chart
Formula
What does the function "=SUMIF(A1:A10, ">50")" do in Excel?
Sums the values in range A1:A10 that are greater than 50.
Calculates the average of cells in range A1:A10 that are greater than 50.
Checks if all cells in range A1:A10 are greater than 50.
Returns the maximum value in range A1:A10 that is greater than 50.
What does SaaS stand for in cloud computing?
Software as a Service
Storage as a Service
Security as a Service
Server as a Service
Which of the following is NOT a component of Google Workspace?
Gmail
Google Drive
Google Calendar
Google Photos
Which Google Workspace application is used for creating and editing documents?
Google Sheets
Google Slides
Google Docs
Google Forms
What is the cloud storage service provided by Google Workspace called?
Google Drive
Google Cloud Storage
Google Backup
Google Archive
Which Google Workspace application is used for managing and scheduling appointments and events?
Google Docs
Google Sheets
Google Slides
Google Calendar
What is the purpose of a chart title in Excel?
To provide a description of the chart data.
To label the horizontal axis.
To label the vertical axis.
To provide an overall title or heading for the chart
Which cell reference accurately identifies the active cell when entering values in the MS Excel spreadsheet at the 3rd column and 4th row?
C3
4C
C4
3C
Deki wants to use MS-Excel features to visually highlight the subject marks which are less than 40 to “red“ in colour. Which feature will help her to do this task?
validation
sort and filter
logical functions
conditional formatting
A group of students collaborate online to work on their English assignment which requires them to write a story. Which Google workspace application is the most appropriate for the task?
sheets
forms
docs
slides
You are given two variables, num1 and num2, both of which contain integer values. Your task is to write an if statement that checks if num1 is divisible by num2 without any remainder. Which code will correctly perform this check?
if num1 % num2 == 0:
if num1 / num2 == 0:
if num1 // num2 == 0:
if num1 * num2 == 0:
Which of the following statements accurately describes the purpose of loops in Python?
Loops are used to execute a block of code only once.
Loops are used to perform mathematical calculations.
Loops are used to define and call functions or methods.
Loops are used to repeat a set of instructions multiple times.
In the context of online resource usage, what does it mean when a teacher emphasises the importance of being mindful and responsible?
using resources for personal gain
using resources without permission
using resources ethically and responsibly
using resources for entertainment
Which of the following data structures in Python stores elements in an ordered, indexed, and mutable manner?
A Set
B List
C Tuple
D Dictionary
You have important files on your computer that you want to make accessible from anywhere by storing them in Google Drive. Which of the following steps is the correct way to transfer the files from your computer to Google Drive?
Clicking on "New" and selecting "File Upload"
Going to the "File" menu and choosing "Save As"
Dragging and dropping the files directly into Google Drive
Right-clicking on the file and "Copy" then "Paste" in Google Drive
Which of the following is the correct name for a variable in Python?
$DzoMark
Dzo Mark
1DzoMark
_DzoMark
Which of the following options describe a legal protection that provides exclusive rights to the creator of an original work, restricting others from using, reproducing, or distributing it without authorization?
A Patent
B Copyright
C Trademark
D Trade secret
A Class X student is seeking guidance in order to understand in-text citation for her research paper. Which option provides the most comprehensive explanation of in-text citation?
including the URL of the source within the text
listing the full reference at the end of the paper
including the title of the source within quotation marks
including the author's name and publication year within parentheses
Study the following code. fruits = ['apple', 'banana', 'orange', 'kiwi'] Which of the following code correctly adds the fruit 'grape' to the end of the list 'fruits'?
fruits.append('grape')
fruits.add('grape')
fruits.insert('grape')
fruits.push('grape')
Which of the following statements will add 'grape' to the list named fruits?
fruits += 'grape'
fruits.append('grape')
fruits.extend('grape')
fruits.insert(0, 'grape')
Pema entered the names of different colours in column A in MS Excel. Which of the following functions can be used by her to count the number of cells with the value ‘Red’?
MAX
COUNTA
COUNT
COUNTIF
A class IX teacher wants to gather feedback from her students regarding her teaching. Which of the following is the most appropriate Google Workspace application for this purpose?
Google Docs
Google Keep
Google Forms
Google Drive
Which of the following Cloud Deployment Model is the most economical Cloud Service option for those individuals that do not wish to invest in IT infrastructure?
A Community Cloud
B Hybrid Cloud
C Private Cloud
D Public Cloud
An ICT teacher highlighted the various benefits of utilising charts, which can help her in different ways to present information. Which of the following options presents the advantages of Chart?
I and II
I and III
II and III
I, II and III
Pema is writing a Python program that prompts users to enter a string value. She also wants to check the number of characters entered by the user. Which function would she use to find it?
len( )
count( )
length( )
countif( )
Which statements accurately describes the purpose of Line 1 and 4 in the code given below?
I It provides the explanation to the code.
II It helps to store the value.
III It helps developers in debugging the code.
IV It helps to display the output.
What should you do regarding citation when you are using data from your own observations or personal experiences?
A cite the source only if the information is surprising
B cite always, to provide credibility and support
C cite only if the information contradicts existing research
D citing personal experience or observation is not required
A formula in Excel always begins with
A Colon
B Comma
C Space
D Equal Sign
What are the main steps of Data Analysis?
Data collection>Data filtering>Decision making.
Data cleaning>Data collection>Decision making.
Data collection>Data cleaning>Decision making.
Data sorting>Data cleaning>Decision making.
Which of the following statement describes the best definition of Collaboration tools?
It allows multiple users to work together on a common project or task despite time and geographical limitation.
Collaboration tools are devices that enable communication between students and instructors only.
Collaboration tools are devices that enable communication.
It allows single users to work together on a common project or task despite time and geographical limitation.
Tency as a class teacher of class 10 wants to analyze the result of her students by arranging the percentage of the students in descending order. Which data analysis tool in MS Excel will help her to arrange the data?
Sort
Filter
Charts
Conditional formatting
The data type of the variable “x” in the code x = “False” is
String
Integer
Float
Boolean
The right given by the government to an inventor to protect his/ her invention from being used/copied for a fixed period.
Copyright
Intellectual Property
Patent
Trademark
Namgay is working on a project and he referred some of the websites and acknowledged the sources appropriately. Now he cannot be accused of
Moral
Author
Plagiarism
Attribution
Which feature is use to join the selected cells into one cell?
Filter
Wrap
Pivot
Merge
What is the output of the following code? x = '5' y = '10' print(x + y)
A 15
B 510
C Syntax error
D None of the above
Karchung, who is working on a Python code to create an application, aims to keep notes for future use and to enhance collaboration with his teammates. Which symbol should he use for this purpose?
@
*
=
#
Which statement accurately describes the purpose of Line 1 and 4 in the code given below?
A It provides the explanation to the code.
B It helps to store the value.
C It helps developers in debugging the code.
D It helps to display the output.
You are assigned with a group project work by your geography teacher. Since you and your friends live in different places which are quite far from each other, you all decided to use one the G-Suite application. Which of the following is the most appropriate Google Workspace application for this purpose?
Google Docs
Google Keep
Google Forms
Google Drive
Two variables class and section are created in Python program which are assigned with values “X” and “A” respectively as follows.
class = “X”
section = “A”
After running the above code, the output displayed is XA. Which of the following operation is used to get this output?
(a)
Dema is coding instructor working in one of the IT institutes of Bhutan. She shares her expertise with her colleagues by exchanging Python files online most of the time. While sharing files, she assures that her codes consist comments to assist her friends in her absence. In what ways would her comments help her friends?
I Debugging
II Readability
III Storage
IV Collaboration
An ICT teacher highlighted the various benefits of utilizing charts, which can help her in different ways to present information. Which of the following options presents the advantages of Chart?
I and II
I and III
II and III
I, II and III
Pema has a string value “Elephant” stored in a variable “animal_1”. She found a substring “ant” and displayed as an output. Which of the following method would have Pema used to get the output?
print(animal_1[0:8:2])
print(animal_1[5:8])
print(animal_1[5:7:2])
print(animal_1[5:7])
Pema entered the names of different colours in column A in MS Excel. Which of the following functions can be used by her to count the number of cells with the value ‘Red’?
MAX
COUNTA
COUNT
COUNTIF
Study the given code and determine the correct output when it is executed. for i in range(4,10): If i%2==0: Print(i)
A 4, 12, 16
B 4, 6, 8, 10
C 4, 6, 8
D 8, 10, 16
You want to store your files online and access them from anywhere without buying physical storage devices. Which service is best suited?
A SaaS
B IaaS
C Cloud Storage
D Local Server
Which of the following is the correct APA 7th edition in-text citation for a book written by Karma Dema in 2020?
A (Karma, 2020)
B (Dema, 2020)
C (K. Dema, 2020)
D (Dema K., 2020)
In Python, which loop type is best when you know exactly how many times you want to repeat a block of code?
A while
B for
C do-while
D if
In MS Excel, which function will return the highest value from cells C2 to C10?
=MAX(C2:C10)
=HIGH(C2:C10)
=TOP(C2:C10)
=HIGHEST(C2:C10)
What is the output of this code? my_list = [10, 20, 30, 40] my_list.pop(1) print(my_list)
Which Creative Commons licence condition allows users to reuse the work, but they must give appropriate credit?
NC
SA
BY
ND
In Google Workspace, which app should you use to conduct online quizzes with automatic grading?
Google Docs
Google Sheets
Google Slides
Google Forms
In Python, what will be printed? for i in range(2, 11, 2): print(i, end=", ")
A 2,4,6,8,10
B 2,4,6,8
C 2,3,4,5
D 2,6,10
Which MS Excel feature is used to prevent invalid data entry in a cell?
Conditional Formatting
Data Validation
Sorting
Filter
Given the following sets: X = {10, 20, 30, 40, 50}; Y = {30, 40, 60, 70} What is the output of the following code? print(X.difference(Y).intersection({10, 50, 60}))
A {10, 50}
B {30, 40}
C {10, 50, 60}
D {10, 40}
Which Python data structure stores key-value pairs?
A List
B Dictionary
C Tuple
D Set
In a Python function definition, the values you pass into the function when calling it are called:
Parameters
Variables
Arguments
Constants
Which formula will correctly calculate the sum of values in column D where column B contains "Apple"?
=SUMIF(B2:B10,"Apple",D2:D10)
=SUMIF(D2:D10,"Apple",B2:B10)
=SUM(B2:B10,"Apple",D2:D10)
=IF(B2:B10="Apple",SUM(D2:D10))
In Python, which method adds a new element to the end of a list?
append()
add()
push()
extend()
