WSO Excel Study Questions And Answers!!

What quick key is used to copy paste special formats? - Answer-Alt-E-S-T Which key(s) is used primarily for navigating to the end of contiguous cells? - Answer-Ctrl Which key is primarily used in combination with other keys to highlight cells? - Answer-Shift Complete the following: in order to highlight multiple contiguous cells, use Ctrl + Shift + (answer) - Answer-Arrow Keys Complete the following: in order to highlight multiple contiguous sheets, use Ctrl + Shift + (answer) - Answer-Page Up/Page Down To select all the cells in a contiguous area, we would press Ctrl + ___ - Answer-A Complete the following: in order to create or display a comment, use Shift + (answer) - Answer-F2 What is the main characteristic of CTRL hotkeys? - Answer-Meant to be held down in tandem with other hotkeys What is the main characteristic of ALT hotkeys? - Answer-Meant to be tapped and used for built-in Excel shortcuts What is the correct hotkey sequence for SPECIAL PASTE? - Answer-Ctrl + Alt + V When making a custom format, what is the difference between using #s and "0"s for formatting numbers? - Answer-'#s are for insignificant digits and "0"s are for significant digits How can we create precise invisible spaces based on other characters in our cell formatting? - AnswerUsing underscore _ before the character whose width we are looking forIt is possible for us to create an all-encompassing format "type" that can handle positive, negative, zero, and text numbers all in one format. - Answer-TRUE Suppose we have the following format type: $#,#0.0; ($##0.0); "null"; "example here" What is the correct order that this format would be piped into the Excel workbook? - Answer-positive ; negative ; zero's ; text Suppose we want to create a custom format style, but we don't need to specify how it should handle inputs that are zero. What would be the correct way to handle such a format? - Answer-positive format ; negative format ;; text format What is the hotkey for opening the format cell menu? - Answer-Ctrl + 1 If we want to create a custom format that can repeatedly format cells in a cyclical manner, which formula should we use? - Answer-Mod() "Freeze top row" freezes row 1 of an Excel sheet. - Answer-True For any given cell, "freeze pane" will freeze which of the following? - Answer-Freeze column to the left of current selection Freeze row above current selection Under what tab in the main ribbon is the Split panes option? - Answer-View If you wanted to split the view of your sheet into four quadrants, where should your selection be placed before splitting? - Answer-Any cell near the middle After splitting your view, how would you shift between your split panes? - Answer-Shift + F6 F6How do we anchor a reference? - Answer-F4 Which definition below is incorrect? - Answer-#NAME! -- occurs when Excel doesn't recognize a cell based on a format applied on it Which basic math function has the hotkey Alt + = ? - Answer-Sum() What is partial anchoring? - Answer-When only the row or column identifier of a cell is anchored