FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!

Quiz about Tips and Tricks in Microsoft Excel

Tips and Tricks in Microsoft Excel Quiz

Have you ever wondered how to make a boring spreadsheet into an eye-catching chart? Or how to process your data quicker and better? Hopefully my quiz will help out. All the tricks in here have been tested in Excel 2000.

A multiple-choice quiz by ozzz2002. Estimated time: 5 mins.

Author
ozzz2002

Time
5 mins

Type
Multiple Choice

Quiz #
125,695

Updated
Dec 03 21

# Qns
10

Difficulty
Tough

Avg Score
6 / 10

Plays
2678

Awards
Top 10% Quiz

One at a Time - Single Page - Timed Game

Question 1 of 10

1. I have a collection of data about monthly sales of three different types of widgets. The numbers are arranged in 4 columns of three rows. My cursor is in cell A2, which contains the sales of red widgets in January. What will happen if I press the F11 key? Hint

Nothing

A new chart is created

Totals are inserted under each column

A formula box opens

NEXT>

Question 2 of 10

2. If you see a small red triangle in the top right corner of a cell, it means there is something 'attached' to the cell. What is it? Hint

A Hyperlink

A Macro

A Comment

A Formula

NEXT>

Question 3 of 10

3. Functions are a very important part of Excel's number-crunching power. Which function would be the best to use to calculate the payout value of a term deposit? Hint

RAND

MAX

NEXT>

Question 4 of 10

4. On the standard Excel toolbar, there is a button that looks like a malformed Z. It is the Sigma button, but what common function is it used for? Hint

Auto-Saving

Totalling a column or row

Sorting Data

Recording a macro

NEXT>

Question 5 of 10

5. It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?

Yes

NEXT>

Question 6 of 10

6. What is the correct syntax for typing a function into a cell? Hint

Function name, equals sign, argument

Function name, argument, equals sign

Equals sign, function name, matching brackets

Equals sign, function name, result

NEXT>

Question 7 of 10

7. Like most other Microsoft applications, there are usually several different methods to achieve the same result. Which of these operations will NOT bring up the 'Format Cells' dialog box? Hint

Pressing Ctrl +1

Pressing F7

Pressing Alt +o, then Alt + e

Clicking on Format, then Cells

NEXT>

Question 8 of 10

8. Excel has one of the seemingly obligatory animated 'assistants' that are either a help, or just a nuisance that always seem to be in the road. What is the name of the friendly pooch that comes out of his kennel to assist? Hint

The Dot

Rocky

Links

Ruff

NEXT>

Question 9 of 10

9. I have a large spreadsheet monitoring production volumes measured against production targets. I wish to highlight any extreme volume variances in colours. Is this possible?

Yes

NEXT>

Question 10 of 10

10. I have imported a lot of address data in .CSV (comma-separated values) format to my spreadsheet. Column A contains an apartment number, column B is the street number, Column C contains the street name, Column D holds the street type (Rd, St, Av, etc). I would like all these values to be in the same cell without having to cut and paste every entry; what function would I use? Hint

This is not possible in Excel

CreateString

JoinCells

Concatenate

(Optional) Create a Free FunTrivia ID to save the points you are about to earn:

Select a User ID:

Choose a Password:

Your Email:

Quiz Answer Key and Fun Facts

Answer: A new chart is created

Hitting this key will open a new worksheet called 'Chart1'. The default chart type is a 2-D column chart, although this can be changed if required. Alt-F1 will do the same thing.

2. If you see a small red triangle in the top right corner of a cell, it means there is something 'attached' to the cell. What is it?

Answer: A Comment

Comments (or notes) enable you to leave messages to yourself and others. Possible uses could include- explanations of a complicated formula, providing feedback to another user or reminder notes to yourself. Comments can be hidden and unhidden by right-clicking on the cell and selecting 'show' or 'hide'. If you hover your cursor over the cell, the comment is also viewable.

3. Functions are a very important part of Excel's number-crunching power. Which function would be the best to use to calculate the payout value of a term deposit?

Answer: FV

The correct syntax for this formula is =FV(rate,nepr,pmt,pv,type) where rate is the interest rate per period, nper is the number of payment periods, pmt is the payment made per period (if any), pv is the present value or the initial deposit, and type indicates whether the interest is paid at the beginning or end of the month.
FV stands for Future Value.
=RAND is a function that returns a random number, =LN will return the natural log of a number and =MAX will return the largest number in a selected range.

4. On the standard Excel toolbar, there is a button that looks like a malformed Z. It is the Sigma button, but what common function is it used for?

Answer: Totalling a column or row

Select the cell where you want the total, and Excel will attempt to 'guess' which cells you want added.

5. It is normal practice that numbers are treated as decimals when entering into a cell, but is it possible to enter a fraction (eg 3/4) into a cell in Excel?

Answer: Yes

Usually Excel will read this as a date- in this example, 03-Apr (04-March in USA), but if you type a zero (or any other number), space and THEN 3/4, it will show as a fraction.

6. What is the correct syntax for typing a function into a cell?

Answer: Equals sign, function name, matching brackets

Most functions also include an argument, eg, =MAX(C5:C12), will return the maximum value in the cell range C5 to C12. There are, however, several functions that do not require an argument for them to work. An example is =PI(), which will return PI to 15 decimal places.

7. Like most other Microsoft applications, there are usually several different methods to achieve the same result. Which of these operations will NOT bring up the 'Format Cells' dialog box?

Answer: Pressing F7

The F7 key activates the spell checker. The Format Cells option contains commands for changing fonts, colours, alignment and borders.

Answer: Rocky

'Links' is a purring kitten, 'The Dot' is, well, a red dot and Ruff is Dennis the Menace's dog. The ridiculous paperclip is also present in Excel, but please do not use it when I am around- it annoys the daylights out of me! The Office Assistant can be turned off by right-clicking on the animation, and then selecting 'Hide'.

9. I have a large spreadsheet monitoring production volumes measured against production targets. I wish to highlight any extreme volume variances in colours. Is this possible?

Answer: Yes

There are several ways to do this, but I would use 'Conditional Formatting'. Select all the cells where you want the volume figures to show, click on Format/Conditional Formatting (Alt o, then alt d) and add the conditions. eg, if your target was 500, and you want to see all volume figures that are less than 400, or greater than 600, set 'Condition one' to, say, red formatting, and 'Condition two' to blue.

Answer: Concatenate

The syntax is =Concatenate(a1, "/",b1, " ",c1, " ",d1). The quotation marks are required if spaces are required between each variable. The '/' character can be inserted to make the completed field read (for example) "2/32 Scott St".

Source: Author ozzz2002

This quiz was reviewed by FunTrivia editor crisw before going online.
Any errors found in FunTrivia content are routinely corrected through our feedback system.