facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Shortcuts for Formatting Numbers Test

Free Online Microsoft Excel Tests
Excel 2010 & Excel 2013

* Shortcuts for Applying Formats
* Shortcuts for General Number & Scientific Number Formats
* Shortcuts for Time and Date Format
* Shortcuts for Percentage Format
* Shortcuts for Currency Format


10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Shortcuts for Formatting Numbers Test

1) Peter created a spreadsheet for his market stall.  See screenshot of his worksheet below this question.  He wants to be able to quickly format the Cost and Retail columns to include a currency (USD) symbol.  Which of the following shortcut combinations will allow him to do this?
a) Select the contents of the two columns and press Alt+Shift+$
b) Select the contents of the two columns and press Ctrl+c
c) Select the contents of the two columns and press Ctrl+#
d) Select the contents of the two columns and press Ctrl+Shift+$
Question 1 - Excel Keyboard Shortcuts for Formatting Numbers Test
2) Peter keeps having difficulty with the time column in his worksheet (see screenshot below).  Which shortcut could he use to format the number values in the Time column to display as time on a 24 hour clock?
a) Select the contents and press Ctrl+t 
b) Select the contents and press Ctrl+@+t
c) Select the contents and press Ctrl+Shift+@
d) Select the contents and press Alt+Shift+@

Question 2 - Excel Keyboard Shortcuts for Formatting Numbers Test
3) Which of the options below best describes the function of the following shortcut:  Ctrl+Shift+~ (tilde)?
a) It will clear the time format applied to the contents of a cell changing it to the general format (for example 20:53 will become 0.870138888888889).
b) It will clear the date format applied to the contents of a cell changing it to the general format (for example 11/10/2014 will become 41923).
c) It will clear the percentage format applied to the contents of a cell changing it to the general format (for example 33% will become 0.33333333).
d) All of the above options are correct.

4) Peter used a formula to convert the numbers in the Profit Margin column in the screenshot below so that the number values display as decimals.  He then used a further formula to convert them to display as percentages.  What is a shortcut he can use to change the display of number values to percentages in future?
a) Selecting the contents of the column and pressing Ctrl+Shift+%
b) Selecting the contents and pressing the % symbol on the keyboard.
c) Selecting the contents and pressing Ctrl+p
d) All of the above options are correct.

Question 4 - Excel Keyboard Shortcuts for Formatting Numbers Test

5) Study the screenshot of Peter's worksheet above this question.  What is a quick shortcut for Peter to format the Date column so that all dates display in the same format: day-month-year?
a) Select the column and press Ctrl+Shift+d
b) Select the column and press Alt+d
c) Select the column and press Ctrl+# or Ctrl+Shift+# (depending on where the # is located)
d) None of the above options are correct


6) What is the purpose of the shortcut combination Ctrl+Shift+! (exclamation)?
a) It adds an exclamation mark after all numbers in a selection that have more than two decimal places.
b) It formats numbers by highlighting all numbers in a selection that have a thousands separator and/or decimal places.
c) It formats numbers to add a minus sign in front of all numbers that contain more than two decimal places and/or a thousands separator.
d) It formats numbers with two decimal places, thousands separator and a minus sign for negative numbers.

7) To quickly repeat your last number formatting action to a selected cell or cells, you could use which of the following shortcut key combinations?
a) Select the cell or cells to repeat the formatting on and press F4
b) Select the cell or cells to repeat the formatting on and press Ctrl+Shift+v
c) Select the cell or cells to repeat the formatting on and press Ctrl+Shift+r
d) Select the cell or cells to repeat the formatting on and press Ctrl+Shift+F4

8) Study the screenshot of the Format Cells dialogue box below this question.  This dialogue box provides multiple options to tweak any number formatting you apply to a cell.  Which of the following shortcut key combinations launches this dialogue box?
a) Pressing Ctrl+Shift+F will launch the Format Cells dialogue box.
b) Pressing Ctrl+Shift+F4 will launch the Format Cells dialogue box.
c) Pressing Ctrl+F1 will launch the Format Cells dialogue box.
d) Pressing Ctrl+1 will launch the Format Cells dialogue box.
Question 8 - Excel Keyboard Shortcuts for Formatting Numbers Test

9) James wants to insert product numbers into a worksheet and then use formulas and functions that sort and use the product numbers.  However, Excel keeps on reading and reformatting the product numbers as numerical values.  What can James do to prevent Excel from reading the product numbers as numerical values?
a) After entering the value into the cell pressing Ctrl+Shift+~ (tilde) will fix this issue.
b) Before entering the value into the cell pressing Ctrl+Shift+# will prevent this issue.
c) Before entering the value into the cell inserting an ' (apostrophe) will prevent this issue.
d) After entering the value into the cell pressing Ctrl+' (apostrophe) will fix this issue.

10) What will be the result if you select a cell that contains the general formatted value: 5 and press Ctrl+Shift+%?
a) It will display 500%.
b) It will display 5.00%.
c) It will display 50%.
d) It will display 5%.