TEST YOUR ICT SKILLS!

Spreadsheets Multiple Choice Questions (MCQ) Online Test #7


Spreadsheets MCQ #61:

Which of the following is a common feature of spreadsheet software?

About Spreadsheets Multiple Choice Question (MCQ) #61:
This ICT Multiple Choice Question (ICT MCQ) #61 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of common features in spreadsheet software.

Spreadsheets MCQ #62:

In spreadsheet software, what is a workbook?

About Spreadsheets Multiple Choice Question (MCQ) #62:
This ICT Multiple Choice Question (ICT MCQ) #62 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of what a workbook is in spreadsheet software.

Spreadsheets MCQ #63:

How is the cell address "D5" interpreted in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #63:
This ICT Multiple Choice Question (ICT MCQ) #63 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of interpreting cell addresses in a spreadsheet.

Spreadsheets MCQ #64:

What does the AVERAGE function calculate in a range of cells?

About Spreadsheets Multiple Choice Question (MCQ) #64:
This ICT Multiple Choice Question (ICT MCQ) #64 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of what the AVERAGE function calculates in a range of cells.

Spreadsheets MCQ #65:

What does the formula =A1*$B$1 do when copied from cell A2 to A3?

About Spreadsheets Multiple Choice Question (MCQ) #65:
This ICT Multiple Choice Question (ICT MCQ) #65 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of how cell references are adjusted when using mixed referencing.

Spreadsheets MCQ #66:

Which feature allows you to highlight cells that meet certain criteria with specific formatting?

About Spreadsheets Multiple Choice Question (MCQ) #66:
This ICT Multiple Choice Question (ICT MCQ) #66 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of the feature that allows highlighting cells based on certain criteria with specific formatting.

Spreadsheets MCQ #67:

Which feature allows you to record and automate repetitive tasks in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #67:
This ICT Multiple Choice Question (ICT MCQ) #67 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of the feature that allows recording and automating repetitive tasks in a spreadsheet.

Spreadsheets MCQ #68:

Which feature allows you to display only the rows that meet certain criteria in a spreadsheet?

About Spreadsheets Multiple Choice Question (MCQ) #68:
This ICT Multiple Choice Question (ICT MCQ) #68 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the knowledge of the feature that allows displaying only the rows that meet certain criteria in a spreadsheet.

Spreadsheets MCQ #69:

Which function would you use to search for 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) #69:
This ICT Multiple Choice Question (ICT MCQ) #69 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the VLOOKUP function.

Spreadsheets MCQ #70:

Which logical function returns TRUE if all arguments are TRUE, and FALSE otherwise?

About Spreadsheets Multiple Choice Question (MCQ) #70:
This ICT Multiple Choice Question (ICT MCQ) #70 focuses on Spreadsheets within the "Basic ICT MCQ" category. This question tests the understanding of the AND logical function.
This page was last modified on by ICT MCQ Hub.


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