Microsoft Excel Test

Put your knowledge to the test by having a go at our challenging Microsoft Excel test. All of these questions are all related to the subject area. Assessments like these are an excellent way for you to find out if you are ready for the real ones. (Answers at the bottom of the page).

Microsoft Excel test multiple choice questions 

Question 1
What is a worksheet?

A.     A single page that contains cells organized in rows and columns.
B.     A blank page on which you can enter information.
C.     The User registration page for Excel.
D.     A journal and ledger that can be used for calculations.

Question 2
What is a worksheet used for;

A.     To enter company financial details onto.
B.     To create a to do list on which jobs done can be ticked off.
C.     A document on which you can autocorrect financial data.
D.     It serves as table that allows you to store, organize, and manipulate data and perform calculations.

Question 3
What is a workbook?

A.     An Excel file that contains one or more worksheets.
B.     A physical book in which you keep financial records.
C.     An Excel file that contains only one worksheet.
D.     A piece of software that allows you to conduct calculations.

Question 4
If an Excel cell shows #### what does it mean?

A.     The equation cannot be calculated.
B.     The column is not wide enough to show all of the cell contents.
C.     You cannot enter data into that call.
D.     Your license for Excel has expired.

Question 5
How do you add a new row?

A.     Simply right click the cell where you want to add the row, a new one will automatically appear.
B.     Select the cell where you want to add the row and click ctrl and R.
C.     Right click the cell where you want to add the row, select ‘insert’ from the pop-up box then select entire row’ from the list.
D.     Choose your row and then select Insert from the top menu bar and click ‘Text box’ on the far right.

Question 6
On a worksheet an active cell is shown by a;

A.     Blinking border
B.     Dotted border
C.     Darker border
D.     Red border around the cell

Question 7
A group of cells is called a;

A.     Cell range
B.     Cell cluster
C.     Chart
D.     Group bunch

Question 8
You can click the tabs at the bottom of a workbook to switch between;

A.     Formulas
B.     Worksheets
C.     Workbooks
D.     Formats

Question 9
What does Mark as Final mean as regards a Excel worksheet?

A.     It has been marked for a Senior Manager to read.
B.     The worksheet has been closed and cannot be opened again by anyone.
C.     Allows you to list yourself as the author.
D.     The editing commands are turned off, and the file becomes read-only.

Question 10
What does the SUM function in Excel do?

A.     It adds all the numbers in a range of selected cells.
B.     It subtracts the numbers in a range of selected cells.
C.     It divides the numbers in a range of selected cells.
D.     Deletes all the numbers in a range of selected cells.

Question 11
What are the shortcut keys for AutoSum? 

A.     ALT and S
B.     CTRL and S
C.     ALT and =
D.     CTRL and =

Question 12
Which of the following would be a correct formula for sum in Excel?

A.     =SUMB+C7
B.     =SUM(C1:C7)
C.     SUM(C3:C9)
D.     =ADD(C3:C9)

Question 13
Which of the following is a range address;

A.     B1;B3
B.     B1-B3
C.     B1=B3
D.     B1:B3

Question 14
By default there are 3 worksheets in a workbook.

A.     True.
B.     False

Question 15
You can view a formula by double-clicking the cell that contains the formula.

A.     True.
B.     False

Answers

1.  A
2.  D
3.  A
4.  B
5.  C
6.  C
7.  A
8.  B
9.  D
10.  A
11.  C
12.  B
13.  D
14.  True
15.  True

More free courses
Online courses