Scribd
Upload
18 views11 pages

Excel MCQ Questions and Answers

The document contains a series of multiple-choice questions related to MS Excel, covering topics such as file extensions, data organization, formulas, and functions. Each question is followed by the correct answer. The questions test knowledge on various Excel features and functionalities.

Uploaded by

joseph cenadero
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
18 views11 pages

Excel MCQ Questions and Answers

The document contains a series of multiple-choice questions related to MS Excel, covering topics such as file extensions, data organization, formulas, and functions. Each question is followed by the correct answer. The questions test knowledge on various Excel features and functionalities.

Uploaded by

joseph cenadero
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MS Excel multiple choice questions:

The extension of database file in excel is


(a) .doc
(b) .xls
(c) bmp
(d) .dbf
Hide Answer

Ans. (b)
In a spreadsheet program the contains related worksheets and
documents.
(a) Workbook
(b) Column
(c) Cell
(d) Formula
Hide Answer

Ans. (a)
A _____ is a collection of data that is stored electronically as a series of
records in a table.
(a) spreadsheet
(b) cell
(c) database
(d) pivot table
Hide Answer

Ans. (a)
Which of the following formulas will Excel Not be able to calculate?
(a) =SUM(Sales)-A3
(b) =SUM(A1:A5)*.5
(c) =SUM(A1:A5)/(10-10)
(d) =SUM(A1:A5)-10
Hide Answer

Ans. (a)
Which among the following is a valid cell address in MS Excel?
(a) A:20
(b) B;15
(c) D6
(d) 10H 90
Hide Answer

Ans. (c)
Related: computer networking quiz
How are data organized in a spreadsheet?
(a) Rows and Columns
(b) Boxes
(c) Tables
(d) None of the above
Hide Answer

Ans. (a)
How many characters can be typed in a single cell in Excel?
(a) 256
(b) 1024
(c) 32,000
(d) 65,535
Hide Answer

Ans. (d)
What is the intersection of a column and a row on a worksheet called?
(a) Column
(b) Value
(c) Address
(d) Cell
Hide Answer

Ans. (d)
Ques. In a spreadsheet program, a is a set of worksheets in the same file.
(a) Formula
(b) Label
(c) Workbook
(d) Value
Hide Answer

Ans. (c)
AutoSum can be used to calculate
(a) Sum
(b) Average
(c) maximum
(d) All of the above
Hide Answer

Ans. (d)
Related: Microsoft Word quiz questions
Which area in an excel allows entering values and formulas
(a) Title bar
(b) Menu bar
(c) Formula bar
(d) Standard toolbar
Hide Answer
Ans. (c)
Ques. In a worksheet, a is the intersection of a row and a column.
(a) Cell
(b) Formula bar
(c) Ruler
(d) Frame
Hide Answer

Ans. (a)
Getting data from a cell located in a different sheet is called __
(a) Accessing
(b) Referencing
(c) Updating
(d) Functioning
Hide Answer

Ans. (b)
In Excel spread sheet, the currently active cell is indicated by
(a) Cell Pointer
(b) Formula bar
(c) Toolbar
(d) None of above
Hide Answer

Ans. (a)
Microsoft excel s also called _
(a) Document
(b) Table
(c) Spreadsheet
(d) Label
Hide Answer

Ans. (c)
Related: powerpoint trivia questions
The auto calculate feature
(a) Can only add values in a range of cells
(b) Provides a quick way to view the result of an arithmetic operation on a
range of cells.
(c) Automatically creates formulas and adds them to a worksheet
(d) Both (a) and (c)
Hide Answer

Ans. (b)
How are data organised in a spreadsheet?
(a) Lines and spaces
(b) Layers and planes
(c) Height and width
(d) Rows and columns
Hide Answer

Ans. (c)
__ is used to study the relationship between variables.
(a) Pie Chart
(b) Line chart
(c) Column chart
(d) Scatter Plot
Hide Answer

Ans. (d)
What does the VLOOKUP function do?
(a) Looks up text that contain ‘v’
(b) Checks whether text is the same in one cell as in the next
(c) Finds related record
(d) All the above
Hide Answer

