MS Excel Basic Data Menu Online Test

0%

12

---

MS Excel Basic Data Menu Questions Online Test 5495

Questions Updated by Shikha Singh

Batch TimeMorningEvening

1 / 25

What is the Use of Recent Sources Tool in MS Excel?

All of these

Import All Delete Recent Sources

Delete and Add to Recent Sources

Manage and Connect to Recent Sources

2 / 25

________ is the Shortcut Key of Refresh All Tool in MS Excel.

Ctrl+ Alt+ F5

Ctrl+ Shift+ RA

Both B & C

Alt+ A+ R

3 / 25

_______ is the Shortcut Key of Recent Sources Tool in MS Excel.

Alt+ H+ PR

Alt+ A+ RS

Alt+ A+ PR

Alt+ A+ S

4 / 25

______ is the Shortcut Key of From Text/CSV Tool in MS Excel.

Alt+ A+ FC

Alt+ A+ F

Alt+ H+ FT

Alt+ A+ FT

5 / 25

______ is the Shortcut Key of Sort A to Z Tool in MS Excel?

Alt+ A+ SA

Alt+ A+ LH

Alt+ A+ HL

Alt+ H+ SA

6 / 25

What is the Use of Filter Tool in MS Excel?

Turn on Filtering on the Selected Cell

Turn on Deleting on the Selected Cell

Turn on Filtering on the Deleted Cell

Turn on Colouring on the Selected Cell

7 / 25

What is the Use of From Table/Range Tool in MS Excel?

Add Cell, Row, Column, Sheet to your Workbook

Both A & C

Create a Deleted linked to the Selected Worksheet or named Range

Create a new Query linked to the Selected Excel Table or named Range

8 / 25

What is the Use of Refresh All Tool in MS Excel?

A and C Both

Create a link your Document

Get the Latest Data By Refreshing all Sources in the Workbook

Get the Latest Data By Refreshing all Sources in the Filter Data

9 / 25

What is the Use of Sort A to Z Tool in MS Excel?

Highest to Lowest

None of these

Lowest to Highest

Lowest to Medium

10 / 25

What is the Use of Get Data Tool in MS Excel?

Remove the Watermark in Table

A and C Both

Then Shape and Refine it to Meet your Needs

Easily Discover, Connect and Combine Data from Multiple Sources

11 / 25

________ is the Shortcut key of Advanced Tool in MS Excel.

Alt+ A+ Q

Alt+ A+ ZA

Alt+ A+ AT

Alt+ A+ A

12 / 25

______ is the Shortcut key of Sort Z to A Tool in MS Excel.

Alt+ H+ SD

Alt+ A+ HL

Alt+ A+ SD

Alt+ A+ LH

13 / 25

_______ is the Shortcut Key of Queries & Connections Tool in MS Excel.

Alt+ A+ O

Alt+ A+ ZC

Alt+ A+ QC

Alt+ A+ Q

14 / 25

_______ is the Shortcut Key of Sort Tool in MS Excel.

Alt+ M+ SS

Alt+ P+ SS

Alt+ A+ SS

Alt+ H+ SS

15 / 25

______ is the Shortcut Key of Get Data Tool in MS Excel.

Alt+ A+ G

Alt+ A+ PN

Alt+ A+ GD

Alt+ A+ ZA

16 / 25

What is the Use of Existing Connections Tool in MS Excel?

Import Data From Text/CSV

All of these

Import Data From Web Page

Import Data From Common Sources

17 / 25

What is the use of Sort Z to A Tool in MS Excel?

None of these

Lowest to Highest

Highest to Medium

Highest to Lowest

18 / 25

______ is the Shortcut key of From Table/Range Tool in MS Excel.

Alt+ M+ PT

Alt+ A+ T

Alt+ A+ PT

Alt+ A+ TR

19 / 25

What is the Use of From Web Tool in MS Excel?

All of these

Import Text from a Web Page

Import Data from a Web Page

Import Fitter Colour from a Web Page

