Advanced Excel (Beginner Level)

Your Name *

Mention Name Correctly. It will be printed on Certificate.

What is the keyboard shortcut key to lock cell references in a formula? *

1 point

CTRL

ALT

F2

F4

Which of the following is the correct formula to calculate the average score in cell C7 as shown below? *

1 point

SUMPRODUCT(C2:C5,B2:B5)

SUMPRODUCT(C2:C4,B2:B4)

AVERAGE(B2:B4)

AVERAGE(C2:C4)

What are the shortcut keys to insert a new cell in an Excel spreadsheet? *

1 point

ALT + H + I + R

ALT + H + I + C

ALT + H + I + I

ALT + H + I + S

Which of the following Excel features allows you to select/highlight cells in all Formula? *

1 point

Find

Replace

Go To

Go To Special

What formula can be used in cell to mention current date? *

1 point

=DATE(B17)

=EDATE($B$17,G17)

=TODAY(B17)

=TODAY()

Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer? *

1 point

=MROUND(A1,100)

=MROUND(A1,10)

=ROUND(A1,0)

=ROUND(A1,1)

Which of the following features cannot be found in the Data ribbon? *

1 point

What-If Analysis

PivotTable

Data Validation

Text to Columns

Which tab of the ribbon should you go to for removing gridlines on a worksheet? *

1 point

Formulas

View

Review

Developer

What is range of Column in MS Excel *

1 point

A to 16384

16384

XFD to 16384

A to XFD

How many cells are present in Single Excel Sheet? *

1 point

10,48,546 x 16,385

10,48,576 x 16,384

A to XFD

10,48,576

An Excel file is called a workbook?

1 point

True

False

Clear selection

To add color to a row or column you click the ___. *

1 point

Click the font color button.

Fill color button (paint pail)

Set a colored border

You can create mixed references by placing a dollar sign in front of only the column letter or only the row number. *

1 point

True

False

You can insert a row by right clicking a column heading. *

1 point

True

False

You can cut and paste data from one cell into another. Instead of using the mouse to do the cut and paste, you can use the keyboard. To cut press _________; to paste, press __________. *

1 point

CTRL+X and CTRL+V

CTRL+C and CTRL+V

CTRL+A and CTRL+V

CTRL+V and CTRL+X

The Conditional Formatting feature is used to: *

1 point

Set the default cell format

Format conditional statements

Format cells conditional on the text size

Change the style of cells meeting a condition

How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4? *

1 point

=A1X6/4

=A1X6%4

=A1*6/4

=A1*6%4

The shortcut key to “undo” an action in Excel 2010 is: *

1 point

CTRL+PAGE UP

CTRL+HOME

CTRL+Z

CTRL+C

What is the default file extension when you save a workbook for Excel 2010? *

1 point

.xls

.xlsx

excel

.xlav

You want to work out the volume of something as the length times the height: *

1 point

What would be the best formula to type into the cell shown? If you know the answer, choose it below:

=9*3.5

=A2*B2

=A2XB2

=9x3.5

In the dialog box below, the first tab has been hidden: *

1 point

What should it say? If you know the answer, choose it below:

Recommended charts

Best fit for data

Frequently used

Chart Templates

You have the following mouse pointer in Excel: *

1 point

What are you doing?

Colouring cell borders

Changing the fill colour of cells

Copying cell formats

Erasing the contents of cells

In the following chart, the totals dwarf all of the other values, making the chart difficult to interpret: *

1 point

What chart type should you choose to get round this?

Combo

Two-axis

Overlay

Mixed

You see a table of tall buildings like this: *

1 point

What icon on the DATA tab of the ribbon has been selected to get the arrows next to each column header to appear?

FILTER

WHERE

QUERY

SELECT ROWS

You have a pivot table visible in Excel, and double-click on the cell shown: *

1 point

What will happen?

Excel will bring up a dialog box giving information about the cell

Excel will create a worksheet listing all of the rows which make up this cell

