Skip to content

Excel MCQ Questions

0
Answered
0
Correct
0%
Accuracy
Q1151 Easy

Excel charts are either placed in their own chart sheets or embedded in a worksheet. ____________

False
True
Q1152 Easy

Which function returns the leftmost five characters in cell A1?

#VALUE!
#VALUE!
conte
Q1153 Easy

Quick keyboard combination for launching VBA:

Ctl+Alt+F11
Ctrl+F10
Alt+F11
Q1154 Easy

The ____ aggregate function finds the largest value.

Form Footer
Detail
Max
Min
Q1155 Easy

If you deselect an item from the filter menu, it is called the filter ____.

Factor
Variable
Index
Criterion
Q1156 Easy

A(n) _______ is a file that stores a collection of related data.

Database
Source
Data cube
None of these
Q1157 Easy

When you enter a two-digit year that is less than 30, excel changes the year to ____.

20xx
19xx
21xx
Q1158 Easy

What is a column on a worksheet?

A diagonal group of cells within a worksheet.
A horizontal group of cells within a worksheet.
A consecutive group of cells within a worksheet.
A vertical group of cells within a worksheet.
Q1159 Easy

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

Inner
Sub
Interactive
Embedded
Q1160 Easy

Which of the following is a statistical function? _____

INT
COUNT
MIN
AVERAGE
Q1161 Easy

To enter data in a cell, you must first select the ____.

ESC
Cell
Text
Click
Q1162 Easy

Which Excel feature allows a user to split apart values in a text string into separate fields?

Remove Duplicates
Text to Columns
Consolidate
What-If Analysis
Q1163 Easy

One way to structure text files is to use a(n) _______.

Index
Matrix
Delimiter
Register
Q1164 Easy

A collection of worksheets contained within a single file is called a ____ .

Range
Workarea
Cell
Workbook
Q1165 Easy

What is the setting that is the default macro security setting?

Disable all macros except digitally signed macros.
Enable all macros.
Disable all macros with notification.
All of the above
Q1166 Easy

Which of the following options allows us to copy content without formatting?

Drag drop
Cut and Paste
Paste Special
None of these
Q1167 Easy

How may criteria can the SUMIF function have?

3
Unlimited
1
0
Q1168 Easy

Which feature allows you to display multiple copies of your worksheet in side-by-side windows?

Subsheets
Views
Freeze
Panes
Q1169 Easy

Right clicking on a cell then selecting insert from the cell menu allows you to do what?

Nothing
Creates a formula
Add a new cell, row, or column
Insert an entirely new workbook
Q1170 Easy

True or False: If a file is saved, the actions that preceeded the save command cannot be undone.

False
True
Q1171 Easy

What's one method of entering headers and footers?

Click the File tab and go to the Info section. Under File Properties, enable headers and footers.
Click the Page Layout tab on the Ribbon. Click the Headers & Footers button.
Switch to Page Layout view. Click and type in one of the boxes at the top or bottom of the page.
Switch to Page Break Preview. Click and type in one of the boxes at the top or bottom of the page.
Q1172 Easy

Which of the following is a "Lookup and Reference" function?

Sumif
Iferror
Average
VLookup
Q1173 Easy

Which worksheet function returns the inverse of the Student

STDINV
INVTDIST
TINVERSE
TINV
Q1174 Easy

When using the PERMUT (number,number_chose) function, what syntax error will occur if the number_chosen is non-numeric?

#VALUE!
#NUM!
Q1175 Easy

Pressing CTRL-Home moves the cursor to:

The A column within the current row
The upper left cell in the active range
Cell A1
The upper right cell in the active range
Q1176 Easy