20 / 25

What is the Use of Advanced Tool in MS Excel?

Options for Filtering Using Complex Criteria

Remove the Watermark in Table

None of these

Add a Financial Function to your Sheet

21 / 25

What is the use of Sort Tool in MS Excel?

Add Cell, Row, Column, Sheet to your Workbook

Add a Math or Trigonometry function on your Address bar

Find Values Quickly By Sorting your Formulas

Find Values Quickly By Sorting your Data

22 / 25

What is the Use of From Text/CSV Tool in MS Excel?

Add a Logical Colour to Your Sheet

To Filter Data Visually

Import Data from a Text

Add Cell, Row, Column, Sheet to your Workbook

23 / 25

________ is the Shortcut Key of Filter Tool in MS Excel.

Both B & C

Ctrl+ Shift+ F

Ctrl+ Shift+ L

Alt+ A+ T

24 / 25

______ is the Shortcut Key of From Web Tool in MS Excel.

Alt+ H+ FW

Alt+ A+ F

Alt+ A+ FW

Alt+ A+ W

25 / 25

What is the Use of Queries & Connections Tool in MS Excel?

Both A & C

Delete & Import the Queries & Connections in this Workbook

Add a Logical Colour to Your Sheet

View & Manage the Queries & Connections in this Workbook

Your score is

The average score is 12%

LinkedIn Facebook Twitter

0%

Restart quiz

Send feedback

December Month Excel Online Test Series

November Month Excel Online Test Series

October Month Excel_Online Test Series

September Month Excel_Online Test Series

August Month Excel_Online Test

July Month Excel_Online Test

June Month Excel_Online Test

May Month Excel_Online Test

Apr Month Excel_Online Test

Read Also: Excel Online Test

Also Read: MSExcel Online Test

Also Read: MS Excel Online Test

About Excel Online Test

This is the Online Test Website Page. If You are preparing for Excel Exam or any competitive exam then you should visit this www.vedantsri.net website.

you can also download this app from the Play Store and you find Just like many more Online Test Series Related For Example MS Word, MS Excel, MS PowerPoint, and Internet-related. MS Online Excel Test

Useful Link:-About MS Excel Course, Duration, Best Top 10 Scope, Fees, Syllabus, Admission, Institutes & Jobs Near Me

MS Excel Online Test

MS Excel Online Test: – This is M.S MS Excel Online Test Website Page. If You are preparing for CCC Exam or any competitive exam then you should visit this www.vedantsri.net website. MS Excel Basic Data Menu, Questions Online Test

यदि आप MsExcel 2nd Useful Tricks सिखाना चाहते है तो इस लिंक जाए

you can also download this app from play store and you find Just like many more Online Test Series Related For Example MS Word, MS Excel, MS PowerPoint, and Internet-related. MS Excel Basic Data Menu, Questions Online Test

यदि आप Internet Most Common Questions सिखाना चाहते है तो इस लिंक जाए

This is Provided By VedantSri Computer Institute in Varanasi. The VedantSri Provides the Best Computer Classes, Courses, Coaching, and Computer Training in Varanasi Uttar Pradesh India. MS Excel Basic Data Menu, Questions Online Test

यदि आप Wordpad Simple Resume Matter सिखाना चाहते है तो इस लिंक जाए

VedantSri Computer Institute Varanasi

provides the best Computer Courses, Classes, and Training in Varanasi. There is NIELIT Courses CCC, BCC, O’level, Certificates, and Diploma Computer Courses available with the best training materials. Also Available Top 100 Best Computer Courses, For Example, OM, DCA, ADCA, DTP, DFA, ADAM, ADTP, ADFA, DCE, and MS Office. VedantSri Computer Coaching updates CCC Online Test in www.vedantsri.net. There are some important computer Courses for jobs CCC Classes, Typing, Internships, And Spoken English Available Free of cost with Offer.