Excel will bring up a panel of pivot table autoformat choices

Excel will bring up the pivot table wizard

In the screen shot below, the dates have been coloured according to when they occur: *

1 point

What's the easiest way to achieve this?

Set the colour as part of the custom number format code

In TOOLS / OPTIONS, tick the APPLY CHRONOLOGICAL FORMATS box

It will happen by default in Excel

Select the date range and set conditional formatting rules

You hover over the selected tool in the Excel status bar: *

1 point

What does this show?

Worksheets side by side

Headers and footers

Formulas for all cells, rather than values

Page break preview

With cell B2 selected, you choose the following option: *

1 point

Which of these gives the best description of what will happen?

The screen will be split into 4 independently scrolling areas

As you scroll to the right, column A will remain visible

As you scroll down and to the right, column A and row 1 will remain visible

As you scroll down, row 1 will remain visible

You have this mouse pointer visible on screen: *

1 point

If you double-click, what will happen?

You will bring up the cell's INFO box

You will copy the number 56 down to the 6 cells beneath it

Nothing

You will be able to edit the formula or number in the cell

You select data as shown and press F11: *

1 point

What will happen?

A dialog box will appear asking you to confirm that you want to create a chart

You'll get a chart in a separate sheet

You'll get a chart embedded on the current sheet

The chart wizard will appear on screen

With a cell containing the value 20 selected, you click on the tool shown below: *

1 point

What will happen?

Excel will display 2000% in the cell

Excel will display 20% in the cell

Excel will display 200% in the cell

Excel will display an error message, explaining that you can't make this number into a percentage

In MS EXCEL which chart is known as XY Chart *

1 point

Pie Chart

Scatter Chart

Bar Diagram

Histogram

It is a collection of data that is stored electronically as a series of records in a table. *

1 point

Spreadsheet

Presentation

Database

MS Word

Where is the fill handle located? *

1 point

Top of Form

At the beginning of any formula or function

On the right side of the Home tab on the Ribbon

In the bottom-right corner of the selected cell

In Backstage View Bottom of Form

You can click the tabs at the bottom of a workbook to switch between top of Form *

1 point

worksheets

formulas

number formats

permissions

You can enter two basic kinds of data into worksheet cells: *

1 point

Numbers and text

Numbers and figures

Text and charts

None of the above

The view that puts a blue line around each page that would be printed is the *

1 point

Page Break Preview

Split View

Normal

Print Preview

The Greater Than sign (>) is an example of _____ operator. *

1 point

Arithmetic

Logical

Conditional

Greater

The process of arranging the items of a column in some sequence or order is known as: *

1 point

Arranging

Autofill

Sorting

Filtering

The ____ feature of MS Excel quickly completes a series of data *

1 point

Auto Complete

Auto Fill

Fill Handle

Sorting

Except for the ______________ function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result *

1 point

=COUNT()

=AND()

=OR()

=NOT()

Which PivotTable toolbar button updates the data in a PivotTable if the data has changed? *

1 point

Refresh Data

Show Detail

Format Report

Group

Which function does not exist in Excel's function library? *

1 point

Proper

Uppercase

Upper

Lower

Which function converts miles to kilo meters, kilograms to pounds, and so on? *

1 point

Change

Convert

Product

All of above

What is the area at the intersection of a single row and column in an Excel spreadsheet referred to as? *

1 point

Window

Matrix

Sheet

Cell

To name a cell or range, you use the _______________ *

1 point

Format cells

Names Box

Define name

Paste name

On an Excel spreadsheet the active cell is indicated by *

1 point

A dotted border

A dark wide border

A blinking border

None of the above

The "Go to" dialogue appears when you press the _____________ key from keyboard. *

1 point

F8

F5

F7

F6

The intersection of a row and a column is called a ________.

1 point

worksheet

chart

cell

sum

Clear selection

A group of cells is called a ________.

1 point

multicell

cell range

cell cluster

chart

Clear selection