Basics of Excel
Advance formulas & functions: If, If-And, SumIf(), SumIfs(), Countif(), Countifs(), Date & Time functions etc.
Templates, customized ribbon & quick access toolbar, linking between worksheets, use of hyperlink, overview Google spreadsheet
integrating excel with other tools, advanced Excel Formulas-I & II
Data-validation and Listing, Conditional formatting
100

 What is MS Excel?

  1. Spreadsheet 
  2. Database Management 
  3. Presentation 
  4. Workbook

Spreadsheet

100

Which function is used to create a date with year, month, and day?

  1. DATE()
  2. DATEDIF()
  3. DATEVALUE()
  4. CURDATE()
  • DATE()
100

What is a template in Excel?
a) pre-designed sheet

b) new sheet 

c) formula sheet

d) none of these

a) pre-designed sheet

100

When you group worksheets


A. You can enter variable data on multiple worksheets at one time
B. You can print more than one worksheet at a time
C. You can enter common data, formats, and formulas on multiple worksheets at one time
D. Both B and C

When you group worksheets
A. You can enter variable data on multiple worksheets at one time
B. You can print more than one worksheet at a time
C. You can enter common data, formats, and formulas on multiple worksheets at one time
D. Both B and C

100

What is the purpose of Conditional Formatting in Excel?


a) To organize data into tables 

c) To visually highlight data based on
certain criteria

b) To create formulas for calculations 

d) To sort data alphabetically

c) To visually highlight data based on
certain criteria

200

The total number of rows in a worksheet?

  1. Unlimited
  2. 1,046,576
  3. 1,048,576
  4. 1,068,576
  • 1,048,576
200

_____ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise. 

A) OR

B) AND

C) IF

D) ANDIF

B) AND

200

Where is Quick Access Toolbar located in worksheet?


a) Bottom row 

b) Top most row

c) Middle row 

d) none of these

b) Top most row

200

What will be the answer for the given formula: =TEXT(0.985,"0.00%") ?


a) 98.50

b) 98.500

c) 98.05 

d) 99

a) 98.50

200

Q-1) What is the primary purpose of data validation in Microsoft Excel?.


a) To perform complex calculations on
data.

b) To import data from external sources
c) To create charts and graphs

d) To ensure data accuracy and
consistency

d) To ensure data accuracy and
consistency

300


The intersection of a column and a row in a worksheet is called____ 

  1. Column
  2. Address 
  3. Value
  4. Cell 


Cell

300

Which symbol is used to specify the fixed columns or rows in the formula?

  1. =
  2. *
  3. $
  4. %
  • $
300

In which tab is the Hyperlink option available?


a) File 

b) View

c) Page Layout 

d) Insert

d) Insert

300

What will be the answer for the given formula: =IFERROR(12/0,"Division Not Possible") ?
a) Infinity 

b) 0

c) 12 

d) Division Not Possible

d) Division Not Possible

300

Which feature in Excel allows users to restrict data input based on predefined rules or criteria?

a) Conditional Formatting 

b) Pivot Tables

c) Data Validation 

d) VLOOKUP function

c) Data Validation

400

What is the extension of a Microsoft Excel file?

  1. msxcl
  2. xcl
  3. xlsx
  4. xlsm
  • xlsx
400

Why is the =COUNTIF function in Excel used? 

  1. Counts cells as specified
  2. Counts blank cells in a range
  3. Counts cells with numbers in a range
  4. Returns values based on a TRUE or FALSE condition

1. Counts cells as specified

400

Hyperlink can also be referred as ___________ to open a desired worksheet.


a) delete 

b) shortcut

c) duplicate 

d) copy

b) shortcut

400

What will be the answer for the given formula: =ROUND(12.4578,2) ?
a) 12.00 

b) 12.45

c) 12.78 

d) 12.22

b) 12.45

400

Which of the following is NOT a feature of Conditional Formatting in Excel?

a) Highlighting cells based on specific
criteria

b) Setting color scales for data
visualization

c) Applying data validation rules 

d) Identifying duplicates or unique
values

b) Setting color scales for data
visualization

500

What is the collection of worksheets called?

  1. Ledger
  2. Book
  3. Testbook
  4. Workbook
  • Workbook
500

What is the correct syntax of IF() function?

  1. =IF (logical_test, {[value_if_true]}, {[value_if_false]})
  2. =IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
  3. =IF (logical_test: [value_if_true], [value_if_false])
  4. =IF (logical_test, [value_if_true], [value_if_false])

D) =IF (logical_test, [value_if_true], [value_if_false])

500

How can you access the "Last Edited" history for a Google Sheets document?
a) It's visible in the document header 

b) Right-click on the spreadsheet tab

c) Use the "Version History" option 

d) Click on the "Comments" section

c) Use the "Version History" option

500

What will be the answer for the given formula: =FACT(7) ?
a) 6055 

b) 7834

c) 5040 

d) 9812

c) 5040

500

When creating a drop-down list in Excel, the list source can be:
a) An external website 

b) A range of cells in the same worksheet

c) A separate Excel file 

d) A Word document

b) A range of cells in the same worksheet

M
e
n
u