Muhammad Imdad Ullah

Currently working as Assistant Professor of Statistics in Ghazi University, Dera Ghazi Khan. Completed my Ph.D. in Statistics from the Department of Statistics, Bahauddin Zakariya University, Multan, Pakistan. l like Applied Statistics, Mathematics, and Statistical Computing. Statistical and Mathematical software used is SAS, STATA, Python, GRETL, EVIEWS, R, SPSS, VBA in MS-Excel. Like to use type-setting LaTeX for composing Articles, thesis, etc.

MCQs Microsoft Excel 1

by

The post is about MCQs Microsoft Excel. Practice with our Microsoft Excel MCQs to enhance your skills in using spreadsheets. This quiz covers key topics like Excel workbooks, getting data from a cell, editing existing data, Excel functions, navigating cells, and the working area of Microsoft Excel. It also includes questions on alternatives to MS Excel and general computer spreadsheet concepts. Perfect for students, job seekers, and computer skills tests. Let us start the MCQs Microsoft Excel now.

This quiz is about Microsoft Excel for the preparation of different examinations such as FPSC, PPSC, college, and University Exams/ Tests.

1. In a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of __________?

 
 
 
 

2. When you insert an Excel file into a Word document, the data are?

 
 
 
 

3. The number of columns in MS-Excel 2007 are:

 
 
 
 

4. Which command can be set to prohibit or allow a cell entry?

 
 
 
 

5. The actual working area of Microsoft Excel is ________?

 
 
 
 

6. ________ is the best alternative to MS Excel offered by Google Inc.

 
 
 
 

7. In a computer spreadsheet, a block of cells is called __________?

 
 
 
 

8. To move to the next cell in the row in MS Excel:

 
 
 
 

9. _________ function in MS Excel worksheet represents the total number(s) of entries in the cell(s).

 
 
 
 

10. An Excel workbook is a collection of __________?

 
 
 
 

11. MS Excel file can NOT be directly exported as ______.

 
 
 
 

12. You can edit existing Excel data by pressing the:________ key.

 
 
 
 

13. The first cell in the Excel worksheet is labeled as _________?

 
 
 
 

14. Which function calculates the largest value in a set of numbers?

 
 
 
 

15. In Microsoft Excel, the file you create and edit is called

 
 
 
 

16. In a computer spreadsheet rows are labeled ________?

 
 
 
 

17. Getting data from a cell located in a different sheet is called ___________.

 
 
 
 

18. Select the correct statement.

 
 
 
 

19. In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed the Enter key?

 
 
 
 

20. In a computer spreadsheet, cell ranges A3 through G3 should be keyed in as _________?

 
 
 
 

MCQs Microsoft Excel

  • The number of columns in MS-Excel 2007 are:
  • In Microsoft Excel, the file you create and edit is called
  • Which command can be set to prohibit or allow a cell entry?
  • The first cell in the Excel worksheet is labeled as ———–?
  • An Excel workbook is a collection of ————-?
  • Getting data from a cell located in a different sheet is called ————.
  • You can edit existing Excel data by pressing the: ———— key.
  • ———— is the best alternative to MS Excel offered by Google Inc.
  • MS Excel file can NOT be directly exported as —————-.
  • Select the correct statement.
  • When you insert an Excel file into a Word document, the data are?
  • To move to the next cell in the row in MS Excel:
  • In a computer spreadsheet rows are labeled ————?
  • ———— function in MS Excel worksheet represents the total number(s) of entries in the cell(s).
  • In a computer spreadsheet, a block of cells is called ————?
  • In a computer spreadsheet, which is true if the current or active cell is B4 and you pressed the Enter key?
  • In a computer spreadsheet, cell ranges A3 through G3 should be keyed in as ————?
  • In a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of ————?
  • The actual working area of Microsoft Excel is ————?
  • Which function calculates the largest value in a set of numbers?
MCQs Microsoft Excel

Perform another Quiz about MS-Word

If you found that the Above POSTED MCQ is/ are WRONG
PLEASE COMMENT below The MCQ with the CORRECT ANSWER and its DETAILED EXPLANATION.

R FAQs

Statistics and Data Analysis

General Knowledge Sports Quiz 6

by

The Post is about General Knowledge Sports Quiz in the form of Multiple Choice Questions that are useful for the different types of examinations conducted by FPSC, NTS, KPPSC, PPSC, SPSC, BPSC, OTS, UTs, PTs, CTs, ATs, and other government testing agencies of Pakistan. Let us start with the General Knowledge Sports Quiz.

Please go to General Knowledge Sports Quiz 6 to view the test

