MS Excel Test: Trivia Quiz! MCQ

Submit

3. Formulas in a cell start with a _______.

:

{

=

/

4. Inserting Page Number is in Header and Footer.

True

False

5. Is it possible to insert an image from a file into an Excel spreadsheet?

Yes

No

6. If you select a range of cells with Value, (without using any formula) the answer (average, sum etc) will appear at the status bar

True

False

7. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

#

%

&

$

8. The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____

A1-J15

A1.J15

A1;J15

A1:J15

9. Once data is entered into a cell, can it be edited?

Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

No, once a file is saved, cell data cannot be changed

Yes, but the file must be saved with a different file name

10. Keyboard Shortcut to Edit the active Cell?

F2

Ctrl + E

Alt + F4

Alt + E

11. A_________ is a built in mathematical formula included in excel.

Function

Cell

Formula

Range

12. The Chart Tools commands are found in these three tabs?

Design, Shape, Layout

Layout, Format, Type

Design, Layout, Format

Styles, Shapes, Effects

13. "Month 1, Month 2, Month 3" is an example of what?

Series

Function

Formula

Syntax

14.

According to the picture the selected cell in yellow corresponds to:

Column A, Row A11, Cell 11

Column 11, Row A, Cell 11A

Column 11, Row A, Cell A11

Column A, Row 11, Cell A11

15. What is the name given to a value that does NOT change when used within a formula?

Reference

Constant

Function

Address

16. When number signs (#####) are displayed in the cell, it means:

The formula in the cell is wrong

There are too many characters in the cell to be displayed with the current cell width

The decimal point placement in the cell is wrong

All of the above

17. Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Count

Average

Sum

Add

18. How do you select noncontiguous cells?

Click a cell, then hold down SHIFT on the keyboard and select the other cells

Click in a cell, then hold down ALT on the keyboard as you select the other cells

Click in a cell, hold down CTRL on the keyboard and then select the other cells

19. Which function would you use to find the largest number of a selected range?

MAXIMUM

MAX

LARGE

LARGEST

20. Which feature in Excel allows you to view two spreadsheets in one window?

Freeze panes

Split

View side by side

Mirror

21. When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?

Seperate the page into two for easier printing

Use the Fit to Page option

Highlight all cells to print and print selection

None of the above

22. What does the following error mean - #REF!?

The #REF! error value occurs when a cell reference is not valid.

The #REF! error value occurs when a cell has been formatted as a currency but contains text.

The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

None of the above

23. Which of the following is mixed cell reference with a fixed row address?

P72

G$9

$K356

$F$8

24. What is a worksheet tab in Excel 2010?

A worksheet tab is used to access tools associated with the worksheet

A worksheet tab is used to move from one cell to the next cell in a worksheet

A worksheet tab is used to get help when working with Microsoft Excel 2010.

25. Which of following options are not available in Conditional Formatting?

New table format

Tab Color

Data Bars

Icon Sets

Submit