Advance Excel Q&A Session

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

MD RASHID HUSSAIN NIIT JAMSHEDPUR CENTRE
-------------------------------------------------------------------------------------
TOTAL 20 QUESTION

FULL SCORE : 100
PASSING SCORE : 60

Full Name*

0 points

Branch

Course*

_______ tab, in the Editing group, click Find & Select, and then click Go To.Home

5 points

Home

Insert

Page Layout

Review

Clear selection

On the ----------tab, in the Page Setup group, click Background

5 points

Home

Insert

Page Layout

Review

Clear selection

Open a new, blank workbook..?

5 points

Ctrl + C

Ctrl + D

Ctrl + N

File Insert

Clear selection

On the ------------tab, in the Sparkline group, click the type of sparkline that you want to create

5 points

Insert

View

Developer

Page Outline

Clear selection

Under SmartArt Tools, on the Format tab, in the _____ group, click the arrow next to Shape Outline

5 points

Shape Smart Group

Shape Smart review

Insert

Page Outline

Clear selection

If the Developer tab is not available, do the following to display it: File tab, - Options- ____________- Developer OK

5 points

Customize Ribbon

Customize Quick Access toolbar

Insert

Page Outline

Clear selection

Which symbol must all formula begin with?

5 points

Clear selection

Which area in an excel window allows entering values and formulas

5 points

Formula bar

Status bar

Ribbon panel

Quick Access Tool bar

Clear selection

Excel is a Word A spreadsheet

5 points

A Spreadsheet

Documents File

Ribbon panel

Anti Virus

Clear selection

How are data organized in a spreadsheet....?

5 points

Rows & Columns

Cell

line bar

A4 page

Clear selection

To drag a selected range of data to another worksheet in the same workbook, use the

5 points

Esc Key

Alt Key

Windows key

Ctrl Key

Clear selection

Which formula is used to calculate the EMI on the loan amount

5 points

=PMT

=EMI

=PPMT

=AVERAGE

Clear selection

You can edit existing Excel data by pressing the

5 points

Rename

Windows key

Clear selection

Which menu option can be used to split windows into two

5 points

Window > Split

Multi Window

View key

Clear selection

What command allows you to highlight the cell(s) in a data table that matches your set-up information?

5 points

Cell Styles

Conditional Formatting

Auto Formatting

Data Table Styles

Clear selection

Which of the following is not a browser..?

5 points

Chrome

Facebook

Mozilla Firefox

Explorer edge

Clear selection

Which of the following is not a Application Software..?

5 points

Memory card

Mozilla Firefox

Explorer edge

Notepad

Clear selection

www Stand for...

5 points

world Wide Web

Web World Web

Wide World Web

Web Wide Web

Clear selection

Who developed first portable computer?

5 points

Adam Osborne

Adam Well

John Well

Charles Babbage

Clear selection

What is Full Form of GPS

5 points

Global Positioning System

Global Positioning Scan

Global Post System

Global Positioning Satellite

Clear selection

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. - Terms of Service - Privacy Policy

Does this form look suspicious? Report

Forms