### MS Excel multiple choice questions:

**Ques. **The extension of database file in excel is

(a) .doc

(b) .xls

(c) bmp

(d) .dbf

**Ques. **In a spreadsheet program the contains related worksheets and documents.

(a) Workbook

(b) Column

(c) Cell

(d) Formula

**Question: **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

**Ques. **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

**Ques. **Which among the following is a valid cell address in MS Excel?

(a) A:20

(b) B;15

(c) D6

(d) 10H 90

Related: computer networking quiz

**Ques. **How are data organized in a spreadsheet?

(a) Rows and Columns

(b) Boxes

(c) Tables

(d) None of the above

**Ques. **How many characters can be typed in a single cell in Excel?

(a) 256

(b) 1024

(c) 32,000

(d) 65,535

**Question: **What is the intersection of a column and a row on a worksheet called?

(a) Column

(b) Value

(c) Address

(d) Cell

**Ques.** In a spreadsheet program, a is a set of worksheets in the same file.

(a) Formula

(b) Label

(c) Workbook

(d) Value

**Ques. **AutoSum can be used to calculate

(a) Sum

(b) Average

(c) maximum

(d) All of the above

Related: Microsoft Word quiz questions

**Ques. **Which area in an excel allows entering values and formulas

(a) Title bar

(b) Menu bar

(c) Formula bar

(d) Standard toolbar

**Ques.** In a worksheet, a is the intersection of a row and a column.

(a) Cell

(b) Formula bar

(c) Ruler

(d) Frame

**Ques. **Getting data from a cell located in a different sheet is called __

(a) Accessing

(b) Referencing

(c) Updating

(d) Functioning

**Ques. **In Excel spread sheet, the currently active cell is indicated by

(a) Cell Pointer

(b) Formula bar

(c) Toolbar

(d) None of above

**Ques. **Microsoft excel s also called _

(a) Document

(b) Table

(c) Spreadsheet

(d) Label

Related: powerpoint trivia questions

**Ques. **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)

**Ques.** How are data organised in a spreadsheet?

(a) Lines and spaces

(b) Layers and planes

(c) Height and width

(d) Rows and columns

**Ques. **__ is used to study the relationship between variables.

(a) Pie Chart

(b) Line chart

(c) Column chart

(d) Scatter Plot

**Ques. **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

Related: Elementary mathematics quiz

**Ques. **__ is used to display values in ascending or descending order.

(a) Filtering

(b) Sorting

(c) Numbering

(d) Formatting

**Ques. **Getting data from a cell located in a different sheet is called

(a) Accessing

(b) Referencing

(c) Updating

(d) Functioning

**Ques. **What term refers to a specific set of values saved with the workbook?

(a) Range

(b) Scenario

(c) Trend line

(d) What-if analysis

**Ques. **Which of the following formula in excel is used for exponential operation?

(a) ^

(b) +

(c) *

(d) /

**Ques.** 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

**Ques. **When integrating MS-Word and Excel, Word is usually the

(a) Server

(b) Source

(c) Client

(d) None

Related: Cyber security quiz for students

**Ques. **How many worksheets a workbook normally consist of?

(a) 3

(b) 2

(c) 1

(d) 4

**Ques. **Excel Probably considers the cell entry January 1, 2000 to be a

(a) Label

(b) Value

(c) Formula

(d) Text String

**Ques. **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

**Ques. **The operator to estimate mean is

(a) =COVAR ()

(b) = MODE ()

(c) =AVERAGE ()

(d) =MEDIAN ()

**Ques.** The horizontal and vertical lines on a worksheet are called:

(a) cells

(b) sheets

(c) block lines

(d) gridlines

**Ques. **Which function will you use to enter current time in a worksheet cell?

(a) =today()

(b) =now()

(c) =time()

(d) =currentTime()

Related: photoshop quiz

**Ques. **The intersection of a raw and column is known as

(a) Cell

(b) chart

(c) Formula

(d) Value

**Ques. **Which tab provides the option to set chart and axis titles?

(a) Insert

(b) Layout

(c) View

(d) Design

**Ques. **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

**Ques.** _____ cells involves creating a single cell by combining two or more selected cells.

(a) Formatting

(b) Merging

(c) Embedding

(d) Splitting

**Ques. **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

**Ques. **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

**Ques. **Which among the following represents a union type cell reference in Excel?

(a) (A10:A20)

(b) (B10:B20)

(c) (A10,A20)

(d) A10 91

Related: mcq for operating system

**Ques. **Which of the following defines a formula in excel ?

(a) &

(b) *

(c) ^

(d) =

**Ques. **What symbol is used before a number to make it a label?

(a) “ (quote)

(b) = (equal)

(c) _ (underscore)

(d) ‘ (apostrophe)

**Ques. **You can activate a cell by

(a) Pressing tab key

(b) clicking the cell

(c) Pressing an arrow key

(d) All of above

**Ques. **Which of the following formula is not entered correctly?

(a) =10+5

(b) =5*9

(c) 2+4

(d) =10/2

**Ques.** How are data organized in a spreadsheet ?

(a) Lines and spaces

(b) Layers and planes

(c) Height and width

(d) Rows and columns

Related: internet question

**Ques. **Formulas built-in into a spreadsheet are called

(a) Formulas

(b) conditions

(c) Functions

(d) Labels

**Ques. **The menu for locating regression in MS Excel is

(a) Format

(b) Tools

(c) Insert

(d) Data Analysis

**Ques. **Which of the following is an operator for defining natural logarithm in excel worksheet

(a) =Ni()

(b) =Ln()

(c) =^()

(d) =log()

**Ques.** 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

**Ques. **Which among the following represents a range type cell reference in Excel?

(a) (A10:A20)

(b) (B10,B20)

(b) (A10,A20)

(d) A10 92

**Ques. **Which among the following represents a individual cell reference in Excel?

(a) (C10:C20)

(b) (D10,D20)

(c) (A10,A20)

(d) F10 93

Related: information security quiz questions and answers

**Ques. **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

**Ques. **An excel workbook is a collection of

(a) Workbooks

(b) Worksheets

(c) Charts

(d) None of above

**Ques. **The operator to estimate variance is

(a) =COVAR ()

(b) =VAR ()

(c) =STDEV ()

(d) =KURT ()

**Ques. **The operator to estimate standard deviation is

(a) =COVAR ()

(b) =VAR ()

(c) = STDEV ()

(d) =MEDIAN ()

Related: database quizzes

**Ques. **__ refers to displaying only the rows that meet certain conditions and the remaining rows are hidden

(a) Filtering

(b) Sorting

(c) Numbering

(d) Formatting

**Ques. **The keyboard shortcut for cut command is

(a) Ctrl+C

(b) Altl+C

(c) Ctrl+X

(d) Alt+V

**Ques. **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

**Ques. **The keyboard shortcut for Paste command is

(a) Ctrl + V

(b) Ctrl + P

(c) Ctrl + J

(d) Alt+P