More than 50 Computer Courses are available with a 50% Fee Discount in VedantSri Varanasi. You can get the Best Digital Marketing Course at Varanasi Institute VedantSri. There is the Latest Computer Course Offer in ADCA Computer Course, DCA Computer Course, CCC Computer Course & English Spoken. MS Excel Basic Data Menu

यदि आप Ms Word Brochure Design Project सिखाना चाहते है तो इस लिंक जाए

About VedantSri Computer Institute Varanasi

VedantSri Computer Institute in Varanasi is the Government recognized and ISO Certified Computer Institute in Varanasi running since 2011. It Provides Computer Courses, Classes, and Training through different own branches all over Varanasi. There is Computer Scholarship Courses DCE Scholarship (Diploma in Computer Engineering), DIT most trusted computer course Available under Scholarship Test Scheme. Varanasi Computer Institute Vedantsri works at different places to ensure students get better computer education. MS Excel Basic Data Menu

Computer Classes has Diploma courses and advance diploma courses on the computer. VedantSri Institute provides the latest version of computer application training in computer courses. वेदांतश्री कम्प्यूटर इंस्टिट्यूट’ वाराणसी में पिछले 10 वर्षो से बेहतर व न्यूनतम शुल्क में कम्प्यूटर शिक्षा प्रदान करने वाली एक कम्प्यूटर ट्रेनिंग इंस्टिट्यूट है | यह संस्था कम्प्यूटर व इंग्लिश स्पीकिंग कोर्स की ट्रेनिंग प्रदान करती है | वाराणसी में कम्प्यूटर शिक्षा को बेहतर व न्यूनतम शुल्क में छात्रो तक पहुचाने में वेदांतश्री पिछले 10 वर्षो से प्रयासरत है | MS Excel Basic Data Menu

यदि आप MsWord Page Layout Questions सिखाना चाहते है तो इस लिंक जाए

Free To Learn In VedantSri Computer Institute in Varanasi

इस वेबसाइट का यूज़ वेदांतश्री में पढ़ रहे छात्रो को कोर्स से सम्बंधित ऑनलाइन सपोर्ट करने से सम्बंधित है | इस वेबसाइट पर उपलब्ध विडियो, टेस्ट शीट, Questions & Answer सेशन, ट्रिक्स, टिप्स वेदांतश्री में सिख रहे कोर्सेज से सम्बंधित है | उपलब्ध कंटेंट संस्था में सिख रहे छात्रो के डिमांड पर अपडेट किया जाता है | उपलब्ध कंटेंट वेदांतश्री में पढ़ रहे छात्रो व सम्बंधित छात्रो को निशुल्क प्रदान किया जाता है जिसका कोई अलग से शुल्क नही लिया जाता है | इस वेबसाइट पर उपलब्ध कंटेंट कम्प्यूटर कोर्सेज व इंग्लिश स्पीकिंग कोर्सेज से सम्बंधित अपडेट किया जाता है |

यदि आप MsWord 6 Useful Tricks सिखाना चाहते है तो इस लिंक जाए

About CCC Online Test

CCC Online Test:- This is the CCC Online Test Website Page. If You are preparing for CCC Exam or any competitive exam then you should visit this www.vedantsri.net website. You can also download this app from play store and you find Just like many more Online Test Series Related For Example MS Word, MS Excel, MS PowerPoint, and Internet-related. This is Provided By VedantSri Computer Institute Varanasi. The VedantSri Provides the Best Computer Classes, Courses, Coaching, and Computer Training in Varanasi Uttar Pradesh India. (1st Rank in Surprise Test)MS Excel Page Layout Menu Test

यदि आप MsWord Visiting Card Projects सिखाना चाहते है तो इस लिंक जाए

External Link

• 1-VedantSri Official Website:- https://vedantsri.com
• 2-Course Store Website:- https://vedantsri.in
• 3-Jobs Assist Website:- https://www.jobdo.in
• 4-MS Word Class:- https://mswordclass.com/
• 5-Corel Free Class:- https://corelclass.com/
• 6-Free Excel Class:- https://msexcelclass.com/