FREE! Click here to Join FunTrivia. Thousands of games, quizzes, and lots more!
Quiz about Tips and Tricks in Microsoft Excel
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.
  1. Home
  2. »
  3. Quizzes
  4. »
  5. Science Trivia
  6. »
  7. Software and Programming
  8. »
  9. Microsoft Excel

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
- -
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


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


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


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


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?


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


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


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


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?


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



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

arrow Select a User ID:
arrow Choose a Password:
arrow Your Email:




Quiz Answer Key and Fun Facts
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?

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.
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?

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.
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?

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.
11/21/2024, Copyright 2024 FunTrivia, Inc. - Report an Error / Contact Us