TEST YOUR ICT SKILLS!

Spreadsheets Multiple Choice Questions (MCQ) Online Test #2

Spreadsheets MCQ #11:

What feature in spreadsheets allows users to sort data in ascending or descending order?

About Spreadsheets Multiple Choice Question (MCQ) #11:
This ICT Multiple Choice Question (ICT MCQ) #11 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question asks about the feature used to arrange data in a specific order.
Spreadsheets MCQ #12:

Which formula would you use to count the number of cells containing numeric values in a range?

About Spreadsheets Multiple Choice Question (MCQ) #12:
This ICT Multiple Choice Question (ICT MCQ) #12 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question identifies the formula used to count cells with numeric values.
Spreadsheets MCQ #13:

In spreadsheet terminology, what is an "absolute reference"?

About Spreadsheets Multiple Choice Question (MCQ) #13:
This ICT Multiple Choice Question (ICT MCQ) #13 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question explains the concept of "absolute reference" in spreadsheets.
Spreadsheets MCQ #14:

Which of the following is used to display data from multiple cells in a single cell, separated by a delimiter?

About Spreadsheets Multiple Choice Question (MCQ) #14:
This ICT Multiple Choice Question (ICT MCQ) #14 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question identifies the function used to combine data from multiple cells into one cell.
Spreadsheets MCQ #15:

What feature in spreadsheets allows users to create graphical representations of data?

About Spreadsheets Multiple Choice Question (MCQ) #15:
This ICT Multiple Choice Question (ICT MCQ) #15 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question asks about the feature used to create visual representations of data.
Spreadsheets MCQ #16:

Which function is used to look up a value in the first column of a table and return a value in the same row from a specified column?

About Spreadsheets Multiple Choice Question (MCQ) #16:
This ICT Multiple Choice Question (ICT MCQ) #16 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question identifies the function used for vertical lookups in a table.
Spreadsheets MCQ #17:

What does the "Freeze Panes" option do in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #17:
This ICT Multiple Choice Question (ICT MCQ) #17 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question addresses the function of the "Freeze Panes" option in a spreadsheet.
Spreadsheets MCQ #18:

What is the function of the "SUMIF" formula in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #18:
This ICT Multiple Choice Question (ICT MCQ) #18 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question identifies the purpose of the "SUMIF" formula.
Spreadsheets MCQ #19:

What does the term "cell range" refer to in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #19:
This ICT Multiple Choice Question (ICT MCQ) #19 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question defines what a "cell range" refers to.
Spreadsheets MCQ #20:

Which spreadsheet feature allows you to apply formatting rules to cells based on their content or value?

About Spreadsheets Multiple Choice Question (MCQ) #20:
This ICT Multiple Choice Question (ICT MCQ) #20 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question focuses on the feature used to apply formatting rules based on cell content.
This page was last modified on by ICT MCQ Hub.
< Previous Next >

Find Your Next MCQ Challenge!

Sharpen Your Skills with More Tests!

ICT MCQ Hub Promo Banner
  • This online test, titled "Spreadsheets Multiple Choice Questions (MCQ) Online Test #2" is designed for individuals at the basic level and focuses on "Spreadsheets". It consists of 10 carefully crafted multiple choice questions (MCQs) with four options each that assess foundational knowledge and understanding of the subject matter. This test aims to help participants evaluate their grasp of key concepts related to "Spreadsheets".
Copyright © 2024 - 2025 ICT MCQ Hub.com - All Rights Reserved.
Terms of Use Privacy Policy About Us Contact Us