MS Excel Test: Trivia Quiz! MCQ

Where you can find the Sort & Filter option in Excel?

Formulas in a cell start with a _______.

• :

• {

• =

• /

Inserting Page Number is in Header and Footer.

• True

• False

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

• Yes

• No

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

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

• #

• %

• &

• $

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

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, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

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

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

Keyboard Shortcut to Edit the active Cell?

• F2

• Ctrl + E

• Alt + F4

• Alt + E

A_________ is a built in mathematical formula included in excel.

• Function

• Cell

• Formula

• Range

The Chart Tools commands are found in these three tabs? 

• Design, Shape, Layout

• Layout, Format, Type

• Design, Layout, Format

• Styles, Shapes, Effects

“Month 1, Month 2, Month 3” is an example of what?

• Series

• Function

• Formula

• Syntax

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

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

• Reference

• Constant

• Function

• Address

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

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

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

• Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

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

• MAXIMUM

• MAX

• LARGE

• LARGEST

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

• Freeze panes

• Split

• View side by side

• Mirror

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

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

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

• P72

• G$9

• $K356

• $F$8

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 activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

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

Which of following options are not available in Conditional Formatting?

• New table format

• Tab Color

• Data Bars

• Icon Sets