Microsoft Excel Quiz

Question 1 of 20

1.
MS-Excel 2003 file Extension ….?

.Xlsx
.xls
.wk1
.dox

Question 2 of 20

2.
Which Symbol must all formula begin with ?

=
+
(
@

Question 3 of 20

3.
What is the quickest way to find out the address of a cell ?

Click the cell and read the name box
Click the cell and + icon
Click the cell and page layout
Click the call and find out the row number & column label

Question 4 of 20

4.
Where can you enter a formula in a worksheet?

In the formula bar only
In a cell only
In 1 or 2 both
In the name box

Question 5 of 20

5.
What type of chart will you use to compare performance of two Employes in the year 2016?

Column chart
Line chart
Pie chart
Dot chart

Question 6 of 20

6.
A collection of worksheets is called?

Work Book
Excel Book
Excel Sheet
None of these

Question 7 of 20

7.
Statistical calculation and preparation of tables and graphs can be done using?

Excel
Notepad
PowerPoint
Adobe Photoshop

Question 8 of 20

8.
Which was the first spreadsheet on a micro-computer?

Excel
Visicalc
Lotus 1-2-3
Starcalc

Question 9 of 20

9.
Which tab in Excel is used for Proofing Protecting and marking up a Spreadsheet?

Formula
Data
Review
View

Question 10 of 20

10.
Which Key is used to make multiple line in a single cell?

Alt+Enter
Tab+Enter
Ctrl+Enter
Shift+Enter

Question 11 of 20

11.
Ctrl+Pgup will take you to?

Previous Sheet
Next Sheet
Last cell in the column
None of these

Question 12 of 20

12.
Which Command is used to closed the window of excel?

Alt +F4
Ctrl + R
Ctrl+ W
Ctrl + E

Question 13 of 20

13.
Named the Shortcut key to fill the value of just above cell?

Ctrl + D
Ctrl + E
Ctrl + T
Ctrl + O

Question 14 of 20

14.
Ctrl + I Shortcut key is used to?

Formalting cell
Auto Fill
Change the Contents of a cell to Italics
Invoke the go to option

Question 15 of 20

15.
Which Shortcut Key is used to inserts a new worksheet?

Alt + Shift + f1
Alt + Shift + f2
Alt + Shift + f3
Alt + Shift + f4

Question 16 of 20

16.
To open the Excel formula window, Press…?

Shift + F3
Shift + F4
Shift + F5
Shift + F6

Question 17 of 20

17.
Which one is not a function in MS-Excel?

SUM
AVG
MAX
MIN

Question 18 of 20

18.
In MS-Excel Permitting data values in specific range for entry in a cell is called … of data?

Validation
Sorting
Filtering
Chart

Question 19 of 20

19.
Which one is the last column header in Excel 2019?

XFD
XFX
XFL
XFT

Question 20 of 20

20.
Each Excel file is called a work book because?

It can contain text and data
It can be modified
It can contain many sheets including work sheets and chart sheets
You have to work hard to create it

Quiz-summary

Information

Results:

Categories

1.
MS-Excel 2003 file Extension ….?

2.
Which Symbol must all formula begin with ?

3.
What is the quickest way to find out the address of a cell ?

4.
Where can you enter a formula in a worksheet?

5.
What type of chart will you use to compare performance of two Employes in the year 2016?

6.
A collection of worksheets is called?

7.
Statistical calculation and preparation of tables and graphs can be done using?

8.
Which was the first spreadsheet on a micro-computer?

9.
Which tab in Excel is used for Proofing Protecting and marking up a Spreadsheet?

10.
Which Key is used to make multiple line in a single cell?

11.
Ctrl+Pgup will take you to?

12.
Which Command is used to closed the window of excel?

13.
Named the Shortcut key to fill the value of just above cell?

14.
Ctrl + I Shortcut key is used to?

15.
Which Shortcut Key is used to inserts a new worksheet?

16.
To open the Excel formula window, Press…?

17.
Which one is not a function in MS-Excel?

18.
In MS-Excel Permitting data values in specific range for entry in a cell is called … of data?

19.
Which one is the last column header in Excel 2019?

20.
Each Excel file is called a work book because?

Brilliantly

Content & Links

Please rotate your device

Average score
Your score

Download your certificate

For Candidate

For Companies

Quiz-summary

Information

Results:

Categories

1. MS-Excel 2003 file Extension ….?

2. Which Symbol must all formula begin with ?

3. What is the quickest way to find out the address of a cell ?

4. Where can you enter a formula in a worksheet?

5. What type of chart will you use to compare performance of two Employes in the year 2016?

6. A collection of worksheets is called?

7. Statistical calculation and preparation of tables and graphs can be done using?

8. Which was the first spreadsheet on a micro-computer?

9. Which tab in Excel is used for Proofing Protecting and marking up a Spreadsheet?

10. Which Key is used to make multiple line in a single cell?

11. Ctrl+Pgup will take you to?

12. Which Command is used to closed the window of excel?

13. Named the Shortcut key to fill the value of just above cell?

14. Ctrl + I Shortcut key is used to?

15. Which Shortcut Key is used to inserts a new worksheet?

16. To open the Excel formula window, Press…?

17. Which one is not a function in MS-Excel?

18. In MS-Excel Permitting data values in specific range for entry in a cell is called … of data?

19. Which one is the last column header in Excel 2019?

20. Each Excel file is called a work book because?

Brilliantly

Content & Links

Please rotate your device

1.
MS-Excel 2003 file Extension ….?

2.
Which Symbol must all formula begin with ?

3.
What is the quickest way to find out the address of a cell ?

4.
Where can you enter a formula in a worksheet?

5.
What type of chart will you use to compare performance of two Employes in the year 2016?

6.
A collection of worksheets is called?

7.
Statistical calculation and preparation of tables and graphs can be done using?

8.
Which was the first spreadsheet on a micro-computer?

9.
Which tab in Excel is used for Proofing Protecting and marking up a Spreadsheet?

10.
Which Key is used to make multiple line in a single cell?

11.
Ctrl+Pgup will take you to?

12.
Which Command is used to closed the window of excel?

13.
Named the Shortcut key to fill the value of just above cell?

14.
Ctrl + I Shortcut key is used to?

15.
Which Shortcut Key is used to inserts a new worksheet?

16.
To open the Excel formula window, Press…?

17.
Which one is not a function in MS-Excel?

18.
In MS-Excel Permitting data values in specific range for entry in a cell is called … of data?

19.
Which one is the last column header in Excel 2019?

20.
Each Excel file is called a work book because?