TEST YOUR ICT SKILLS!

Spreadsheets Multiple Choice Questions (MCQ) Online Test #12


Spreadsheets MCQ #111:

Which feature of spreadsheet software helps in organizing data visually?

About Spreadsheets Multiple Choice Question (MCQ) #111:
This ICT Multiple Choice Question (ICT MCQ) #111 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of features that help in organizing data visually in spreadsheet software.

Spreadsheets MCQ #112:

Which term refers to a horizontal group of cells in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #112:
This ICT Multiple Choice Question (ICT MCQ) #112 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the term for a horizontal group of cells in a spreadsheet.

Spreadsheets MCQ #113:

Which of the following is the correct cell address for column G, row 20?

About Spreadsheets Multiple Choice Question (MCQ) #113:
This ICT Multiple Choice Question (ICT MCQ) #113 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of the correct cell address for column G, row 20.

Spreadsheets MCQ #114:

If you want to find the average of values in cells A1 to A10, which formula would you use?

About Spreadsheets Multiple Choice Question (MCQ) #114:
This ICT Multiple Choice Question (ICT MCQ) #114 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the formula used to find the average of values in cells A1 to A10.

Spreadsheets MCQ #115:

Which cell reference is an example of mixed referencing?

About Spreadsheets Multiple Choice Question (MCQ) #115:
This ICT Multiple Choice Question (ICT MCQ) #115 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of mixed referencing in a spreadsheet.

Spreadsheets MCQ #116:

What does setting a data validation rule to "List" do?

About Spreadsheets Multiple Choice Question (MCQ) #116:
This ICT Multiple Choice Question (ICT MCQ) #116 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of what setting a data validation rule to "List" does.

Spreadsheets MCQ #117:

In a pivot table, what is the purpose of the "Filters" area?

About Spreadsheets Multiple Choice Question (MCQ) #117:
This ICT Multiple Choice Question (ICT MCQ) #117 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the purpose of the "Filters" area in a pivot table.

Spreadsheets MCQ #118:

How can you sort data in a spreadsheet by multiple columns?

About Spreadsheets Multiple Choice Question (MCQ) #118:
This ICT Multiple Choice Question (ICT MCQ) #118 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of how to sort data in a spreadsheet by multiple columns.

Spreadsheets MCQ #119:

What feature would you use to prevent specific cells from being edited in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #119:
This ICT Multiple Choice Question (ICT MCQ) #119 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the feature used to prevent specific cells from being edited.

Spreadsheets MCQ #120:

What does the VAR function calculate in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #120:
This ICT Multiple Choice Question (ICT MCQ) #120 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the VAR function, which calculates the variance in a dataset.
This page was last modified on by ICT MCQ Hub.


  • This online test, titled "Spreadsheets Multiple Choice Questions (MCQ) Online Test #12" 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".