Advanced Excel (Intermediate Level)

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

Your Name *

Mention Name Correctly. It will be printed on Certificate.

Repeats the last command or action *

1 point

Ctrl + C

Ctrl + R

Ctrl + U

Ctrl + Y

_____ are equations that perform calculations on values in your worksheet. *

1 point

Functions

References

Formulas

Constants

Press _____ to bring up search box. *

1 point

Shift + F3

Shift + F4

Shift + F5

Shift + F6

In ______ tab you will find AutoSum button. *

1 point

Formatting tab

Formulas tab

Standard tab

Clipboard tab

Press _____ to create a chart. *

1 point

F11

F12

While selecting multiple worksheets in Excel, the following key must also be used when clicking the sheet ta *

1 point

Alt

Ctrl

Shift

Insert

This dialog box specifies or modifies the worksheet cell range containing data to be charte *

1 point

Chart Location

Chart Style

Chart Options

Chart Source Data

Which of the following is the purpose of AutoSum? *

1 point

Display the sum of the selected cells directly after the selected cells

Display the sum of the selected cells directly before the selected cells

Don’t add the grand total

All of these

The default file extension of MS Excel is *

1 point

Xlr

Exe

Xls

Exl

By default the cell content alignment is *

1 point

Text left aligned and number right alignment

Text right aligned and numbers left alignment

Left aligned

Centrally aligned

Excel probably considers the cell entry January 1, 2000 tobe a

1 point

Label

Value

Formula

Text string

Clear selection

You can enter which types of data into worksheet cells? *

1 point

Labels, values, and formulas

Labels and values but not formulas

Values and formulas but not labels

Formulas only

All worksheet formula *

1 point

Manipulate values

Manipulate labels

Return a formula result

Use the addition operator

The Paste Special command lets you copy and paste: *

1 point

Multiply the selection by a copied value

Cell comments

Formatting options

The resulting values of a formula instead of the actual formula

The numbers in our worksheet look like this: You want them to look like this: $1,000. How can you accomplish this? *

1 point

None of these

Select Format > Money from the menu

Click the Currency Style button on the formatting toolbar

You have to retype everything and manually add the dollar signs, commas, and decimals.

Which of the following is not a valid data type in excel *

1 point

Number

Character

Label

Date/time

Without using the mouse or the arrow keys, what is thefastest way of getting to cell A1 in a spreadsheet? *

1 point

Press Ctrl +Home

Press Home

Press Shift + Home

Press Alt + Home

If you begin typing an entry into a cell and then realize thatyou don’t want your entry placed into a cell, you: *

1 point

Press the Erase key

Press Esc

Press the Enter button

Press the Edit Formula button

To view a cell comment *

1 point

click the edit comment command on the insert menu

click the display comment command on the window menu

position the mouse pointer over the cell

click the comment command on the view menu

When you want to insert a blank embedded excel object in aword document you can *

1 point

Click the object command on the insert menu

Click the office links button on the standard toolbar

Click the create worksheet button on the formatting toolbar

Click the import excel command on the file menu

You can select a single range of cells by *

1 point

Clicking the upper-left cell in a group of cells and then pressing theShift key while clicking the lower right cell in a group of cells

Pressing the Ctrl key while dragging over the desired cells

Pressing the Shift key and an arrow key

Dragging over the desired cells

Which elements of worksheet can be protected fromaccidental modification *

1 point

Contents

Objects

Scenarios

All of above

You can use the drag and drop method to *

1 point

Copy cell contents

Move cell contents

Add cell contents

a and b

It is acceptable to let long text flow into adjacent cells on aworksheet when *

1 point

Data will be entered in the adjacent cells

No data will be entered in the adjacent cells

There is no suitable abbreviation of the text

There is not time to format the next

How can you delete a record? *

1 point

Delete the column from the worksheet

Select Data > Form from the menu to open the Data Formdialog box, find the record and Click the Delete button

Select Data > Delete Record from the menu

Click the Delete button on the Standard toolbar

Which menu option can be sued to split windows into two *

1 point

Format > window

View > window > split

Window > split

View > split

Which of the following formulas will Excel Not be able tocalculate? *

1 point

=SUM(Sales)-A3

=SUM(A1:A5)*.5

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)-10

The chart wizard term data series refers to *

1 point

A chart legend

A collection of chart data markers

A set of values you plot in a chart

A data label

Tab scrolling button *

1 point

Allow you to view a different worksheet

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

Allow you to view additional sheets tabs

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 are creating a formula to calculate the total revenue from ticket sales, and want to be able to copy this down to give the correct result for each row: *

1 point

If the mouse pointer is in the position shown in the diagram, which key should you press to make the formula correct?

You have 7 cells selected, and see the following in the Excel status bar: *

1 point

How would you see the average of the selected cells?

Double-click and choose it from the list which appears

You can't

Right-click and choose it from the list which appears

Go into the FILE / OPTIONS menu, and tick the box next to the statistic that you want to appear in the status bar

Consider the following two functions: *

1 point

What is the difference between them?

The first function is made-up, while the second one exists in Excel and gives the current date and time

The first function returns midnight on the current day, while the second one returns the current date and time

The first one will give today's date which will not subsequently update, whereas the second one will always give the current date

There isn't one - they're interchangeable

You are on cell A1 and press CTRL + the down arrow key, to take you to the last row in your worksheet: *

1 point

Assuming all the cells in column A are blank, which cell will this take you to?

A999999

A1024000

A1000000

A1048576

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

Consider this screen shot from Excel: *

1 point

In all probability, what is this showing?

Formula auditing errors

Inconsistent formula

Circular references

Data validation errors

You want to create a chart comparing silver medals won for the 5 leading countries for a particular Olympic Games, and plan to select data as per the shaded cells: *

1 point

Why won't this plan lead to the correct chart being created?

Charts must contain at least 2 data series

It will

You can't create a chart from non-adjacent areas

Because you haven't included cell A3 in your selection

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

You realise that you've made a mistake: you bought 13 tins of baked beans, not just 1: *

1 point

When you change the value of cell E2 shown selected above, what will a pivot table based on this data do?

It won't automatically update to show the correct new figures until you refresh it

It will never update to show the new figures (you'll need to create a new pivot table)

It will automatically update to show the correct new figures

It wouldn't be possible to create a pivot table based on this data

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 a pop-up dialog box, asking you what percentage you want to multiply this figure by

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

You are entering a formula, and change your mind: *

1 point

Instead of clicking on the red cross shown selected above, which key could you press to abandon this formula?

ESC

Space bar

Backspace

The formula in the pink cell in this screen shot currently reads =D8*E5.

1 point

Why won't copying this down give the correct cost estimate for each task?

Because the reference to the task duration in hours is absolute, whereas it should be relative

Because the reference to the hourly rate is relative, whereas it needs to be absolute

It will

Because you can't copy formulae down to adjacent cells in an Excel worksheet

Clear selection

You are typing in the CELL function:

1 point

Most of the arguments are omitted from the screen shot. Which of the following arguments would you see in the list, if you could see the full picture?

sheet name

tab name

worksheet name

Filename

Clear selection

Submit

Clear form

Never submit passwords through Google Forms.

This form was created inside of IPS BUSINESS SCHOOL. Report Abuse

Forms