Ans. (c)
Related: Elementary mathematics quiz
__ is used to display values in ascending or descending order.
(a) Filtering
(b) Sorting
(c) Numbering
(d) Formatting
Hide Answer

Ans. (b)
Getting data from a cell located in a different sheet is called
(a) Accessing
(b) Referencing
(c) Updating
(d) Functioning
Hide Answer

Ans. (b)
What term refers to a specific set of values saved with the workbook?
(a) Range
(b) Scenario
(c) Trend line
(d) What-if analysis
Hide Answer

Ans. (b)
Which of the following formula in excel is used for exponential operation?
(a) ^
(b) +
(c) *
(d) /
Hide Answer

Ans. (a)
If you begin typing an entry into acell and then realize that you don’t want
your entry placed into a cell, you:
(a) Press the Erase key
(b) Press esc
(c) Press the Enter button
(d) Press the Edit Formula button
Hide Answer

Ans. (b)
When integrating MS-Word and Excel, Word is usually the
(a) Server
(b) Source
(c) Client
(d) None
Hide Answer

Ans. (c)
Related: Cyber security quiz for students
How many worksheets a workbook normally consist of?
(a) 3
(b) 2
(c) 1
(d) 4
Hide Answer

Ans. (a)
Excel Probably considers the cell entry January 1, 2000 to be a
(a) Label
(b) Value
(c) Formula
(d) Text String
Hide Answer

Ans. (b)
When you see a cell with a red triangle in the top right corner, what does
this signify?
(a) There is an error in the cell
(b) There is a comment associated with the cell
(c) The font color for text in the cell is red
(d) A formula cannot be entered into the cell
Hide Answer

Ans. (b)
The operator to estimate mean is
(a) =COVAR ()
(b) = MODE ()
(c) =AVERAGE ()
(d) =MEDIAN ()
Hide Answer

Ans. (c)
The horizontal and vertical lines on a worksheet are called:
(a) cells
(b) sheets
(c) block lines
(d) gridlines
Hide Answer

Ans. (d)
Which function will you use to enter current time in a worksheet cell?
(a) =today()
(b) =now()
(c) =time()
(d) =currentTime()
Hide Answer

Ans. (b)
Related: photoshop quiz
The intersection of a raw and column is known as
(a) Cell
(b) chart
(c) Formula
(d) Value
Hide Answer

Ans. (a)
Which tab provides the option to set chart and axis titles?
(a) Insert
(b) Layout
(c) View
(d) Design
Hide Answer

Ans. (b)
The autofill feature
(a) Extends a sequential series of data
(b) Automatically adds a range of cell values
(c) Applies a boarder around selected cells
(d) None of above
Hide Answer

Ans. (a)
_____ cells involves creating a single cell by combining two or more
selected cells.
(a) Formatting
(b) Merging
(c) Embedding
(d) Splitting
View Answer

You can enter which type of data into worksheet cells?


(a) Labels, values, and formulas
(b) Labels and values but not formulas
(c) Values and formulas but not labels
(d) Formulas only
View Answer

Except for the …… function, a formula with a logical function shows the
word “TRUE” or “FALSE” as a result
(a) IF
(b) AND
(c) OR
(d) NOT
Hide Answer

Ans. (a)
Which among the following represents a union type cell reference in
Excel?
(a) (A10:A20)
(b) (B10:B20)
(c) (A10,A20)
(d) A10 91
Hide Answer

Ans. (c)
Related: mcq for operating system
Which of the following defines a formula in excel ?
(a) &
(b) *
(c) ^
(d) =
Hide Answer

Ans. (d)
What symbol is used before a number to make it a label?
(a) “ (quote)
(b) = (equal)
(c) _ (underscore)
(d) ‘ (apostrophe)
Hide Answer

Ans. (c)
You can activate a cell by
(a) Pressing tab key
(b) clicking the cell
(c) Pressing an arrow key
(d) All of above
Hide Answer

Ans. (d)
Which of the following formula is not entered correctly?
(a) =10+5
(b) =5*9
(c) 2+4
(d) =10/2
Hide Answer

Ans. (c)
How are data organized in a spreadsheet ?
(a) Lines and spaces
(b) Layers and planes
(c) Height and width
(d) Rows and columns
Hide Answer

