All Wall Street Prep Excel Crash Course Exam (20 Sets) Questions with Verified Answers,100% CORRECT

Wall Street Prep Excel Crash Course Exam 246 Questions with Verified Answers Keyboard Versus the Mouse - CORRECT ANSWER Almost everything that can be done in Excel using a mouse can also be done using the keyboard shortcuts Best way to learn is to disconnect the mouse and work through Excel usin...

WallStreet Prep Excel Crash course Exam 27 Questions with Verified Answers All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - CORRECT ANSWER Alt h i w What is a keyboard shortcut to open a file?` - CORRECT ANSWER Ctrl o What is th...

Excel Crash Course Exam 128 Questions with Verified Answers move back and forth between the worksheets in a workbook - CORRECT ANSWER *Ctrl PageUp* or *Ctrl PageDown* open a file - CORRECT ANSWER *alt f o* *ctrl o* save a file - CORRECT ANSWER *alt f s* *ctrl s* print a file - CORR...

Wall Street Prep Excel Exam 74 Questions with Verified Answers All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w - CORRECT ANSWER Alt h i w What is a keyboard shortcut to open ...

Wall Street Prep Excel Crash Course Formulas Exam 64 Questions with Verified Answers =AVERAGE(number1,[number2],...) - CORRECT ANSWER Average Function =IF(logical test, [value if true], [value if false]) - CORRECT ANSWER Simple IF Function =IFS(logical test n, value if true n, value if fals...

Wall Street Prep Excel Shortcut Exam 27 Questions with Verified Answers Alt I W - CORRECT ANSWER Add new sheet Alt E L - CORRECT ANSWER Delete worksheet Alt V Z - CORRECT ANSWER Zoom size Alt H O I - CORRECT ANSWER Auto fit column width Ctrl 1 - CORRECT ANSWER Formatting window C...

Wall Street Prep Excel Crash Course Formulas Explained Exam 45 Questions with Verified Answers Average Function - CORRECT ANSWER Definition: An Excel function that adds a group of values, and then divides the result by the number of values in the group. IF Statement Function - CORRECT ANSWER D...

Excel Exam 62 Questions with Verified Answers spreadsheet - CORRECT ANSWER an electronic file that contains a grid of columns and rows containing related data worksheet - CORRECT ANSWER s spreadsheet that contains formulas, functions, values, texts, and visual aids workbook - CORRECT ANSWER...

Excel Training Exam 58 Questions with Verified Answers What are filter views? - CORRECT ANSWER A tool that allows you to customize and save certain filters When sorting A-Z on a column that includes the numbers 1-20, what number will be at the top? - CORRECT ANSWER 1 How do you apply filter...

Excel Essential Training Exam 34 Questions with Verified Answers In Excel, a file is a ____________. - CORRECT ANSWER workbook You click once a cell that has the word "cat" in it and begin typing the word "dog", and then hit Return on your keyboard. The cell - CORRECT ANSWER now says "dog...

Excel Final Exam Review 211 Questions with Verified Answers Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? - CORRECT ANSWER B. Show Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT ANS...

Excel Training 1 Exam 35 Questions with Verified Answers Which are three ways to create a new workbook in Excel 2016? - CORRECT ANSWER Using an existing template, using an online template, create a blank workbook from scratch Users can save a workbook in Excel 2016 using which item? - CORRECT ...

Microsoft Excel LinkedIn Assessment 101 Questions with Verified Answers Excel's menu system is known as the - CORRECT ANSWER ribbon some of the buttons in the ribbon have a small arrow in the bottom right corner. What are these arrows? - CORRECT ANSWER dialog box launchers You would like t...

Excel Keyboard Shortcuts Exam 129 Questions with Verified Answers CTRL+PgUp - CORRECT ANSWER Switches between worksheet tabs, from left-to-right. CTRL+PgDn - CORRECT ANSWER Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+( - CORRECT ANSWER Unhides any hidden rows within the ...