PMT (rate, nper, pv, [fv=0], [type=0]

In the figure above, fv and type are ____.
Future Value
Optional arguments
Both A & B
Q1177 Easy

Double-clicking the column line to the right of a column activates the ____ feature for the column.

Format
Page layout
Autofit
Alignment
Q1178 Easy

In Excel's PMT(rate, nper, pv, [fv], [type]) function, pv stands for the ____.

Present value of the loan
Past value of the loan
Upcoming value of the loan
None of the above
Q1179 Easy

Which of the following is not true about an offline cube file?

It stores data in the form of an OLAP cube
The file format for an offline cube file is .CUE
It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable
Q1180 Easy

What is the function of 'Relationships' or 'Data Model'?

It links multiple tables with each other and generates a powerful pivot table.
It formats the worksheets.
It adds timelines to any date column in a pivot table.
It links up VLOOKUP using multiple tables.
Q1181 Easy

To split a merged cell, select the cell and click the ____ button.

Merge and center
Hiding
Insert options
Ribbon
Q1182 Easy

Which options reflect a correct range?

B1:B30
Sheet1:Sheet3!A1:E10
'First Quarter:Fourth Quarter'!A1:F16
Shee1:A3:B30
Q1183 Easy

What conclusion could you reach if Cell B13 contained the text Apple and the formula =LEN(B13) returned 6?

There is an extra space somewhere in the text.
Cell B13 is formatted as a number.
There are 6 spaces after the word.
There is an error in the formula. The correct result should be 4 as the LEN() function does not count capital letters.
Q1184 Easy

Maria needs to find unique values in a Microsoft Excel 2010 worksheet. Which of the following is correct about selecting data for finding unique values?

Unique values can be found by selecting columns only.
Unique values can be found by selecting rows only.
Unique values can be found by selecting data from anywhere in a worksheet.
None of the above.
Q1185 Easy

To add a blank table to a page, use the table button on the ____ tab.

NEW
INSERT
HOME
VIEW
Q1186 Easy

In Excel, which function would you use to find the average of all the cells that meet multiple criteria?

AVERAGEIFS
AVERAGEA
AVERAGEIF
AVERAGE
Q1187 Easy

The report layout tools tabs are ____ tabs available only when working with report objects.

Contextual
Single record
Detail record
Wildcard character
Q1188 Easy

Excel can retrieve external data from which of the following sources?

Data Connection Wizard
All of these
SQL Server
Microsoft Query
Q1189 Easy

What is the option on the Document Inspector that finds the content type information?

Comments and Annotations
Headers and Footers
Document Properties and Personal Information
Hidden Rows and Columns
Q1190 Easy

Cell A1 contains the text string 'X489Smith1740'. To determine the number of characters in the text string, use the formula:

7
#NAME?
Q1191 Easy

Which of the following statements are correct about Microsoft Excel Online?

Excel Online is available in OneDrive.
With Excel 2010, workbooks can be published in the read-only mode.
Excel Online is available with Office Online on SharePoint 2010.
You can filter data but cannot re-calculate the values.
Q1192 Easy

A ____ is a reference to a cell or range of cells in another workbook.

Function
Formula
Code
Link
Q1193 Easy

In the formula, which symbol specifies the fixed columns or rows?

%
$
&
*
Q1194 Easy

What does CTRL(CMD)+D do?

Fill down
Deletes the active cell
Navigate to the Data ribbon
Opens the Font dialog box
Q1195 Easy

Microsoft Excel Services is a component of:

Microsoft SharePoint Technology
Microsoft Server Technology
Microsoft Virtualization Technology
Q1196 Easy

A ________ in a pie chart identifies the pie slices.

Data series
Data lable
Legend
Data marke
Q1197 Easy

Apa-style papers use ________ as the title of the list of sources.

Works Cited
References
Bibliography
Sources
Q1198 Easy

A worksheet is made up of _____ organized in a grid of rows and columns.

Record
Numbers
Cell address
Cells
Q1199 Easy

You drew a triangle on the page and want to place an exact duplicate to the right. You want to make certain that the duplicate isn't any higher or lower on the page. How can you do this?

While holding Shift, drag the triangle to the right
While holding Alt, drag the triangle to the right
While holding Alt + Shift, drag the triangle to the right
While holding Ctrl + Shift, drag the triangle to the right
Q1200 Easy

Cell A1 contains "Chang", and cell A2 contains "Pie". What is the result of the formula: =CONCATENATE(A1," ","and"," ",A2)

Change, Pie
Chang & Pie
Chang and Pie
Chang Pie
Showing 1200 of 1421 questions

Teachers: using these Excel questions with a class? Tell us about your class.

Report a mistake

What's wrong?