Scribd
Upload
40 views2 pages

Excel Spreadsheet Exam Questions

This document outlines the examination details for the Int BBA-MBA Summer 2020-21 Semester 2 at Parul University, focusing on the subject 'Working on Spread Sheet'. It includes instructions, multiple choice questions, definitions, and various tasks related to Excel and Google Sheets. The exam consists of compulsory questions with a total of 60 marks, covering topics such as cell references, pivot tables, and Excel features.

Uploaded by

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

Excel Spreadsheet Exam Questions

This document outlines the examination details for the Int BBA-MBA Summer 2020-21 Semester 2 at Parul University, focusing on the subject 'Working on Spread Sheet'. It includes instructions, multiple choice questions, definitions, and various tasks related to Excel and Google Sheets. The exam consists of compulsory questions with a total of 60 marks, covering topics such as cell references, pivot tables, and Excel features.

Uploaded by

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

Seat No:______________ Enrollment No:______________

PARUL UNIVERSITY
FACULTY OF MANAGEMENT
Int BBA-MBA Summer 2020-21 Examination
Semester: 2 Date: 26/05/2022
Subject Code: 06302155 Time: 10:30 am to 1:00pm
Subject Name: Working on Spread Sheet Total Marks: 60
Instructions
1. All questions are compulsory.
2. Figures to the right indicate full marks.
3. Make suitable assumptions wherever necessary.
4. Start new question on new page.

Q.1 Do as Directed.
A). Multiple choice type questions/Fill in the blanks. (Each of 1 mark) (05)
1. What's another name for the conditions used in conditional formatting?
a) Specifics b) Criteria
c) Labels d) Situation
2. How many levels can you have in an outline?
a) Five b) Eight
c) Two d) Six
3. What does the V in VLOOKUP mean?
a) Vertical b) Value_if_true
c) Value d) View
4. Which of the following features is Flash Fill a part of?
a) AutoFill b) AutoFit
c) Filter d) Advanced Filter
5. If a cell has a ##### error code, what does it indicate?
a) The column is not wide enough to b) The cell has the wrong type of
display the cell contents formatting applied.

c) The function uses an incorrect operator. d) The cell contains a circular reference.

B). Define the following. (Each of 1 mark) (05)


1. Worksheet
2. Referencing
3. Contextual
4. QAT
5. Macro
C). Direct questions. (Each of 1 mark) (05)
1. What is a cell?
2. Which commands can help fix errors in a worksheet?
3. What is MS Excel Online?
4. What is a Cell Reference?
5. What is pivot Table

Page 1 of 2
Q.2 Answer the following questions.
A. Differentiate Excel with “Google Sheets” (07)
(08)
6. Give detail description of marked image.
B.

Q.3 Answer the following questions.


A. How to Make a Table in Excel? (07)
B. How to perform operation by “Using Formula and Function” (08)
Q.4 Attempt any two questions. (Each of 7.5 mark) (15)

1. Explain the types of Chart and Data labels


2. Explain the Format and Modification of Text (Use of Function)
3. Explain the Features of MS-Excel in Detail
4. Give a detail description about MS Excel, Sheet, Worksheet, Work Book

Page 2 of 2

You might also like