Scribd
Upload
13 views2 pages

Excel MCQ and True/False Questions

This document is a Unit Test for Class VII Computer subject at St. Peter's School Purulia, affiliated to CISCE. It includes multiple-choice questions, true/false statements, and open-ended questions related to MS-Excel functionalities. The test covers topics such as cell selection, functions, and formulas in Excel, with a total of 20 marks allocated.

Uploaded by

tapaskumarmahato
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

Excel MCQ and True/False Questions

This document is a Unit Test for Class VII Computer subject at St. Peter's School Purulia, affiliated to CISCE. It includes multiple-choice questions, true/false statements, and open-ended questions related to MS-Excel functionalities. The test covers topics such as cell selection, functions, and formulas in Excel, with a total of 20 marks allocated.

Uploaded by

tapaskumarmahato
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

S T.

PETER’S SCHOOL PURULIA


Affiliated to CISCE, New Delhi, Code: WB-401
UNIT TEST-II 2021-2022
Class- VII
Subject- Computer

Time Allowed: Total Marks: - 20

1. Choose the correct answer. 1 ×5=5

I. To select multiple ranges, select the first range of cells, hold down the _______ key and
select another range of cells.

A. Shift B. Ctrl C. Alt

II. Which option reverses the effect of the last command?

A. Undo B. Redo C. None of these

III. Which of the following is not a function of Ms-Excel?

A. AVERAGE B. ADD C. MAX D. MIN

IV. Using ______ option we can insert the numbers series 1 to 10 automatically.

A. AutoFit Content B. Autofill C. Insert

V. How do you insert today’s date in the document while working with MS-Excel?

A. Ctrl + ‘ (Single quote) B. Ctrl+;(Semi colon) C. Ctrl+.(dot) D. Ctrl+!(Exclamation)

2. State whether the following statements are true (T) or false(f). 1 ×5=5

1. Columns are the horizontal lines in a worksheet.


2. The name box is at the left end of the formula bar
3. The name of a cell or range can be same as the cell/range reference.
4. You can only select cells that are adjacent to each other.
5. The formula bar displays the active cell address.
3. Answer any four (4) questions out of five (5) questions. 1 ×4=4

1. What will be the result of =SUBSTITUTE ("SCHOOL","H", "K") in MS-Excel?


2. What will be the result of =FIND ("no", "Technology") in MS-Excel?
3. If A2=abcdefghijk, then what will be the result of =REPLACE (A2, 6, 5, "*") in Excel?
4. If A5= Technology, then what will be the result of =MID (A5, 3, 4) in Excel?
5. What will be the result of =REPT ("ABC", 3) in MS-Excel?

4. Answer any three (3) questions. 2 ×3=6

1) Write steps to use auto fill feature.


2) Write steps to display the date in different formats.
3) What is the difference between worksheet and workbook?
4) Write down the steps to merge cells in excel?

You might also like