MS Excel Basic Formulas Menu, Questions Online Test 2023

0%

4

---

MS Excel Basic Formulas Menu Questions Online Test 5493

Questions Updated by Shikha Singh

Batch TimeMorningEvening

1 / 25

What is the Use of Math & Trig Tool in MS Excel?

Add a Math or Trigonometry function on your Worksheet

Add a Logical Colour to Your Sheet

Add a Break where you want the next page to begin in the Printed copy

Add a Math or Trigonometry function on your Address bar

2 / 25

What is the Use of Logical Tool in MS Excel?

Add a Logical Function to Your Sheet

Add a Logical Colour to Your Sheet

All of these

Add a Logical Text to Your Sheet

3 / 25

_______ is the Shortcut key of Auto SUM Tool in MS Excel.

Alt+ M+ U

A & B Both

Alt+ M+ AS

Alt+ =

4 / 25

________ is the shortcut key of Financial Tool in MS Excel.

Alt+ M+F

Alt+ H+I

Alt+ M+FT

Alt+ M+I

5 / 25

What is the use of Text Function Tool in MS Excel?

Add a Break where you want the next page to begin in the Printed copy

Add Cell, Row, Column, Sheet to your Workbook

Add a Logical Colour to Your Sheet

Add a text Function to your sheet

6 / 25

What is the Use of Recently Used Tool in MS Excel?

Quickly Change Page

All of these

Quickly Choose form Formula you Recently used

Quickly Choose form function you Recently used

7 / 25

How Many Tools in Function Library Tool Box of MS Excel?

6

8

9

7

8 / 25

What is the Use of Date & Time Tool in MS Excel?

Add a Time Function

Add a time Equation

Add a Time Formulas

All of these

9 / 25

______ is the Shortcut Key of Date & Time Tool in MS Excel.

Alt+ M+ E

Alt+ H+ E

Alt+ M+ DT

Alt+ M+ D

10 / 25

What is the Use of Define Name Tool in MS Excel?

Define & Apply Name

Find Deleted name

Delete Name

Add a Lookup & Reference in your Sheet

11 / 25

What is the Use of Auto SUM Tool in MS Excel?

All of these

Automatically add a Quick Worksheet

Automatically add a Quick Calculation

Automatically add a Insert Formulas

12 / 25

What is the Shortcut Key of Create From selection Tool in MS Excel?

Ctrl+ Shift+ F3

A & C Both

Alt+ M+ C

Ctrl+ Shift+ C

13 / 25

_______ is the Shortcut Key of Define Name Tool in MS Excel.

Alt+ M+ N

Alt+ M+ DN

Alt+ H+ M

Alt+ M+ M

14 / 25

What is the Shortcut Key of Logical tool in MS Excel?

Alt+ M+ LG

Alt+ M+ ZL

Alt+ M+ L

Alt+ H+ L

15 / 25

______ is the Shortcut Key of Math & Trig. Tool in MS Excel.

Alt+ M+ M

Alt+ M+ G

Alt+ M+ T

Alt+ M+ MT

16 / 25

______ is the Shortcut Key of Text Function Tool in MS Excel.

Alt+ M+ T

Alt+ H+ T

Alt+ M+ WT

Alt+ M+ TL

17 / 25

What is the use of Lookup & Reference Tool in MS Excel?

Add a Lookup & Reference in your Formula bar

Add a Lookup & Reference in your Sheet

Add a Lookup & Reference in your Address bar

All of these

18 / 25

What is the Shortcut key of Lookup & Reference Tool in MS Excel?

Alt+ M+ ZR

Alt+ M+ L

Alt+ M+ O

Alt+ M+ LR

19 / 25

What is the Shortcut Key of Insert Function Tool in MS Excel?

Shift+ F3

Alt+ M+ F

Ctrl+ IF

Both A & C

20 / 25

________is the shortcut Key of Recently Used Tool in MS Excel.

Alt+ H+ R

Alt+ M+ FM

Alt+ M+U

Alt+ M+ R

21 / 25

What is the Use of Insert Function Tool in MS Excel?

Insert Math & Trig.

Work with the formula in the Current Cell

Work with the formula in the Deleted Cell

All of these

22 / 25

_______ is the Shortcut key of More Functions Tool in MS Excel.

Alt+ M+ MF

Alt+ M+ Q

Alt+ H+ Q

Alt+ M+ F

23 / 25

What is the Use of Name Manager Tool in MS Excel?

A & C both

Create Edit, Delete, and Find all the Name used in a worksheet

Find all the Delete Name used in a entry

Add a Logical Colour to Your Sheet

24 / 25

What is the Use of Financial Tool in MS Excel?

Add a Financial Formula to your page

Add a Financial Colour to your Sheet

Add a Financial Function to your Sheet

All of these

25 / 25

What is the Shortcut Key for Name Manager Tool in MS Excel?

Ctrl+ F3

B & C both

Alt+ M+ N

Ctrl+ N

Your score is

The average score is 7%

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 2023

Also Read: MS Excel 2022 Online Test

Also Read: MS Excel 2022 Online Test

About Excel Online Test 2023

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. MS Online Excel Test 2023

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 2023

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

MS Excel Online Test 2023

MS Excel Online Test 2023:- 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.

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

MS Excel Online Test 2023

MS Excel Online Test 2023:- 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 Formulas Menu

यदि आप 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, Internet-related. MS Excel Basic Formulas Menu

यदि आप 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 Formulas Menu

यदि आप 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 2021 on www.vedantsri.net. There are some important computer Courses for jobs CCC Classes, Typing, Internships, And Spoken English Available Free of cost with Offer. MS Excel Basic Formulas Menu

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 Page Layout Menu Test

यदि आप 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 MS Excel Basic Formulas MenuScheme. Varanasi Computer Institute Vedantsri works at different places to ensure students get better computer education.

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 वर्षो से प्रयासरत है | (1st Rank in Surprise Test) MS Excel Basic Formulas Menu

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

Free To Learn In VedantSri Computer Institute in Varanasi

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

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

About CCC Online Test 2023

CCC Online Test 2021:- 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 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. 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 सिखाना चाहते है तो इस लिंक जाए

Important Links

1-VedantSri Official Website:- https://vedantsri.com

2-Student Support Website:- https://www.vedantsri.net

3-Jobs Assist Website:- https://www.jobdo.in

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/