All the quizzes about General Knowledge consist of MCQs related to the World Geography, Atmosphere, Science and literature, events that occurred all around the world Current Affairs, Pakistan Affairs, and International Organizations. Performing these quizzes successfully will enable you to pass your exam/test with good grades/Marks in the General Knowledge portion of the test.

General Knowledge questions are included almost in all of the tests and exams being conducted for job or promotion purposes conducted by the Federal Public Service Commission (FPSC), Punjab Public Service Commission (PPSC), Balochistan Public Service Commission (BPSC), Khyber Pakhtunkhwa Public Service Commission (KPPSC), Sindh Public Service Commission (SPSC), Azad Jammu & Kashmir (AJKPSC), National Testing Service of Pakistan (NTS), Pak Army, Navy, PAF, ISSB, Police, and other organization.

A good command of the General Knowledge will enable you to secure good marks in the Gk portion of the test. Note that nowadays, General Knowledge Questions are now part of admission tests too.

General Knowledge Sports Quiz

General Knowledge Sports Quiz

  • How many balls are on the table at the start of a game of pool?
  • In the game of darts, what is the value of the outer bull?
  • Which indoor game is played with a shuttlecock?
  • In which sport do teams compete for the Dunhill Cup?
  • What is the national sport of Malaysia and Indonesia?
  • How many innings are there for each team in a game of baseball?
  • Which sport was originally called “Soccer-in-Water”?
  • How many points is the pink ball worth in snooker?
  • What is the name of the Winter Olympics event that combines cross-country skiing and shooting?
  • When was the first time the Commonwealth Games were held in Asia?
  • What does the globe in the ICC World Cup Trophy symbolize?
  • Which player has scored the fastest double centuries in ODIs?
  • Which country houses the headquarters of the “International Olympic Committee”?
  • The Cricket World Cup is normally held every how many years?
  • Which country hosted the 2019 Kabaddi World Cup?
  • Which country won the most number medals in the World Weightlifting Championships?
  • Archery is the national sport of which country?
  • _________ has won the Cricket World Cup for the maximum number of times.
  • The duration of the Football game is?
  • How much time are professional golf Tour Players given per shot?

Take and other General Knowledge Quiz

MCQs in Statistics

General Knowledge Capitals Quiz 5

by

The Test is about the general knowledge Capitals Quiz in the form of Multiple Choice Questions that are useful for the different types of examinations conducted by FPSC, NTS, KPPSC, PPSC, SPSC, BPSC, OTS, UTs, PTs, CTs, ATs, and other government testing agencies of Pakistan. Let us start with the General Knowledge Capitals Quiz.

Please go to General Knowledge Capitals Quiz 5 to view the test

All the quizzes about General Knowledge consist of MCQs related to the World Geography, Atmosphere, Science and literature, events that occurred all around the world Current Affairs, Pakistan Affairs, and International Organizations. Performing these quizzes successfully will enable you to pass your exam/test with good grades/Marks in the General Knowledge portion of the test.

General Knowledge questions are included almost in all of the tests and exams being conducted for job or promotion purposes conducted by the Federal Public Service Commission (FPSC), Khyber Pakhtunkhwa Public Service Commission (KPPSC), Punjab Public Service Commission (PPSC), Sindh Public Service Commission (SPSC), Balochistan Public Service Commission (BPSC), Azad Jammu & Kashmir (AJKPSC), National Testing Service of Pakistan (NTS), Pak Army, Navy, PAF, ISSB, and other organization.

A good command of the General Knowledge will enable you to secure good marks in the Gk portion of the test. Note that nowadays, General Knowledge questions are now part of admission tests too.

General Knowledge Capitals Quiz

General Knowledge Capitals Quiz

  • The capital of Austria is?
  • Which Asian Capital city was known as Batavia until 1949?
  • San Juan is the capital of which island in the West Indies?
  • Of which Caribbean country is Port-au-Prince the capital?
  • What is the capital of Morocco?
  • Of which Middle East, country is Baghdad the Capital?
  • What is the capital of Poland?
  • Manama is the capital of which country?
  • Of where is Amman the capital?
  • Addis Ababa is the capital of which country?
  • What is the capital of Libya?
  • Which city was the first capital of the Kingdom of Italy until 1865?
  • Kathmandu is the capital of which country?
  • The capital of Pakistan is
  • The capital of India is
  • The capital of Afghanistan is
  • The capital of Iran is
  • The capital of Iraq is
  • The capital of Saudi Arabia is
  • The capital of China is

Perform another General Knowledge Quiz

R Programming Language