WSP Excel Crash Course Exam with verified detailed answers

WSP: Excel Crash Course Exam with verified || || || || || || ||




detailed answers ||




Alt + HOI
|| ||




Auto fit the width of your column of the cell you have selected
|| || || || || || || || || || || ||




shift + space
|| ||




Highlights entire row of selected cell || || || || ||




ctrl + space
|| ||




Highlights entire column of selected cell || || || || ||




ctrl + fn + page
|| || || ||




Moves to the next sheet in a workbook
|| || || || || || ||




Alt + ES (additional keys are used for formulas, formats, and multiplication)
|| || || || || || || || || || ||




Opens Paste Special Dialogue Box
|| || || ||




ESF: pastes formulas
|| ||




EST: pastes formats
|| ||




ESM: multiplies pasted range by the copied cell
|| || || || || || ||

, Alt + WFF
|| ||




Freeze Panes ||




Place the cursor one row below and one column to the right
|| || || || || || || || || || ||




ctrl + shift + (+)
|| || || ||




When you have a row or column highlighted, this will add an additional row or column
|| || || || || || || || || || || || || || ||




Alt + IR|| ||




Alt + IC|| ||




Inserts row above or column to the left
|| || || || || || ||




alt + HDR
|| ||




alt + HDC
|| ||




Delete row or column || || ||




ctrl + shift + !
|| || || ||




ctrl + shift + $
|| || || ||




ctrl + shuft + #
|| || || ||




Number format 2 decimal places || || || ||




Currency format 2 decimal places || || || ||




Date format with day, month, year
|| || || || ||