FINAN 4020 Shortcut Key Quiz 2

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Show hotkeys

Alt

Select visible cells

Alt ;

Auto sum - sum all the cells above

Alt =

Group using hot keys

Alt A G G

Sort in ascending order using hot keys

Alt A S A

Sort in descending order using hot keys

Alt A S D

Open sort dialog box using hot keys

Alt A S S

Filter a table or range using hot keys

Alt A T

Ungroup using hot keys

Alt A U U

Open a combo box or filter list

Alt Down

Wrap text - when inside a cell this will start a new line in that cell

Alt Enter

Format using hot keys

Alt H 0

Increase decimal using hot keys

Alt H 0

Indent using hot keys

Alt H 6

Decrease decimal using hot keys

Alt H 9

Apply all borders using hot keys

Alt H B A

Remove the outline border from the selected cells using hot keys

Alt H B N

Apply a bottom border using hot keys

Alt H B O

Apply a top border using hot keys

Alt H B P

Apply outline border to the selected cells using hot keys

Alt H B S

Top and double bottom border using hot keys

Alt H B U

Delete cells using hot keys

Alt H D

Clear all using hot keys

Alt H E A

Insert cells using hot keys

Alt H I

Format accounting using hot keys

Alt H K

Conditional formatting using hot keys

Alt H L

Format percentage using hot keys

Alt H P

Decrease indent using hot keys

Alt H S

Paste values using hot keys

Alt H V V

Name a cell using hot keys

Alt M M D

Open name dialog box using hot keys

Alt M N

Insert pivot table using hot keys

Alt N V

Insert new worksheet

Alt Shift F1

Cycle backward through open applications

Alt Shift Tab

Cycle forward through open applications

Alt Tab

Freeze and unfreeze panes using hot keys

Alt W F F

Move to next cell

Arrow key

Displays the quick analysis options for your data when you have cells that contain that data selected

Crtl Q

Copy the value from the cell above the active cell into the cell or formula bar

Ctrl '

Hide columns

Ctrl 0

Open format dialog

Ctrl 1

Hide rows

Ctrl 9

Enter the current date

Ctrl ;

Select all

Ctrl A

Move to next section of text

Ctrl Arrow key

Bold highlighted section

Ctrl B

Copy

Ctrl C

Fill down command to copy the contents and format of the topmost cell of a selected range into the cells below

Ctrl D

Move to the end of line of text (or region)

Ctrl End

Enter the same data or formula into all cells selected

Ctrl Enter

Find

Ctrl F

Minimize / maximize currently selected window

Ctrl F10

Print preview

Ctrl F2

Minimize current window

Ctrl F9

Find & replace

Ctrl H

Move to beginning of line of text (or region)

Ctrl Home

Italic highlighted selection

Ctrl I

New workbook

Ctrl N

Bring up the print dialog box to begin printing

Ctrl P

Switches between worksheet tabs, from left-to-right

Ctrl PgDn

Switches between worksheet tabs, from right-to-left

Ctrl PgUp

Save

Ctrl S

Apply comma format

Ctrl Shift !

Applies the currency format with two decimal places (negative numbers in parentheses)

Ctrl Shift $

Applies the percentage format with no decimal places

Ctrl Shift %

Unhide rows

Ctrl Shift (

Unhide columns

Ctrl Shift )

Enter the current time

Ctrl Shift ;

Selecting a range

Ctrl Shift Arrows

Select to end of line of text (or region)

Ctrl Shift End

Select to beginning of line of text (or cell a1)

Ctrl Shift Home

Applies the general number format

Ctrl Shift ~

Select entire column

Ctrl Space

Create table

Ctrl T

Move between open excel files

Ctrl Tab

Underline highlighted selection

Ctrl U

Paste

Ctrl V

Cut

Ctrl X

Redo last action (can be used multiple times)

Ctrl Y

Undo last action (can be used multiple times)

Ctrl Z

Alternate between displaying cell values and displaying formulas in the worksheet

Ctrl ~

Delete cell content

Del

Help

F1

Create chart

F11

Save as

F12

Edit the selected cell

F2

Show names

F3

Cycle through absolute and relative (in formula)

F4

Display the go to dialog box

F5

Switch between the ribbon and task pane

F6

Spell check selected text and/or document

F7

Toggle extended selection

F8

Calculate the workbook

F9

Selecting cells

Shift Arrows

Open context menu

Shift F10

Insert a new worksheet

Shift F11

Adds or edit a cell comment

Shift F2

Open the excel formula window

Shift F3

Calculate the worksheet

Shift F9

Select entire row

Shift Space


संबंधित स्टडी सेट्स

Cultural Anthropology Chapter 10; Kinship and Descent

View Set

the day before ap psychology exam review

View Set

Chapter 18: Creating competitive advantage

View Set

BUS1B Managerial Accounting Chapter 6

View Set

PHYSICS 4.07 First Law of Thermodynamics

View Set

Chapter 14- Flexibility Training Concepts

View Set