Ans. (d)
Related: internet question
Formulas built-in into a spreadsheet are called
(a) Formulas
(b) conditions
(c) Functions
(d) Labels
Hide Answer

Ans. (c)
The menu for locating regression in MS Excel is
(a) Format
(b) Tools
(c) Insert
(d) Data Analysis
View Answer

Which of the following is an operator for defining natural logarithm in


excel worksheet
(a) =Ni()
(b) =Ln()
(c) =^()
(d) =log()
Hide Answer

Ans. (b)
In Excel, any set of characters containing a letter , hyphen, or space is
considered:
(a) a formula
(b) text
(c) a name
(d) a title
Hide Answer

Ans. (b)
Which among the following represents a range type cell reference in
Excel?
(a) (A10:A20)
(b) (B10,B20)
(b) (A10,A20)
(d) A10 92
Hide Answer

Ans. (a)
Which among the following represents a individual cell reference in Excel?
(a) (C10:C20)
(b) (D10,D20)
(c) (A10,A20)
(d) F10 93
Hide Answer

Ans. (d)
Related: information security quiz questions and answers
Which of the following is not a basic step in creating a worksheet?
(a) Save workbook
(b) modify the worksheet
(c) Enter text and the data
(d) copy the worksheet
Hide Answer

Ans. (d)
An excel workbook is a collection of
(a) Workbooks
(b) Worksheets
(c) Charts
(d) None of above
Hide Answer

Ans. (b)
The operator to estimate variance is
(a) =COVAR ()
(b) =VAR ()
(c) =STDEV ()
(d) =KURT ()
Hide Answer

Ans. (b)
The operator to estimate standard deviation is
(a) =COVAR ()
(b) =VAR ()
(c) = STDEV ()
(d) =MEDIAN ()
Hide Answer

Ans. (c)
Related: database quizzes
__ refers to displaying only the rows that meet certain conditions and the
remaining rows are hidden
(a) Filtering
(b) Sorting
(c) Numbering
(d) Formatting
Hide Answer

Ans. (a)
The keyboard shortcut for cut command is
(a) Ctrl+C
(b) Altl+C
(c) Ctrl+X
(d) Alt+V
Hide Answer
Answer. (c)
Which of the following methods cannot be used to enter data in a cell?
(a) Pressing an arrow key
(b) pressing an tab key
(c) Pressing escape key
(d) clicking on the formula bar
Hide Answer

Ans. (c)
The keyboard shortcut for Paste command is
(a) Ctrl + V
(b) Ctrl + P
(c) Ctrl + J
(d) Alt+P
Hide Answer

Answer. (a)

Common questions

Powered by AI

In Excel, data is organized in a spreadsheet using rows and columns. This tabular structure allows for efficient data management, manipulation, and presentation .

The VLOOKUP function in Excel is used to find related records by searching for a value in the first column of a range and returning a value in the same row from a specified column. This aids in organizing and retrieving data efficiently within spreadsheets .

The currently active cell in an Excel spreadsheet is indicated by the Cell Pointer, which acts as a highlight to denote the location of the active cell .

The Autofill feature in Excel benefits users by extending a sequential series of data automatically. This feature greatly aids in efficient data entry and management by eliminating repetitive manual entries, enhancing data accuracy and consistency .

Creating a single cell by combining two or more selected cells is known as 'Merging' in Excel. This process is beneficial for formatting purposes, particularly when organizing headings or consolidating information across multiple cells for clarity .

The keyboard shortcut for the Paste command in Microsoft Excel is Ctrl+V. This shortcut enhances productivity by allowing users to quickly insert copied data into a desired location without navigating through menu options .

The auto calculate feature in MS Excel provides a quick way to view the result of an arithmetic operation on a range of cells without needing to create formulas .

In MS Excel, getting data from a cell located in a different sheet is referred to as 'Referencing.' This process allows users to link and manage data across different sheets without duplicating content .

An Excel workbook, which is a collection of worksheets, allows for the organization and management of related datasets within a single file. Each worksheet can cater to different data needs, analyses, or reporting formats without cluttering the main document .

To avoid unwanted entries while typing information into a cell in Excel, users can press the Esc key. This action cancels the ongoing entry process, ensuring that no undesired data is committed to the cell .

You might also like