The extension of the database file in Excel is
(a) .doc
(b) .xls
(c) .bmp
(d) .dbf
A spreadsheet program contains related worksheets and documents.
(a) Workbook
(b) Column
(c) Cell
(d) Formula
A _____ is a data collection stored electronically as a series of records in a table.
(a) spreadsheet
(b) cell
(c) database
(d) pivot table
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
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
How is data organized in a spreadsheet?
(a) Rows and Columns
(b) Boxes
(c) Tables
How many characters can be typed in a single cell in Excel?
(a) 256
(b) 1024
(c) 32,000
(d) 65,535
What is the intersection of a column and a row on a worksheet?
(a) Column
(b) Value
(c) Address
(d) Cell
A spreadsheet program is a set of worksheets in the same file.
(a) Formula
(b) Label
(c) Workbook
(d) Value
Related: Microsoft Word quiz questions
Which area in Excel allows entering values and formulas
(a) Title bar
(b) Menu bar
(c) Formula bar
(d) Standard toolbar
A is the intersection of a row and a column in a worksheet.
(a) Cell
(b) Formula bar
(c) Ruler
(d) Frame
Getting data from a cell located in a different sheet is called __
(a) Accessing
(b) Referencing
(c) Updating
(d) Functioning
In the Excel spreadsheet, the currently active cell is indicated by
(a) Cell Pointer
(b) Formula bar
(c) Toolbar
Microsoft Excel is also called _
(a) Document
(b) Table
(c) Spreadsheet
(d) Label
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
How is data organized in a spreadsheet?
(a) Lines and spaces
(b) Layers and planes
(c) Height and width
(d) Rows and columns
__ is used to study the relationship between variables.
(a) Pie Chart
(b) Line chart
(c) Column chart
(d) Scatter Plot
What does the VLOOKUP function do?
(a) Looks up text that contains ‘v.’
(b) Checks whether the text is the same in one cell as in the next
(c) Finds related record
Related: Elementary mathematics quiz
__ is used to display values in ascending or descending order.
(a) Filtering
(b) Sorting
(c) Numbering
(d) Formatting
Getting data from a cell located in a different sheet is called
(a) Accessing
(b) Referencing
(c) Updating
(d) Functioning
What term refers to a specific set of values saved with the workbook?
(a) Range
(b) Scenario
(c) Trendline
(d) What-if analysis
Which of the following formulas in Excel is used for exponential operation?
(a) ^
(b) +
(c) *
(d) /
If you begin typing an entry into a cell 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
When integrating MS Word and Excel, Word is usually the
(a) Server
(b) Source
(c) Client
Related: Cyber security quiz for students
How many worksheets does a workbook typically consist of?
(a) 3
(b) 2
(c) 1
(d) 4
Excel Probably considers the cell entry January 1, 2000, to be a
(a) Label
(b) Value
(c) Formula
(d) Text String
What does this signify when you see a cell with a red triangle in the top right corner?
(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
The operator to estimate the mean is
(a) =COVAR ()
(b) = MODE ()
(c) =AVERAGE ()
(d) =MEDIAN ()
The horizontal and vertical lines on a worksheet are called:
(a) cells
(b) sheets
(c) block lines
(d) gridlines
Which function will you use to enter the current time in a worksheet cell?
(a) =today()
(b) =now()
(c) =time()
(d) =currentTime()
Related: photoshop quiz
The intersection of a raw and a column is known as
(a) Cell
(b) chart
(c) Formula
(d) Value
Which tab provides the option to set chart and axis titles?
(a) Insert
(b) Layout
(c) View
(d) Design
The autofill feature
(a) Extends a sequential series of data
(b) Automatically adds a range of cell values
(c) Applies a border around selected cells
_____ cells involves creating a single cell by combining two or more selected cells.
(a) Formatting
(b) Merging
(c) Embedding
(d) Splitting
Which type of data can you enter 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
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
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 the operating system
Which of the following defines a formula in Excel?
(a) &
(b) *
(c) ^
(d) =
What symbol is used before a number to make it a label?
(a) “(quote)
(b) = (equal)
(c) _ (underscore)
(d) ‘(apostrophe)
You can activate a cell by
(a) Pressing tab key
(b) clicking the cell
(c) Pressing an arrow key
(d) All of the above
Which of the following formulas needs to be entered correctly?
(a) =10+5
(b) =5*9
(c) 2+4
(d) =10/2
How is data organized in a spreadsheet?
(a) Lines and spaces
(b) Layers and planes
(c) Height and width
(d) Rows and columns
Related: internet question
Formulas built-in into a spreadsheet are called
(a) Formulas
(b) conditions
(c) Functions
(d) Labels
The menu for locating regression in MS Excel is
(a) Format
(b) Tools
(c) Insert
(d) Data Analysis
Which of the following is an operator for defining natural logarithms in an excel worksheet
(a) =Ni()
(b) =Ln()
(c) =^()
(d) =log()
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
Which among the following represents a range-type cell reference in Excel?
(a) (A10:A20)
(b) (B10,B20)
(b) (A10,A20)
(d) A10 92
Which among the following represents an individual cell reference in Excel?
(a) (C10:C20)
(b) (D10,D20)
(c) (A10,A20)
(d) F10 93
Related: information security quiz questions and answers
Which of the following is not an essential step in creating a worksheet?
(a) Save workbook
(b) modify the worksheet
(c) Enter text and the data
(d) copy the worksheet
An Excel workbook is a collection of
(a) Workbooks
(b) Worksheets
(c) Charts
The operator to estimate variance is
(a) =COVAR ()
(b) =VAR ()
(c) =STDEV ()
(d) =KURT ()
The operator to estimate standard deviation is
(a) =COVAR ()
(b) =VAR ()
(c) = STDEV ()
(d) =MEDIAN ()
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
The keyboard shortcut for the cut command is
(a) Ctrl+C
(b) Altl+C
(c) Ctrl+X
(d) Alt+V
Which methods cannot be used to enter data in a cell?
(a) Pressing an arrow key
(b) pressing a tab key
(c) Pressing escape key
(d) clicking on the formula bar
The keyboard shortcut for the Paste command is
(a) Ctrl + V
(b) Ctrl + P
(c) Ctrl + J
(d) Alt+P